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