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