public int DeleteFactoryChallanHeader(DTO.FactoryChallanHeader Ob) { SqlCommand cmd = SqlHelper.CreateSqlCommand("sp_FactoryChallanHeader"); FlagType flag; flag = FlagType.Delete; cmd = AddParameters_FactoryChallanHeader(cmd, flag, Ob); return((int)SqlHelper.ExecuteStoredProc(cmd)); }
public int DeleteItemCategory(DTO.Item_Categories Ob) { SqlCommand cmd = SqlHelper.CreateSqlCommand("sp_ItemCategories"); FlagType flag; flag = FlagType.Delete; cmd = AddParameters_ItemCategory(cmd, flag, Ob); return((int)SqlHelper.ExecuteStoredProc(cmd)); }
public int DeleteBooking(DTO.Booking_Items Ob) { SqlCommand cmd = SqlHelper.CreateSqlCommand("sp_Booking_Items"); FlagType flag; flag = FlagType.Delete; cmd = AddParameters_BookingItems(cmd, flag, Ob); return((int)SqlHelper.ExecuteStoredProc(cmd)); }
public int SaveBookingItemPatterns(DTO.Booking_Items_Patterns Ob) { SqlCommand cmd = SqlHelper.CreateSqlCommand("sp_Proc_BookingItemPatterns"); FlagType flag; if (Ob.Booking_ItemPatternID > 0) { flag = FlagType.Update; } else { flag = FlagType.Insert; } cmd = AddParameters_BookingItemPattern(cmd, flag, Ob); return((int)SqlHelper.ExecuteStoredProc(cmd)); }
public int SavePromoData(string promoXml, string promoName, string promoDesc, int schemeTemplateID, int promoID) { SqlCommand cmd = SqlHelper.CreateSqlCommand("usp_PromoSchemes"); FlagType flag; if (promoID > 0) { flag = FlagType.Update; } else { flag = FlagType.Insert; } cmd = AddParameters_Promos(cmd, flag, promoXml, promoName, promoDesc, schemeTemplateID, promoID); return((int)SqlHelper.ExecuteStoredProc(cmd)); }
public int SaveSubItem(DTO.Sub_Items Ob) { SqlCommand cmd = SqlHelper.CreateSqlCommand("sp_SubItems"); FlagType flag; if (Ob.SubID > 0) { flag = FlagType.Update; } else { flag = FlagType.Insert; } cmd = AddParameters_SubItems(cmd, flag, Ob); return((int)SqlHelper.ExecuteStoredProc(cmd)); }
public int SaveBranchChallanDetail(DTO.BranchChallanDetail Ob) { SqlCommand cmd = SqlHelper.CreateSqlCommand("sp_BranchChallanDetail"); FlagType flag; if (Ob.BranchDetailID > 0) { flag = FlagType.Update; } else { flag = FlagType.Insert; } cmd = AddParameters_BranchChallanDetail(cmd, flag, Ob); return((int)SqlHelper.ExecuteStoredProc(cmd)); }
public int SaveItemTracking(DTO.Item_Tracking Ob) { SqlCommand cmd = SqlHelper.CreateSqlCommand("sp_ItemTracking"); FlagType flag; if (Ob.TrackId > 0) { flag = FlagType.Update; } else { flag = FlagType.Insert; } cmd = AddParameters_ItemTracking(cmd, flag, Ob); return((int)SqlHelper.ExecuteStoredProc(cmd)); }
public int SaveFactoryChallanHeader(DTO.FactoryChallanHeader Ob) { SqlCommand cmd = SqlHelper.CreateSqlCommand("sp_FactoryChallanHeader"); FlagType flag; if (Ob.FactoryChallanID > 0) { flag = FlagType.Update; } else { flag = FlagType.Insert; } cmd = AddParameters_FactoryChallanHeader(cmd, flag, Ob); return((int)SqlHelper.ExecuteStoredProc(cmd)); }
public int SaveItemCategory(DTO.Item_Categories Ob) { SqlCommand cmd = SqlHelper.CreateSqlCommand("sp_ItemCategories"); FlagType flag; if (Ob.ItemCatID > 0) { flag = FlagType.Update; } else { flag = FlagType.Insert; } cmd = AddParameters_ItemCategory(cmd, flag, Ob); return((int)SqlHelper.ExecuteStoredProc(cmd)); }
public int SaveNewCustomer(DTO.CustomerMaster Ob) { SqlCommand cmd = SqlHelper.CreateSqlCommand("sp_CustomerNewMaster"); FlagType flag; if (Ob.CustID > 0) { flag = FlagType.Update; } else { flag = FlagType.Insert; } cmd = AddParameters_Customer(cmd, flag, Ob); return((int)SqlHelper.ExecuteStoredProc(cmd)); }
public int SaveItemVariation(DTO.Item_Variations Ob) { SqlCommand cmd = SqlHelper.CreateSqlCommand("sp_ItemVariations"); FlagType flag; if (Ob._ItemVarId > 0) { flag = FlagType.Update; } else { flag = FlagType.Insert; } cmd = AddParameters_ItemVariation(cmd, flag, Ob); return((int)SqlHelper.ExecuteStoredProc(cmd)); }
public int SaveBookingData(string bookingXml, DTO.Booking Ob) { SqlCommand cmd = SqlHelper.CreateSqlCommand("sp_Booking"); FlagType flag; if (Ob.BookingID > 0) { flag = FlagType.Update; } else { flag = FlagType.Insert; } cmd = AddParameters_Booking(cmd, flag, Ob); cmd.Parameters.Add(new SqlParameter("@booking_Xml", bookingXml)); return((int)SqlHelper.ExecuteStoredProc(cmd)); }