protected void lb_SalesOrder_Released_Click(object sender, EventArgs e) { try { NetworkCredential NetCredentials = new NetworkCredential(); NetCredentials.UserName = ConfigurationManager.AppSettings["UserName"]; NetCredentials.Password = ConfigurationManager.AppSettings["Password"]; // Released Sales Order By Code unit function Web_Order_Mail objser1 = new Web_Order_Mail(); objser1.UseDefaultCredentials = true; objser1.Credentials = NetCredentials; objser1.ReleaseSalesOrder(Convert.ToString(ViewState["SalesOrder"])); objser1 = null; var message = new JavaScriptSerializer().Serialize("Sales Order No: " + Convert.ToString(ViewState["SalesOrder"]) + " has been released successfully."); var script = string.Format("alert({0});window.location='DashBoard.aspx';", message); ScriptManager.RegisterClientScriptBlock(Page, Page.GetType(), "", script, true); } catch (Exception ex) { var message = new JavaScriptSerializer().Serialize(ex.Message.ToString()); var script = string.Format("alert({0});", message); ScriptManager.RegisterClientScriptBlock(Page, Page.GetType(), "", script, true); } }
protected void btnCreate_Click(object sender, EventArgs e) { try { NetworkCredential NetCredentials = new NetworkCredential(); NetCredentials.UserName = SessionManager.GetNAVUserName(HttpContext.Current); NetCredentials.Password = SessionManager.GetNAVUserPassword(HttpContext.Current); Web_Order_Mail objser = new Web_Order_Mail(); objser.UseDefaultCredentials = true; objser.Credentials = NetCredentials; no = objser.CreateReleasedProductionOrder(drpItem.SelectedItem.Value, Convert.ToString(Session["NavUserName"])); objser = null; lblItemNo.Text = drpItem.SelectedItem.Value; lblItemDescription.Text = drpItem.SelectedItem.Text; lblItemNo.Visible = false; lblNo.Text = no; pnlHide.Visible = false; pnlShow.Visible = true; tblID.Visible = true; txtPostingDate.Focus(); } catch (Exception ex) { var message1 = new JavaScriptSerializer().Serialize(ex.Message.ToString()); var script1 = string.Format("alert({0});", message1); ScriptManager.RegisterClientScriptBlock(Page, Page.GetType(), "", script1, true); } }
public void ViewedOrder() { try { if (Request["OrderNo"].ToString() != "" && Request["OrderNo"].ToString() != null) { NetworkCredential NetCredentials = new NetworkCredential(); NetCredentials.UserName = ConfigurationManager.AppSettings["UserName"]; // "JCIL\\ADMINISTRATOR"; //"MSPL\\NAVTRN1"; // NetCredentials.Password = ConfigurationManager.AppSettings["Password"]; //"JCILADMIN@123"; //"admin@12"; // Web_Order_Mail objser = new Web_Order_Mail(); objser.UseDefaultCredentials = true; objser.Credentials = NetCredentials; objser.OrderViewed(Request["OrderNo"]); } else { } } catch (Exception ex) { var message = new JavaScriptSerializer().Serialize(ex.Message.ToString()); var script = string.Format("alert({0});", message); ScriptManager.RegisterClientScriptBlock(Page, Page.GetType(), "", script, true); } }
public void ShowShipmentCount() { try { NetworkCredential NetCredentials = new NetworkCredential(); NetCredentials.UserName = ConfigurationManager.AppSettings["UserName"]; NetCredentials.Password = ConfigurationManager.AppSettings["Password"]; Web_Order_Mail objser = new Web_Order_Mail(); objser.UseDefaultCredentials = true; objser.Credentials = NetCredentials; //string str; //str = Convert.ToInt32(objser.CountAgentsOutward(SessionManager.GetAgentCode(HttpContext.Current), Convert.ToInt32(ConfigurationManager.AppSettings["Agenttype"]))).ToString(); //if (str != null && str != "" && str != "0") //{ // lblShipmentNotification.Text = "( " + Convert.ToInt32(objser.CountAgentsOutward(SessionManager.GetAgentCode(HttpContext.Current), Convert.ToInt32(ConfigurationManager.AppSettings["Agenttype"]))).ToString() + " )*"; //} //else //{ // lblShipmentNotification.Text = ""; //} //objser = null; } catch (Exception ex) { var message = new JavaScriptSerializer().Serialize(ex.Message.ToString()); var script = string.Format("alert({0});window.location='DashBoard.aspx';", message); ScriptManager.RegisterClientScriptBlock(Page, Page.GetType(), "", script, true); //Response.Redirect("ThanksYouForSub.html"); } }
protected void Page_Load(object sender, EventArgs e) { try { NetworkCredential NetCredentials = new NetworkCredential(); NetCredentials.UserName = ConfigurationManager.AppSettings["UserName"]; NetCredentials.Password = ConfigurationManager.AppSettings["Password"]; if (Request["OrderNo"].ToString() != "") { Web_Order_Mail objser = new Web_Order_Mail(); objser.UseDefaultCredentials = true; objser.Credentials = NetCredentials; string str = ConfigurationManager.AppSettings["FilePath"] + objser.OrderConfirmationPrint(Convert.ToString(Request["OrderNo"].ToString())); Response.Clear(); Response.ContentType = "application/pdf"; Response.WriteFile(str); Response.Flush(); } } catch (Exception ex) { var message = new JavaScriptSerializer().Serialize(ex.Message.ToString()); var script = string.Format("alert({0});", message); ScriptManager.RegisterClientScriptBlock(Page, Page.GetType(), "", script, true); } }
protected void Page_Load(object sender, EventArgs e) { try { tblDate.Visible = true; tblMessage.Visible = false; if (!Page.IsPostBack) { if (Session["userName"] == null) { Response.Redirect("Login.aspx"); } else { NetworkCredential NetCredentials = new NetworkCredential(); NetCredentials.UserName = ConfigurationManager.AppSettings["UserName"]; NetCredentials.Password = ConfigurationManager.AppSettings["Password"]; Web_Order_Mail objser = new Web_Order_Mail(); objser.UseDefaultCredentials = true; objser.Credentials = NetCredentials; txtMail.Text = objser.GetAgentEmailAddr(SessionManager.GetAgentCode(HttpContext.Current)); } } } catch (Exception ex) { var message = new JavaScriptSerializer().Serialize(ex.Message.ToString()); var script = string.Format("alert({0});", message); ScriptManager.RegisterClientScriptBlock(Page, Page.GetType(), "", script, true); } }
//send for pdf protected void btnmail_Click(object sender, EventArgs e) { try { NetworkCredential NetCredentials = new NetworkCredential(); NetCredentials.UserName = ConfigurationManager.AppSettings["UserName"]; NetCredentials.Password = ConfigurationManager.AppSettings["Password"]; if (Request["CustomerNo"].ToString() != "") { if (txtStartDate.Text != null && txtEndDate.Text != null && txtEndDate.Text != "" && txtEndDate.Text != "" && txtMail.Text != "") { DateTime startdate = Convert.ToDateTime(txtStartDate.Text); DateTime enddate = Convert.ToDateTime(txtEndDate.Text); DateTime todayDate = DateTime.Now; if (IsValidEmailId(txtMail.Text)) { if (enddate < startdate) { var message = new JavaScriptSerializer().Serialize("End Date should not be less than Start Date."); var script = string.Format("alert({0});", message); ScriptManager.RegisterClientScriptBlock(Page, Page.GetType(), "", script, true); } else { Web_Order_Mail objser = new Web_Order_Mail(); objser.UseDefaultCredentials = true; objser.Credentials = NetCredentials; objser.SendMailforCustomerLedger(Convert.ToString(Request["CustomerNo"]), txtMail.Text, txtMail1.Text, startdate, enddate, Convert.ToBoolean(0)); txtEndDate.Text = ""; txtStartDate.Text = ""; txtMail.Text = ""; txtMail1.Text = ""; tblMessage.Visible = true; tblDate.Visible = false; } } else { Label1.Text = "Please enter Start date,End Date and Email."; Label1.Visible = true; } } else { Label1.Text = "Please enter Start date,End Date and Email."; Label1.Visible = true; } } } catch (Exception ex) { var message = new JavaScriptSerializer().Serialize(ex.Message.ToString()); var script = string.Format("alert({0});", message); ScriptManager.RegisterClientScriptBlock(Page, Page.GetType(), "", script, true); } }
public static string LoginCredential(string Username, string Password) { try { string Success = "Success"; string SuccessApp = "SuccessApp"; string Fail = "Fail"; Agent obj = Agent.LoginCredentials(Username, Password); if (obj != null) { HttpContext.Current.Session["userName"] = Username; SessionManager.AddToUserSession(HttpContext.Current, obj.Code, obj.AgentName); SessionManager.AddItemCategoryToSession(HttpContext.Current, obj.ItemCategoryCode); SessionManager.AddUserTypeSession(HttpContext.Current, obj.UserType); //SessionManager.AddLoginTimeSession(HttpContext.Current, Convert.ToDateTime(obj.LastLoginTime)); HttpContext.Current.Session["ItemCategoryCode"] = obj.ItemCategoryCode; // for updating the date time of the user login. .// added by Raj Shah 09/11/2016 try { NetworkCredential NetCredentials = new NetworkCredential(ConfigurationManager.AppSettings["UserName"], ConfigurationManager.AppSettings["Password"]); Web_Order_Mail objser1 = new Web_Order_Mail(); objser1.UseDefaultCredentials = true; objser1.Credentials = NetCredentials; //DateTime LastLoginTime = objser1.GetLastLoginDateTime(obj.LastLoginTime); SessionManager.AddLoginTimeSession(HttpContext.Current, Convert.ToDateTime(obj.LastLoginTime)); objser1.LastLoginLogoutDateTime(obj.Code, DateTime.Now, true); objser1 = null; } catch (Exception ex) { // not to throw error. } if (obj.AccountActivated == false) { return(SuccessApp); } else { return(Success); } } else { return(Fail); } } catch (Exception ex) { //throw ex; return(ex.Message); } }
protected void btnExcel_Download_Click(object sender, EventArgs e) { try { NetworkCredential NetCredentials = new NetworkCredential(); NetCredentials.UserName = ConfigurationManager.AppSettings["UserName"]; NetCredentials.Password = ConfigurationManager.AppSettings["Password"]; if (txtStartDate.Text != null && txtEndDate.Text != null && txtEndDate.Text != "" && txtEndDate.Text != "") { DateTime startdate = Convert.ToDateTime(txtStartDate.Text); DateTime enddate = Convert.ToDateTime(txtEndDate.Text); DateTime todayDate = DateTime.Now; if (enddate < startdate) { var message = new JavaScriptSerializer().Serialize("End Date should not be less than Start Date."); var script = string.Format("alert({0});", message); ScriptManager.RegisterClientScriptBlock(Page, Page.GetType(), "", script, true); } else { Web_Order_Mail objser = new Web_Order_Mail(); objser.UseDefaultCredentials = true; objser.Credentials = NetCredentials; string str = ConfigurationManager.AppSettings["FilePath"] + objser.CustomerLedgerPrint(Convert.ToString(Request["CustomerNo"]), Convert.ToDateTime(startdate), Convert.ToDateTime(enddate), Convert.ToBoolean(1)); hf_Excel.Value = str; ClientScript.RegisterStartupScript(GetType(), "Javascript", "javascript: AddPathExcel(); ", true); Response.Clear(); Response.ContentType = "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet"; Response.AppendHeader("content-disposition", "attachment; filename=\"" + str + "\""); Response.WriteFile(str); Response.Flush(); Response.End(); Response.Close(); } } else { lblMessage.Text = "Please enter Start date and End Date both."; lblMessage.Visible = true; } } catch (Exception ex) { var message = new JavaScriptSerializer().Serialize(ex.Message.ToString()); var script = string.Format("alert({0});", message); ScriptManager.RegisterClientScriptBlock(Page, Page.GetType(), "", script, true); } }
public void StatisticData() { try { // Called SalesOrderStatistic function Codeunit Function. SalesOrderStatistics so = new SalesOrderStatistics(); NetworkCredential NetCredentials = new NetworkCredential(); NetCredentials.UserName = ConfigurationManager.AppSettings["UserName"]; NetCredentials.Password = ConfigurationManager.AppSettings["Password"]; Web_Order_Mail objser1 = new Web_Order_Mail(); objser1.UseDefaultCredentials = true; objser1.Credentials = NetCredentials; objser1.SalesOrderStatistics(Convert.ToString(Request.QueryString["SalesOrder"])); objser1 = null; // Filter with Sales Order No and Fetched Statistic Data SalesOrderStatistics_Service objso = new SalesOrderStatistics_Service(); objso.UseDefaultCredentials = true; objso.Credentials = NetCredentials; List <SalesOrderStatistics_Filter> filterArray = new List <SalesOrderStatistics_Filter>(); SalesOrderStatistics_Filter Filter = new SalesOrderStatistics_Filter(); Filter.Field = SalesOrderStatistics_Fields.No; Filter.Criteria = Convert.ToString(Request.QueryString["SalesOrder"]); filterArray.Add(Filter); SalesOrderStatistics[] ListData = objso.ReadMultiple(filterArray.ToArray(), null, 1); if (ListData.Length > 0) { lbl_Amt_Excl_VAT.Text = (ListData[0].TotalSalesLine1_Line_Amount).ToString("0.00"); lbl_Total_Excl_VAT.Text = (ListData[0].TotalAmount11).ToString("0.00"); lbl_Charges_Amt.Text = (ListData[0].TotalSalesLine1_Charges_To_Customer).ToString("0.00"); lbl_Tax_Amt.Text = (ListData[0].TotalSalesLine1_Tax_Amount).ToString("0.00"); lbl_Net_total.Text = (ListData[0].TotalSalesLine1_Amount_To_Customer).ToString("0.00"); lbl_Excise_Amt.Text = (ListData[0].TotalSalesLine1_Excise_Amount).ToString("0.00"); } objso = null; so = null; } catch (Exception ex) { var message = new JavaScriptSerializer().Serialize(ex.Message.ToString()); var script = string.Format("alert({0});", message); ScriptManager.RegisterClientScriptBlock(Page, Page.GetType(), "", script, true); } }
protected void Bnt_SendMail_Click(object sender, EventArgs e) { try { NetworkCredential NetCredentials = new NetworkCredential(); NetCredentials.UserName = ConfigurationManager.AppSettings["UserName"]; NetCredentials.Password = ConfigurationManager.AppSettings["Password"]; if (txt_UserId.Text != null && txt_EmailId.Text != null && txt_UserId.Text != "" && txt_EmailId.Text != "") { Web_Order_Mail objser = new Web_Order_Mail(); objser.UseDefaultCredentials = true; objser.Credentials = NetCredentials; Boolean bol = objser.SendVerificationCode(txt_UserId.Text, txt_EmailId.Text); if (bol == true) { Response.Write("<script language='javascript'>window.alert('Verification code has been sent successfully in your mail.');</script>"); ShowSection2(); } else { Response.Write("<script language='javascript'>window.alert('Please enter valid User Id and E-mail Id.');</script>"); txt_UserId.Text = string.Empty; txt_EmailId.Text = string.Empty; } } else { Response.Write("<script language='javascript'>window.alert('Please enter User Id and E-mail Id.');</script>"); } } catch (Exception ex) { var message = new JavaScriptSerializer().Serialize(ex.Message.ToString()); var script = string.Format("alert({0});", message); ScriptManager.RegisterClientScriptBlock(Page, Page.GetType(), "", script, true); } }
protected void btnSave_Click(object sender, EventArgs e) { try { NetworkCredential NetCredentials = new NetworkCredential(); NetCredentials.UserName = SessionManager.GetNAVUserName(HttpContext.Current); NetCredentials.Password = SessionManager.GetNAVUserPassword(HttpContext.Current); ItemTrackDetails.DataSource = getTrackList(); ItemTrackDetails.DataBind(); foreach (RepeaterItem itemEquipment in ItemTrackDetails.Items) { string lblLotNo = (itemEquipment.FindControl("lblLotNo") as Label).Text; string Qty = (itemEquipment.FindControl("lblQty") as Label).Text; string lblDimenItem = (itemEquipment.FindControl("lblDimenItem") as Label).Text; Decimal quantity = 0; if (Qty != null && Qty != "") { if (Qty != null) { quantity = Convert.ToDecimal(Qty); } Web_Order_Mail objser = new Web_Order_Mail(); objser.UseDefaultCredentials = true; objser.Credentials = NetCredentials; objser.CreateItemJournal(1, Request.QueryString["No"], Convert.ToDecimal(Qty), string.Empty, lblDimenItem, Convert.ToDateTime(txtPostingDate.Text), Convert.ToDateTime(txtDocumentDate.Text), Convert.ToString(Session["NavUserName"]), lblLotNo); objser = null; } } } catch (Exception ex) { var message1 = new JavaScriptSerializer().Serialize(ex.Message.ToString()); var script1 = string.Format("alert({0});", message1); ScriptManager.RegisterClientScriptBlock(Page, Page.GetType(), "", script1, true); } }
protected void Btn_Submit_Click(object sender, EventArgs e) { try { NetworkCredential NetCredentials = new NetworkCredential(); NetCredentials.UserName = ConfigurationManager.AppSettings["UserName"]; NetCredentials.Password = ConfigurationManager.AppSettings["Password"]; if (txt_VerifyCode.Text != null && txt_ConfirmPwd.Text != null && txtRe_ConfirmPwd.Text != null) { Web_Order_Mail objser = new Web_Order_Mail(); objser.UseDefaultCredentials = true; objser.Credentials = NetCredentials; Boolean bol1 = objser.IsVarified(txt_UserId1.Text, txt_VerifyCode.Text, txt_ConfirmPwd.Text); if (bol1 == true) { Response.Write("<script language='javascript'>window.alert('Password has been changed successfully.');window.location='LogIn.aspx';</script>"); ClearData(); } else { Response.Write("<script language='javascript'>window.alert('Please check your verification code.');</script>"); } } else { Response.Write("<script language='javascript'>window.alert('Please enter Verification Code, Confirm-Password and Reconfirm-Password.');</script>"); } } catch (Exception ex) { var message = new JavaScriptSerializer().Serialize(ex.Message.ToString()); var script = string.Format("alert({0});window.location='DashBoard.aspx';", message); ScriptManager.RegisterClientScriptBlock(Page, Page.GetType(), "", script, true); } }
protected void lb_Modify_Click(object sender, EventArgs e) { Boolean flag = false; NetworkCredential NetCredentials = new NetworkCredential(); NetCredentials.UserName = ConfigurationManager.AppSettings["UserName"]; NetCredentials.Password = ConfigurationManager.AppSettings["Password"]; try { foreach (RepeaterItem item in rpt_Cart.Items) { HiddenField hf_ProductCode = (HiddenField)item.FindControl("hf_ProductCode"); TextBox tb_ProductName = (TextBox)item.FindControl("tb_ProductName"); HiddenField dd_UOM = (HiddenField)item.FindControl("hf_UOM"); TextBox tb_Qty = (TextBox)item.FindControl("tb_Qty"); TextBox tb_Price = (TextBox)item.FindControl("tb_Price"); TextBox tb_CPrice = (TextBox)item.FindControl("txt_Customerprice"); DropDownList dd_Variant = (DropDownList)item.FindControl("dd_Variant"); TextBox tb_Remark = (TextBox)item.FindControl("tb_Remark"); TextBox tb_Discount = (TextBox)item.FindControl("tb_Discount"); TextBox tb_Total = (TextBox)item.FindControl("tb_Total"); HiddenField hf_QuantityShipped = (HiddenField)item.FindControl("hf_QuantityShipped"); HiddenField hf_OutStandingQty = (HiddenField)item.FindControl("hf_OutStandingQty"); HiddenField hf_CustomerPriceGroup = (HiddenField)item.FindControl("hf_CustomerPriceGroup") as HiddenField; if (Convert.ToDecimal(hf_QuantityShipped.Value) > 0) { if (tb_Qty.Text != string.Empty) { string Qty = Convert.ToString(VaraintQtyforProduct(hf_ProductCode.Value, dd_Variant.SelectedItem.Text, hf_CustomerPriceGroup.Value)); decimal mod = Convert.ToDecimal(tb_Qty.Text) % Convert.ToDecimal(Qty); if (mod > 0) { ScriptManager.RegisterStartupScript(this, GetType(), "showalert", "alert('Please enter quantity in multiple of variant code.');", true); flag = false; tb_Qty.Focus(); tb_Qty.Text = string.Empty; break; } else { Web_Order_Mail objser = new Web_Order_Mail(); objser.UseDefaultCredentials = true; objser.Credentials = NetCredentials; objser.UpdateBanketSalesLineQty(Convert.ToString(Request["BlanketOrderNo"]), Convert.ToInt32(Request["LineNo"]), Convert.ToDecimal(tb_Qty.Text)); objser = null; Web_Order_Mail objser1 = new Web_Order_Mail(); objser1.UseDefaultCredentials = true; objser1.Credentials = NetCredentials; objser1.UpdateSalesLineQty(Convert.ToString(Request["OrderNo"]), Convert.ToInt32(Request["LineNo"]), Convert.ToDecimal(tb_Qty.Text)); objser1 = null; flag = true; } } else { ScriptManager.RegisterStartupScript(this, GetType(), "showalert", "alert('Please enter quantity.');", true); flag = false; tb_Qty.Focus(); break; } } else { decimal amt = Convert.ToDecimal(Convert.ToDecimal(tb_Qty.Text) * Convert.ToDecimal(tb_CPrice.Text)); decimal totalamount = Convert.ToDecimal(amt); if (tb_Qty.Text != null && tb_CPrice.Text != null) { if (Convert.ToDecimal(tb_CPrice.Text) < Convert.ToDecimal(tb_Price.Text)) { ScriptManager.RegisterStartupScript(this, GetType(), "showalert", "alert('Please enter price above base price.');", true); flag = false; tb_CPrice.Focus(); tb_CPrice.Text = string.Empty; break; } else { string Qty = Convert.ToString(VaraintQtyforProduct(hf_ProductCode.Value, dd_Variant.SelectedItem.Text, hf_CustomerPriceGroup.Value)); decimal mod = Convert.ToDecimal(tb_Qty.Text) % Convert.ToDecimal(Qty); if (mod > 0) { ScriptManager.RegisterStartupScript(this, GetType(), "showalert", "alert('Please enter quantity in multiple of variant code.');", true); flag = false; tb_Qty.Focus(); tb_Qty.Text = string.Empty; break; } else { decimal d = Convert.ToDecimal(tb_Price.Text) * 15 / 100; d = Convert.ToDecimal(tb_Price.Text) + d; if (Convert.ToDecimal(tb_CPrice.Text) >= d) { ClientScript.RegisterStartupScript(GetType(), "Javascript", "javascript: fnShowMessage(); ", true); flag = false; tb_CPrice.Focus(); tb_CPrice.Text = string.Empty; break; } else { flag = true; //Update Blanket Order due to updating Qty in blanket Order as well as Sales Order Web_Order_Mail objser2 = new Web_Order_Mail(); objser2.UseDefaultCredentials = true; objser2.Credentials = NetCredentials; objser2.UpdateSalesLine(Convert.ToString(Request["BlanketOrderNo"]), Convert.ToInt32(Request["LineNo"]), hf_ProductCode.Value, dd_Variant.SelectedItem.Text, dd_UOM.Value, Convert.ToDecimal(tb_Qty.Text), Convert.ToDecimal(tb_CPrice.Text), tb_Remark.Text); objser2 = null; // Update SalesOrder Lines Details. Web_Order_Mail objser1 = new Web_Order_Mail(); objser1.UseDefaultCredentials = true; objser1.Credentials = NetCredentials; objser1.UpdateSalesLine(Convert.ToString(Request["OrderNo"]), Convert.ToInt32(Request["LineNo"]), hf_ProductCode.Value, dd_Variant.SelectedItem.Text, dd_UOM.Value, Convert.ToDecimal(tb_Qty.Text), Convert.ToDecimal(tb_CPrice.Text), tb_Remark.Text); objser1 = null; } } } } else { var message = new JavaScriptSerializer().Serialize("Quantity or Bill Price should not be blank or zero."); var script = string.Format("alert({0});", message); ScriptManager.RegisterClientScriptBlock(Page, Page.GetType(), "", script, true); } } if (flag == false) { } else { //ScriptManager.RegisterStartupScript(this, GetType(), "showalert", "alert('Record updated successfully.');window.location ='OrderModificationView.aspx';", true); Response.Redirect("OrderModificationView.aspx?OrderNo=" + Request["OrderNo"].ToString() + "&BlanketOrderNo=" + Convert.ToString(Request["BlanketOrderNo"]) + "&PostingDate=" + Convert.ToString(Request.QueryString["PostingDate"]), false); } } } catch (Exception ex) { var message = new JavaScriptSerializer().Serialize(ex.Message.ToString()); var script = string.Format("alert({0});", message); ScriptManager.RegisterClientScriptBlock(Page, Page.GetType(), "", script, true); } }
protected void lb_Finish_Click(object sender, EventArgs e) { CheckBox chk = sender as CheckBox; RepeaterItem ri = chk.NamingContainer as RepeaterItem; if (ri != null) { Label tb_Qty1 = ri.FindControl("tdAmt") as Label; TextBox txtPrice = ri.FindControl("txtAmounttoVerify") as TextBox; CheckBox chk1 = ri.FindControl("chk_Select") as CheckBox; if (chk1.Checked == true) { } } try { NetworkCredential NetCredentials = new NetworkCredential(); NetCredentials.UserName = ConfigurationManager.AppSettings["UserName"]; // "JCIL\\ADMINISTRATOR"; //"MSPL\\NAVTRN1"; // NetCredentials.Password = ConfigurationManager.AppSettings["Password"]; //"JCILADMIN@123"; //"admin@12"; // Web_Order_Mail objser1 = new Web_Order_Mail(); objser1.UseDefaultCredentials = true; objser1.Credentials = NetCredentials; string bankname = string.Empty; string bankbranch = string.Empty; string modeofpayment = string.Empty; decimal amount = 0; string accountno = string.Empty; string customerno = Convert.ToString(Request["Customer"]); DateTime d = Convert.ToDateTime(txtDate.Text); if (tb_BankName.Text != "" && tb_BankName.Text != string.Empty) { bankname = tb_BankName.Text; } if (txt_BankBranch.Text != "" && txt_BankBranch.Text != string.Empty) { bankbranch = txt_BankBranch.Text; } if (drpModeofPayment.SelectedItem.Text != "") { modeofpayment = drpModeofPayment.SelectedItem.Text; } if (txt_PaymentAmount.Text != "" && txt_PaymentAmount.Text != string.Empty) { amount = Convert.ToDecimal(txt_PaymentAmount.Text); } if (txtAccountNo.Text != "" && txtAccountNo.Text != string.Empty) { accountno = txtAccountNo.Text; } if (txtDate.Text != "" && txtDate.Text != string.Empty) { d = Convert.ToDateTime(txtDate.Text); } //string strdata = objser1.SendRTGSForm(bankname, bankbranch, modeofpayment, amount, accountno, customerno, d, Convert.ToString(rnd.Next(1, 10000))); objser1 = null; } catch (Exception ex) { throw ex; } }
//private void BindTextGroupCode(string TextGroupCode, DropDownList dd_TextGroupCode) //{ // try // { // List<ProductCat> list = ProductCat.ListTextGroupCode(); // if (list != null && list.Count > 0) // { // dd_TextGroupCode.DataSource = list; // dd_TextGroupCode.DataTextField = "Code"; // dd_TextGroupCode.DataValueField = "Code"; // dd_TextGroupCode.DataBind(); // dd_TextGroupCode.Items.Insert(0, new ListItem("-Select-", "0")); // } // else // { // dd_TextGroupCode.DataSource = null; // dd_TextGroupCode.DataBind(); // } // } // catch (Exception ex) // { // l_Error.Text = ex.Message; // l_Error.Visible = true; // } //} public void btn_Update(object sender, EventArgs e) { try { Boolean flag = false; if (drpNoseries.SelectedIndex == 0) { ScriptManager.RegisterStartupScript(this, GetType(), "showalert", "alert('Please select sales order no series.');", true); } else if (drpStructure.SelectedIndex == 0) { ScriptManager.RegisterStartupScript(this, GetType(), "showalert", "alert('Please select structure.');", true); } else if (drpProductCode.SelectedIndex == 0) { ScriptManager.RegisterStartupScript(this, GetType(), "showalert", "alert('Please select Product code.');", true); } else if (txtDestination.Text == "") { ScriptManager.RegisterStartupScript(this, GetType(), "showalert", "alert('Please enter Destination.');", true); } else if (drplocationcode.SelectedIndex == 0) { ScriptManager.RegisterStartupScript(this, GetType(), "showalert", "alert('Please select Location code.');", true); } else { NetworkCredential NetCredentials = new NetworkCredential(); NetCredentials.UserName = ConfigurationManager.AppSettings["UserName"]; NetCredentials.Password = ConfigurationManager.AppSettings["Password"]; foreach (RepeaterItem item in rpt_FinalCart.Items) { HiddenField ItemNo = (HiddenField)item.FindControl("hf_ItemNo"); HiddenField LineNo = (HiddenField)item.FindControl("hf_LineNo"); TextBox Qty_to_Ship = (TextBox)item.FindControl("Qty_to_Ship"); TextBox tb_Discount = (TextBox)item.FindControl("tb_discount"); Label lbl_QTY = (Label)item.FindControl("lbl_QTY"); DropDownList dd_TaxAreaCode = (DropDownList)item.FindControl("dd_TaxAreaCode"); TextBox dd_TaxGroupCode = (TextBox)item.FindControl("dd_TaxGroupCode"); DropDownList dd_Excise_PostingGrpCode = (DropDownList)item.FindControl("dd_Excise_PostingGrpCode"); Label lbl_SalesOrderNo = (Label)item.FindControl("lbl_SalesOrderNo"); Label lbl_home_logo = (Label)item.FindControl("lbl_home_logo"); if (Qty_to_Ship.Text == "") { ScriptManager.RegisterStartupScript(this, GetType(), "showalert", "alert('Quantity to Ship should not be allowed blank.');", true); flag = true; } else if (Convert.ToDecimal(Qty_to_Ship.Text) == 0) { ScriptManager.RegisterStartupScript(this, GetType(), "showalert", "alert('Quantity to Ship should not be allowed zero.');", true); Qty_to_Ship.Focus(); flag = true; } else if (Convert.ToDecimal(Qty_to_Ship.Text) > Convert.ToDecimal(lbl_QTY.Text)) { ScriptManager.RegisterStartupScript(this, GetType(), "showalert", "alert('Quantity to Ship should not be greater than Order Quantity.');", true); Qty_to_Ship.Focus(); flag = true; } else if (Convert.ToString(tb_Discount.Text) == "") { ScriptManager.RegisterStartupScript(this, GetType(), "showalert", "alert('Discount should not be allowed blank.');", true); tb_Discount.Focus(); tb_Discount.Text = Convert.ToString(0); flag = true; } //else if (dd_TaxGroupCode.SelectedIndex == 0) //{ // ScriptManager.RegisterStartupScript(this, GetType(), "showalert", "alert('Please select Tax Group Code.');", true); // flag = true; //} else if (dd_Excise_PostingGrpCode.SelectedIndex == 0) { ScriptManager.RegisterStartupScript(this, GetType(), "showalert", "alert('Please select Excise Group Code.');", true); flag = true; } else { string str = string.Empty; if (drpFormCode.SelectedIndex == 0) { str = ""; } else { str = Convert.ToString(drpFormCode.SelectedValue); } // Update Values of Blanket Sales Order by Codeunit Function. Web_Order_Mail objser1 = new Web_Order_Mail(); objser1.UseDefaultCredentials = true; objser1.Credentials = NetCredentials; objser1.UpdateBlanketOrder(Convert.ToString(Request.QueryString["OrderNo"]), string.Empty, drpProductCode.SelectedItem.Value, drpStructure.SelectedItem.Value, txtTransporterName.Text, drpNoseries.SelectedItem.Value, txtDestination.Text, Convert.ToString(str), drplocationcode.SelectedValue); objser1 = null; // Update Quantity to ship in Sales Order by Codeunit Function. Web_Order_Mail objser = new Web_Order_Mail(); objser.UseDefaultCredentials = true; objser.Credentials = NetCredentials; objser.UpdateQtyToShip(Convert.ToString(Request.QueryString["OrderNo"]), Convert.ToInt32(LineNo.Value), Convert.ToDecimal(Qty_to_Ship.Text), Convert.ToDecimal(tb_Discount.Text), string.Empty, Convert.ToString(dd_TaxGroupCode.Text), Convert.ToString(dd_Excise_PostingGrpCode.SelectedItem.Value)); objser = null; } } if (flag == true) { } else { // Release Blanket Sales Order by Codeunit Function. Web_Order_Mail objservice = new Web_Order_Mail(); objservice.UseDefaultCredentials = true; objservice.Credentials = NetCredentials; objservice.ReleaseBlanketOrder(Convert.ToString(Request.QueryString["OrderNo"])); objservice = null; // Make Order By Codeunit Function Return with OrderNo. Web_Order_Mail objser2 = new Web_Order_Mail(); objser2.UseDefaultCredentials = true; objser2.Credentials = NetCredentials; string MakeOrderNo = objser2.MakeOrder(4, Convert.ToString(Request.QueryString["OrderNo"])); objser2 = null; //lb_Update.Visible = false; //lb_Satistic.Visible = true; //lbl_home_logo.Visible = false; lb_Update.Visible = false; lb_Satistic.Visible = true; // lbl_home_logo.Visible = false; lbl_SalesOrderNo.Visible = true; lblOrderNo.Visible = false; blanketOrder_tr.Visible = true; lbl_blk_No.Text = Convert.ToString(Request.QueryString["OrderNo"]); ViewState["SalesOrder"] = Convert.ToString(MakeOrderNo); lbl_SalesOrderNo.Text = Convert.ToString(MakeOrderNo); var message = new JavaScriptSerializer().Serialize("Order has been successfully updated and Sales Order generated - Sales Order No. " + MakeOrderNo.ToString() + ""); var script = string.Format("alert({0});", message); ScriptManager.RegisterClientScriptBlock(Page, Page.GetType(), "", script, true); } } } catch (Exception ex) { string IsSalesOrderExist = string.Empty; NetworkCredential NetCredentials = new NetworkCredential(); NetCredentials.UserName = ConfigurationManager.AppSettings["UserName"]; NetCredentials.Password = ConfigurationManager.AppSettings["Password"]; Web_Order_Mail objservice = new Web_Order_Mail(); objservice.UseDefaultCredentials = true; objservice.Credentials = NetCredentials; IsSalesOrderExist = objservice.IsOrderExistfromBlanketOrder(Convert.ToString(Request.QueryString["OrderNo"])); if (IsSalesOrderExist != "") { lb_Update.Visible = false; lb_Satistic.Visible = true; ViewState["SalesOrder"] = Convert.ToString(IsSalesOrderExist); objservice.ReleaseBlanketOrder(Convert.ToString(Request.QueryString["OrderNo"])); objservice = null; var message = new JavaScriptSerializer().Serialize("Order has been successfully updated and Sales Order generated - Sales Order No. " + IsSalesOrderExist.ToString() + ""); var script = string.Format("alert({0});", message); ScriptManager.RegisterClientScriptBlock(Page, Page.GetType(), "", script, true); } else { objservice.ReOpenOrder(Convert.ToString(Request.QueryString["OrderNo"])); objservice = null; lb_Update.Visible = true; lb_Satistic.Visible = false; var message = new JavaScriptSerializer().Serialize(ex.Message.ToString()); var script = string.Format("alert({0});", message); ScriptManager.RegisterClientScriptBlock(Page, Page.GetType(), "", script, true); } //var message = new JavaScriptSerializer().Serialize(ex.Message.ToString()); //var script = string.Format("alert({0});", message); //ScriptManager.RegisterClientScriptBlock(Page, Page.GetType(), "", script, true); } }
protected void lb_Modify_Click(object sender, EventArgs e) { Boolean flag = false; NetworkCredential NetCredentials = new NetworkCredential(); NetCredentials.UserName = ConfigurationManager.AppSettings["UserName"]; NetCredentials.Password = ConfigurationManager.AppSettings["Password"]; try { foreach (RepeaterItem item in rpt_Cart.Items) { HiddenField hf_ProductCode = (HiddenField)item.FindControl("hf_ProductCode"); TextBox tb_ProductName = (TextBox)item.FindControl("tb_ProductName"); HiddenField dd_UOM = (HiddenField)item.FindControl("hf_UOM"); TextBox tb_Qty = (TextBox)item.FindControl("tb_Qty"); TextBox txtSellingPrice = (TextBox)item.FindControl("txtSellingPrice"); DropDownList dd_Variant = (DropDownList)item.FindControl("dd_Variant"); TextBox tb_Remark = (TextBox)item.FindControl("tb_Remark"); HiddenField hf_QuantityShipped = (HiddenField)item.FindControl("hf_QuantityShipped"); HiddenField hf_OutStandingQty = (HiddenField)item.FindControl("hf_OutStandingQty"); HiddenField CustomerId = (HiddenField)item.FindControl("hf_SelltoCustomerNo") as HiddenField; HiddenField ConsigneeId = (HiddenField)item.FindControl("hf_ShiptoCode") as HiddenField; HiddenField hf_CustomerPriceGroup = (HiddenField)item.FindControl("hf_CustomerPriceGroup") as HiddenField; if (string.IsNullOrEmpty(ConsigneeId.Value)) { ConsigneeId.Value = CustomerId.Value; } string s = Convert.ToString(PriceforProduct(hf_ProductCode.Value, dd_Variant.SelectedItem.Text, hf_CustomerPriceGroup.Value, CustomerId.Value, ConsigneeId.Value)); decimal amt = Convert.ToDecimal(Convert.ToDecimal(tb_Qty.Text) * Convert.ToDecimal(txtSellingPrice.Text)); decimal totalamount = Convert.ToDecimal(amt); string ConsumerPrice = Convert.ToString(ConsumerPriceforProduct(hf_ProductCode.Value, dd_Variant.SelectedItem.Text)); decimal ConsPriceIncPercentage = 0; ConsPriceIncPercentage = Convert.ToDecimal(ConsumerPrice) + (Convert.ToDecimal(ConsumerPrice) * Convert.ToDecimal(ConfigurationManager.AppSettings["ConsumerPriceIncreasePercentage"]) / 100); if (tb_Qty.Text != null && txtSellingPrice.Text != null) { if (Convert.ToDecimal(ConsPriceIncPercentage) > 0) { if (Convert.ToDecimal(txtSellingPrice.Text) > Convert.ToDecimal(ConsPriceIncPercentage)) { ScriptManager.RegisterStartupScript(this, GetType(), "showalert", "alert('Bill Price exceeds permissible limit.');", true); txtSellingPrice.Focus(); var script = String.Format("document.getElementById('{0}').select();", txtSellingPrice.ClientID); ClientScript.RegisterStartupScript(GetType(), "focus", script, true); } else if (Convert.ToDecimal(txtSellingPrice.Text) < Convert.ToDecimal(s)) { ScriptManager.RegisterStartupScript(this, GetType(), "showalert", "alert('Bill Price below permissible limit.');", true); txtSellingPrice.Focus(); var script = String.Format("document.getElementById('{0}').select();", txtSellingPrice.ClientID); ClientScript.RegisterStartupScript(GetType(), "focus", script, true); } else { string Qty = Convert.ToString(VaraintQtyforProduct(hf_ProductCode.Value, dd_Variant.SelectedItem.Text)); decimal mod = Convert.ToDecimal(tb_Qty.Text) % Convert.ToDecimal(Qty); if (mod > 0) { ScriptManager.RegisterStartupScript(this, GetType(), "showalert", "alert('Please enter quantity in multiple of variant code.');", true); flag = false; tb_Qty.Focus(); tb_Qty.Text = string.Empty; break; } else { flag = true; //Update Blanket Order due to updating Qty in blanket Order as well as Sales Order Web_Order_Mail objser2 = new Web_Order_Mail(); objser2.UseDefaultCredentials = true; objser2.Credentials = NetCredentials; objser2.UpdateSalesLine(Convert.ToString(Request["OrderNo"]), Convert.ToInt32(Request["LineNo"]), hf_ProductCode.Value, dd_Variant.SelectedItem.Text, dd_UOM.Value, Convert.ToDecimal(tb_Qty.Text), Convert.ToDecimal(txtSellingPrice.Text), tb_Remark.Text); objser2 = null; } } } } if (flag == false) { } else { Response.Redirect("BlanketOrderModificationView.aspx?OrderNo=" + Request["OrderNo"].ToString() + "&BlanketOrderNo=" + Convert.ToString(Request["BlanketOrderNo"]) + "&PostingDate=" + Convert.ToString(Request.QueryString["PostingDate"]), false); } } } catch (Exception ex) { var message = new JavaScriptSerializer().Serialize(ex.Message.ToString()); var script = string.Format("alert({0});", message); ScriptManager.RegisterClientScriptBlock(Page, Page.GetType(), "", script, true); } }
protected void btnSave_Click(object sender, EventArgs e) { if (ViewState["Indicator"] != null) { indicatorofOutputPosted = true; } if (!Regex.IsMatch(txtPostingDate.Text, "(((0|1)[0-9]|2[0-9]|3[0-1])\\/(0[1-9]|1[0-2])\\/((19|20)\\d\\d))$") || !Regex.IsMatch(txtDocumentDate.Text, "(((0|1)[0-9]|2[0-9]|3[0-1])\\/(0[1-9]|1[0-2])\\/((19|20)\\d\\d))$")) { var message1 = new JavaScriptSerializer().Serialize("Not Valid dates!!!"); var script1 = string.Format("alert({0});", message1); ScriptManager.RegisterClientScriptBlock(Page, Page.GetType(), "", script1, true); } else { foreach (GridViewRow g1 in gvOutput.Rows) { string Qty = (g1.FindControl("txtOut") as TextBox).Text; if (Qty != null && Qty != "") { OpSum = OpSum + Convert.ToDecimal(Qty); } lblOutputSum.Text = ":" + Convert.ToString(OpSum); } foreach (GridViewRow g1 in gvCons.Rows) { string Qty = (g1.FindControl("txtCons") as TextBox).Text; if (Qty != null && Qty != "") { ConsSum = ConsSum + Convert.ToDecimal(Qty); } lblConsumptionTotal.Text = ":" + Convert.ToString(ConsSum); } if (OpSum == ConsSum) { NetworkCredential NetCredentials = new NetworkCredential(); NetCredentials.UserName = SessionManager.GetNAVUserName(HttpContext.Current); NetCredentials.Password = SessionManager.GetNAVUserPassword(HttpContext.Current); try { if (indicatorofOutputPosted == false) { foreach (GridViewRow g1 in gvOutput.Rows) { string code = (g1.FindControl("lblDimCode1") as Label).Text; string Qty = (g1.FindControl("txtOut") as TextBox).Text; Decimal quantity = 0; if (Qty != null && Qty != "") { if (Qty != null) { quantity = Convert.ToDecimal(Qty); } Web_Order_Mail objser = new Web_Order_Mail(); objser.UseDefaultCredentials = true; objser.Credentials = NetCredentials; // 0 = output objser.CreateItemJournal(0, lblNo.Text, quantity, code, lblItemNo.Text, Convert.ToDateTime(txtPostingDate.Text), Convert.ToDateTime(txtDocumentDate.Text), Convert.ToString(Session["NavUserName"]), string.Empty); objser = null; } } // posted the entry for output Web_Order_Mail objserv = new Web_Order_Mail(); objserv.UseDefaultCredentials = true; objserv.Credentials = NetCredentials; indicatorofOutputPosted = objserv.PostItemJournal(0); objserv = null; } try { foreach (GridViewRow g1 in gvCons.Rows) { string code = (g1.FindControl("lblDimCode2") as Label).Text; string Qty = (g1.FindControl("txtCons") as TextBox).Text; if (Qty != null && Qty != "") { Decimal quantity = Convert.ToDecimal(Qty); Web_Order_Mail objser = new Web_Order_Mail(); objser.UseDefaultCredentials = true; objser.Credentials = NetCredentials; // 1 = Consumption objser.CreateItemJournal(1, lblNo.Text, quantity, code, lblItemNo.Text, Convert.ToDateTime(txtPostingDate.Text), Convert.ToDateTime(txtDocumentDate.Text), Convert.ToString(Session["NavUserName"]), string.Empty); objser = null; } } // Consumption post Web_Order_Mail objservc = new Web_Order_Mail(); objservc.UseDefaultCredentials = true; objservc.Credentials = NetCredentials; bool i = objservc.PostItemJournal(1); objservc = null; } catch (Exception ex) { ViewState["Indicator"] = true; var message1 = new JavaScriptSerializer().Serialize(ex.Message.ToString()); var script1 = string.Format("alert({0});", message1); ScriptManager.RegisterClientScriptBlock(Page, Page.GetType(), "", script1, true); } var messagefordi1 = new JavaScriptSerializer().Serialize("Production Order :" + lblNo.Text + " : Output and Consumption entries are posted successfully.!!!"); var scriptForview = string.Format("alert({0});window.location='ShowRlsProductOdr.aspx';", messagefordi1); ScriptManager.RegisterClientScriptBlock(Page, Page.GetType(), "", scriptForview, true); } catch (Exception ex) { //ViewState["Indicator"] = true; var message1 = new JavaScriptSerializer().Serialize(ex.Message.ToString()); var script1 = string.Format("alert({0});", message1); ScriptManager.RegisterClientScriptBlock(Page, Page.GetType(), "", script1, true); } } else { var message1 = new JavaScriptSerializer().Serialize("Sum of Output and Consumption must be same!!!"); var script1 = string.Format("alert({0});", message1); ScriptManager.RegisterClientScriptBlock(Page, Page.GetType(), "", script1, true); } } }
protected void btn_Submit_Click(object sender, EventArgs e) { try { //Deleting Blank Lines of Gridview DataTable dtCurrentTable = (DataTable)ViewState["CurrentTable"]; Boolean flag = true; for (int i = dtCurrentTable.Rows.Count - 1; i >= 0; i--) { if (dtCurrentTable.Rows[i]["CustomerName"].ToString() == string.Empty && dtCurrentTable.Rows[i]["Location"].ToString() == string.Empty && dtCurrentTable.Rows[i]["ItemList"].ToString() == Convert.ToString(0)) { dtCurrentTable.Rows[i].Delete(); } else if (dtCurrentTable.Rows[i]["CustomerName"].ToString() == string.Empty && dtCurrentTable.Rows[i]["ItemList"].ToString() == Convert.ToString(0)) { dtCurrentTable.Rows[i].Delete(); } } dtCurrentTable.AcceptChanges(); DataTable dt = dtCurrentTable; //Deleting Blank Lines of Gridview //Checked validations of Gridview fields for (int i = 0; i < dtCurrentTable.Rows.Count; i++) { TextBox lb_CustomerName = (TextBox)Gridview3.Rows[i].Cells[1].FindControl("lb_CustomerName"); TextBox lb_Location = (TextBox)Gridview3.Rows[i].Cells[2].FindControl("lb_Location"); TextBox lb_Quantity = (TextBox)Gridview3.Rows[i].Cells[7].FindControl("lb_Quantity"); DropDownList ddlMonth = (DropDownList)Gridview3.Rows[i].Cells[8].FindControl("ddlMonth"); DropDownList ddl_ItemList = (DropDownList)Gridview3.Rows[i].Cells[4].FindControl("ddl_ItemList"); if (lb_CustomerName.Text == string.Empty) { var message1 = new JavaScriptSerializer().Serialize("Please enter Customer Name."); var script1 = string.Format("alert({0});", message1); ScriptManager.RegisterClientScriptBlock(Page, Page.GetType(), "", script1, true); //ClientScript.RegisterStartupScript(this.GetType(), "alert", "ShowPopup();", true); //this.lblMessage.Text = "Please enter Customer Name."; flag = false; lb_CustomerName.Focus(); break; } else if (lb_Location.Text == string.Empty) { var message1 = new JavaScriptSerializer().Serialize("Please enter Location."); var script1 = string.Format("alert({0});", message1); ScriptManager.RegisterClientScriptBlock(Page, Page.GetType(), "", script1, true); flag = false; lb_Location.Focus(); break; } else if (ddl_ItemList.SelectedIndex == 0) { var message1 = new JavaScriptSerializer().Serialize("Please Select Product."); var script1 = string.Format("alert({0});", message1); ScriptManager.RegisterClientScriptBlock(Page, Page.GetType(), "", script1, true); ddl_ItemList.Focus(); flag = false; break; } else if (lb_Quantity.Text == string.Empty && lb_Quantity.Text == "0") { var message1 = new JavaScriptSerializer().Serialize("Please enter Quantity."); var script1 = string.Format("alert({0});", message1); ScriptManager.RegisterClientScriptBlock(Page, Page.GetType(), "", script1, true); lb_Quantity.Focus(); flag = false; break; } else if (ddlMonth.SelectedValue == "0") { var message1 = new JavaScriptSerializer().Serialize("Please select Month."); var script1 = string.Format("alert({0});", message1); ScriptManager.RegisterClientScriptBlock(Page, Page.GetType(), "", script1, true); ddlMonth.Focus(); flag = false; break; } } //Checked validations of Gridview fields if (flag == true) { //Created Lines in SQL InternalDB Database's [Secondary Sales Details] Table string ItemNo = string.Empty; string Description = string.Empty; String strConnString = ConfigurationManager.ConnectionStrings["WA_JAYCHEM_INTDB"].ConnectionString; using (SqlConnection con = new SqlConnection(strConnString)) { for (int i = 0; i < dtCurrentTable.Rows.Count; i++) { SqlCommand cmd = new SqlCommand(); cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "SP_SecondarySalesDetails"; String[] CodeAndDesc = dtCurrentTable.Rows[i]["ItemList"].ToString().Split('-'); if (CodeAndDesc.Length >= 1) { ItemNo = CodeAndDesc[0].Trim(); Description = CodeAndDesc[1].Trim(); } //string[] sDate = Convert.ToString(dtCurrentTable.Rows[i]["Date"]).Split('/'); //string sDateTime = sDate[1] + '/' + sDate[2]; string st = "01/" + dtCurrentTable.Rows[i]["Month"] + "/" + DateTime.Now.Year.ToString(); DateTime dtt = Convert.ToDateTime(st); DateTimeFormatInfo dinfo = new DateTimeFormatInfo(); string MonthYear = dinfo.GetMonthName(Convert.ToInt16(dtCurrentTable.Rows[i]["Month"])) + "-" + DateTime.Now.Year.ToString(); cmd.Parameters.Add("@Date", SqlDbType.DateTime).Value = Convert.ToDateTime(dtt); cmd.Parameters.Add("@CustomerName", SqlDbType.VarChar).Value = Convert.ToString(dtCurrentTable.Rows[i]["CustomerName"]); cmd.Parameters.Add("@Location", SqlDbType.VarChar).Value = Convert.ToString(dtCurrentTable.Rows[i]["Location"]); cmd.Parameters.Add("@ItemNo", SqlDbType.VarChar).Value = Convert.ToString(ItemNo); cmd.Parameters.Add("@Description", SqlDbType.VarChar).Value = Convert.ToString(Description); cmd.Parameters.Add("@ItemCategoryCode", SqlDbType.VarChar).Value = Convert.ToString(dtCurrentTable.Rows[i]["ProductCategory"]); cmd.Parameters.Add("@Range", SqlDbType.VarChar).Value = Convert.ToString(dtCurrentTable.Rows[i]["Range"]); cmd.Parameters.Add("@Quantity", SqlDbType.VarChar).Value = Convert.ToDecimal(dtCurrentTable.Rows[i]["Quantity"]); cmd.Parameters.Add("@MonthYear", SqlDbType.VarChar).Value = Convert.ToString(MonthYear); cmd.Connection = con; con.Open(); cmd.ExecuteNonQuery(); con.Close(); } con.Dispose(); } //Created Lines in SQL InternalDB Database's [Secondary Sales Details] Table //Deleted SecondarySales.xls files if exist in Shared Folder string path = ConfigurationManager.AppSettings["FilePath"] + "SecondarySales.xls"; FileInfo file = new FileInfo(path); if (file.Exists)//check file exsit or not { file.Delete(); } //Deleted SecondarySales.xls files if exist in Shared Folder //Generated SecondarySales.xls file in Shared Folder with Design of excel string Desc = string.Empty; StreamWriter wr = new StreamWriter(ConfigurationManager.AppSettings["FilePath"] + "SecondarySales.xls"); try { wr.Write("<HTML><HEAD>"); wr.Write("<style> {font-family:Verdana; font-size: 11px; } </style>"); wr.Write("</HEAD><BODY>"); wr.Write("<TABLE border='1' width='100%' >"); wr.Write("<TR>"); for (int i = 0; i < dt.Columns.Count; i++) { wr.Write("<TD align='center' style='color: White; font-weight: bold;background-color:#8A0886;font-size: 12px'>"); wr.Write(dt.Columns[i].ToString().ToUpper() + "\t"); wr.Write("</TD>"); } wr.Write("</TR>"); wr.WriteLine(); for (int i = 0; i < (dt.Rows.Count); i++) { wr.Write("<TR>"); for (int j = 0; j < dt.Columns.Count; j++) { wr.Write("<style> {font-family:Verdana; font-size: 11px; } </style>"); wr.Write("<TD align='center'>"); if (dt.Rows[i][j] != null) { if (dt.Rows[i][j] == dt.Rows[i][4]) { String[] CodeAndDesc = dt.Rows[i][4].ToString().Split('-'); if (CodeAndDesc.Length >= 1) { ItemNo = CodeAndDesc[0]; Desc = CodeAndDesc[1].Trim(); } wr.Write(Convert.ToString(Desc).ToUpper() + "\t"); } else if (dt.Rows[i][j] == dt.Rows[i][8]) { DateTimeFormatInfo dinfo = new DateTimeFormatInfo(); string MonthYear12 = Convert.ToString(dinfo.GetMonthName(Convert.ToInt16(dt.Rows[i]["Month"])));// + "-" + DateTime.Now.Year.ToString() wr.Write((MonthYear12).ToUpper() + "-" + DateTime.Now.Year.ToString() + "\t"); } else if (dt.Rows[i][j] == dt.Rows[i][3]) { wr.Write(ItemNo + "\t"); } else { wr.Write(Convert.ToString(dt.Rows[i][j]).ToUpper() + "\t"); } } else { wr.Write("\t"); } wr.WriteLine(); wr.Write("</TD>"); } wr.Write("</TR>"); } wr.Write("</TABLE>"); wr.Write("</BODY>"); wr.Close(); //Generated SecondarySales.xls file in Shared Folder with Design of excel //Mailing to Agents Email as well as General Ledger's Secondary Sales Internal Email NetworkCredential NetCredentials = new NetworkCredential(); NetCredentials.UserName = ConfigurationManager.AppSettings["UserName"]; NetCredentials.Password = ConfigurationManager.AppSettings["Password"]; Web_Order_Mail objser1 = new Web_Order_Mail(); objser1.UseDefaultCredentials = true; objser1.Credentials = NetCredentials; objser1.SendMailForSecondarySalesExcel(ConfigurationManager.AppSettings["FilePath"] + "SecondarySales.xls", Convert.ToString(Request["CompanyCode"])); objser1 = null; } catch (Exception ex) { var message = new JavaScriptSerializer().Serialize(ex.Message.ToString()); var script = string.Format("alert({0});", message); ScriptManager.RegisterClientScriptBlock(Page, Page.GetType(), "", script, true); } var message1 = new JavaScriptSerializer().Serialize("Mail Sent successfully."); var script1 = string.Format("alert({0});window.location='DashBoard.aspx';", message1); ScriptManager.RegisterClientScriptBlock(Page, Page.GetType(), "", script1, true); } } catch (Exception ex) { var message = new JavaScriptSerializer().Serialize(ex.Message.ToString()); var script = string.Format("alert({0});", message); ScriptManager.RegisterClientScriptBlock(Page, Page.GetType(), "", script, true); } }
protected void btn_delete_Command(object sender, CommandEventArgs e) { try { LinkButton btn_Delete = (LinkButton)sender; RepeaterItem item = (RepeaterItem)btn_Delete.NamingContainer; HiddenField ItemNo = (HiddenField)item.FindControl("hf_ItemNo"); HiddenField LineNo = (HiddenField)item.FindControl("hf_LineNo"); HiddenField hf_QuantityShipped = (HiddenField)item.FindControl("hf_QuantityShipped"); if (Convert.ToDecimal(hf_QuantityShipped.Value) > 0) { var message2 = new JavaScriptSerializer().Serialize("Shipped product could not be deleted."); var script2 = string.Format("alert({0});", message2); ScriptManager.RegisterClientScriptBlock(Page, Page.GetType(), "", script2, true); BindCartData(); } else { NetworkCredential NetCredentialsOrder = new NetworkCredential(); NetCredentialsOrder.UserName = ConfigurationManager.AppSettings["UserName"]; NetCredentialsOrder.Password = ConfigurationManager.AppSettings["Password"]; //delete For Sales Order Line Web_Order_Mail objserSalesOrder = new Web_Order_Mail(); objserSalesOrder.UseDefaultCredentials = true; objserSalesOrder.Credentials = NetCredentialsOrder; objserSalesOrder.DeleteSalesLine(Convert.ToInt16(ConfigurationManager.AppSettings["SalesOrderDocumentType"]), Convert.ToString(Request["OrderNo"]), Convert.ToInt32(LineNo.Value), ItemNo.Value, true); objserSalesOrder = null; //delete For Blanket Order Line Web_Order_Mail objserBlkOrder = new Web_Order_Mail(); objserBlkOrder.UseDefaultCredentials = true; objserBlkOrder.Credentials = NetCredentialsOrder; objserBlkOrder.DeleteSalesLine(Convert.ToInt16(ConfigurationManager.AppSettings["DocumentType"]), Convert.ToString(Request.QueryString["BlanketOrderNo"]), Convert.ToInt32(LineNo.Value), ItemNo.Value, true); objserBlkOrder = null; //list = Qtm.Lib.OrderModifiCustomerInfo.ListDeleteItemLine(Request["OrderNo"].ToString(), ItemNo.Value, LineNo.Value, Convert.ToString(Request.QueryString["BlanketOrderNo"])); SalesOrderStatistics so = new SalesOrderStatistics(); NetworkCredential NetCredentials = new NetworkCredential(); NetCredentials.UserName = ConfigurationManager.AppSettings["UserName"]; NetCredentials.Password = ConfigurationManager.AppSettings["Password"]; Web_Order_Mail objser1 = new Web_Order_Mail(); objser1.UseDefaultCredentials = true; objser1.Credentials = NetCredentials; objser1.SalesOrderStatistics(Convert.ToString(Request.QueryString["OrderNo"])); objser1 = null; if (list != null && list.Count > 0) { rpt_FinalCart.DataSource = list; rpt_FinalCart.DataBind(); } else { rpt_FinalCart.DataSource = null; rpt_FinalCart.DataBind(); l_Error.Visible = true; } BindCartData(); } } catch (Exception ex) { var message = new JavaScriptSerializer().Serialize(ex.Message.ToString()); var script = string.Format("alert({0});", message); ScriptManager.RegisterClientScriptBlock(Page, Page.GetType(), "", script, true); } }