public int DL_InsUpdUnitMaster(ML_Pharmacy objML_Pharmacy) { SqlParameter[] par = { new SqlParameter("@UnitID", objML_Pharmacy.UnitID), new SqlParameter("@UnitName", objML_Pharmacy.UnitName), new SqlParameter("@CreatedBy", objML_Pharmacy.CreatedBy), new SqlParameter("@ModifyBy", objML_Pharmacy.ModifyBy), new SqlParameter("@Description", objML_Pharmacy.Description) }; return(SqlHelper.ExecuteNonQuery(con, "SPCN_InsUpdUnitMaster", par)); }
public int DL_InsUpdItemMaster(ML_Pharmacy objML_Pharmacy) { SqlParameter[] par = { new SqlParameter("@ItemCode", objML_Pharmacy.ItemCode), new SqlParameter("@ItemName", objML_Pharmacy.ItemName), new SqlParameter("@SaleAccount", objML_Pharmacy.SaleAccount), new SqlParameter("@PurchaseAccount", objML_Pharmacy.PurchaseAccount), new SqlParameter("@ItemCost", objML_Pharmacy.ItemCost), new SqlParameter("@MRP", objML_Pharmacy.MRP), new SqlParameter("@HSNCode", objML_Pharmacy.HSNCode), new SqlParameter("@UOM", objML_Pharmacy.UOM), new SqlParameter("@Active", objML_Pharmacy.Active), new SqlParameter("@CreatedBy", objML_Pharmacy.CreatedBy), new SqlParameter("@ModifyBy", objML_Pharmacy.ModifyBy) }; return(SqlHelper.ExecuteNonQuery(con, "SPCN_InsUpdItemMaster", par)); }
public int DL_InsUpdVendorMaster(ML_Pharmacy objML_Pharmacy) { SqlParameter[] par = { new SqlParameter("@VendorID", objML_Pharmacy.ID), new SqlParameter("@VendorName", objML_Pharmacy.VendorName), new SqlParameter("@Description", objML_Pharmacy.Description), new SqlParameter("@Address", objML_Pharmacy.Address), new SqlParameter("@Country", objML_Pharmacy.Country), new SqlParameter("@State", objML_Pharmacy.State), new SqlParameter("@City", objML_Pharmacy.City), new SqlParameter("@MobileNo", objML_Pharmacy.MobileNo), new SqlParameter("@Phone1", objML_Pharmacy.Phone1), new SqlParameter("@Phone2", objML_Pharmacy.Phone2), new SqlParameter("@EmailID", objML_Pharmacy.EmailID), new SqlParameter("@WebSite", objML_Pharmacy.WebSite), new SqlParameter("@AccountCode", objML_Pharmacy.AccountCode), new SqlParameter("@GSTINNo", objML_Pharmacy.GSTINNo), new SqlParameter("@CreatedBy", objML_Pharmacy.CreatedBy), new SqlParameter("@ModifyBy", objML_Pharmacy.ModifyBy) }; return(SqlHelper.ExecuteNonQuery(con, "SPCN_InsUpdVendorMaster", par)); }
public int BL_InsUpdCustomerMaster(ML_Pharmacy ObjML_Pharmacy) { return(objDL_Pharmacy.DL_InsUpdCustomerMaster(ObjML_Pharmacy)); }
public DataTable BL_BindCustomerMaster(ML_Pharmacy ObjML_Pharmacy) { return(objDL_Pharmacy.DL_BindCustomerMaster(ObjML_Pharmacy)); }
public DataTable BL_SelectVendorMaster(ML_Pharmacy ObjML_Pharmacy) { return(objDL_Pharmacy.DL_SelectvendorMaster(ObjML_Pharmacy)); }
public int BL_InsUpdVendorMaster(ML_Pharmacy ObjML_Pharmacy) { return(objDL_Pharmacy.DL_InsUpdVendorMaster(ObjML_Pharmacy)); }
public DataTable BL_SearchItem(ML_Pharmacy ObjML_Pharmacy) { return(objDL_Pharmacy.DL_SearchItem(ObjML_Pharmacy)); }
public DataTable BL_SearchUnitMaster(ML_Pharmacy ObjML_Pharmacy) { return(objDL_Pharmacy.DL_SearchUnitMaster(ObjML_Pharmacy)); }
public DataTable DL_SelectCustomerMaster(ML_Pharmacy objML_Pharmacy) { SqlParameter[] par = { new SqlParameter("@ID", objML_Pharmacy.ID) }; return(SqlHelper.ExecuteDataset(con, "SPCN_CustomerMaster_Select", par).Tables[0]); }
public DataTable DL_BindVendorMaster(ML_Pharmacy objML_Pharmacy) { SqlParameter[] par = { new SqlParameter("@ID", objML_Pharmacy.ID) }; return(SqlHelper.ExecuteDataset(con, "SPCN_vendorMaster_Bind", par).Tables[0]); }
public DataTable DL_SearchItem(ML_Pharmacy objML_Pharmacy) { SqlParameter[] par = { new SqlParameter("@ID", objML_Pharmacy.ID) }; return(SqlHelper.ExecuteDataset(con, "SPCN_ItemMaster_Search", par).Tables[0]); }