protected void btnget_Click(object sender, EventArgs e) { try { lblmessage.InnerHtml = ""; pnlDetails.Visible = true; docno.InnerHtml = txtdocno.Text.Trim(); // upDetails.Visible = true; txtempc.Visible = true; lblemp.Visible = true; btnPrint.Visible = true; txtremark.Visible = true; DataSet ds6 = new DataSet(); //ds6 = DCDetails.Idv_Get_DCDetails_By_DocNo(Convert.ToInt32(txtdocno.Text), "allbydocno"); ds6 = DCDetails.Idv_Get_DCDetails_By_DocNo(Convert.ToInt32(txtdocno.Text), "allbydocno", Convert.ToInt32(strFY)); grdconfirm.DataSource = DCDetails.Idv_Get_DCDetails_By_DocNo(Convert.ToInt32(txtdocno.Text), "allbydocno", Convert.ToInt32(strFY)).Tables[0]; grdconfirm.DataBind(); // pnlDetails.Visible = true; grdconfirm.Visible = true; int id = Convert.ToInt32(ds6.Tables[1].Rows[0]["CustID"]); lblempname1.InnerHtml = Convert.ToString(ds6.Tables[1].Rows[0]["FirstName"]) + " " + Convert.ToString(ds6.Tables[1].Rows[0]["LastName"]) + " "; lblcustname.InnerHtml = " " + Convert.ToString(ds6.Tables[1].Rows[0]["CustName"]); lblspinstruction.InnerHtml = Convert.ToString(ds6.Tables[0].Rows[0]["SpInstruction"]); lbldcdate.InnerHtml = Convert.ToString(ds6.Tables[0].Rows[0]["DocumentDate"]); lblorder.InnerHtml = Convert.ToString(ds6.Tables[0].Rows[0]["OrderDate"]); ViewState["EmailID"] = Convert.ToString(ds6.Tables[1].Rows[0]["CUSTEmailID"]); lblemailid.InnerHtml = Convert.ToString(ds6.Tables[1].Rows[0]["CUSTEmailID"]); //strEmailID = Convert.ToString(ds6.Tables[1].Rows[0]["CUSTEmailID"]); DataSet ds7 = G_GetPass.CustEMail_LocalEntry(id); ViewState["SEmailid"] = Convert.ToString(ds7.Tables[0].Rows[0]["SEmailID"]); if (Convert.ToString(ds6.Tables[1].Rows[0]["CUSTEmailID"]) == "") { lblEmailAlert.Visible = true; lblEmailAlert.ForeColor = System.Drawing.Color.Red; lblEmailAlert.Text = "Add email id"; btnEmail.Enabled = false; } else { lblEmailAlert.Visible = false; btnEmail.Enabled = true; } string jv = ""; if (grdconfirm.Rows.Count <= 0) { btnconfirm.Visible = false; jv = "document.getElementById('ctl00_ContentPlaceHolder1_uc_PendingDC1_btnconfirm').style.display='none';"; } else { btnconfirm.Visible = true; jv = "document.getElementById('ctl00_ContentPlaceHolder1_uc_PendingDC1_btnconfirm').style.display='visible';"; } ScriptManager.RegisterClientScriptBlock(Page, Page.GetType(), "a", jv, true); } catch { } txtempc.Focus(); }
protected void RepDetailsConfirm_ItemDataBound(object sender, RepeaterItemEventArgs e) { TextBox txtFright = null; TextBox txttax = null; Label lbltotalamt = null; Label lbltotalAmtget = null; txtFright = (TextBox)e.Item.FindControl("txtfrieght"); txttax = (TextBox)e.Item.FindControl("txttax"); lbltotalamt = (Label)e.Item.FindControl("lbltotalamt"); lbltotalAmtJS = (Label)e.Item.FindControl("lbltotalAmtJS"); Label SubConfirmID = (Label)e.Item.FindControl("SubConfirmID"); GridView grdView = (GridView)e.Item.FindControl("grdapproval"); if (ViewState["staticDS"] != null) { stDS = (DataSet)ViewState["staticDS"]; } else { stDS = DCDetails.Get_SubDocId_And_ItsRecords_By_DocNo(Convert.ToInt32(txtDocno.Text), "confirmed", Convert.ToInt32(strFY)); ViewState["staticDS"] = stDS; } DataView dv = new DataView(stDS.Tables[1]); dv.RowFilter = "SubConfirmID = " + SubConfirmID.Text.Trim(); grdView.DataSource = dv; grdView.DataBind(); int ID = Convert.ToInt32(stDS.Tables[2].Rows[0]["CustID"]); lblempname1.InnerHtml = Convert.ToString(stDS.Tables[2].Rows[0]["FirstName"]) + " " + Convert.ToString(stDS.Tables[2].Rows[0]["LastName"]) + " "; lblcustname.InnerHtml = " " + Convert.ToString(stDS.Tables[2].Rows[0]["CustDetails"]); ViewState["cname"] = Convert.ToString(stDS.Tables[2].Rows[0]["CustDetails"]); lblEmail.Text = Convert.ToString(stDS.Tables[2].Rows[0]["Email"]); lblMobNo.Text = Convert.ToString(stDS.Tables[2].Rows[0]["mobNo"]); ((TextBox)e.Item.FindControl("txtdateabc")).Text = DateTime.Now.ToString("dd/MM/yyyy"); txtfrieght.Text = "0"; txttax.Text = "0"; ((Label)e.Item.FindControl("LblRemark")).Text = stDS.Tables[2].Rows[0]["Remark"].ToString(); ((Label)e.Item.FindControl("lblCustId1")).Text = stDS.Tables[2].Rows[0]["CustId"].ToString(); //Updated By Rupesh 17/10/2014 ((TextBox)e.Item.FindControl("txtbundles")).Text = stDS.Tables[1].Rows[0]["Bundles"].ToString(); // DataSet ds7 = G_GetPass.CustEMail_LocalEntry(ID); ViewState["SEmailid"] = Convert.ToString(ds7.Tables[0].Rows[0]["SEmailID"]); lbltotalamt.Text = tamount.Text.ToString(); if (stDS.Tables[2].Rows.Count > 0) { ((TextBox)e.Item.FindControl("lbltransporter")).Text = stDS.Tables[2].Rows[0]["Transporter"].ToString(); } lbltotalAmtJS.Text = tamount.Text.ToString(); txtfrieght.Attributes.Add("onkeyup", "sumCharges('" + txtfrieght.ClientID + "','" + txttax.ClientID + "','" + lbltotalAmtJS.ClientID + "','" + lbltotalamt.ClientID + "')"); txttax.Attributes.Add("onkeyup", "sumCharges('" + txtfrieght.ClientID + "','" + txttax.ClientID + "','" + lbltotalAmtJS.ClientID + "','" + lbltotalamt.ClientID + "')"); }
public void saveMaster(bool isprint) { int DocId = 0; string Localout = string.Empty; try { string date = txtDocDate.Text.Split('/')[1] + "/" + txtDocDate.Text.Split('/')[0] + "/" + txtDocDate.Text.Split('/')[2]; string LRdate = txtLrDate.Text.Split('/')[1] + "/" + txtLrDate.Text.Split('/')[0] + "/" + txtLrDate.Text.Split('/')[2]; G_GetPass obj = new G_GetPass(); obj.Doc_ID = Convert.ToInt32(lblDocNo.Text.Trim()); obj.Local_Out = "O"; Localout = "O"; obj.Doc_Date = Convert.ToDateTime(date); obj.DC_No = Convert.ToDecimal(txtDcNo.Text.Trim()); obj.Cust_ID = Convert.ToInt32(lblCustID.Text.Trim()); obj.Transporter_ID = Convert.ToInt32(lblTransID.Text.Trim()); obj.No_Bundles = txtNoOfBund.Text.Trim(); obj.Bill_Nos = txtBillNo.Text.Trim(); if (txtValOfGoods.Text.Trim() == "") { obj.Value_Goods = 0; } else { obj.Value_Goods = Convert.ToDecimal(txtValOfGoods.Text.Trim()); } obj.Sent_By = txtSentBy.Text.Trim(); obj.LR_No = txtLRNo.Text.Trim(); obj.LR_Date = Convert.ToDateTime(LRdate); obj.Pay_Paid = rdoPaidStaus.SelectedValue.ToString(); if (txtAmt.Text.Trim() == "") { obj.Amount = 0; } else { obj.Amount = Convert.ToDecimal(txtAmt.Text.Trim()); } obj.Delivery = chIsDelivery.Checked; obj.Fy = Convert.ToInt32(strFY); obj.Created_By = UserName; obj.Updated_By = UserName; obj.Remark1 = txtRemark.Text; int Doc_No_New = 0; DocId = obj.Save(out Doc_No_New); MessageBox("Data Saved! \\r\\n Documennt no." + Doc_No_New.ToString()); int SCD; CourierDetails _objCD = new CourierDetails(); _objCD.SaveDispatchEmailDetails(Convert.ToInt32(DocId), "O", Convert.ToInt32(strFY), Convert.ToString(Session["UserName"]), out SCD); DataSet ds = new DataSet(); ds = G_GetPass.CustEMail_LocalEntry(obj.Cust_ID); String CustEmailId = ""; if (ds.Tables.Count != 0) { CustEmailId = ds.Tables[0].Rows[0]["EmailId"].ToString(); string SZEmailid = ds.Tables[0].Rows[0]["SEmailID"].ToString(); if (CustEmailId.Trim() != "") { MailMessage msg = new MailMessage(); msg.From = new MailAddress("*****@*****.**"); msg.To.Add(new MailAddress(CustEmailId)); msg.To.Add(new MailAddress("*****@*****.**")); msg.Bcc.Add(new MailAddress(SZEmailid)); msg.Subject = "Chetana Book Depot"; string CustomerName = ""; if (lblCustomer.Text.Trim() != "") { string[] tokens = lblCustomer.Text.Split(new string[] { "::" }, StringSplitOptions.None); CustomerName = tokens[0].Trim(); } if (CustomerName == "") { CustomerName = txtcustomer.Text; } string TransporterName = ""; TransporterName = lbltransporter.Text; if (TransporterName == "") { TransporterName = txttransporter.Text; } msg.Body = MailBodyDesign(CustomerName, obj.DC_No, obj.No_Bundles, TransporterName, obj.LR_No, obj.LR_Date.ToString()).ToString(); msg.IsBodyHtml = true; SmtpClient smtp = new SmtpClient(); smtp.Host = "crm.chetanapublications.com"; smtp.Port = 25; smtp.UseDefaultCredentials = false; smtp.Credentials = new System.Net.NetworkCredential("*****@*****.**", "we0504260"); smtp.EnableSsl = false; try { smtp.Send(msg); DataSet DsMailLog = new DataSet(); string mDocumentNo = obj.DC_No.ToString(); DsMailLog = CourierDetails.SendDispatchEmail(SCD, float.Parse(mDocumentNo), "DispatchEmail", "DispatchId", Convert.ToInt32(strFY), "*****@*****.**", "we0504260", Convert.ToString(Session["UserName"])); //MessageBox("Mail Sent successfully"); } catch (Exception ex) { //MessageBox(ex.Message); } } } ds.Dispose(); if (isprint) { ScriptManager.RegisterClientScriptBlock(Page, Page.GetType(), "window", "f_open_window_max('Godown/print/OutGodownPrint.aspx?d=" + DocId + "&L=" + Localout + "')", true); } Clear(); CallButonVisible("new"); } catch (Exception ex) { MessageBox("Error! : " + ex.Message.ToString()); } }
public void SaveSubRecords(int DocId, int DocIdnew) { try { G_GetPassSub obj = new G_GetPassSub(); obj.DOC_ID = DocId; int SCD; DataSet ds = new DataSet(); CourierDetails _objCD = new CourierDetails(); _objCD.SaveDispatchEmailDetails(Convert.ToInt32(DocIdnew), "O", Convert.ToInt32(strFY), Convert.ToString(Session["UserName"]), out SCD); foreach (GridViewRow row in grdTemp.Rows) { obj.DOC_SUB_ID = Convert.ToInt32(((Label)(row.FindControl("lblSubID"))).Text.Trim()); obj.DC_NO = Convert.ToInt32(((Label)(row.FindControl("lblDcNo"))).Text.Trim()); obj.BILL_NO = ((Label)(row.FindControl("lblBillNo"))).Text.Trim(); obj.SCHL_NAME = ((Label)(row.FindControl("lblCustName"))).Text.Trim(); obj.SCHL_AREA = ((Label)(row.FindControl("lblArea"))).Text.Trim(); obj.NO_OF_BUNDLES = ((Label)(row.FindControl("lblNoOfBundles"))).Text.Trim(); obj.DELIVERY = ((CheckBox)(row.FindControl("ChkDelivery"))).Checked; obj.Cust_ID = Convert.ToInt32(((Label)(row.FindControl("lblCustid"))).Text.Trim()); obj.Created_By = UserName; obj.Updated_By = UserName; obj.Save(); ds = G_GetPass.CustEMail_LocalEntry(obj.Cust_ID); String CustEmailId = ""; if (ds.Tables.Count != 0) { CustEmailId = ds.Tables[0].Rows[0]["EmailId"].ToString(); if (CustEmailId.Trim() != "") { MailMessage msg = new MailMessage(); msg.From = new MailAddress("*****@*****.**"); msg.To.Add(new MailAddress("*****@*****.**")); msg.To.Add(new MailAddress(CustEmailId)); msg.To.Add(new MailAddress("*****@*****.**")); msg.Subject = "Chetana Book Depot"; msg.Body = MailBodyDesign(obj.SCHL_NAME, obj.DC_NO, obj.NO_OF_BUNDLES).ToString(); msg.IsBodyHtml = true; SmtpClient smtp = new SmtpClient(); smtp.Host = "crm.chetanapublications.com"; smtp.Port = 25; smtp.UseDefaultCredentials = false; smtp.Credentials = new System.Net.NetworkCredential(ConfigurationManager.AppSettings["Username"].ToString(), ConfigurationManager.AppSettings["Password"].ToString()); smtp.EnableSsl = false; try { smtp.Send(msg); DataSet DsMailLog = new DataSet(); string mDocumentNo = obj.DC_NO.ToString(); DsMailLog = CourierDetails.SendDispatchEmail(SCD, float.Parse(mDocumentNo), "DispatchEmail", "DispatchId", Convert.ToInt32(strFY), "*****@*****.**", "we0504260", Convert.ToString(Session["UserName"])); //MessageBox("Mail Sent successfully"); } catch (Exception ex) { //MessageBox(ex.Message); } } } } MessageBox("Data Saved! \\r\\n Documennt no." + DocIdnew); } catch (Exception ex) { MessageBox("Error! : " + ex.Message.ToString()); } }