public ChallanPageSide(PageLoader pageLoader, Challan challan) : base(pageLoader) { InitializeComponent(); DataContext = this; Challan = challan; NotifyPropertyChanged("Challan"); }
public ChallanPageNav(PageLoader pageLoader, Challan orderChallan, ChallanPage pageRef) : base(pageLoader) { InitializeComponent(); DataContext = this; OrderChallan = orderChallan; challanPageRef = pageRef; }
async void InitPage(PageLoader pageLoader) { OrderChallan = new Challan(); await OrderChallan.AssignChallanBookSerialNo(); PageNav = new ChallanPageNav(pageLoader, OrderChallan, this); PageSide = new ChallanPageSide(pageLoader, OrderChallan); VatList = await Tax.RetriveTaxesByType("VAT"); CstList = await Tax.RetriveTaxesByType("CST"); }
public static async Task <Challan> RetrieveChallanByOrder(OrderForm orderForm) { Challan challan = null; string sqlCmdString = "Select * From dbo.challans Where order_id = @order_id"; Database myDb = new Database(); SqlCommand sqlCmd = new SqlCommand(sqlCmdString, myDb.Connection); SqlDataAdapter dataAdapt = new SqlDataAdapter(sqlCmd); DataTable table = new DataTable(); await Task.Run(() => { try { myDb.OpenConnection(); sqlCmd.Parameters.Add(new SqlParameter("@order_id", orderForm.OrderId)); dataAdapt.Fill(table); if (table.Rows.Count == 1) { DataRow row = table.Rows[0]; challan = new Challan() { BookNo = Convert.ToInt32(row["book_no"]), ChallanNo = Convert.ToInt32(row["sl_no"]), ChallanDate = (DateTime)row["challan_date"], ChallanType = new ChallanType() { TypeName = (string)row["challan_type"] }, OrderForm = orderForm, FreightCharge = Convert.ToInt32(row["freight_charge"]), VehicleNo = (string)row["vehicle_no"], DriverMobile = (string)row["driver_mobile"], ConsignmentNoteNo = (string)row["consignment_note_no"], TransporterName = (string)row["transporter_name"], Vat = Convert.ToDouble(row["vat"]), Cst = Convert.ToDouble(row["cst"]), SpecialNote = row["special_note"] == DBNull.Value ? "" : (string)row["special_note"], ReceivedAmount = Convert.ToInt32(row["received_amount"]), IsPersist = true }; } } finally { dataAdapt.Dispose(); table.Dispose(); myDb.CloseConnection(); } }); return(challan); }
public async Task <Challan> RetrieveOrderChallan() { return(Challan = await Challan.RetrieveChallanByOrder(this)); }
public static async Task<Challan> RetrieveChallanByOrder(OrderForm orderForm) { Challan challan = null; string sqlCmdString = "Select * From dbo.challans Where order_id = @order_id"; Database myDb = new Database(); SqlCommand sqlCmd = new SqlCommand(sqlCmdString, myDb.Connection); SqlDataAdapter dataAdapt = new SqlDataAdapter(sqlCmd); DataTable table = new DataTable(); await Task.Run(() => { try { myDb.OpenConnection(); sqlCmd.Parameters.Add(new SqlParameter("@order_id", orderForm.OrderId)); dataAdapt.Fill(table); if (table.Rows.Count == 1) { DataRow row = table.Rows[0]; challan = new Challan() { BookNo = Convert.ToInt32(row["book_no"]), ChallanNo = Convert.ToInt32(row["sl_no"]), ChallanDate = (DateTime)row["challan_date"], ChallanType = new ChallanType() { TypeName = (string)row["challan_type"] }, OrderForm = orderForm, FreightCharge = Convert.ToInt32(row["freight_charge"]), VehicleNo = (string)row["vehicle_no"], DriverMobile = (string)row["driver_mobile"], ConsignmentNoteNo = (string)row["consignment_note_no"], TransporterName = (string)row["transporter_name"], Vat = Convert.ToDouble(row["vat"]), Cst = Convert.ToDouble(row["cst"]), SpecialNote = row["special_note"] == DBNull.Value ? "" : (string)row["special_note"], ReceivedAmount = Convert.ToInt32(row["received_amount"]), IsPersist = true }; } } finally { dataAdapt.Dispose(); table.Dispose(); myDb.CloseConnection(); } }); return challan; }