1 files changed, 20 insertions, 0 deletions
diff --git a/lib/vendors/repository.ts b/lib/vendors/repository.ts
index d2be43ca..5b9b1116 100644
--- a/lib/vendors/repository.ts
+++ b/lib/vendors/repository.ts
@@ -175,6 +175,26 @@ export const getVendorContactsById = async (id: number): Promise<VendorContact |
   return contact
 };
 
+export const getVendorContactById = async (id: number): Promise<VendorContact | null> => {
+  const contactsRes = await db.select().from(vendorContacts).where(eq(vendorContacts.id, id)).execute();
+  if (contactsRes.length === 0) return null;
+
+  const contact = contactsRes[0];
+  return contact
+};
+
+export async function updateVendorContactById(
+  tx: PgTransaction<any, any, any>,
+  id: number,
+  data: Partial<VendorContact>
+) {
+  return tx
+    .update(vendorContacts)
+    .set(data)
+    .where(eq(vendorContacts.id, id))
+    .returning();
+}
+
 export async function selectVendorContacts(
   tx: PgTransaction<any, any, any>,
   params: {