private string SaveBooking(DTO.Common Ob)
{
string res = string.Empty;
DataSet ds = new DataSet();
DataTable DTBooking = MainBooking(Ob);
SqlCommand CMD_Booking = new SqlCommand();
CMD_Booking.CommandText = "sp_NewXmlSave";
CMD_Booking.CommandType = CommandType.StoredProcedure;
CMD_Booking.Parameters.AddWithValue("@BOOKINGNUMBER", DTBooking.Rows[0]["BookingNumber"].ToString());
CMD_Booking.Parameters.AddWithValue("@BookingByCustomer", DTBooking.Rows[0]["BookingByCustomer"].ToString());
CMD_Booking.Parameters.AddWithValue("@BookingAcceptedByUserId", DTBooking.Rows[0]["BookingAcceptedByUserId"].ToString());
CMD_Booking.Parameters.AddWithValue("@IsUrgent", DTBooking.Rows[0]["IsUrgent"].ToString());
//CMD_Booking.Parameters.AddWithValue("@BookingDate", DTBooking.Rows[0]["BookingDate"].ToString());
CMD_Booking.Parameters.AddWithValue("@BookingDeliveryDate", DTBooking.Rows[0]["BookingDeliveryDate"].ToString());
CMD_Booking.Parameters.AddWithValue("@BookingDeliveryTime", DTBooking.Rows[0]["BookingDeliveryTime"].ToString());
CMD_Booking.Parameters.AddWithValue("@TotalCost", DTBooking.Rows[0]["TotalCost"].ToString());
CMD_Booking.Parameters.AddWithValue("@Discount", DTBooking.Rows[0]["Discount"].ToString());
CMD_Booking.Parameters.AddWithValue("@NetAmount", DTBooking.Rows[0]["NetAmount"].ToString());
CMD_Booking.Parameters.AddWithValue("@BookingCancelReason", "");
CMD_Booking.Parameters.AddWithValue("@BookingRemarks", DTBooking.Rows[0]["BookingRemarks"].ToString());
CMD_Booking.Parameters.AddWithValue("@ItemTotalQuantity", DTBooking.Rows[0]["ItemTotalQuantity"].ToString());
CMD_Booking.Parameters.AddWithValue("@HomeDelivery", DTBooking.Rows[0]["HomeDelivery"].ToString());
CMD_Booking.Parameters.AddWithValue("@CheckedByEmployee", DTBooking.Rows[0]["CheckedByEmployee"].ToString());
CMD_Booking.Parameters.AddWithValue("@DiscountAmt", DTBooking.Rows[0]["DiscountAmt"].ToString());
CMD_Booking.Parameters.AddWithValue("@DiscountOption", DTBooking.Rows[0]["DiscountOption"].ToString());
CMD_Booking.Parameters.AddWithValue("@BranchId", DTBooking.Rows[0]["BranchId"].ToString());
CMD_Booking.Parameters.AddWithValue("@IsNextTodayUrgent", DTBooking.Rows[0]["IsNextTodayUrgent"].ToString());
CMD_Booking.Parameters.AddWithValue("@Flag", 1);
res = PrjClass.ExecuteNonQuery(CMD_Booking);
return(res);
}
private string SaveAccountEntries(DTO.Common Ob)
{
string res = string.Empty;
DataTable DTBooking = MainBooking(Ob);
try
{
SqlCommand CMD_Priority = new SqlCommand();
CMD_Priority.CommandText = "sp_NewXmlSave";
CMD_Priority.CommandType = CommandType.StoredProcedure;
CMD_Priority.Parameters.AddWithValue("@TotalCost", DTBooking.Rows[0]["TotalCost"].ToString());
CMD_Priority.Parameters.AddWithValue("@CustomerCode", DTBooking.Rows[0]["BookingByCustomer"].ToString());
CMD_Priority.Parameters.AddWithValue("@AdvanceAmt", DTBooking.Rows[0]["AdvanceAmt"].ToString());
CMD_Priority.Parameters.AddWithValue("@BOOKINGNUMBER", DTBooking.Rows[0]["BookingNumber"].ToString());
ArrayList date = new ArrayList();
date = DAL.DALFactory.Instance.DAL_DateAndTime.getDateAndTimeAccordingToZoneTime(Ob.BID);
CMD_Priority.Parameters.AddWithValue("@DateTime", date[0].ToString());
CMD_Priority.Parameters.AddWithValue("@Time", date[1].ToString());
CMD_Priority.Parameters.AddWithValue("@BranchId", Ob.BID);
CMD_Priority.Parameters.AddWithValue("@Flag", 3);
res = PrjClass.ExecuteNonQuery(CMD_Priority);
}
catch (Exception ex)
{ res = ex.ToString(); }
return(res);
}
private bool CheckDuplicateReason(DTO.Common Ob)
{
SqlCommand cmd = new SqlCommand();
SqlDataReader sdr = null;
bool status = false;
try
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "sp_Dry_BarcodeMaster";
cmd.Parameters.AddWithValue("@BranchId", Ob.BID);
cmd.Parameters.AddWithValue("@RemoveReason", Ob.Input);
cmd.Parameters.AddWithValue("@Flag", 32);
sdr = PrjClass.ExecuteReader(cmd);
if (sdr.Read())
{
status = true;
}
else
{
status = false;
}
}
catch (Exception ex) { }
finally
{
sdr.Close();
sdr.Dispose();
cmd.Dispose();
}
return(status);
}
protected void btnSearch_Click(object sender, EventArgs e)
{
if (txtArea.Text == "")
{
lblErr.Text = "Please Enter some text in Area name for searching.";
return;
}
Ob = SetValue();
//grdSearchResult.DataSource = BAL.BALFactory.Instance.BAL_Area.SearchArea(Ob);
grdSearchResult.DataBind();
}
public DataSet ShowAllColor(DTO.Common Ob)
{
DataSet ds = new DataSet();
SqlCommand cmd = new SqlCommand();
cmd.CommandText = "sp_NewColorMaster";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@BranchId", Ob.BID);
cmd.Parameters.AddWithValue("@Flag", "3");
ds = PrjClass.GetData(cmd);
return(ds);
}
public string ItemRename(DTO.Common Ob)
{
SqlCommand cmd = new SqlCommand();
cmd.CommandText = "Proc_RenameItem";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@OldItem", Ob.Input);
cmd.Parameters.AddWithValue("@NewItem", Ob.ChangeName);
cmd.Parameters.AddWithValue("@BranchId", Ob.BID);
Common.Result = PrjClass.ExecuteNonQuery(cmd);
return(Common.Result);
}
public DataSet ShowAllReason(DTO.Common Ob)
{
SqlCommand cmd = new SqlCommand();
DataSet ds = new DataSet();
cmd.CommandText = "sp_RemoveReason";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@BranchId", Ob.BID);
cmd.Parameters.AddWithValue("@Flag", 3);
ds = PrjClass.GetData(cmd);
return(ds);
}
public DataSet BindRemoveDrop(DTO.Common Ob)
{
SqlCommand cmd = new SqlCommand();
DataSet ds = new DataSet();
cmd.CommandText = "Proc_ReturnChoth";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@BranchId", Ob.BID);
cmd.Parameters.AddWithValue("@Flag", 10);
ds = PrjClass.GetData(cmd);
return(ds);
}
public DataSet BindItemDropDown(DTO.Common Ob)
{
SqlCommand cmd = new SqlCommand();
DataSet ds = new DataSet();
cmd.CommandText = "sp_ItemWisePriceList";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@BranchId", Ob.BID);
cmd.Parameters.AddWithValue("@Flag", 1);
ds = PrjClass.GetData(cmd);
return(ds);
}
public string DeleteReasonMain(DTO.Common Ob)
{
string res = "";
SqlCommand cmd = new SqlCommand();
cmd.CommandText = "sp_RemoveReason";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@BranchId", Ob.BID);
cmd.Parameters.AddWithValue("@ID", Ob.Id);
cmd.Parameters.AddWithValue("@Flag", 7);
res = PrjClass.ExecuteNonQuery(cmd);
return(res);
}
public string SaveArea(DTO.Common Ob)
{
string res = "";
SqlCommand cmd = new SqlCommand();
cmd.CommandText = "sp_Area";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Area", Ob.Input);
cmd.Parameters.AddWithValue("@BranchId", Ob.BID);
cmd.Parameters.AddWithValue("@Flag", 1);
res = PrjClass.ExecuteNonQuery(cmd);
return(res);
}
public string DeleteExpenses(DTO.Common Ob)
{
string res = "";
SqlCommand cmd = new SqlCommand();
cmd.CommandText = "sp_ExpenseEntryScreen";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@ID", Ob.Id);
cmd.Parameters.AddWithValue("@BranchId", Ob.BID);
cmd.Parameters.AddWithValue("@Flag", 2);
res = PrjClass.ExecuteNonQuery(cmd);
return(res);
}
public DataSet SearchArea(DTO.Common Ob)
{
SqlCommand cmd = new SqlCommand();
DataSet ds = new DataSet();
cmd.CommandText = "sp_Area";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@BranchId", Ob.BID);
cmd.Parameters.AddWithValue("@Area", Ob.Input);
cmd.Parameters.AddWithValue("@Flag", 4);
ds = PrjClass.GetData(cmd);
return(ds);
}
public SqlDataReader ReadProcessRate(DTO.Common Ob)
{
SqlCommand cmd = new SqlCommand();
SqlDataReader sdr = null;
cmd.CommandText = "sp_ItemWisePriceList";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@BranchId", Ob.BID);
cmd.Parameters.AddWithValue("@ItemName", Ob.Input);
cmd.Parameters.AddWithValue("@Flag", 3);
sdr = PrjClass.ExecuteReader(cmd);
return(sdr);
}
public DataSet SearchRemarks(DTO.Common Ob)
{
DataSet ds = new DataSet();
SqlCommand cmd = new SqlCommand();
cmd.CommandText = "Sp_Remarks";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@BranchId", Ob.BID);
cmd.Parameters.AddWithValue("@Remarks", Ob.Input);
cmd.Parameters.AddWithValue("@Flag", "4");
ds = PrjClass.GetData(cmd);
return(ds);
}
public DataSet FillWebsiteCustomerTextBoxes(DTO.Common Ob)
{
SqlCommand cmd = new SqlCommand();
DataSet ds = new DataSet();
cmd.CommandText = "Proc_Registration";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@BranchId", Ob.BID);
cmd.Parameters.AddWithValue("@CustomerCode", Ob.Input);
cmd.Parameters.AddWithValue("@Flag", 7);
ds = PrjClass.GetData(cmd);
return(ds);
}
public DataSet UpdateIncomeLedgerName(DTO.Common Ob)
{
DataSet ds = new DataSet();
SqlCommand cmd = new SqlCommand();
cmd.CommandText = "sp_ExpenseEntryScreen";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@ChangeName", Ob.ChangeName);
cmd.Parameters.AddWithValue("@LedgerName", Ob.LedgerName);
cmd.Parameters.AddWithValue("@BranchId", Ob.BID);
cmd.Parameters.AddWithValue("@Flag", 5);
ds = PrjClass.GetData(cmd);
return(ds);
}
public DataSet SetDataInvoiceWise(DTO.Common Ob)
{
SqlCommand cmd = new SqlCommand();
DataSet ds = new DataSet();
cmd.CommandText = "Proc_Registration";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@BranchId", Ob.BID);
cmd.Parameters.AddWithValue("@CustomerCode", Ob.Input);
cmd.Parameters.AddWithValue("@BookingNumber", Ob.Result);
cmd.Parameters.AddWithValue("@Flag", 11);
ds = PrjClass.GetData(cmd);
return(ds);
}
private string SaveBarCode(DTO.Common Ob)
{
string res = string.Empty;
DataTable DTBooking = MainBooking(Ob);
SqlCommand CMD_Barcode = new SqlCommand();
CMD_Barcode.CommandTimeout = 0;
CMD_Barcode.CommandText = "sp_InsertIntoBarcodeTable";
CMD_Barcode.CommandType = CommandType.StoredProcedure;
CMD_Barcode.Parameters.AddWithValue("@BOOKINGNUMBER", DTBooking.Rows[0]["BookingNumber"].ToString());
CMD_Barcode.Parameters.AddWithValue("@BranchId", DTBooking.Rows[0]["BranchId"].ToString());
res = PrjClass.ExecuteNonQuery(CMD_Barcode);
return(res);
}
public string UpdateRemarks(DTO.Common Ob)
{
string res = "";
SqlCommand cmd = new SqlCommand();
cmd.CommandText = "Sp_Remarks";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Remarks", Ob.Input);
cmd.Parameters.AddWithValue("@ID ", Ob.Id);
cmd.Parameters.AddWithValue("@BranchId", Ob.BID);
cmd.Parameters.AddWithValue("@Flag", "2");
res = PrjClass.ExecuteNonQuery(cmd);
return(res);
}
protected void btnSave_Click(object sender, EventArgs e)
{
Ob = SetValue();
Ob.Result = BAL.BALFactory.Instance.BAL_Area.SaveArea(Ob);
if (Ob.Result == "Record Saved")
{
lblMsg.Text = PrjClass.SaveSuccess;
BindGrid();
RefreshForm();
}
else
{
lblErr.Text = Ob.Result;
}
}
private DataTable MainBooking(DTO.Common Ob)
{
DataTable DB1 = EntBookingsDataTable();
doc.Load(Ob.Path);
DataRow NewRow = DB1.NewRow();
XmlNodeList bookList2 = doc.SelectNodes("/booking/receiptheader/iswalkin");
XmlNodeList bookList1 = doc.SelectNodes("/booking/receiptheader/ishomebooking");
XmlNodeList bookList = doc.SelectNodes("/booking/receiptheader");
int j = 0, Quantity;
foreach (XmlNode node in bookList)
{
NewRow["BookingNumber"] = bookList2.Item(0).SelectSingleNode("bookingnumber").InnerText;
string HomeDelivery = bookList1.Item(0).SelectSingleNode("homeeceiptnumber").InnerText;
NewRow["BookingByCustomer"] = node["customerid"].InnerText;
NewRow["BookingAcceptedByUserId"] = Ob.UserId;
NewRow["IsUrgent"] = node["isurgent"].InnerText;
NewRow["BookingDate"] = DateTime.Today.ToString("dd-MMM-yyyy");
NewRow["BookingDeliveryDate"] = node["duedate"].InnerText;
NewRow["BookingDeliveryTime"] = node["duetime"].InnerText;
NewRow["TotalCost"] = node["totalgrossamount"].InnerText;
NewRow["Discount"] = node["totaldiscount"].InnerText;
NewRow["AdvanceAmt"] = node["totaladvance"].InnerText;
NewRow["NetAmount"] = float.Parse(node["totalgrossamount"].InnerText) - float.Parse(node["totaldiscount"].InnerText);
NewRow["BookingRemarks"] = node["remarks"].InnerText;
Quantity = Convert.ToInt32(node["quantity"].InnerText.ToString());
if (Quantity == 0)
{
Quantity = 1;
}
else
{
NewRow["ItemTotalQuantity"] = Quantity;
}
NewRow["ItemTotalQuantity"] = Quantity;
NewRow["HomeDelivery"] = HomeDelivery == "" ? "0" : "1";
NewRow["CheckedByEmployee"] = node["checkedby"].InnerText;
NewRow["DiscountAmt"] = node["totaldiscount"].InnerText;
NewRow["DiscountOption"] = "";
NewRow["BranchId"] = Ob.BID;
NewRow["IsNextTodayUrgent"] = "";
}
DB1.Rows.Add(NewRow);
DB1.AcceptChanges();
j++;
return(DB1);
}
protected void btnDelete_Click(object sender, EventArgs e)
{
Ob = SetValue();
Ob.Result = BAL.BALFactory.Instance.BAL_Color.DeleteColor(Ob);
if (Ob.Result == "Record Saved")
{
ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "ScriptRegistration", "setDivMouseOver('Green', '#999999');", true);
lblMsg.Text = "Color deleted sucessfully.";
BindGrid();
RefreshForm();
}
else
{
ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "ScriptRegistration", "setDivMouseOver('Red', '#999999');", true);
lblErr.Text = Ob.Result;
}
}
public string SaveDataInDataBase(GridView grdTable, DTO.Common Ob)
{
string res = "";
DeleteItemRate(Ob);
for (int r = 0; r < grdTable.Rows.Count; r++)
{
SqlCommand cmd = new SqlCommand();
cmd.CommandText = "sp_ItemWisePriceList";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@ItemName", Ob.Input);
cmd.Parameters.AddWithValue("@BranchId", Ob.BID);
cmd.Parameters.AddWithValue("@ProcessCode", ((HiddenField)grdTable.Rows[r].FindControl("hdnProcessCode")).Value);
cmd.Parameters.AddWithValue("@ProcessRate", ((TextBox)grdTable.Rows[r].Cells[1].FindControl("txtProcessRate")).Text.Trim());
cmd.Parameters.AddWithValue("@Flag", 5);
res = PrjClass.ExecuteNonQuery(cmd);
}
return(res);
}
public string SaveColor(DTO.Common Ob)
{
string res = "";
if (CheckDuplicateColor(Ob) == true)
{
res = "Record allready exist.";
return(res);
}
SqlCommand cmd = new SqlCommand();
cmd.CommandText = "sp_NewColorMaster";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@ColorName", Ob.Input);
cmd.Parameters.AddWithValue("@BranchId", Ob.BID);
cmd.Parameters.AddWithValue("@Flag", "1");
res = PrjClass.ExecuteNonQuery(cmd);
return(res);
}
public string UpdateCustomerDetailWebsite(DTO.Common Ob)
{
string res = string.Empty;
SqlCommand cmd = new SqlCommand();
cmd.CommandText = "Proc_Registration";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@CommunicationMeans", Ob.LedgerName);
cmd.Parameters.AddWithValue("@CustomerMobile", Ob.Path);
cmd.Parameters.AddWithValue("@CustomerPhone", Ob.Result);
cmd.Parameters.AddWithValue("@CustomerEmailId", Ob.UserId);
cmd.Parameters.AddWithValue("@BirthDate", Ob.Id);
cmd.Parameters.AddWithValue("@AnniversaryDate", Ob.ChangeName);
cmd.Parameters.AddWithValue("@Branchid", Ob.BID);
cmd.Parameters.AddWithValue("@CustomerCode", Ob.Input);
cmd.Parameters.AddWithValue("@Flag", 8);
res = PrjClass.ExecuteNonQuery(cmd);
return(res);
}
private bool DeleteItemRate(DTO.Common Ob)
{
SqlCommand cmd = new SqlCommand();
string res = "";
cmd.CommandText = "sp_ItemWisePriceList";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@BranchId", Ob.BID);
cmd.Parameters.AddWithValue("@ItemName", Ob.Input);
cmd.Parameters.AddWithValue("@Flag", 4);
res = PrjClass.ExecuteNonQuery(cmd);
if (res == "Record Saved")
{
return(true);
}
else
{
return(false);
}
}
public string SaveReason(DTO.Common Ob)
{
string res = "";
if (CheckDuplicateReason(Ob) == false)
{
SqlCommand cmd = new SqlCommand();
cmd.CommandText = "sp_RemoveReason";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@RemoveReason", Ob.Input);
cmd.Parameters.AddWithValue("@BranchId", Ob.BID);
cmd.Parameters.AddWithValue("@Flag", 1);
res = PrjClass.ExecuteNonQuery(cmd);
}
else
{
res = "Record allready exists.";
}
return(res);
}
public string SaveRecordInTheDataBase(DTO.Common Ob)
{
string res = string.Empty;
res = SaveBooking(Ob);
if (res == "Record Saved")
{
res = SaveBookingDetails(Ob);
if (res == "Record Saved")
{
//sucess
res = SaveBarCode(Ob);
if (res == "Record Saved")
{
//sucess
res = SaveAccountEntries(Ob);
if (res == "Record Saved")
{
//sucess
}
else
{
return(res);
}
}
else
{
return(res);
}
}
else
{
return(res);
}
}
else
{
return(res);
}
return(res);
}
private string SaveBookingDetails(DTO.Common Ob)
{
string res = string.Empty;
DataTable DTBookingDetails = GetData(Ob);
for (int iRow = 0; iRow < DTBookingDetails.Rows.Count; iRow++)
{
SqlCommand CMD_BookingDetails = new SqlCommand();
CMD_BookingDetails.CommandText = "sp_NewXmlSave";
CMD_BookingDetails.CommandType = CommandType.StoredProcedure;
CMD_BookingDetails.Parameters.AddWithValue("@ISN", DTBookingDetails.Rows[iRow]["ISN"].ToString());
CMD_BookingDetails.Parameters.AddWithValue("@ItemName", DTBookingDetails.Rows[iRow]["ItemName"].ToString());
if (DTBookingDetails.Rows[iRow]["ItemTotalQuantity"].ToString() == "0")
{
DTBookingDetails.Rows[iRow]["ItemTotalQuantity"] = 1;
}
else
{
CMD_BookingDetails.Parameters.AddWithValue("@ItemTotalQuantity", DTBookingDetails.Rows[iRow]["ItemTotalQuantity"].ToString());
}
CMD_BookingDetails.Parameters.AddWithValue("@ItemProcessType", DTBookingDetails.Rows[iRow]["ItemProcessType"].ToString());
CMD_BookingDetails.Parameters.AddWithValue("@ItemQuantityAndRate", DTBookingDetails.Rows[iRow]["ItemQuantityAndRate"].ToString());
CMD_BookingDetails.Parameters.AddWithValue("@ItemExtraProcessType1", DTBookingDetails.Rows[iRow]["ItemExtraProcessType1"].ToString());
CMD_BookingDetails.Parameters.AddWithValue("@ItemExtraProcessRate1", DTBookingDetails.Rows[iRow]["ItemExtraProcessRate1"].ToString());
CMD_BookingDetails.Parameters.AddWithValue("@ItemExtraProcessType2", DTBookingDetails.Rows[iRow]["ItemExtraProcessType2"].ToString());
CMD_BookingDetails.Parameters.AddWithValue("@ItemExtraProcessRate2", DTBookingDetails.Rows[iRow]["ItemExtraProcessRate2"].ToString());
CMD_BookingDetails.Parameters.AddWithValue("@ItemSubTotal", DTBookingDetails.Rows[iRow]["ItemSubTotal"].ToString());
CMD_BookingDetails.Parameters.AddWithValue("@ItemRemark", DTBookingDetails.Rows[iRow]["ItemRemark"].ToString());
CMD_BookingDetails.Parameters.AddWithValue("@ItemColor", DTBookingDetails.Rows[iRow]["ItemColor"].ToString());
CMD_BookingDetails.Parameters.AddWithValue("@STPAmt", DTBookingDetails.Rows[iRow]["STPAmt"].ToString());
CMD_BookingDetails.Parameters.AddWithValue("@STEP1Amt", DTBookingDetails.Rows[iRow]["STEP1Amt"].ToString());
CMD_BookingDetails.Parameters.AddWithValue("@STEP2Amt", DTBookingDetails.Rows[iRow]["STEP2Amt"].ToString());
CMD_BookingDetails.Parameters.AddWithValue("@BOOKINGNUMBER", DTBookingDetails.Rows[iRow]["BookingNumber"].ToString());
CMD_BookingDetails.Parameters.AddWithValue("@BranchId", DTBookingDetails.Rows[iRow]["BranchId"].ToString());
CMD_BookingDetails.Parameters.AddWithValue("@Flag", 2);
res = PrjClass.ExecuteNonQuery(CMD_BookingDetails);
}
return(res);
}
