protected void btnGenerate_Click(object sender, EventArgs e) { //checking product selected or not if (checkproducts()) { //insert into db //update order status in invoice master cls.ExecuteDA("Update_InvoiceOrderStatus", new SqlParameter("@InvoiceId", invoiceid), new SqlParameter("@OrderStatus", drpStatus.SelectedItem.Text)); //calculate CalcualtePrices(); //insert into invoice dispatch id = (long)cls.ReturnScaler("Insert_InvoiceDispatch", new SqlParameter("@InvoiceId", Convert.ToInt32(invoiceid)), new SqlParameter("@InvoiceNumber", lblInvoiceNo.Text), new SqlParameter("@InvoiceNo", invno), new SqlParameter("@CourierName", drpCourier.SelectedItem.Text), new SqlParameter("@URL", drpCourier.SelectedValue.ToString()), new SqlParameter("@TrackingNumber", txtTrackingNo.Text), new SqlParameter("@InvoiceDate", cls.FormatDate_IND_US(txtDate.Text)), new SqlParameter("@Barcode", txtTrackingNo.Text), new SqlParameter("@OtherDetails", txtOtherDetails.Text), new SqlParameter("@InvoiceAmount", ViewState["InvoiceAmount"]), new SqlParameter("@InvoiceDiscountPer", ViewState["InvoiceDiscountPer"]), new SqlParameter("@InvoiceDiscountAmount", ViewState["InvoiceDiscountAmount"]), new SqlParameter("@InvoiceOriginalAmount", ViewState["InvoiceOriginalAmount"])); //insert into invoice dispatch product foreach (RepeaterItem ri in rptPendingproducts.Items) { CheckBox chk = (CheckBox)ri.FindControl("chk"); if (chk != null) { if (chk.Checked == true) { cls.ExecuteDA("Insert_InvoiceDispatchProduct", new SqlParameter("@InvoiceId", invoiceid), new SqlParameter("@InvoiceDispatchId", id), new SqlParameter("@ProductId", chk.ToolTip.ToString())); //update isdispatch in invoice product cls.ExecuteDA("Update_InvoiceProductIsDispatch", new SqlParameter("@InvoiceId", Convert.ToInt32(invoiceid)), new SqlParameter("@ProductId", chk.ToolTip.ToString()), new SqlParameter("@IsDispatched", 1)); } } } // create pdf and sending mail string invdisid = id.ToString(); string inid = Request.QueryString["ID"].ToString(); setPdfandMail(invdisid, inid); Response.Redirect("Orders.aspx"); } else { MsgBox("Please select product to generate invoice"); } }