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