public void getitemcount(int productid, int quantity, string grateid, string itemid)
{
HttpContext.Current.Response.Clear();
HttpContext.Current.Response.AddHeader("Content-Type", "text/html");
// HttpContext.Current.Response.Write("bhushan");
using (dbDatabaseDataDataContext db = new dbDatabaseDataDataContext())
{
if (quantity != 0)
{
// int custid = int.Parse(HttpContext.Current.Session["CustId"].ToString());
// int? regid = (int?)HttpContext.Current.Session["RegId"];
int?custid = (int?)HttpContext.Current.Session["CustId"];
int?id = (int?)HttpContext.Current.Session["ProdId"];
var check = (from s in db.tbl_CartDtls where s.GrocerRateID == int.Parse(grateid.ToString()) && s.ItemId == int.Parse(itemid.ToString()) && s.CustomerId == custid && s.PaymentStatus == false select s).FirstOrDefault();
if (check == null)
{
tbl_CartDtl tb = new tbl_CartDtl();
tb.CustomerId = custid;
tb.GrocerRateID = int.Parse(grateid.ToString());
tb.Quantity = int.Parse(quantity.ToString());
tb.ItemId = int.Parse(itemid.ToString());
tb.PaymentStatus = false;
tb.IsDelete = false;
db.tbl_CartDtls.InsertOnSubmit(tb);
db.SubmitChanges();
// Response.Redirect("~/frmAddContentToCart.aspx?ProdId=" + id);
// string message = "";
// return message;
Console.Write("Item added to cart Successfully");
//Server.Transfer("~/frmAddContentToCart.aspx");
// HttpContext.Current.Response.Redirect("~/frmAddContentToCart.aspx");
}
else
{
//check.CustomerId = int.Parse(Session["CustID"].ToString());
//check.GrocerRateID = int.Parse(grocerrate.ToString());
//check.Quantity = int.Parse(FinalCount.ToString());
//check.ItemId = int.Parse(abc.ToString());
int a = int.Parse(check.Quantity.ToString());
check.Quantity = a + quantity;
check.PaymentStatus = false;
check.IsDelete = false;
db.SubmitChanges();
Console.Write("Item added to cart Successfully");
// System.Web.UI.ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alertMessage", "alert('Record Inserted Successfully')", true);
//Server.Transfer("~/frmAddContentToCart.aspx");
// HttpContext.Current.Response.Redirect("~/frmAddContentToCart.aspx");
}
}
else
{
HttpContext.Current.Response.Write("Please Select Quantity of Product");
//return (" ");
//count++;
}
}
}
protected void btnPlaceOrder_Click(object sender, EventArgs e)
{
if (Page.IsValid)
{
if (Session["CustId"] != null)
{
int CustID = int.Parse(Session["CustId"].ToString());
var k = DateTime.Today.ToString("ddMMyy");
//string OderID = k + CustID + CustOdr;
string OderID = CustID + k;
using (dbDatabaseDataDataContext db = new dbDatabaseDataDataContext())
{
string j = "";
int rowcount = 1;
foreach (GridViewRow row in GvCardDtl.Rows) //Running all lines of grid
{
int CartId = int.Parse(((Label)row.FindControl("lblItemID")).Text.ToString());
int Quantity = int.Parse(((Label)row.FindControl("txtQunatity")).Text.ToString());
int MRP = int.Parse(((Label)row.FindControl("lblMRP")).Text.ToString());
string Size = (((Label)row.FindControl("lblSize")).Text.ToString());
int grocerid = int.Parse(((Label)row.FindControl("lblGrocerId")).Text.ToString());
if (rowcount < 2)
{
//var da = (from s in db.tbl_orderConfirms where s.ConfirmOdrID == j && s.GrocerId == grocerid select s).FirstOrDefault();
//if (da == null)
//{
tbl_orderConfirm h = new tbl_orderConfirm();
h.ConfirmOdrID = OderID;
db.tbl_orderConfirms.InsertOnSubmit(h);
db.SubmitChanges();
h.CustId = CustID;
h.OrderAmount = lblSubTotal.Text;
//if (rbtDelivertype.SelectedItem != null)
//{
// t.DeliType = rbtDelivertype.SelectedItem.Text;
//}
//else
//{
// t.DeliType = "Standard Delivery";
//}
h.Time_Date = DateTime.Now;
//t.PaymentMode =
h.Toatal_price = lblGrandTotal.Text;
h.isDelete = false;
//if (rbtDelivertype.SelectedItem != null)
//{
// t.Deliver_Charge = rbtDelivertype.SelectedItem.Value;
//}
//else
//{
// t.Deliver_Charge = "FREE";
//}
h.Deliver_Charge = lblShoppingCost.Text;
h.Odr_status = true;
h.Complt_Odr = "S";
h.GrocerId = grocerid;
h.ConfirmOdrID = OderID + h.CustOrdId;
// db.tbl_orderConfirms.InsertOnSubmit(t);
db.SubmitChanges();
rowcount++;
j = h.ConfirmOdrID;
//}
}
var daa = (from s in db.tbl_orderConfirms where s.ConfirmOdrID == j && s.GrocerId == grocerid select s).FirstOrDefault();
if (daa == null)
{
tbl_orderConfirm b = new tbl_orderConfirm();
b.GrocerId = grocerid;
b.CustId = CustID;
b.OrderAmount = lblSubTotal.Text;
//if (rbtDelivertype.SelectedItem != null)
//{
// t.DeliType = rbtDelivertype.SelectedItem.Text;
//}
//else
//{
// t.DeliType = "Standard Delivery";
//}
b.Time_Date = DateTime.Now;
//t.PaymentMode =
b.Toatal_price = lblGrandTotal.Text;
b.isDelete = false;
//if (rbtDelivertype.SelectedItem != null)
//{
// t.Deliver_Charge = rbtDelivertype.SelectedItem.Value;
//}
//else
//{
// t.Deliver_Charge = "FREE";
//}
b.Odr_status = true;
b.Complt_Odr = "S";
b.ConfirmOdrID = j;
db.tbl_orderConfirms.InsertOnSubmit(b);
db.SubmitChanges();
}
tbl_CartDtl m = new tbl_CartDtl();
var a = (from s in db.tbl_CartDtls where s.cartID == CartId select s).FirstOrDefault();
//a.Quantity = int.Parse(Quantity.ToString());
m.ItemId = CartId;
m.Quantity = Quantity;
m.GrocerRateID = MRP;
m.CustomerId = CustID;
m.Size = Size;
m.GrocerId = grocerid;
m.PaymentStatus = false;
m.IsDelete = false;
m.CustmerOdrId = j;
db.tbl_CartDtls.InsertOnSubmit(m);
db.SubmitChanges();
}
Tbl_CustDeliveryAddressDtl c = new Tbl_CustDeliveryAddressDtl();
c.CustId = CustID;
c.CustFullName = txtFName.Text;
c.CustLName = txtLName.Text;
c.MobileNo = txtMobileNo.Text;
c.AltMobileNo = txtALTMobile.Text;
c.EmailId = txtEMail.Text;
if (ddlState.SelectedItem.Value != "-----Select-----")
{
c.StateId = int.Parse(ddlState.SelectedItem.Value);
}
if (ddlCity.SelectedItem.Value != "-----Select-----")
{
c.CityId = int.Parse(ddlCity.SelectedItem.Value);
}
c.Address = txtAddress.Text;
//if (rbtDelivertype.SelectedItem != null)
//{
// c.Deliverytype = rbtDelivertype.SelectedItem.Value;
//}
//else
//{
// c.Deliverytype = "FREE";
//}
c.Odr_Status = true;
c.CustOrdId = j;
c.isdelete = false;
if (txtZip.Text != "")
{
c.ZipCode = int.Parse(txtZip.Text);
}
db.Tbl_CustDeliveryAddressDtls.InsertOnSubmit(c);
db.SubmitChanges();
txtFName.Text = "";
txtLName.Text = "";
txtMobileNo.Text = "";
txtAddress.Text = "";
txtALTMobile.Text = "";
txtCreDitCardNumber.Text = "";
txtCVV.Text = "";
txtEMail.Text = "";
txtExperyDate.Text = "";
txtNameOnCard.Text = "";
txtZip.Text = "";
ddlState.Items.Clear();
ddlCity.Items.Clear();
//rbtDelivertype.SelectedItem.Value = "FREE";
GvCardDtl.DataSource = null;
GvCardDtl.DataBind();
lblSubTotal.Text = "";
if (Request.Cookies["ShoppingCart"] != null)
{
//Session.Abandon();
//Session.Clear();
Response.Cookies.Clear();
Response.Cookies["ShoppingCart"].Value = null;
Request.Cookies["ShoppingCart"].Value = null;
Response.Cookies["ShoppingCart"].Expires = DateTime.Now.AddDays(-30);
Session["ShoppingCart"] = null;
//Response.Cookies.Add(Response.Cookies["ShoppingCart"]);
}
((Site1)Master).BindGvCardDtl();
Response.Redirect("Default.aspx");
//var a = (from s in db.tbl_CartDtls where s.CustomerId == CustID && s.PaymentStatus == false && s.IsDelete == false select s).ToList();
// var c = (from s in db.Tbl_CustDeliveryAddressDtls where s.CustId == CustID & s.Odr_Status == false select s).FirstOrDefault();
//var d = (from s in db.tbl_orderConfirms where s.CustOrdId == CustOdr select s).FirstOrDefault();
//foreach (tbl_CartDtl s in a)
//{
// s.CustmerOdrId = Convert.ToInt64(OderID);
// s.CustmerOdrId = CustOdr;
// s.PaymentStatus = true;
// db.SubmitChanges();
//}
//c.CustOrdId = int.Parse(CustOdr.ToString());
//c.Odr_Status = true;
//db.SubmitChanges();
//d.Complt_Odr = false;
//d.Odr_status = true;
//d.ConfirmOdrID = int.Parse(OderID.ToString());
//db.SubmitChanges();
//if (Session["OnlinePayment"] != null)
//{
// Response.Redirect("~/m.app/PaytmPaymentGateway.aspx");
//}
//API api = new API();
//var Customer = (from s in db.mstCustomerDtls where s.CustId == CustID select s).FirstOrDefault();
//var Grocer = (from s in db.mstGrocerDtls where s.GrocerId == GrocerID select s).FirstOrDefault();
//string _CustomerName = Customer.CustName;
//string _MOBNO = Customer.MobileNo;
//string _OderNo = d.ConfirmOdrID.ToString();
//string _msg = "Thanks Mr. " + _CustomerName + "<br>" + " your order list has been submitted successfully." + " Order ID :" + ' ' + _OderNo + " for future reference. your order will be process soon. " + "<br>" + "KITCHEN BASKET";
//sendsms(_MOBNO, _msg);
//string _GrocerName = Grocer.ShopName;
//string _MOBILENO = Grocer.MobNo;
//string _MESSAGE = "MR. " + _CustomerName + " has Submited Order list Order ID " + ' ' + _OderNo + " For Future reference" + "<br>" + "KITCHEN BASKET";
//sendsms(_MOBILENO, _MESSAGE);
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "str", "alert('Your Order Place Successfully...!.' );", true);
}
}
else
{
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "str", "alert('Please Login First');", true);
}
}
}
