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]);
}
