private DataTable GetDataSet1()
{
//SqlConnection con = new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["A2ZRetailConnectionString"].ConnectionString);
SqlConnection con = new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["RetailManagementConnectionString"].ConnectionString);
// SqlConnection con = new SqlConnection("Data Source=localhost;Initial Catalog=" + DatabaseName + ";Integrated Security=True");
string ChallanNo = Session["ChallanNo"].ToString();
SqlDataAdapter adp = new SqlDataAdapter("select * from DeliveryChallanItems where ChallanNo='" + ChallanNo + "'", con);
DeliveryChallanItemsDataSet ds = new DeliveryChallanItemsDataSet();
con.Open();
adp.Fill(ds);
return(ds.Tables[1]);
}
private DataTable GetDataSet1()
{
SqlConnection con = new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["RetailManagementConnectionString"].ConnectionString);
// SqlConnection con = new SqlConnection("Data Source=localhost;Initial Catalog=" + DatabaseName + ";Integrated Security=True");
string ChallanNo = Session["ChallanNo"].ToString();
SqlDataAdapter adp = new SqlDataAdapter("select * from DeliveryChallanItems where ChallanNo='" + ChallanNo + "'", con);
DeliveryChallanItemsDataSet ds = new DeliveryChallanItemsDataSet();
con.Open();
adp.Fill(ds);
double?TotalAmount = 0;
double?TotalDiscount = 0;
for (int i = 0; i < ds.Tables[1].Rows.Count; i++)
{
double?discountonmrp = ((Convert.ToDouble(ds.Tables[1].Rows[i]["Quantity"])) * (Convert.ToDouble(ds.Tables[1].Rows[i]["MRP"]))) * Convert.ToDouble(ds.Tables[1].Rows[i]["DiscountPercent"]) / 100;
TotalDiscount = TotalDiscount + discountonmrp;
TotalAmount = TotalAmount + ((Convert.ToDouble(ds.Tables[1].Rows[i]["Quantity"])) * (Convert.ToDouble(ds.Tables[1].Rows[i]["MRP"]))) - discountonmrp;
}
Session["TotalAmount"] = TotalAmount;
Session["TotalDiscount"] = TotalDiscount;
return(ds.Tables[1]);
}
