protected void lblBookType_TextChanged(object sender, EventArgs e) { TextBox txtbooktype = (TextBox)sender; GridViewRow gvRow = (GridViewRow)txtbooktype.Parent.Parent; Label lblTotalRs = (Label)gvRow.FindControl("bookId"); TextBox txtFromQty = (TextBox)gvRow.FindControl("lblFromQty"); string BookCode = txtbooktype.Text.Split(':')[0].Trim(); txtbooktype.Text = BookCode; if (txtbooktype.Text != "") { Other_Z.OtherBAL ObjBAL = new Other_Z.OtherBAL(); DataSet ds = ObjBAL.GetBookIdWithBookType(BookCode, Convert.ToInt32(Session["FY"]), "booktype"); if (ds.Tables[0].Rows.Count > 0) { lblTotalRs.Text = ds.Tables[0].Rows[0][0].ToString(); txtFromQty.Focus(); } else { MessageBox("Invalid book name please try again"); txtbooktype.Text = ""; txtbooktype.Focus(); return; } } else { MessageBox("Please enter book code"); txtbooktype.Text = ""; txtbooktype.Focus(); return; } }
protected void btnSave_Click(object sender, EventArgs e) { if (txtUser.Text != "") { StringBuilder sb = new StringBuilder(); string SuperzoneId = ""; string UserName = txtUser.Text.Split(':')[0].ToString(); foreach (GridViewRow item in usergrid.Rows) { CheckBox chk = (CheckBox)item.FindControl("ChkVal"); if (chk.Checked) { SuperzoneId = Convert.ToInt32(((Label)item.FindControl("chkid")).Text).ToString(); sb.Append(SuperzoneId + ","); } } if (sb.ToString() != "") { Other_Z.OtherBAL ObjDal = new Other_Z.OtherBAL(); ObjDal.Idv_Chetana_UserTicketMap_Save(UserName, sb.ToString(), Convert.ToInt32(FY), Session["Username"].ToString(), "", "", "", "", "", "", ""); Message("Record save successfully"); txtUser.Text = ""; txtUser.Focus(); } else { Message("Please select super zone "); return; } } Message("Please enter user name"); txtUser.Focus(); return; }
protected void btnUpload_Click(object sender, EventArgs e) { XmlDocument doc = new XmlDocument(); XmlNode inode = doc.CreateElement("f"); XmlNode fnode = doc.CreateElement("r"); foreach (GridViewRow row in grdImportCust.Rows) { XmlNode element = doc.CreateElement("i"); inode = doc.CreateElement("c"); inode.InnerText = ((Label)row.FindControl("lblcode")).Text.ToString(); element.AppendChild(inode); inode = doc.CreateElement("s"); inode.InnerText = ((Label)row.FindControl("lblsplitdc")).Text.ToString(); element.AppendChild(inode); fnode.AppendChild(element); } Other_Z.OtherBAL objBal = new Other_Z.OtherBAL(); objBal.UpdateCustomermaster(fnode.OuterXml, "", "", ""); MessageBox("Data Upload Success"); grdpanl.Visible = false; btnUpload.Visible = false; }
private void BindReport() { StringBuilder objste = new StringBuilder("-"); try { Other_Z.OtherBAL ObjDal = new Other_Z.OtherBAL(); DoLog(objste, "Start"); DataSet dsSuperZones = OtherNewClass.AutoMail.AutoMailParams("missingreceipts", "", "", "", "", "", "", "", ""); DataTable dtsz = dsSuperZones.Tables[0]; DoLog(objste, "Get Super Zones Count >> " + dtsz.Rows.Count.ToString()); DataTable dt = dsSuperZones.Tables[1]; DoLog(objste, "Get Dates Count >> " + dt.Rows.Count.ToString()); DataTable dtmaildesc = dsSuperZones.Tables[2]; DoLog(objste, "Get Mail setting Count >> " + dtmaildesc.Rows.Count.ToString()); string FirstPath = string.Empty; string SecondPath = string.Empty; DoLog(objste, "Generating 1 File"); FirstPath = "../AutoEmailAttachment/MissingReceipts/" + Convert.ToDateTime(dt.Rows[0]["todate"].ToString()).ToString("MM_dd_yyyy_HH_MM") + "/" + DateTime.Now.ToString("MM_dd_yyyy_HH_MM") + "/"; SecondPath = ""; DirectoryManagement(FirstPath); DataSet ds = ObjDal.Idv_Chetana_Missing_UnuseReceiptNo(dt.Rows[0]["fromdate"].ToString(), dt.Rows[0]["todate"].ToString(), Convert.ToInt32(dt.Rows[0]["fy"].ToString()), Convert.ToInt32("0"), Convert.ToInt32("0"), Convert.ToInt32("0"), Convert.ToInt32("0"), "", "email"); DoLog(objste, "Main Dataset >> "); Response.Write(generatefiles(ds, dtsz, dt.Rows[0]["fromdate"].ToString(), dt.Rows[0]["todate"].ToString(), FirstPath, dtmaildesc)); DoLog(objste, "Wrote Data >> "); } catch (Exception wex) { Response.Write("Error >> " + DoLog(objste, "Error >> " + wex.Message).ToString()); } Response.End(); }
protected void BindStatus() { Other_Z.OtherBAL ObjDal = new Other_Z.OtherBAL(); DataSet DSX = ObjDal.BindStatus(); DataTable dt = new DataTable(); DSX.Tables.Add(dt); InqSatatus.DataSource = DSX; InqSatatus.DataTextField = "Status_Name"; InqSatatus.DataBind(); InqSatatus.Items.Insert(0, new ListItem("Select", "NA")); }
protected void btnUpdate_Click(object sender, EventArgs e) { int OutNo = 0; // We were using CustomerDetails but no more using it. //CustomerDetails obj=new CustomerDetails(); //BankPayment obj = new BankPayment(); Other_Z.OtherBAL ObjBal = new Other_Z.OtherBAL(); Other_Z.OtherBAL.SaveBankPay obj = new Other_Z.OtherBAL.SaveBankPay(); foreach (GridViewRow row in gdGeneral.Rows) { if (Convert.ToDecimal(((TextBox)row.FindControl("txtAmount")).Text) > 0) { try { obj.BankPaymentID = 0; obj.BankCode = ""; obj.Documentno = 0; obj.Serialno = 1; obj.DocumentDate = DateTime.Now; obj.AccountCode = ((Label)row.FindControl("lblCode")).Text; obj.PersonInCharge = ""; obj.ReportCode = ""; obj.Cash_Cheque_DD = ""; obj.Cheque_DD_NO = ""; // obj.Type = txtType.Text.Trim(); obj.Type = ""; obj.Amount = Convert.ToDecimal(((TextBox)row.FindControl("txtAmount")).Text); obj.DrawnOn = ""; obj.Remarks = "debit"; obj.IsActive = true; obj.CreatedBy = Session["UserName"].ToString(); obj.UpdatedBy = ""; obj.strFY = Convert.ToInt32(strFY); obj.Paymode = "AddcomisionDebit"; obj.IsChequeBounce = false; //When Remarks = "debit", in sp we will insert value in Amount field to AddComDebit column in column ObjBal.SaveBankPayment(obj, out OutNo); } catch (Exception ex) { throw; } } } ShowDetails(); MessageBox("Record updated sucessfully..." + OutNo.ToString()); }
protected void btn_Save_Click(object sender, EventArgs e) { XmlDocument doc = new XmlDocument(); XmlNode finode = doc.CreateElement("r"); XmlNode inode = doc.CreateElement("f"); bool flag = false; foreach (GridViewRow item in grdBookset.Rows) { XmlNode element = doc.CreateElement("i"); string limit = ((TextBox)item.FindControl("lbllimit")).Text.ToString(); if (limit != "") { flag = true; inode = doc.CreateElement("c"); inode.InnerText = ((Label)item.FindControl("lblCode")).Text.ToString().Trim(); element.AppendChild(inode); inode = doc.CreateElement("l"); inode.InnerText = ((TextBox)item.FindControl("lbllimit")).Text.ToString(); element.AppendChild(inode); inode = doc.CreateElement("n"); inode.InnerText = ((Label)item.FindControl("lblname")).Text.ToString().Trim(); element.AppendChild(inode); finode.AppendChild(element); } } if (flag == true) { Other_Z.OtherBAL objbl = new Other_Z.OtherBAL(); objbl.SaveSalesmnBookSetLimit(finode.OuterXml.ToString(), txtMRCode.Text.Split(':')[0].ToString(), Convert.ToInt32(strFY), UserName, "booksetsave", ""); MessageBox("Record Save Successfull"); txtMRCode.Text = ""; txtMRCode.Focus(); grdBookset.Visible = false; btndownsave.Visible = false; } else { MessageBox("Kindly, enter the limit"); return; } }
protected void BindStatus() { Other_Z.OtherBAL ObjDal = new Other_Z.OtherBAL(); string Flag = "Status"; DataSet DSX = ObjDal.BindStatus(Flag); DataTable dt = new DataTable(); DSX.Tables.Add(dt); InqSatatus.DataSource = DSX; InqSatatus.DataTextField = "Status_Name"; InqSatatus.DataBind(); InqSatatus.Items.Insert(0, new ListItem("Select", "NA")); //Flag = "Escalation"; //DSX = ObjDal.BindStatus(Flag); //DDlEscalation.DataSource = DSX; //DDlEscalation.DataBind(); //DDlEscalation.Items.Insert(0, new ListItem("Select", "Na")); }
protected void btn_Save_Click(object sender, EventArgs e) { docdate = txtdocDate.Text.Split('/')[2] + "/" + txtdocDate.Text.Split('/')[1] + "/" + txtdocDate.Text.Split('/')[0]; ddt = Convert.ToDateTime(docdate); string BankCode = txtbankcode.Text.Trim(); //BankPayment obBnkpay = new BankPayment(); Other_Z.OtherBAL.SaveBankPay obBnkpay = new Other_Z.OtherBAL.SaveBankPay(); Other_Z.OtherBAL ObjBal = new Other_Z.OtherBAL(); // txtdocno.Text = BankPayment.Get_BankPaymentDocNo(BankCode); // txtdocDate.Text = DateTime.Now.ToString("dd/MM/yyyy"); if (Session["UserName"] != null) { try { obBnkpay.BankPaymentID = Convert.ToInt32(LblBankPID.Text); obBnkpay.BankCode = txtbankcode.Text.Trim(); // obBnkpay.DocumentNo = 0; obBnkpay.Serialno = 1; obBnkpay.DocumentDate = ddt; obBnkpay.AccountCode = txtAccode.Text.Trim();; obBnkpay.PersonInCharge = txtperson.Text.Trim(); obBnkpay.ReportCode = txtreportcode.Text.Trim(); obBnkpay.Cash_Cheque_DD = DDLCCDD.SelectedItem.Text; // obBnkpay.Type = txtType.Text.Trim(); obBnkpay.Cheque_DD_NO = txtCCDDNo.Text.Trim(); obBnkpay.Amount = Convert.ToDecimal(txtAmt.Text.Trim()); obBnkpay.DrawnOn = txtDrawnon.Text.Trim(); obBnkpay.Remarks = txtRemark.Text.Trim(); obBnkpay.IsActive = true; obBnkpay.IsChequeBounce = CheckActive.Checked; obBnkpay.CreatedBy = Session["UserName"].ToString(); obBnkpay.strFY = Convert.ToInt32(strFY); if (Session["url"] != null) { obBnkpay.Paymode = "Addcomision"; } else { obBnkpay.Paymode = ""; } //obBnkpay.Save(out DocNo); ObjBal.SaveBankPayment(obBnkpay, out DocNo); txtdocno.Text = Convert.ToString(DocNo); // MessageBox("Record saved successfully"); MessageBox(Constants.save + "\\r\\n Document No: " + (txtdocno.Text)); loder("Last saved Document no. : " + txtdocno.Text); GrdBankPDetails.DataBind(); txtbankcode.Text = ""; lblbankname.Text = ""; txtdocno.Text = ""; txtdocDate.Text = DateTime.Now.ToString("dd/MM/yyyy"); // txtsrno.Text = ""; txtAccode.Text = ""; lblaccname.Text = ""; txtperson.Text = ""; txtreportcode.Text = ""; lblacname.Text = ""; DDLCCDD.SelectedIndex = 0; //txtType.Text = ""; txtCCDDNo.Text = ""; txtAmt.Text = ""; txtDrawnon.Text = ""; lblDrawnonname.Text = ""; txtRemark.Text = ""; Session["url"] = null; CheckActive.Checked = false; lblCustOS.Text = ""; btn_Save.Text = "Save"; PnlAddBankP.Visible = true; Pnldate.Visible = false; PnlBankPDetails.Visible = false; } catch { } } }
public void BindAllDate() { #region FromDate ToDate CustomerCode And Status if (txtFrom.Text != string.Empty && txtTo.Text != string.Empty && txtCutomerName.Text != string.Empty && InqSatatus.SelectedItem.Text != "Select") { Other_Z.OtherBAL ObjDal = new Other_Z.OtherBAL(); HelpDeskReports IDS = new HelpDeskReports(); DataSet DS = new DataSet(); string FromDate = DateTime.Now.ToString("MM/dd/yyyy"); string TODate = DateTime.Now.ToString("MM/dd/yyyy"); FromDate = txtFrom.Text.Split('/')[1] + "/" + txtFrom.Text.Split('/')[0] + "/" + txtFrom.Text.Split('/')[2]; TODate = txtTo.Text.Split('/')[1] + "/" + txtTo.Text.Split('/')[0] + "/" + txtTo.Text.Split('/')[2]; DS = ObjDal.AllRecordRepordTicketHistory(Convert.ToDateTime(FromDate), Convert.ToDateTime(TODate), "0", "0", txtCutomerName.Text.Split(':')[0].ToString(), "0", "0", InqSatatus.SelectedValue, "FD&TD&Status&CustCode"); if (DS.Tables[0].Rows.Count > 0) { crystalreportviewercheque.Visible = true; DataView dv = new DataView(DS.Tables[0]); ReportDocument rd = new ReportDocument(); rd.Load(Server.MapPath("Report/CallReport.rpt")); rd.Database.Tables[0].SetDataSource(dv); crystalreportviewercheque.ReportSource = rd; } else { ScriptManager.RegisterStartupScript(this, this.GetType(), "alert", "alert('Record are not Found !')", true); crystalreportviewercheque.Visible = false; txtFrom.Focus(); } } #endregion #region FromDate ToDate CustomerCode else if (txtFrom.Text != string.Empty && txtTo.Text != string.Empty && txtCutomerName.Text != string.Empty) { Other_Z.OtherBAL ObjDal = new Other_Z.OtherBAL(); HelpDeskReports IDS = new HelpDeskReports(); DataSet DS = new DataSet(); string FromDate = DateTime.Now.ToString("MM/dd/yyyy"); string TODate = DateTime.Now.ToString("MM/dd/yyyy"); FromDate = txtFrom.Text.Split('/')[1] + "/" + txtFrom.Text.Split('/')[0] + "/" + txtFrom.Text.Split('/')[2]; TODate = txtTo.Text.Split('/')[1] + "/" + txtTo.Text.Split('/')[0] + "/" + txtTo.Text.Split('/')[2]; DS = ObjDal.AllRecordRepordTicketHistory(Convert.ToDateTime(FromDate), Convert.ToDateTime(TODate), "0", "0", txtCutomerName.Text.Split(':')[0].ToString(), "0", "0", "0", "FD&TD&CustCode"); if (DS.Tables[0].Rows.Count > 0) { crystalreportviewercheque.Visible = true; DataView dv = new DataView(DS.Tables[0]); ReportDocument rd = new ReportDocument(); rd.Load(Server.MapPath("Report/CallReport.rpt")); rd.Database.Tables[0].SetDataSource(dv); crystalreportviewercheque.ReportSource = rd; } else { ScriptManager.RegisterStartupScript(this, this.GetType(), "alert", "alert('Record are not Found !')", true); crystalreportviewercheque.Visible = false; txtFrom.Focus(); } } #endregion #region FromDate ToDate And Status else if (txtFrom.Text != string.Empty && txtTo.Text != string.Empty && InqSatatus.SelectedItem.Text != "Select") { Other_Z.OtherBAL ObjDal = new Other_Z.OtherBAL(); HelpDeskReports IDS = new HelpDeskReports(); DataSet DS = new DataSet(); string FromDate = DateTime.Now.ToString("MM/dd/yyyy"); string TODate = DateTime.Now.ToString("MM/dd/yyyy"); FromDate = txtFrom.Text.Split('/')[1] + "/" + txtFrom.Text.Split('/')[0] + "/" + txtFrom.Text.Split('/')[2]; TODate = txtTo.Text.Split('/')[1] + "/" + txtTo.Text.Split('/')[0] + "/" + txtTo.Text.Split('/')[2]; DS = ObjDal.AllRecordRepordTicketHistory(Convert.ToDateTime(FromDate), Convert.ToDateTime(TODate), "0", "0", "0", "0", "0", InqSatatus.SelectedValue, "FD&TD&Status"); if (DS.Tables[0].Rows.Count > 0) { crystalreportviewercheque.Visible = true; DataView dv = new DataView(DS.Tables[0]); ReportDocument rd = new ReportDocument(); rd.Load(Server.MapPath("Report/CallReport.rpt")); rd.Database.Tables[0].SetDataSource(dv); crystalreportviewercheque.ReportSource = rd; } else { ScriptManager.RegisterStartupScript(this, this.GetType(), "alert", "alert('Record are not Found !')", true); crystalreportviewercheque.Visible = false; txtFrom.Focus(); } } #endregion #region From Date To Date Method else if (txtFrom.Text != string.Empty && txtTo.Text != string.Empty) { Other_Z.OtherBAL ObjDal = new Other_Z.OtherBAL(); HelpDeskReports IDS = new HelpDeskReports(); DataSet DS = new DataSet(); string FromDate = DateTime.Now.ToString("MM/dd/yyyy"); string TODate = DateTime.Now.ToString("MM/dd/yyyy"); FromDate = txtFrom.Text.Split('/')[1] + "/" + txtFrom.Text.Split('/')[0] + "/" + txtFrom.Text.Split('/')[2]; TODate = txtTo.Text.Split('/')[1] + "/" + txtTo.Text.Split('/')[0] + "/" + txtTo.Text.Split('/')[2]; InqBal.Action = "FD&TD"; DS = ObjDal.AllRecordRepordTicketHistory(Convert.ToDateTime(FromDate), Convert.ToDateTime(TODate), "0", "0", "0", "0", "0", "0", "FD&TD"); if (DS.Tables[0].Rows.Count > 0) { crystalreportviewercheque.Visible = true; DataView dv = new DataView(DS.Tables[0]); ReportDocument rd = new ReportDocument(); rd.Load(Server.MapPath("Report/CallReport.rpt")); rd.Database.Tables[0].SetDataSource(dv); crystalreportviewercheque.ReportSource = rd; } else { ScriptManager.RegisterStartupScript(this, this.GetType(), "alert", "alert('Record are not Found !')", true); crystalreportviewercheque.Visible = false; txtFrom.Focus(); } } #endregion }
protected void btn_Save_Click(object sender, EventArgs e) { try { if (grdBookDetails.Rows.Count == 0) { MessageBox("Kindly fill Book details"); txtsalemanCode.Focus(); return; } if (txtTrasnport.Text == "") { MessageBox("Kindly Select Transpoter"); txtTrasnport.Focus(); return; } else { Other_Z.OtherBAL.SpecimanCN _objSepciman = new Other_Z.OtherBAL.SpecimanCN(); Other_Z.OtherBAL objbal = new Other_Z.OtherBAL(); string CNDate = txtCNDate.Text.Split('/')[1] + "/" + txtCNDate.Text.Split('/')[0] + "/" + txtCNDate.Text.Split('/')[2]; _objSepciman.GCN = Convert.ToInt32(txtGCN.Text == "" ? "0" : txtGCN.Text); _objSepciman.SCN = Convert.ToInt32(txtSCN.Text == "" ? "0" : txtSCN.Text); _objSepciman.CNDate = Convert.ToDateTime(CNDate); _objSepciman.LrNo = Convert.ToInt32(txtlrno.Text == "" ? "0" : txtlrno.Text); _objSepciman.SalesmanId = txtsalemanCode.Text.Split(':')[0]; _objSepciman.FY = Convert.ToInt32(strFY); _objSepciman.SpInstruction = txtspInstruct.Text.Trim(); _objSepciman.CreatedBy = Convert.ToString(Session["UserName"]);; _objSepciman.XmlData = SaveSpecimanDetails(); // SaveSpecimanDetails(1); _objSepciman.BooksetId = Convert.ToInt32(DDLSelectSet.SelectedValue); _objSepciman.BooksetQty = Convert.ToInt32(txtsetqty.Text); _objSepciman.TrasportCode = txtTrasnport.Text.Split(':')[0]; objbal.SaveReturnSpeciman(_objSepciman); // _objSepciman.ChallanDate = Convert.ToDateTime(ChallanDate); // string ordno = txtorder.Text.Trim(); //if (ordno == "") //{ // ordno = "0"; //} // _objSepciman.OrderNo = txtorder.Text.Trim(); // _objSepciman.OrderDate = Convert.ToDateTime(OrderDate); //_objSepciman.IsActive = true; //_objSepciman.IsDeleted = false; // _objSepciman.Description = Description; //_objSepciman.Save(out DocNo, 1, out DocNewNo); // _objSepciman.Save(out DocNo); //txtGCN.Text = Convert.ToString(DocNo); // MessageBox("Record saved successfully \\r\\n Documennt no. " ); MessageBox("Record saved successfully "); //lblmsg.Text = "Last saved Document no. : " + txtGCN.Text; txtGCN.Text = ""; txtSCN.Text = ""; Session["tempBookData"] = null; grdBookDetails.DataSource = null; grdBookDetails.DataBind(); upGridData.Update(); DDLSelectSet.SelectedValue = "0"; Description = ""; } } catch (Exception ex) { string ermsg = ex.Message.ToString(); } }
protected void btnAddAccess_Click(object sender, EventArgs e) { Other_Z.OtherBAL ObjBAL = new Other_Z.OtherBAL(); string BookCode = txtBookType.Text.Split(':')[0].Trim(); DataSet ds = ObjBAL.GetBookIdWithBookType(BookCode, Convert.ToInt32(Session["FY"]), "booktype"); if (ds.Tables[0].Rows.Count > 0) { DataTable dt = GetDataTempTableAssorted(); if (dt != null) { if (Convert.ToInt32(txtDiscount.Text) <= 0 || Convert.ToInt32(txtDiscount.Text) >= 100) { MessageBox("Discount greater then 0 and less then 100"); txtDiscount.Focus(); return; } if (Convert.ToInt32(txtFromQty.Text) >= Convert.ToInt32(txtToQty.Text)) { MessageBox("From quantity shold be less than To quantity"); txtFromQty.Focus(); return; } else { // //DataRow[] rows1 = dt.Select("BookType = '" + BookCode + "' And ToQty > " + txtFromQty.Text); //if (rows1.Length > 0) //{ // MessageBox("Wrong from quantity and to quantity"); // txtFromQty.Focus(); // return; //} bool isflage = false; DataRow[] rows = dt.Select("BookType = '" + BookCode + "' And FromQty =" + txtFromQty.Text + " And ToQty = " + txtToQty.Text + "And Discount=" + txtDiscount.Text + ""); DataRow dr = null; if (rows.Length > 0) { dr = rows[0]; isflage = true; MessageBox("Already Add Assorted Discount"); txtTODAmount.Focus(); return; } else { dt.DefaultView.Sort = "BookType ASC"; dr = dt.NewRow(); } dr["BookType"] = BookCode; dr["Bookid"] = ds.Tables[0].Rows[0][0].ToString(); dr["FromQty"] = Convert.ToInt32(txtFromQty.Text.Trim()); dr["ToQty"] = Convert.ToInt32(txtToQty.Text.Trim()); dr["Discount"] = Convert.ToInt32(txtDiscount.Text.Trim()); if (!isflage) { AddRowAssorted(dr); txtTODAmount.Text = ""; txtTodDis.Text = ""; } } GridAssorted.DataSource = dt; GridAssorted.DataBind(); GridAssorted.Visible = true; txtBookType.Text = ""; txtFromQty.Text = ""; txtToQty.Text = ""; txtDiscount.Text = ""; txtBookType.Focus(); } } else { MessageBox("Invalid book name please try again"); txtBookType.Text = ""; txtBookType.Focus(); return; } }
public void BindAllDate() { #region FromDate And ToDate And Customer And Status And Executive if (txtFrom.Text != string.Empty && txtTo.Text != string.Empty && txtCutomerName.Text != string.Empty && InqSatatus.SelectedItem.Text != "Select" && txtExeutiveName.Text != string.Empty) { HelpDeskReports IDS = new HelpDeskReports(); Other_Z.OtherBAL ObjDal = new Other_Z.OtherBAL(); DataSet DS = new DataSet(); string FromDate = DateTime.Now.ToString("MM/dd/yyyy"); string TODate = DateTime.Now.ToString("MM/dd/yyyy"); FromDate = txtFrom.Text.Split('/')[1] + "/" + txtFrom.Text.Split('/')[0] + "/" + txtFrom.Text.Split('/')[2]; TODate = txtTo.Text.Split('/')[1] + "/" + txtTo.Text.Split('/')[0] + "/" + txtTo.Text.Split('/')[2]; DS = ObjDal.AllRecordRepordTicketHistory(Convert.ToDateTime(FromDate), Convert.ToDateTime(TODate), "0", "0", txtCutomerName.Text.Split(':')[0].ToString(), txtExeutiveName.Text, "0", InqSatatus.SelectedValue, "FD&TD&Status&CustCode&EmpCode"); if (DS.Tables[0].Rows.Count > 0) { CustomerWiseAmount.Visible = true; DataView dv = new DataView(DS.Tables[0]); ReportDocument rd = new ReportDocument(); rd.Load(Server.MapPath("Report/CallReportExecutive.rpt")); rd.Database.Tables[0].SetDataSource(dv); CustomerWiseAmount.ReportSource = rd; CustomerWiseAmount.RefreshReport(); CustomerWiseAmount.DataBind(); } else { ScriptManager.RegisterStartupScript(this, this.GetType(), "alert", "alert('Record not Found !')", true); CustomerWiseAmount.Visible = false; txtFrom.Focus(); } } #endregion #region FromDate And ToDate And Customer And Status else if (txtFrom.Text != string.Empty && txtTo.Text != string.Empty && txtCutomerName.Text != string.Empty && InqSatatus.SelectedItem.Text != "Select") { Other_Z.OtherBAL ObjDal = new Other_Z.OtherBAL(); HelpDeskReports IDS = new HelpDeskReports(); DataSet DS = new DataSet(); string FromDate = DateTime.Now.ToString("MM/dd/yyyy"); string TODate = DateTime.Now.ToString("MM/dd/yyyy"); FromDate = txtFrom.Text.Split('/')[1] + "/" + txtFrom.Text.Split('/')[0] + "/" + txtFrom.Text.Split('/')[2]; TODate = txtTo.Text.Split('/')[1] + "/" + txtTo.Text.Split('/')[0] + "/" + txtTo.Text.Split('/')[2]; DS = ObjDal.AllRecordRepordTicketHistory(Convert.ToDateTime(FromDate), Convert.ToDateTime(TODate), "0", "0", txtCutomerName.Text.Split(':')[0].ToString(), "0", "0", InqSatatus.SelectedValue, "FD&TD&Status&CustCode"); if (DS.Tables[0].Rows.Count > 0) { CustomerWiseAmount.Visible = true; DataView dv = new DataView(DS.Tables[0]); ReportDocument rd = new ReportDocument(); rd.Load(Server.MapPath("Report/CallReportExecutive.rpt")); rd.Database.Tables[0].SetDataSource(dv); CustomerWiseAmount.ReportSource = rd; CustomerWiseAmount.RefreshReport(); CustomerWiseAmount.DataBind(); } else { ScriptManager.RegisterStartupScript(this, this.GetType(), "alert", "alert('Record are not Found !')", true); CustomerWiseAmount.Visible = false; txtFrom.Focus(); } } #endregion #region FromDate And ToDate And Status else if (txtFrom.Text != string.Empty && txtTo.Text != string.Empty && InqSatatus.SelectedItem.Text != "Select") { //if (txtFrom.Text != string.Empty && txtTo.Text != string.Empty && InqSatatus.SelectedItem.Text != "Select") //{ Other_Z.OtherBAL ObjDal = new Other_Z.OtherBAL(); HelpDeskReports IDS = new HelpDeskReports(); DataSet DS = new DataSet(); string FromDate = DateTime.Now.ToString("MM/dd/yyyy"); string TODate = DateTime.Now.ToString("MM/dd/yyyy"); FromDate = txtFrom.Text.Split('/')[1] + "/" + txtFrom.Text.Split('/')[0] + "/" + txtFrom.Text.Split('/')[2]; TODate = txtTo.Text.Split('/')[1] + "/" + txtTo.Text.Split('/')[0] + "/" + txtTo.Text.Split('/')[2]; //InqBal.Fromdate = Convert.ToDateTime(txtFrom.Text.Split('/')[2] + "/" + txtFrom.Text.Split('/')[1] + "/" + txtFrom.Text.Split('/')[0]); //InqBal.ToDate = Convert.ToDateTime(txtTo.Text.Split('/')[2] + "/" + txtTo.Text.Split('/')[1] + "/" + txtTo.Text.Split('/')[0]); //InqBal.Status = InqSatatus.SelectedValue; //InqBal.Action = "FD&TD&Status"; DS = ObjDal.AllRecordRepordTicketHistory(Convert.ToDateTime(FromDate), Convert.ToDateTime(TODate), "0", "0", "0", "0", "0", InqSatatus.SelectedValue, "FD&TD&Status"); if (DS.Tables[0].Rows.Count > 0) { CustomerWiseAmount.Visible = true; DataView dv = new DataView(DS.Tables[0]); ReportDocument rd = new ReportDocument(); rd.Load(Server.MapPath("Report/CallReportExecutive.rpt")); rd.Database.Tables[0].SetDataSource(dv); CustomerWiseAmount.ReportSource = rd; CustomerWiseAmount.RefreshReport(); CustomerWiseAmount.DataBind(); } else { ScriptManager.RegisterStartupScript(this, this.GetType(), "alert", "alert('Record are not Found !')", true); CustomerWiseAmount.Visible = false; txtFrom.Focus(); } // } //else //{ // ScriptManager.RegisterStartupScript(this, this.GetType(), "alert", "alert('Please Enter Between Date.. !')", true); // txtFrom.Focus(); // txtFrom.Text = ""; //} } #endregion #region FromDate And ToDate And Customer else if (txtFrom.Text != string.Empty && txtTo.Text != string.Empty && txtCutomerName.Text != string.Empty) { Other_Z.OtherBAL ObjDal = new Other_Z.OtherBAL(); HelpDeskReports IDS = new HelpDeskReports(); DataSet DS = new DataSet(); string FromDate = DateTime.Now.ToString("MM/dd/yyyy"); string TODate = DateTime.Now.ToString("MM/dd/yyyy"); FromDate = txtFrom.Text.Split('/')[1] + "/" + txtFrom.Text.Split('/')[0] + "/" + txtFrom.Text.Split('/')[2]; TODate = txtTo.Text.Split('/')[1] + "/" + txtTo.Text.Split('/')[0] + "/" + txtTo.Text.Split('/')[2]; DS = ObjDal.AllRecordRepordTicketHistory(Convert.ToDateTime(FromDate), Convert.ToDateTime(TODate), "0", "0", txtCutomerName.Text.Split(':')[0].ToString(), "0", "0", "0", "FD&TD&CustCode"); if (DS.Tables[0].Rows.Count > 0) { CustomerWiseAmount.Visible = true; DataView dv = new DataView(DS.Tables[0]); ReportDocument rd = new ReportDocument(); rd.Load(Server.MapPath("Report/CallReportExecutive.rpt")); rd.Database.Tables[0].SetDataSource(dv); CustomerWiseAmount.ReportSource = rd; } else { ScriptManager.RegisterStartupScript(this, this.GetType(), "alert", "alert('Record are not Found !')", true); CustomerWiseAmount.Visible = false; txtFrom.Focus(); } } #endregion #region FromDate And ToDate And Exeutive else if (txtFrom.Text != string.Empty && txtTo.Text != string.Empty && txtExeutiveName.Text != string.Empty) { Other_Z.OtherBAL ObjDal = new Other_Z.OtherBAL(); HelpDeskReports IDS = new HelpDeskReports(); DataSet DS = new DataSet(); string FromDate = DateTime.Now.ToString("MM/dd/yyyy"); string TODate = DateTime.Now.ToString("MM/dd/yyyy"); FromDate = txtFrom.Text.Split('/')[1] + "/" + txtFrom.Text.Split('/')[0] + "/" + txtFrom.Text.Split('/')[2]; TODate = txtTo.Text.Split('/')[1] + "/" + txtTo.Text.Split('/')[0] + "/" + txtTo.Text.Split('/')[2]; DS = ObjDal.AllRecordRepordTicketHistory(Convert.ToDateTime(FromDate), Convert.ToDateTime(TODate), "0", "0", "0", txtExeutiveName.Text, "0", "0", "FD&TD&Emp"); if (DS.Tables[0].Rows.Count > 0) { CustomerWiseAmount.Visible = true; DataView dv = new DataView(DS.Tables[0]); ReportDocument rd = new ReportDocument(); rd.Load(Server.MapPath("Report/CallReportExecutive.rpt")); rd.Database.Tables[0].SetDataSource(dv); CustomerWiseAmount.ReportSource = rd; } else { ScriptManager.RegisterStartupScript(this, this.GetType(), "alert", "alert('Record are not Found !')", true); CustomerWiseAmount.Visible = false; txtFrom.Focus(); } } #endregion #region FromDate And ToDate And Exeutive And Customer else if (txtFrom.Text != string.Empty && txtTo.Text != string.Empty && txtCutomerName.Text != string.Empty && txtExeutiveName.Text != string.Empty) { Other_Z.OtherBAL ObjDal = new Other_Z.OtherBAL(); HelpDeskReports IDS = new HelpDeskReports(); DataSet DS = new DataSet(); string FromDate = DateTime.Now.ToString("MM/dd/yyyy"); string TODate = DateTime.Now.ToString("MM/dd/yyyy"); FromDate = txtFrom.Text.Split('/')[1] + "/" + txtFrom.Text.Split('/')[0] + "/" + txtFrom.Text.Split('/')[2]; TODate = txtTo.Text.Split('/')[1] + "/" + txtTo.Text.Split('/')[0] + "/" + txtTo.Text.Split('/')[2]; DS = ObjDal.AllRecordRepordTicketHistory(Convert.ToDateTime(FromDate), Convert.ToDateTime(TODate), "0", "0", txtCutomerName.Text.Split(':')[0].ToString(), txtExeutiveName.Text, "0", "0", "FD&TD&Emp"); if (DS.Tables[0].Rows.Count > 0) { CustomerWiseAmount.Visible = true; DataView dv = new DataView(DS.Tables[0]); ReportDocument rd = new ReportDocument(); rd.Load(Server.MapPath("Report/CallReportExecutive.rpt")); rd.Database.Tables[0].SetDataSource(dv); CustomerWiseAmount.ReportSource = rd; } else { ScriptManager.RegisterStartupScript(this, this.GetType(), "alert", "alert('Record are not Found !')", true); CustomerWiseAmount.Visible = false; txtFrom.Focus(); } } #endregion #region From Date And To Date else if (txtFrom.Text != string.Empty && txtTo.Text != string.Empty) { Other_Z.OtherBAL ObjDal = new Other_Z.OtherBAL(); HelpDeskReports IDS = new HelpDeskReports(); DataSet DS = new DataSet(); string FromDate = DateTime.Now.ToString("MM/dd/yyyy"); string TODate = DateTime.Now.ToString("MM/dd/yyyy"); FromDate = txtFrom.Text.Split('/')[1] + "/" + txtFrom.Text.Split('/')[0] + "/" + txtFrom.Text.Split('/')[2]; TODate = txtTo.Text.Split('/')[1] + "/" + txtTo.Text.Split('/')[0] + "/" + txtTo.Text.Split('/')[2]; DS = ObjDal.AllRecordRepordTicketHistory(Convert.ToDateTime(FromDate), Convert.ToDateTime(TODate), "0", "0", "0", "0", "0", "0", "FD&TD"); if (DS.Tables[0].Rows.Count > 0) { CustomerWiseAmount.Visible = true; DataView dv = new DataView(DS.Tables[0]); ReportDocument rd = new ReportDocument(); rd.Load(Server.MapPath("Report/CallReportExecutive.rpt")); rd.Database.Tables[0].SetDataSource(dv); CustomerWiseAmount.ReportSource = rd; } else { ScriptManager.RegisterStartupScript(this, this.GetType(), "alert", "alert('Record are not Found !')", true); CustomerWiseAmount.Visible = false; txtFrom.Focus(); } } #endregion else { ScriptManager.RegisterStartupScript(this, this.GetType(), "alert", "alert('Record are not Found !')", true); CustomerWiseAmount.Visible = false; txtFrom.Focus(); } }
protected void btn_Save_Click(object sender, EventArgs e) { try { if (grdBookDetails.Rows.Count == 0) { MessageBox("Kindly fill Book details"); } else { Specimen _objSepciman = new Specimen(); // _objSepciman.DocumentNo = Convert.ToInt32(txtdoc.Text.Trim()); string DocumentDate = txtdocDate.Text.Split('/')[1] + "/" + txtdocDate.Text.Split('/')[0] + "/" + txtdocDate.Text.Split('/')[2]; string ChallanDate = txtChalDate.Text.Split('/')[1] + "/" + txtChalDate.Text.Split('/')[0] + "/" + txtChalDate.Text.Split('/')[2]; string OrderDate = txtOrdDate.Text.Split('/')[1] + "/" + txtOrdDate.Text.Split('/')[0] + "/" + txtOrdDate.Text.Split('/')[2]; if (txtdoc.Text != "") { _objSepciman.DocumentNo = Convert.ToInt32(txtdoc.Text.Trim()); } _objSepciman.DocumentDate = Convert.ToDateTime(DocumentDate); _objSepciman.ChallanNo = txtchalan.Text.Trim(); _objSepciman.ChallanDate = Convert.ToDateTime(ChallanDate); // string ordno = txtorder.Text.Trim(); //if (ordno == "") //{ // ordno = "0"; //} _objSepciman.OrderNo = txtorder.Text.Trim(); _objSepciman.OrderDate = Convert.ToDateTime(OrderDate); _objSepciman.SalesmanCode = txtsalemanCode.Text.Trim(); _objSepciman.SpInstruction = txtspInstruct.Text.Trim(); _objSepciman.IsActive = true; _objSepciman.IsDeleted = false; _objSepciman.CreatedBy = Convert.ToString(Session["UserName"]);; _objSepciman.Description = Description; _objSepciman.FinancialYearFrom = Convert.ToInt32(strFY); _objSepciman.Save(out DocNo, 1, out DocNewNo); // _objSepciman.Save(out DocNo); txtdoc.Text = Convert.ToString(DocNo); SaveSpecimanDetails(DocNo); Other_Z.OtherBAL objBal = new Other_Z.OtherBAL(); if (DDLSelectSet.SelectedValue != "0") { objBal.SaveSalesmnBookSetLimit(xmlstr, txtsalemanCode.Text, Convert.ToInt32(strFY), Convert.ToString(Session["UserName"]), "Updatebookset", ""); } MessageBox("Record saved successfully \\r\\n Documennt no. " + txtdoc.Text); lblmsg.Text = "Last saved Document no. : " + txtdoc.Text; txtdoc.Text = ""; txtchalan.Text = ""; txtorder.Text = ""; txtsalemanCode.Text = ""; lblSalesManName.Text = ""; txtorder.Focus(); Session["tempBookData"] = null; grdBookDetails.DataSource = null; grdBookDetails.DataBind(); upGridData.Update(); DDLSelectSet.SelectedValue = "0"; Description = ""; } } catch (Exception ex) { string ermsg = ex.Message.ToString(); } }
private void Save(string Flag) { try { if (grdBookDetails.Rows.Count == 0) { MessageBox("Kindly fill Book details"); } if (txtTrasnport.Text == "") { MessageBox("Kindly Select Transpoter"); txtTrasnport.Focus(); return; } else { Other_Z.OtherBAL.SpecimanCN _objSepciman = new Other_Z.OtherBAL.SpecimanCN(); Other_Z.OtherBAL objbal = new Other_Z.OtherBAL(); string CNDate = txtCNDate.Text.Split('/')[1] + "/" + txtCNDate.Text.Split('/')[0] + "/" + txtCNDate.Text.Split('/')[2]; _objSepciman.GCN = Convert.ToInt32(txtGCN.Text == "" ? "0" : txtGCN.Text); _objSepciman.SCN = Convert.ToInt32(txtSCN.Text == "" ? "0" : txtSCN.Text); _objSepciman.CNDate = Convert.ToDateTime(CNDate); _objSepciman.LrNo = Convert.ToInt32(txtlrno.Text == "" ? "0" : txtlrno.Text); _objSepciman.SalesmanId = txtsalemanCode.Text.Split(':')[0]; _objSepciman.FY = Convert.ToInt32(strFY); _objSepciman.SpInstruction = txtspInstruct.Text.Trim(); _objSepciman.CreatedBy = Convert.ToString(Session["UserName"]);; _objSepciman.XmlData = SaveSpecimanDetails(); // SaveSpecimanDetails(1); _objSepciman.BooksetId = Convert.ToInt32(DDLSelectSet.SelectedValue); if (txtsetqty.Text.Trim() != "") { _objSepciman.BooksetQty = Convert.ToInt32(txtsetqty.Text); } else { _objSepciman.BooksetQty = 0; } _objSepciman.TrasportCode = txtTrasnport.Text.Split(':')[0]; int insertno = 0; objbal.SaveReturnSpeciman(_objSepciman, out insertno); MessageBox("Record saved successfully Document No : " + insertno.ToString()); if (Flag == "print") { Page.ClientScript.RegisterStartupScript( this.GetType(), "OpenWindow", "window.open('CNSpecimanPrint.aspx?docno=" + insertno.ToString() + "');", true); } ClearForm(); // _objSepciman.ChallanDate = Convert.ToDateTime(ChallanDate); // string ordno = txtorder.Text.Trim(); //if (ordno == "") //{ // ordno = "0"; //} // _objSepciman.OrderNo = txtorder.Text.Trim(); // _objSepciman.OrderDate = Convert.ToDateTime(OrderDate); //_objSepciman.IsActive = true; //_objSepciman.IsDeleted = false; // _objSepciman.Description = Description; //_objSepciman.Save(out DocNo, 1, out DocNewNo); // _objSepciman.Save(out DocNo); //txtGCN.Text = Convert.ToString(DocNo); // MessageBox("Record saved successfully \\r\\n Documennt no. " ); //lblmsg.Text = "Last saved Document no. : " + txtGCN.Text; } } catch (Exception ex) { string ermsg = ex.Message.ToString(); } }
private void SaveEmailLog() { XmlDocument doc = new XmlDocument(); XmlNode inode = doc.CreateElement("f"); XmlNode fnode = doc.CreateElement("r"); XmlNode element = doc.CreateElement("i"); inode = doc.CreateElement("subdoc"); inode.InnerText = Invno; element.AppendChild(inode); inode = doc.CreateElement("dcdoc"); inode.InnerText = txtOrgDocNo.Text.ToString(); element.AppendChild(inode); inode = doc.CreateElement("mud"); inode.InnerText = "invoice".ToString(); element.AppendChild(inode); inode = doc.CreateElement("toe"); inode.InnerText = lblEmail.Text.ToString(); element.AppendChild(inode); if (ConfigurationManager.AppSettings["invoice_cc"].ToString() != "-1") { inode = doc.CreateElement("cc"); inode.InnerText = ConfigurationManager.AppSettings["invoice_cc"].ToString(); element.AppendChild(inode); } if (ConfigurationManager.AppSettings["invoice_bcc"].ToString() != "-1") { inode = doc.CreateElement("bcc"); inode.InnerText = ConfigurationManager.AppSettings["invoice_bcc"].ToString(); element.AppendChild(inode); } inode = doc.CreateElement("sub"); inode.InnerText = ConfigurationManager.AppSettings["invoice_sub"].ToString() + Invno; element.AppendChild(inode); inode = doc.CreateElement("msg"); inode.InnerText = MailBodyDesign().ToString(); element.AppendChild(inode); inode = doc.CreateElement("sndtm"); inode.InnerText = null; element.AppendChild(inode); inode = doc.CreateElement("st"); inode.InnerText = "pending".ToString(); element.AppendChild(inode); inode = doc.CreateElement("fp"); inode.InnerText = "null".ToString(); element.AppendChild(inode); inode = doc.CreateElement("fy"); inode.InnerText = Convert.ToInt32(Session["FY"]).ToString(); element.AppendChild(inode); inode = doc.CreateElement("ext"); inode.InnerText = "Username :"******"Username"].ToString().ToString() + "," + "FromMail :" + ConfigurationManager.AppSettings["FromMail"].ToString() + "," + "Password :"******"Password"].ToString(); element.AppendChild(inode); inode = doc.CreateElement("rem1"); inode.InnerText = "Insert".ToString(); element.AppendChild(inode); inode = doc.CreateElement("rem2"); inode.InnerText = "".ToString(); element.AppendChild(inode); inode = doc.CreateElement("rem3"); inode.InnerText = "".ToString(); element.AppendChild(inode); fnode.AppendChild(element); Other_Z.OtherBAL ObjBal = new Other_Z.OtherBAL(); ObjBal.SaveEmailLog(fnode.OuterXml, "invoice", "", ""); }