private void CountDeliveryAmount()
{
foreach (DataListItem item in DataList1.Items)
{
Label lblcartid = (Label)item.FindControl("lblCartid");
string ChefID = con.singlecell("select Chef_ID from CartMaster where Cart_ID='" + lblcartid.Text + "'");
string ChefZipCode = con.singlecell("Select PinCode from ChefPersonalDetail Where Chef_ID='" + ChefID + "'");
string Destination = lblpincode.Text;
//string consumeraddresss = objcheck.get_User_Address(Session["Consumer_ID"].ToString(),false,true,addressid);
//string chefaddress = objcheck.get_User_Address(ChefID,true,true,null);
if (con.check_data("Select * from DeliveryCount where Cart_ID='" + lblcartid.Text + "'"))
{
}
else
{
commonfunctions cf = new commonfunctions();
Dictionary<string, string> fromvalues = new Dictionary<string, string>();
//fromvalues = cf.CalculateResult(chefaddress, consumeraddresss);
fromvalues = cf.CalculateResult(ChefZipCode, Destination);
lblshippingcharge.Text = fromvalues["charges"];
string shippingcarge = fromvalues["charges"];
int shippingcharge = int.Parse(fromvalues["charges"]);
SqlParameter[] p1 = new SqlParameter[3];
p1[0] = new SqlParameter("@CartID", lblcartid.Text);
p1[1] = new SqlParameter("@Mode", 3);
p1[2] = new SqlParameter("@DeliveryAmt", shippingcharge);
con1.Ins_Upd_Del("SP_ConsumerCart_Edit", p1);
// con.insert_data("insert into DeliveryCount values('" + ChefID + "','" + fromvalues["distancecount"] + "','" + lblcartid.Text + "','" + shippingcharge.ToString() + "')");
con.insert_data("insert into DeliveryCount values('" + Session["Consumer_ID"] + "','" + fromvalues["distancecount"] + "','" + lblcartid.Text + "','" + shippingcharge.ToString() + "')");
}
}
string totdelAmt = con.singlecell("Select Sum(Amount) from DeliveryCount where Chef_ID='" + Session["Consumer_ID"] + "' and Amount!='-1'");
con.delete_data("delete from DeliveryCount where Chef_ID='" + Session["Consumer_ID"] + "'");
lblshippingcharge.Text = totdelAmt;
}
