protected void btnRefresh_Click(object sender, EventArgs e) { objpl = new PL_APILog(); objpl.Ind = 6; objpl.ReferenceId = lblreferenceId.Text; objpl.ClientCode = int.Parse(Session["ClientCode"].ToString()); objpl.ClientCodeOdp = int.Parse(Session["ClientCodeOdp"].ToString()); objpl.CaCode = int.Parse(Session["CaCode"].ToString()); objpl.CaCodeOdp = int.Parse(Session["CaCodeOdp"].ToString()); objpl.GSTNNO = Session["ClientGSTNNo"].ToString(); objpl.LogId = Convert.ToInt64(hfLogId.Value.ToString()); objpl.RecordNo = 3; objpl.MonthCD = int.Parse(Session["MonthYrCode"].ToString()); tblInvoice.Visible = false; lblUploadStatus.Text = ""; btnRefresh.Visible = false; DataTable dt = CLSCommon.CallApiPost("api/GSTR2File/TrackStatus", objpl); if (dt != null) { lblTotalInvoices.Text = dt.Rows[0]["TotalInvoice"].ToString(); if (dt.Rows[0]["res"].ToString() == "1") { divSubmit.Visible = true; divSummary.Visible = true; tblInvoice.Visible = true; btnView.Enabled = false; lblUploadStatus.Text = "Prcoess";// +dt.Rows[0]["referenceID"].ToString(); lblUploadStatus.CssClass = "text-success"; lblreferenceId.Text = dt.Rows[0]["referenceID"].ToString(); lblUploaded.Text = (int.Parse(dt.Rows[0]["TotalInvoice"].ToString())).ToString(); lblErrorInvoice.Text = "0"; } else if (dt.Rows[0]["res"].ToString() == "2") { divSubmit.Visible = true; divSummary.Visible = true; btnView.Enabled = true; lblUploaded.Text = (int.Parse(dt.Rows[0]["TotalInvoice"].ToString()) - int.Parse(dt.Rows[0]["ErrorInvoice"].ToString())).ToString(); lblErrorInvoice.Text = dt.Rows[0]["ErrorInvoice"].ToString(); lblreferenceId.Text = dt.Rows[0]["referenceID"].ToString(); tblInvoice.Visible = true; lblUploadStatus.Text = "Error";// +dt.Rows[0]["referenceID"].ToString(); lblUploadStatus.CssClass = "text-danger"; grd.DataSource = dt; grd.DataBind(); } else if (dt.Rows[0]["res"].ToString() == "3") { lblreferenceId.Text = dt.Rows[0]["referenceID"].ToString(); lblUploadStatus.Text = "In Process"; lblUploadStatus.CssClass = "text-danger"; btnRefresh.Visible = true; } else { lblUploadStatus.Text = dt.Rows[0]["Error"].ToString(); } } }
protected void btnConnectTOGSTIN_Click(object sender, EventArgs e) { objpl = new PL_APILog(); objpl.Ind = 1; objpl.ActivityId = 6; objpl.ActivityDesc = "GSTR3B SAVE"; objpl.ClientCode = int.Parse(Session["ClientCode"].ToString()); objpl.ClientCodeOdp = int.Parse(Session["ClientCodeOdp"].ToString()); objpl.CaCode = int.Parse(Session["CaCode"].ToString()); objpl.CaCodeOdp = int.Parse(Session["CaCodeOdp"].ToString()); objpl.GSTNNO = Session["ClientGSTNNo"].ToString(); DataTable dt = CLSCommon.CallApiPost("api/OTPRequest/GenerateOTP", objpl); if (dt != null) { if (dt.Rows[0]["res"].ToString() == "1") { divOTP.Visible = true; lblOTPMessage.Text = "OTP Has Been Sent To your Mobile Number And EmailId Registered With GSTN.."; hfLogId.Value = dt.Rows[0]["LogId"].ToString(); } else { lblOTPMessage.Text = "Some Error Occured In Process Please Try Again.."; } } else { lblOTPMessage.Text = "Some Error Occured In Process Please Try Again.."; } Page.ClientScript.RegisterStartupScript(this.GetType(), "CallMyFunction", "$(document).ready(function(){$('#OTPModal').modal('show');});", true); }
protected void grdAllGstrName_RowCommand(object sender, GridViewCommandEventArgs e) { int RowIndex = 0; RowIndex = int.Parse(e.CommandArgument.ToString()); int data = int.Parse(grdAllGstrName.DataKeys[RowIndex][0].ToString()); foreach (GridViewRow grow in grdAllGstrName.Rows) { LinkButton lnkbtn1 = (LinkButton)grow.FindControl("lblGSTRName"); lnkbtn1.CssClass = "list-group-item"; } LinkButton lnkbtn = (LinkButton)grdAllGstrName.Rows[RowIndex].FindControl("lblGSTRName"); lnkbtn.CssClass = "list-group-item active"; DropDownList ddlMonthYear = (DropDownList)wucTaxPayerStrip.FindControl("ddlMonthYear"); PL_TaxPayerNew objpl = new PL_TaxPayerNew(); objpl.Ind = 1; objpl.ClientCode = int.Parse(Session["ClientCode"].ToString()); objpl.ClientCodeOdp = int.Parse(Session["ClientCodeOdp"].ToString()); objpl.ClientGSTNNO = Session["ClientGSTNNO"].ToString(); objpl.RecordNo = data.ToString(); objpl.MonthCD = ddlMonthYear.SelectedValue.ToString(); DataTable dt = CLSCommon.CallApiPost("api/TaxPayeNew/GetAllData", objpl); if (dt.Rows.Count > 0) { GridView1.DataSource = dt; GridView1.DataBind(); } }
public void GetClientstatusDashboard() { DropDownList ddl = (DropDownList)wucTaxPayerStrip.FindControl("ddlMonthYear"); PL_ClientDashboard objpl = new PL_ClientDashboard(); objpl.ind = 1; objpl.ClientCode = Convert.ToInt32(HttpContext.Current.Session["ClientCode"]); // objpl.ClientCode = 52; objpl.ClientCodeOdp = Convert.ToInt32(HttpContext.Current.Session["ClientCodeOdp"]); // objpl.ClientCodeOdp = 136; objpl.GSTIN = HttpContext.Current.Session["ClientGSTNNO"].ToString(); //objpl.GSTIN = "23CYBER1234I1ZA"; objpl.MonthInd = Convert.ToInt32(ddl.SelectedValue.ToString()); objpl.YearInd = 0; DataTable dt = new DataTable(); dt = CLSCommon.CallApiPost("api/ClientDashboard/GetClientstatusDashboard", objpl); if (dt.Rows.Count > 0) { // " Record Inserted Successfully" } else { // "Not Inserted" } }
protected void btnSave_Click(object sender, EventArgs e) { //DropDownList ddl = (DropDownList)wucTaxPayerStrip.FindControl("ddlMonthYear"); objpl = new PL_APILog(); objpl.Ind = 5; objpl.ClientCode = int.Parse(Session["ClientCode"].ToString()); objpl.ClientCodeOdp = int.Parse(Session["ClientCodeOdp"].ToString()); objpl.CaCode = int.Parse(Session["CaCode"].ToString()); objpl.CaCodeOdp = int.Parse(Session["CaCodeOdp"].ToString()); objpl.GSTNNO = Session["ClientGSTNNo"].ToString(); objpl.LogId = Convert.ToInt64(hfLogId.Value.ToString()); objpl.RecordNo = 3; objpl.MonthCD = int.Parse(Session["MonthYrCode"].ToString()); DataTable dt = CLSCommon.CallApiPost("api/ctrlGSTR3B/SaveGSTR3B", objpl); if (dt != null) { if (dt.Rows[0]["res"].ToString() == "1") { lblGSTR3B.Text = "Data Saved To GSTIN Refrence ID " + dt.Rows[0]["referenceID"].ToString(); } else { lblGSTR3B.Text = dt.Rows[0]["Error"].ToString(); } } }
protected void btnUploadSummary_Click(object sender, EventArgs e) { objpl = new PL_APILog(); // DropDownList ddl = (DropDownList)wucTaxPayerStrip.FindControl("ddlMonthYear"); objpl.Ind = 1; // objplSigned.ReferenceId = lblreferenceId.Text; objpl.ClientCode = int.Parse(Session["ClientCode"].ToString()); objpl.ClientCodeOdp = int.Parse(Session["ClientCodeOdp"].ToString()); objpl.CaCode = int.Parse(Session["CaCode"].ToString()); objpl.CaCodeOdp = int.Parse(Session["CaCodeOdp"].ToString()); objpl.GSTNNO = Session["ClientGSTNNo"].ToString(); objpl.LogId = Convert.ToInt64(hfLogId.Value.ToString()); objpl.MonthCD = int.Parse(Session["MonthYrCode"].ToString()); DataTable dt = CLSCommon.CallApiPost("api/GSTR1File/GetSignedData", objpl); if (dt != null) { if (dt.Rows[0]["res"].ToString() == "1") { lblFileMessage.CssClass = "text-danger"; ViewState["Summary"] = dt.Rows[0]["Summary"].ToString(); // JObject obj = JObject.Parse(dt.Rows[0]["Error"].ToString()); lblFileMessage.Text = dt.Rows[0]["Message"].ToString(); } else { lblFileMessage.CssClass = "text-danger"; // JObject obj = JObject.Parse(dt.Rows[0]["Error"].ToString()); lblFileMessage.Text = dt.Rows[0]["Error"].ToString(); } } }
protected void btnGetSummary_Click(object sender, EventArgs e) { divOTPSuccess.Style.Add("display", "none"); // DropDownList ddl = (DropDownList)wucTaxPayerStrip.FindControl("ddlMonthYear"); objpl = new PL_APILog(); objpl.Ind = 6; objpl.ClientCode = int.Parse(Session["ClientCode"].ToString()); objpl.ClientCodeOdp = int.Parse(Session["ClientCodeOdp"].ToString()); objpl.CaCode = int.Parse(Session["CaCode"].ToString()); objpl.CaCodeOdp = int.Parse(Session["CaCodeOdp"].ToString()); objpl.GSTNNO = Session["ClientGSTNNo"].ToString(); objpl.LogId = Convert.ToInt64(hfLogId.Value.ToString()); objpl.RecordNo = 3; objpl.MonthCD = int.Parse(Session["MonthYrCode"].ToString()); DataTable dt = CLSCommon.CallApiPost("api/GSTR2File/GetSummary", objpl); if (dt != null) { if (dt.Rows[0]["res"].ToString() == "1") { txtSummary.Text = dt.Rows[0]["Summary"].ToString(); Page.ClientScript.RegisterStartupScript(this.GetType(), "CallMyFunction", "$(document).ready(function(){$('#viewsubmit').modal('show');});", true); } else { lblSummMessage.Text = dt.Rows[0]["Error"].ToString(); } } else { lblSummMessage.Text = "Some Error Occured try Again."; } }
protected void btnGstr2Summary_Click(object sender, EventArgs e) { lblmsg.Text = ""; PL_GSTR2Summary obj = new PL_GSTR2Summary(); DataTable dt = new DataTable(); obj.Ind = 1; obj.CaCode = Convert.ToInt32(Session["CaCode"]); // obj.CaCode = 38; obj.CaCodeOdp = Convert.ToInt32(Session["CaCodeOdp"]); //DropDownList ddlMonthYear = (DropDownList)wucTaxPayerStrip.FindControl("ddlMonthYear"); obj.MonthCD = Convert.ToInt32(Session["MonthYrCode"].ToString()); if (Session["ClientCode"] != null && Session["ClientCodeOdp"] != null) { obj.ClientCode = Convert.ToInt32(Session["ClientCode"].ToString()); obj.ClientCodeOdp = Convert.ToInt32(Session["ClientCodeOdp"].ToString()); obj.ClientGSTIN = Session["ClientGSTNNO"].ToString(); // obj.ClientGSTIN = "33GSPTN3741G1Z9"; dt = CLSCommon.CallApiPost("api/GSTR2Summary/GetGSTR2Summary/", obj); if (dt != null) { GridGSTR2Summ.DataSource = dt; GridGSTR2Summ.DataBind(); } } else { lblmsg.Text = "Please Select Client"; } }
protected void btnSubmit_Click(object sender, EventArgs e) { // divOTPSuccess.Style.Add("display", "none"); //DropDownList ddl = (DropDownList)wucTaxPayerStrip.FindControl("ddlMonthYear"); objpl = new PL_APILog(); objpl.Ind = 1; objpl.ReferenceId = lblreferenceId.Text; objpl.ClientCode = int.Parse(Session["ClientCode"].ToString()); objpl.ClientCodeOdp = int.Parse(Session["ClientCodeOdp"].ToString()); objpl.CaCode = int.Parse(Session["CaCode"].ToString()); objpl.CaCodeOdp = int.Parse(Session["CaCodeOdp"].ToString()); objpl.GSTNNO = Session["ClientGSTNNo"].ToString(); objpl.LogId = Convert.ToInt64(hfLogId.Value.ToString()); objpl.RecordNo = 3; objpl.MonthCD = int.Parse(Session["MonthYrCode"].ToString()); tblInvoice.Visible = false; lblUploadStatus.Text = ""; btnRefresh.Visible = false; DataTable dt = CLSCommon.CallApiPost("api/GSTR2File/SubmitGSTR2", objpl); if (dt != null) { if (dt.Rows[0]["res"].ToString() == "1") { lblSubmitMsg.CssClass = "text-success"; lblSubmitMsg.Text = "Data Submitted Successfully."; } else { lblSubmitMsg.CssClass = "text-danger"; JObject obj = JObject.Parse(dt.Rows[0]["Error"].ToString()); lblSubmitMsg.Text = obj.GetValue("message").ToString(); } } }
protected void btnUploadSummary_Click(object sender, EventArgs e) { objpl = new PL_APILog(); objpl.Ind = 1; objpl.ClientCode = int.Parse(Session["ClientCode"].ToString()); objpl.ClientCodeOdp = int.Parse(Session["ClientCodeOdp"].ToString()); objpl.CaCode = int.Parse(Session["CaCode"].ToString()); objpl.CaCodeOdp = int.Parse(Session["CaCodeOdp"].ToString()); objpl.GSTNNO = Session["ClientGSTNNo"].ToString(); objpl.LogId = Convert.ToInt64(hfLogId.Value.ToString()); objpl.MonthCD = int.Parse(Session["MonthYrCode"].ToString()); DataTable dt = CLSCommon.CallApiPost("api/GSTR2File/GetSignedData", objpl); if (dt != null) { if (dt.Rows[0]["res"].ToString() == "1") { lblFileMessage.CssClass = "text-danger"; ViewState["Summary"] = dt.Rows[0]["Summary"].ToString(); lblFileMessage.Text = dt.Rows[0]["Message"].ToString(); } else { lblFileMessage.CssClass = "text-danger"; lblFileMessage.Text = dt.Rows[0]["Error"].ToString(); } } }
protected void btnGetB2B_Click(object sender, EventArgs e) { divOTPSuccess.Attributes.Add("class", "col-sm-12 col-xs-12 alert alert-success success"); objGSTR2A = new PL_GSTR2A(); objGSTR2A.Ind = 1; objGSTR2A.ClientCode = int.Parse(Session["ClientCode"].ToString()); objGSTR2A.ClientCodeOdp = int.Parse(Session["ClientCodeOdp"].ToString()); objGSTR2A.CaCode = int.Parse(Session["CaCode"].ToString()); objGSTR2A.CaCodeOdp = int.Parse(Session["CaCodeOdp"].ToString()); objGSTR2A.GSTNNO = Session["ClientGSTNNo"].ToString(); objGSTR2A.LogId = Convert.ToInt64(hfLogId.Value.ToString()); objGSTR2A.MonthCD = Convert.ToInt32(Session["MonthYrCode"].ToString()); divOTPSuccess.Style.Add("display", "block"); DataTable dt = CLSCommon.CallApiPost("api/GSTR2A/GetGSTR2AData", objGSTR2A); if (dt != null) { if (dt.Rows[0]["res"].ToString() == "1") { lblGSTR2AStatus.CssClass = "text-success"; DataTable dtGroupFilte = new DataTable(); ViewState["AllData"] = dt; if (rbtn_All.Checked == true) { pnlGroupFilter.Visible = false; pnlUniqe.Visible = false; PnlAlldata.Visible = true; grdGSTR2AData.DataSource = dt; grdGSTR2AData.DataBind(); } else { PnlAlldata.Visible = false; pnlGroupFilter.Visible = true; pnlUniqe.Visible = false; } if (dt.Rows.Count > 0) { dtGroupFilte = dt.DefaultView.ToTable(true, "PurchGSTIN"); GridGroupFilter.DataSource = dtGroupFilte; GridGroupFilter.DataBind(); } // ScriptManager.RegisterStartupScript(this, this.GetType(), "Pop", "ShowSummModal();", true); // Page.ClientScript.RegisterStartupScript(this.GetType(), "CallMyFunction", "$('#GSTR2AModal').modal('show');", true); // lblGSTR2AStatus.Text = dt.Rows[0]["data"].ToString(); } else { lblGSTR2AStatus.CssClass = "text-danger"; lblGSTR2AStatus.Text = dt.Rows[0]["Error"].ToString(); } } }
void GetStatus(int RowIndex) { if (grdAllGstrName.Rows.Count > 0) { int data = int.Parse(grdAllGstrName.DataKeys[RowIndex][0].ToString()); foreach (GridViewRow grow in grdAllGstrName.Rows) { LinkButton lnkbtn1 = (LinkButton)grow.FindControl("lnkbtn"); lnkbtn1.CssClass = "list-group-item text-center brdno"; } LinkButton lnkbtn = (LinkButton)grdAllGstrName.Rows[RowIndex].FindControl("lnkbtn"); lnkbtn.CssClass = "list-group-item text-center brdno active"; //DropDownList ddlMonthYear = (DropDownList)wucTaxPayerStrip.FindControl("ddlMonthYear"); PL_TaxPayerNew objpl = new PL_TaxPayerNew(); objpl.Ind = 1; objpl.ClientCode = int.Parse(Session["ClientCode"].ToString()); objpl.ClientCodeOdp = int.Parse(Session["ClientCodeOdp"].ToString()); objpl.ClientGSTNNO = Session["ClientGSTNNO"].ToString(); objpl.RecordNo = data.ToString(); objpl.MonthCD = Session["MonthYrCode"].ToString(); DataTable dt = CLSCommon.CallApiPost("api/TaxPayeNew/GetAllData", objpl); li3bGenerated.Attributes.Remove("class"); liSaved.Attributes.Remove("class"); liSubmit.Attributes.Remove("class"); liFiled.Attributes.Remove("class"); step1.Attributes.Remove("class"); step2.Attributes.Remove("class"); step3.Attributes.Remove("class"); if (dt.Rows.Count > 0) { if (int.Parse(dt.Rows[0]["TotalCompleted"].ToString()) > 0) { li3bGenerated.Attributes.Add("class", "active"); } if (int.Parse(dt.Rows[0]["TotalSaved"].ToString()) > 0) { liSaved.Attributes.Add("class", "active"); step1.Attributes.Add("class", "step active"); } if (int.Parse(dt.Rows[0]["TotalSubmit"].ToString()) > 0) { liSubmit.Attributes.Add("class", "active"); step2.Attributes.Add("class", "step active"); } if (int.Parse(dt.Rows[0]["TotalFiled"].ToString()) > 0) { liFiled.Attributes.Add("class", "active"); step3.Attributes.Add("class", "step active"); } } } }
protected void btnSave_Click(object sender, EventArgs e) { lblMsg.Text = ""; lblMsg.CssClass = ""; DataTable dt = CreatGridDtItem(); foreach (ListItem lst in chkListMainMenu.Items) { if (lst.Selected) { DataRow dr = dt.NewRow(); dr["MenuId"] = lst.Value; dr["MenuDesc"] = lst.Text; dt.Rows.Add(dr); } } if (ddlUserLevel.SelectedIndex <= 0) { ShowMessage("Please Select User Level", false); ddlUserLevel.Focus(); return; } if (ddlClient_Ca_Arti.SelectedIndex <= 0) { ShowMessage("Please Select CA / Article / Client", false); ddlUserLevel.Focus(); return; } if (dt.Rows.Count <= 0) { ShowMessage("Please Select At Least One Menu", false); return; } if (VsdtGvItemDetail == null || VsdtGvItemDetail.Rows.Count <= 0) { ShowMessage("Please Add Menu In Grid First", false); return; } plob.Ind = 5; plob.UserLevelId = Convert.ToInt32(ddlUserLevel.SelectedValue); plob.UserLevelDesc = ddlUserLevel.SelectedItem.Text; plob.ClientId = Convert.ToInt32(Session["CaCode"]); plob.ClientIdOdp = Convert.ToInt32(Session["CaCodeOdp"]); plob.LoginId = Convert.ToInt32(Session["UserCode"]); plob.CAAdminCode = Convert.ToInt32(Session["CaCode"]); plob.dt_Menu = VsdtGvItemDetail; DataTable dtApi = new DataTable(); dtApi = CLSCommon.CallApiPost("api/MenuAllotment/MenuAllotmentSave", plob); if (dtApi.Rows.Count > 0) { Clear(); ShowMessage("Record Save Successfully....!!!!", true); } }
protected void btnVerify_Click(object sender, EventArgs e) { if (txtOtp.Text.Trim() == "") { return; } else if (hfLogId.Value.ToString() == "") { return; } else { objpl = new PL_APILog(); objpl.Ind = 3; objpl.ClientCode = int.Parse(Session["ClientCode"].ToString()); objpl.ClientCodeOdp = int.Parse(Session["ClientCodeOdp"].ToString()); objpl.CaCode = int.Parse(Session["CaCode"].ToString()); objpl.CaCodeOdp = int.Parse(Session["CaCodeOdp"].ToString()); objpl.GSTNNO = Session["ClientGSTNNo"].ToString(); objpl.LogId = Convert.ToInt64(hfLogId.Value.ToString()); objpl.OTP = txtOtp.Text; divOTPSuccess.Attributes.Remove("class"); divOTPSuccess.Style.Add("display", "block"); DataTable dt = CLSCommon.CallApiPost("api/OTPRequest/VerifyOTP", objpl); if (dt != null) { if (dt.Rows[0]["res"].ToString() == "1") { lblSuccess.InnerText = "Verified Successfully."; divOTP.Enabled = false; divOTPSuccess.Attributes.Add("class", "col-sm-12 col-xs-12 alert alert-success success"); divSaveTOGSTN.Visible = true; pnlFile.Visible = true; divSubmit.Visible = true; divSummary.Visible = true; CheckSession(); } else { lblSuccess.InnerText = dt.Rows[0]["Message"].ToString(); divOTPSuccess.Attributes.Add("class", "col-sm-12 col-xs-12 alert alert-danger denger"); divOTP.Visible = true; divOTP.Enabled = true; } } else { lblSuccess.InnerText = "Error Occured In verifying OTP Try Again."; divOTPSuccess.Attributes.Add("class", "col-sm-12 col-xs-12 alert alert-danger denger"); divOTP.Visible = true; divOTP.Enabled = true; } } }
protected void btnRegisterDSC_Click(object sender, EventArgs e) { if (hfLogId.Value.ToString() == "") { return; } else { objdscpl = new PL_DSCRegByTrueCopy(); objdscpl.Ind = 3; objdscpl.ClientCode = int.Parse(Session["ClientCode"].ToString()); objdscpl.ClientCodeOdp = int.Parse(Session["ClientCodeOdp"].ToString()); objdscpl.CaCode = int.Parse(Session["CaCode"].ToString()); objdscpl.CaCodeOdp = int.Parse(Session["CaCodeOdp"].ToString()); objdscpl.GSTNNO = Session["ClientGSTNNo"].ToString(); objdscpl.LogId = Convert.ToInt64(hfLogId.Value.ToString()); //objpl.OTP = txtOtp.Text; DataTable dt = CLSCommon.CallApiPost("api/DSCRegByTrueCopy/RegisterDSC", objdscpl); if (dt != null) { if (dt.Rows[0]["res"].ToString() == "1") { lblUploadStatus.Text = "DSC Regitration Successfully With GSTN."; lblUploadStatus.CssClass = "text-success"; divOTP.Enabled = false; // divOTPSuccess.Attributes.Add("class", "col-sm-12 col-xs-12 alert alert-success success"); divRegisterDSC.Visible = true; } else { lblUploadStatus.CssClass = "text-danger"; if (dt.Rows[0]["Error"].ToString() == "PENDING") { lblUploadStatus.Text = "Uploaded Hash is pending for Approval, Please Approve Uploaded Hash."; } else { lblUploadStatus.Text = dt.Rows[0]["Error"].ToString(); } //divOTPSuccess.Attributes.Add("class", "col-sm-12 col-xs-12 alert alert-danger denger"); } } else { lblUploadStatus.Text = "Error Occured In Registering DSC."; lblUploadStatus.CssClass = "text-danger"; //divOTPSuccess.Attributes.Add("class", "col-sm-12 col-xs-12 alert alert-danger denger"); } } }
protected void btnValidate_Click(object sender, EventArgs e) { X509Store store = new X509Store(StoreLocation.CurrentUser); store.Open(OpenFlags.ReadOnly); X509CertificateCollection certificates = X509Certificate2UI.SelectFromCollection(store.Certificates, "Select Certificate", "Select Certificate for encrypting return", X509SelectionFlag.SingleSelection ); X509Certificate2 mycert = null; foreach (X509Certificate2 cert in store.Certificates) { if (cert.Subject.Contains("CN=BHAGWAT SINGH NAGORI")) { //byte[] certbyte = Encoding.ASCII.GetBytes(cert.ToString()); mycert = cert; break; } } store.Close(); objpl = new PL_APILog(); objpl.Ind = 3; objpl.ReferenceId = lblreferenceId.Text; objpl.ClientCode = int.Parse(Session["ClientCode"].ToString()); objpl.ClientCodeOdp = int.Parse(Session["ClientCodeOdp"].ToString()); objpl.CaCode = int.Parse(Session["CaCode"].ToString()); objpl.CaCodeOdp = int.Parse(Session["CaCodeOdp"].ToString()); objpl.GSTNNO = Session["ClientGSTNNo"].ToString(); objpl.LogId = Convert.ToInt64(hfLogId.Value.ToString()); objpl.RecordNo = 3; objpl.MonthCD = int.Parse(Session["MonthYrCode"].ToString()); tblInvoice.Visible = false; lblUploadStatus.Text = ""; btnRefresh.Visible = false; DataTable dt = CLSCommon.CallApiPost("api/GetSignedData/GetSignedData", objpl); if (dt != null) { if (dt.Rows[0]["res"].ToString() == "1") { byte[] SignByte = Convert.FromBase64String(dt.Rows[0]["SignedData"].ToString()); //byte[] SignByte = Encoding.ASCII.GetBytes(EDecodedStringnc); bool Check = ClsSignUtil.Verify(SignByte, mycert); } } }
protected void btnSave_Click(object sender, EventArgs e) { objpl = new PL_ClientProfile(); objpl.Ind = 1; objpl.StateCode = int.Parse(ddlState.SelectedValue.ToString()); objpl.DistrictCode = 0; objpl.CityCode = int.Parse(ddlCity.SelectedIndex < 0 ? "0" : ddlCity.SelectedValue.ToString()); objpl.ClientType = 0; objpl.FirmName = txtOrganisationName.Text; objpl.ClientNameE = txtName.Text; objpl.ClientNameH = txtName.Text; objpl.ClientDesg = txtDesignation.Text; objpl.ClientMobileNo1 = txtMobileNo.Text; objpl.ClientMobileNo2 = txtAlternateMobile.Text; objpl.LandLineNo = txtLandLineNo.Text; objpl.EmailId = txtEmailId.Text; objpl.ClientPANNo = txtPanNo.Text.ToUpper(); objpl.AadhaarNo = txtAadhaarNo.Text; objpl.AlternateContactName = txtAlternatePerson.Text; objpl.AlternateMobileNo = txtAlternateMobile.Text; objpl.AlternateEmailid = txtEmailId.Text; objpl.BankName = txtBankName.Text; objpl.BranchName = txtBranchName.Text; objpl.IFSCCode = IFSCCode.Text.ToUpper(); objpl.AccountNo = txtAccountNo.Text; objpl.DependentInd = 1; objpl.CACode = int.Parse(Session["CACode"].ToString()); objpl.CACodeOdp = 0; objpl.ActiveInd = 1; objpl.LoginUserCode = 0; objpl.RefnoOtherSys = 0; objpl.BussinessTypeId = int.Parse(ddlBussinessType.SelectedValue.ToString()); objpl.BussinessNatureId = int.Parse(ddlBussinessNature.SelectedValue.ToString()); objpl.FullAddress = txtFullAddress.Text; objpl.PinCode = txtPinCode.Text; objpl.RegNo = 0;//int.Parse(Session["RegNo"].ToString()); objpl.GSTINNo = txtGSTINNo.Text.ToUpper(); DataTable dt = CLSCommon.CallApiPost("api/ClientProfile/SaveClientData/", objpl); if (dt.Rows.Count > 0) { pnlError.Visible = true; Session["ErrorMsg"] = dt.Rows[0]["ErrorMsg"].ToString(); Response.Redirect("frmSubmitted.aspx"); lblMsg.Text = "Record Saved Successfully. Client Code : " + dt.Rows[0]["ClientCode"].ToString(); clear(); } }
protected void btnGetSummary_Click(object sender, EventArgs e) { GridGSTR1Summ.DataSource = null; GridGSTR1Summ.DataBind(); // divOTPSuccess.Style.Add("display", "none"); // DropDownList ddl = (DropDownList)wucTaxPayerStrip.FindControl("ddlMonthYear"); objpl = new PL_APILog(); objpl.Ind = 6; objpl.ClientCode = int.Parse(Session["ClientCode"].ToString()); objpl.ClientCodeOdp = int.Parse(Session["ClientCodeOdp"].ToString()); objpl.CaCode = int.Parse(Session["CaCode"].ToString()); objpl.CaCodeOdp = int.Parse(Session["CaCodeOdp"].ToString()); objpl.GSTNNO = Session["ClientGSTNNo"].ToString(); objpl.LogId = Convert.ToInt64(hfLogId.Value.ToString()); objpl.RecordNo = 3; objpl.MonthCD = int.Parse(Session["MonthYrCode"].ToString()); DataTable dt = CLSCommon.CallApiPost("api/GSTR1File/GetSummary", objpl); if (dt != null) { if (dt.Rows[0]["res"].ToString() == "1") { // txtSummary.Text = dt.Rows[0]["Summary"].ToString(); ViewState["Summary"] = dt.Rows[0]["Summary"].ToString(); ClsGSTR1Summ objGstr1summ = JsonConvert.DeserializeObject <ClsGSTR1Summ>(dt.Rows[0]["Summary"].ToString()); GridGSTR1Summ.DataSource = objGstr1summ.sec_sum; GridGSTR1Summ.DataBind(); ScriptManager.RegisterStartupScript(this, this.GetType(), "Pop", "ShowSummModal();", true); // Page.ClientScript.RegisterStartupScript(this.GetType(), "CallMyFunction", "ShowSummModal();", true); } else { lblSummMessage.Text = dt.Rows[0]["Error"].ToString(); } } else { lblSummMessage.Text = "Some Error Occured try Again."; } }
//protected void ddlState_SelectedIndexChanged(object sender, EventArgs e) //{ // DataSet ds = CLSCommon.CallApiGet("api/AddCAAdmin/FillDdlState?Ind=3&StateCode=" + ddlState.SelectedValue.ToString()); // if (ds.Tables.Count > 0) // { // ddlCity.DataSource = ds.Tables[0]; // ddlCity.DataTextField = "CityDesc"; // ddlCity.DataValueField = "CityCode"; // ddlCity.DataBind(); // ddlCity.Items.Insert(0, new ListItem("Select", "0")); // ddlCity.Focus(); // Page.ClientScript.RegisterStartupScript(this.GetType(), "CallMyFunction", "$(document).ready(function(){ $('#ContentPlaceHolder1_ddlCity_chzn').focus();});", true); // } //} protected void btnSave_Click1(object sender, EventArgs e) { PL_AddCaAdmin objpl = new PL_AddCaAdmin(); objpl.Ind = 1; // objpl.StateCode = int.Parse(ddlState.SelectedValue.ToString()); objpl.DistrictCode = 0; // objpl.CityCode = ddlCity.SelectedIndex == -1 ? 0 : int.Parse(ddlCity.SelectedValue.ToString()); objpl.CACode = 0; objpl.CaCodeOdp = 0; // objpl.CaFirmType = int.Parse(ddlConsultantType.SelectedValue.ToString()); objpl.CaNameE = txtName.Text.Trim(); objpl.CaNameH = txtName.Text.Trim(); // objpl.CaFirmNm = txtOrganisationName.Text.Trim(); // objpl.CaFirmAddress = txtFullAddress.Text.Trim(); // objpl.CaFirmCityCode = ddlCity.SelectedIndex == -1 ? 0 : int.Parse(ddlCity.SelectedValue.ToString()); // objpl.CaFirmPinCode = txtPinCode.Text.Trim(); // objpl.CaFirmStateCode = int.Parse(ddlState.SelectedValue.ToString()); objpl.CaMobileNo1 = txtMobileNo.Text.Trim(); // objpl.CaMobileNo2 = txtAlternateMobile.Text.Trim(); // objpl.CaLandlineNo = txtLandLineNo.Text.Trim(); //objpl.CaadhaarNo = txtAadhaarNo.Text.Trim(); objpl.CaEmailid = txtEmailId.Text.Trim(); // objpl.AlternativeContactname = txtAlternatePerson.Text.Trim(); // objpl.AlternateMobileNo = txtAlternateMobile.Text.Trim(); // objpl.AlternateEmailid = txtAlternateEmailId.Text.Trim(); objpl.AdminCAInd = 2; objpl.AdminCaCode = int.Parse(Session["CaCode"].ToString()); objpl.MainAdminCaOdpCode = int.Parse(Session["CaCodeOdp"].ToString()); objpl.LoginUserCode = 0;//int.Parse(Session["UserCode"].ToString()); DataTable dt = CLSCommon.CallApiPost("api/AddCAAdmin/SaveData/", objpl); if (dt.Rows.Count > 0) { pnlError.Visible = true; Session["ErrorMsg"] = dt.Rows[0]["ErrorMsg"].ToString(); Response.Redirect("frmSubmitted.aspx"); // lblMsg.Text = "Record Saved Successfully. Client Code : " + dt.Rows[0]["ClientCode"].ToString(); } ClearAllControls(); }
void UpdateData(int AllotCaCode, int ClientCode, int ClientCodeOdp, string GSTNNO, int OdpGSTNNO, string ClientName) { objpl = new PL_CAAllotment(); objpl.Ind = 2; objpl.CaCode = int.Parse(Session["CaCode"].ToString()); objpl.CaCodeOdp = int.Parse(Session["CaCodeOdp"].ToString()); objpl.AllotmentCaCode = AllotCaCode; objpl.ClientCode = ClientCode; objpl.ClientCodeOdp = ClientCodeOdp; objpl.GSTNNO = GSTNNO; objpl.OdpGSTNNO = OdpGSTNNO; DataTable dt = CLSCommon.CallApiPost("api/CAAllotment/UpdateClientAllotment", objpl); if (dt.Rows.Count > 0) { pnlError.CssClass = "alert alert-success"; lblMsg.Text = "Ca Alloted Successfully Client Name : " + ClientName; pnlError.Visible = true; GetAllClient(); } }
protected void btnUploadHasg_Click(object sender, EventArgs e) { if (hfLogId.Value.ToString() == "") { return; } else { objdscpl = new PL_DSCRegByTrueCopy(); objdscpl.Ind = 1; objdscpl.ClientCode = int.Parse(Session["ClientCode"].ToString()); objdscpl.ClientCodeOdp = int.Parse(Session["ClientCodeOdp"].ToString()); objdscpl.CaCode = int.Parse(Session["CaCode"].ToString()); objdscpl.CaCodeOdp = int.Parse(Session["CaCodeOdp"].ToString()); objdscpl.GSTNNO = Session["ClientGSTNNo"].ToString(); objdscpl.LogId = Convert.ToInt64(hfLogId.Value.ToString()); DataTable dt = CLSCommon.CallApiPost("api/DSCRegByTrueCopy/UploadHash", objdscpl); if (dt != null) { if (dt.Rows[0]["res"].ToString() == "1") { lblUploadStatus.Text = "Hash Uploaded Successfully."; lblUploadStatus.CssClass = "text-success"; divOTP.Enabled = false; divRegisterDSC.Visible = true; } else { lblUploadStatus.Text = dt.Rows[0]["Error"].ToString(); lblUploadStatus.CssClass = "text-danger"; } } else { lblUploadStatus.Text = "Error Occured In Hash Uploading."; lblUploadStatus.CssClass = "text-danger"; } } }
protected void btnSave_Click(object sender, EventArgs e) { objpl = new PL_AddArticle(); objpl.Ind = 1; objpl.Name = txtName.Text; objpl.MobileNo = txtMobileNo.Text; objpl.EmailId = txtEmailId.Text; objpl.CaCode = int.Parse(Session["CaCode"].ToString()); objpl.CaCodeOdp = int.Parse(Session["CaCodeOdp"].ToString()); objpl.UserLevel = int.Parse(Session["UserLevel"].ToString()); DataTable dt = CLSCommon.CallApiPost("api/Article/SaveArticle", objpl); if (dt != null) { if (dt.Rows.Count > 0) { pnlError.Visible = true; Session["ErrorMsg"] = dt.Rows[0]["ErrorMsg"].ToString(); Response.Redirect("frmSubmitted.aspx"); } } }
protected void btnGetSummary_Click(object sender, EventArgs e) { divOTPSuccess.Style.Add("display", "none"); // DropDownList ddl = (DropDownList)wucTaxPayerStrip.FindControl("ddlMonthYear"); objpl = new PL_APILog(); objpl.Ind = 6; objpl.ClientCode = int.Parse(Session["ClientCode"].ToString()); objpl.ClientCodeOdp = int.Parse(Session["ClientCodeOdp"].ToString()); objpl.CaCode = int.Parse(Session["CaCode"].ToString()); objpl.CaCodeOdp = int.Parse(Session["CaCodeOdp"].ToString()); objpl.GSTNNO = Session["ClientGSTNNo"].ToString(); objpl.LogId = Convert.ToInt64(hfLogId.Value.ToString()); objpl.RecordNo = 3; objpl.MonthCD = int.Parse(Session["MonthYrCode"].ToString()); DataTable dt = CLSCommon.CallApiPost("api/GSTR1File/GetSummary", objpl); if (dt != null) { if (dt.Rows[0]["res"].ToString() == "1") { txtSummary.Text = dt.Rows[0]["Summary"].ToString(); UploadForSigning(); } else { divsuccessmsg.CssClass = "alert alert-danger"; divsuccessmsg.Visible = true; lblSummMessage.Text = dt.Rows[0]["Error"].ToString(); } } else { divsuccessmsg.CssClass = "alert alert-danger"; divsuccessmsg.Visible = true; lblSummMessage.Text = "Some Error Occured try Again."; } }
protected void btnSave_Click1(object sender, EventArgs e) { plobj = new PL_CARegis(); plobj.Ind = 1; plobj.CA_Name = txtName.Text; plobj.CA_OrganizationName = txtOrganisationName.Text; plobj.CA_Category = txtCategory.Text; plobj.CA_PANNo = txtPanNo.Text; plobj.CA_MobileNo = txtMobileNo.Text; plobj.CA_EmailId = txtEmailId.Text; plobj.CA_ConsultantType = ddlConsultantType.SelectedValue.ToString(); plobj.CA_Designation = txtDesignation.Text; plobj.CA_LandlineNo = txtLandLineNo.Text; plobj.CA_AadharNo = txtAadhaarNo.Text; plobj.CA_FullAddress = txtFullAddress.Text; plobj.CA_State = ddlState.SelectedValue.ToString(); plobj.CA_City = ddlCity.SelectedIndex < 0 ? "0" : ddlCity.SelectedValue.ToString(); plobj.CA_PinCode = txtPinCode.Text; plobj.CA_AlternateContPerson = txtAlternatePerson.Text; plobj.CA_AlternateMobileNo = txtAlternateMobile.Text; plobj.CA_AlternateEmailId = txtAlternateEmailId.Text; plobj.CA_BankName = txtBankName.Text; plobj.CA_BranchName = txtBranchName.Text; plobj.CA_IFSCCode = IFSCCode.Text; plobj.CA_AC_No = txtAccountNo.Text; DataTable dt = CLSCommon.CallApiPost("api/CARegis/SaveData/", plobj); if (dt.Rows.Count > 0) { pnlError.Visible = true; Session["ErrorMsg"] = dt.Rows[0]["ErrorMsg"].ToString(); Response.Redirect("frmSubmitted.aspx"); lblMsg.Text = "Record Saved Successfully. Client Code : " + dt.Rows[0]["ClientCode"].ToString(); } ClearAllControls(); }
protected void btnGSTR1Data_Click(object sender, EventArgs e) { divOTPSuccess.Attributes.Add("class", "col-sm-12 col-xs-12 alert alert-success success"); //DropDownList ddl = (DropDownList)wucTaxPayerStrip.FindControl("ddlMonthYear"); objplGSTR1 = new PL_GetGSTR1Data(); objplGSTR1.Ind = 1; objplGSTR1.ClientCode = int.Parse(Session["ClientCode"].ToString()); objplGSTR1.ClientCodeOdp = int.Parse(Session["ClientCodeOdp"].ToString()); // objPLLedger.CaCode = int.Parse(Session["CaCode"].ToString()); // objPLLedger.CaCodeOdp = int.Parse(Session["CaCodeOdp"].ToString()); objplGSTR1.GSTNNO = Session["ClientGSTNNo"].ToString(); objplGSTR1.LogId = Convert.ToInt64(hfLogId.Value.ToString()); // objPLLedger.OTP = txtOtp.Text; objplGSTR1.MonthCD = Convert.ToInt32(Session["MonthYrCode"].ToString()); // objplGSTR1.FromDate = "01-07-2017"; //objplGSTR1.ToDate = "30-07-2017"; // divOTPSuccess.Attributes.Remove("class"); divOTPSuccess.Style.Add("display", "block"); DataTable dt = CLSCommon.CallApiPost("api/GetGSTR1Data/" + ddlGstr1Type.SelectedValue.ToString(), objplGSTR1); if (dt != null) { if (dt.Rows[0]["res"].ToString() == "1") { lblLedgerStatus.CssClass = "text-success"; lblLedgerStatus.Text = dt.Rows[0]["data"].ToString(); } else { lblLedgerStatus.CssClass = "text-danger"; lblLedgerStatus.Text = dt.Rows[0]["Error"].ToString(); } } }
protected void GetCashLedger_Click(object sender, EventArgs e) { divOTPSuccess.Attributes.Add("class", "col-sm-12 col-xs-12 alert alert-success success"); objPLLedger = new PL_LegderApiLog(); objPLLedger.Ind = 1; objPLLedger.ClientCode = int.Parse(Session["ClientCode"].ToString()); objPLLedger.ClientCodeOdp = int.Parse(Session["ClientCodeOdp"].ToString()); // objPLLedger.CaCode = int.Parse(Session["CaCode"].ToString()); // objPLLedger.CaCodeOdp = int.Parse(Session["CaCodeOdp"].ToString()); objPLLedger.GSTNNO = Session["ClientGSTNNo"].ToString(); objPLLedger.LogId = Convert.ToInt64(hfLogId.Value.ToString()); // objPLLedger.OTP = txtOtp.Text; objPLLedger.MonthCD = Convert.ToInt32(Session["MonthYrCode"].ToString()); objPLLedger.FromDate = "01-07-2017"; objPLLedger.ToDate = "30-07-2017"; // divOTPSuccess.Attributes.Remove("class"); divOTPSuccess.Style.Add("display", "block"); DataTable dt = CLSCommon.CallApiPost("api/ctrlLedger/Get_Ledger_BAL", objPLLedger); if (dt != null) { if (dt.Rows[0]["res"].ToString() == "1") { lblLedgerStatus.CssClass = "text-success"; lblLedgerStatus.Text = dt.Rows[0]["Response"].ToString(); } else { lblLedgerStatus.CssClass = "text-danger"; lblLedgerStatus.Text = dt.Rows[0]["Error"].ToString(); } } }
void SaveMismatchAction(int ind, Int64 recordNo, int ActionId, string ActionDesc, string invoiceNo, Int64 RecordNo2A, DataTable dtinv, string PurchGSTIN, string G2APurchGSTIN, string G2AinvoiceNo) { //DropDownList ddl = (DropDownList)wucTaxPayerStrip.FindControl("ddlMonthYear"); PL_GenerateMismatch objpl = new PL_GenerateMismatch(); objpl.Ind = ind; objpl.ClientCode = int.Parse(Session["ClientCode"].ToString()); objpl.ClientCodeOdp = int.Parse(Session["ClientCodeOdp"].ToString()); objpl.GSTIN = Session["ClientGSTNNO"].ToString(); objpl.MonthCd = int.Parse(Session["MonthYrCode"].ToString()); objpl.ActionId = ActionId; objpl.ActionDesc = ActionDesc; objpl.RecordNo = recordNo; objpl.UserCode = int.Parse(Session["UserCode"].ToString()); objpl.InvoiceNo = invoiceNo; objpl.RecordNo2A = RecordNo2A; objpl.dtInvoice = dtinv; objpl.PurchGSTIN = PurchGSTIN; objpl.G2APurchGSTIN = G2APurchGSTIN; objpl.G2AInvoiceNo = G2AinvoiceNo; DataTable dt = CLSCommon.CallApiPost("api/GenerateMismatch/SaveMismatchAction", objpl); if (dt != null) { if (dt.Rows[0]["res"].ToString() == "1") { lblActinLabel.Text = "Action Taken Successfully."; lblActinLabel.CssClass = "text-success"; } else { lblActinLabel.Text = "Invoice Already Available In GSTR-2."; lblActinLabel.CssClass = "text-danger"; } } }
private void Import_To_Grid(string FilePath, string Extension, string ExcelNo) { OleDbConnection connExcel = null; OleDbCommand cmdExcel; OleDbDataAdapter oda; try { string conStr = ""; switch (Extension) { case ".xls": //Excel 97-03 conStr = ConfigurationManager.ConnectionStrings["Excel03ConString"] .ConnectionString; break; case ".xlsx": //Excel 07 conStr = ConfigurationManager.ConnectionStrings["Excel07ConString"] .ConnectionString; break; case ".xlsm": //Excel 07 conStr = ConfigurationManager.ConnectionStrings["Excel07ConString"] .ConnectionString; break; default: { Panels.Attributes.Add("class", "alert alert-danger"); lblMessage.Text = "Please Select Excel File Only."; Page.ClientScript.RegisterStartupScript(this.GetType(), "CallMyFunction", "$(document).ready(function(){$('#inputModal').modal('show');});", true); Panels.Visible = true; return; //break; } } conStr = String.Format(conStr, FilePath + Extension, "Yes"); connExcel = new OleDbConnection(conStr); cmdExcel = new OleDbCommand(); oda = new OleDbDataAdapter(); DataTable dt = new DataTable(); cmdExcel.Connection = connExcel; DataTable dt1 = new DataTable(); DataTable dt2 = new DataTable(); //Get the name of First Sheet connExcel.Open(); DataTable dtExcelSchema; dtExcelSchema = connExcel.GetOleDbSchemaTable(OleDbSchemaGuid.Tables, null); string SheetName = dtExcelSchema.Rows[0]["TABLE_NAME"].ToString(); connExcel.Close(); // string str1 = " "; //Read Data from First Sheet connExcel.Open(); if (rdbExcelOswal.Checked) { cmdExcel.CommandText = "SELECT [LineNo],[ClientGstin],[DocType],[Billgstin] ,[InvoiceNo],Format( [InvoiceDate],'yyyy/MM/dd') AS [InvoiceDate],[InvoiceValue] ,[GoodsSacInd] ,[HsnSacCode],[HsnSacDesc] ,[ItemTaxRate],[Quantity],[Unit] ,[ItemTaxableVal] ,[IgstTax] ,[CgstTax] ,[SGstTax] ,[CessRate],[CessAmount] ,[SuppyStatecode] ,[Suppystateename] ,[ReverseChargInd] ,[E-commerceInd] ,[EcommGstin] ,[ZeroDeemedExp],[shippBillExportNo] ,Format([shippBillExportDate],'yyyy/MM/dd') AS [shippBillExportDate],[OrignalInvoNo] ,[OrignalGstIn] ,Format([OrignalInvoDt],'yyyy/MM/dd') AS [OrignalInvoDt] ,[ind],[Validate],[Reason For Issuing document],[UR Type] From [GSTR1Sales$] where [LineNo] IS NOT NULL"; } else { DataSet ds = CLSCommon.CallApiGet("api/ImportTaxPayerData/GetClientExcelQuery?Ind=1&ClientCode=" + Session["ClientCode"].ToString()); if (ds != null) { if (ds.Tables[0].Rows[0]["Query"].ToString() == "0") { Panels.Attributes.Add("class", "alert alert-danger"); lblMessage.Text = "Your Excel file is not mapped with oswal excel file. Please Map Your Excel File To Oswal Excel File."; Page.ClientScript.RegisterStartupScript(this.GetType(), "CallMyFunction", "$(document).ready(function(){$('#inputModal').modal('show');});", true); Panels.Visible = true; connExcel.Close(); return; } else { cmdExcel.CommandText = ds.Tables[0].Rows[0]["Query"].ToString(); } } else { return; } } //"SELECT [SNO#],[Month],[Year],[ClientGstin] ,[Legal Name] ,[TradeName] ,[AggrturnOver] ,[AggrturnOverAprJune] ,[ClientStatecode] ,[Billgstin] ,[InvoiceNo] ,[InvoiceDate] ,[InvoiceValue] ,[GoodsSacInd] ,[HsnSacCode] ,[HsnSacDesc] ,[ItemRate] ,[ItemTaxableVal] ,[IgstTax] ,[CgstTax] ,[SGstTax] ,[Cess] ,[SuppyStatecode] ,[Suppystateename] ,[ReverseChargInd] ,[E-commerceInd] ,[EcommGstin] ,[shippBillExportNo] ,[shippBillExportDate] ,[NillExmNonGstInd] ,[SaleAmdRecInd] ,[OrignalInvoNo] ,[OrignalGstIn] ,[OrignalInvoDt] ,[AdvanceSalInd] ,[AdvRecvOrAdjustInd] ,[ind],[ZeroDeemedSezInd],[ZeroDeemedSezDesc] From [Sheet1$] where [Month] IS NOT NULL"; oda.SelectCommand = cmdExcel; oda.Fill(dt); //dt.Columns[4].DataType = typeof(string); cmdExcel.CommandText = "Select [LineNo], InfoPeriod, AdvAdjInd, Rate, GrossAdvAdj ,PosCode ,PosName ,IGSTTax ,CGSTTax ,SGSTTax ,CessTax from [GSTR1Adv$] where [LineNo] is not null"; oda.Fill(dt1); cmdExcel.CommandText = "Select [LineNo], [Nature Of Doc], [SrNo From], [SrNo To], [Total Number], [Cancelled],[Net Issued] from [DocIssued$] where [LineNo] is not null"; oda.Fill(dt2); //dt.Columns["shippBillExportDate"].DataType = typeof(DateTime); //dt.Columns["InvoiceDate"].DataType = typeof(DateTime); //dt.Columns["OrignalInvoDt"].DataType = typeof(DateTime); connExcel.Close(); PL_ImportTaxPayerData objpl = new PL_ImportTaxPayerData(); //objpl.dt = dt; objpl.ds.Tables.Add(dt); objpl.ds.Tables.Add(dt1); objpl.ds.Tables.Add(dt2); objpl.ds.Tables[0].TableName = "Table1"; objpl.ds.Tables[1].TableName = "Table2"; objpl.ds.Tables[2].TableName = "Table3"; objpl.ind = 1; objpl.UserCode = int.Parse(Session["UserCode"].ToString()); objpl.ClientCode = int.Parse(Session["ClientCode"].ToString()); objpl.ClientCodeOdp = int.Parse(Session["ClientCodeOdp"].ToString()); //Label lbl = (Label)wucTaxPayerStrip.FindControl("lblGSTINNo"); objpl.ClientGSTNNO = Session["ClientGSTNNO"].ToString();//lbl.Text; objpl.CACode = int.Parse(Session["CaCode"].ToString()); objpl.CaCodeOdp = int.Parse(Session["CaCodeOdp"].ToString()); objpl.MonthCD = int.Parse(Session["MonthYrCode"].ToString()); objpl.MonthYearDesc = Session["MonthYearDesc"].ToString(); objpl.ExcelType = rdbSale.Checked ? 1 : 2; objpl.ExcelNo = int.Parse(ExcelNo); DataTable dtresponse = CLSCommon.CallApiPost("api/ImportTaxPayerData/ImportData", objpl); if (dtresponse != null) { if (dtresponse.Rows.Count > 0) { if (dtresponse.Rows[0][0].ToString() == "1") { // DataSet ds1 = CLSCommon.CallApiGet("api/GSTR1Payload/SaveSGTR1Payload?Ind=1&ClientCode=" + Session["ClientCode"].ToString() + "&ClientCodeOdp=" + Session["ClientCodeOdp"].ToString() + "&CaCode=" + Session["CaCode"].ToString() + "&CacodeOdp=" + Session["CacodeOdp"].ToString() + "&GSTIN=" + Session["ClientGSTNNO"].ToString() + "&MonthCD=" + ddlMonthYear.SelectedValue.ToString() + "&UserCode=" + Session["UserCode"].ToString() + "&ExcelNo=" + dtresponse.Rows[0]["ExcelNo"].ToString()); // txtPayload.Text = ds1.Tables[0].Rows[0]["Payload"].ToString(); // lnkbtn1.Visible = true; Panels.Visible = true; lnkbtnViewError.Visible = false; Panels.Attributes.Add("class", "alert alert-success"); lblTotalRecords.Text = dt.Rows.Count.ToString(); lblImported.Text = dt.Rows.Count.ToString(); lblMessage.Text = "Excel Imported Successfully. \n Total Rows : " + dt.Rows.Count.ToString(); // lnkbtn.Visible = true; } else if (dtresponse.Rows[0][0].ToString() == "2") { Label lblOrganisation = (Label)wucTaxPayerStrip.FindControl("lblClientName"); Panels.Visible = true; Panels.Attributes.Add("class", "alert alert-warning"); lblTotalRecords.Text = "0"; lblImported.Text = "0"; lblMessage.Text = "Excel File Data Contains Validity Errors Download Error Invoices Here."; StringBuilder sb = new StringBuilder(); sb.AppendLine("-------------------------------------------------------------------------------------------------------------"); sb.AppendLine("-------------------------------------------------------------------------------------------------------------"); sb.AppendLine(""); sb.AppendLine("***GST SAATHI REUTRN FILING PORTAL**** Client Code : " + Session["ClientCode"].ToString()); sb.AppendLine(""); sb.AppendLine(" SALES DATA IMPORT VALIDITY : Client Name : " + lblOrganisation.Text); sb.AppendLine(" Date & Time : " + DateTime.Parse(dtresponse.Rows[0]["CurrentDate"].ToString()).ToString("dd/MM/yyyy HH:mm:ss tt") + " Client GSTIN : " + Session["ClientGSTNNO"].ToString()); sb.AppendLine(""); sb.AppendLine("-------------------------------------------------------------------------------------------------------------"); sb.AppendLine("-------------------------------------------------------------------------------------------------------------"); sb.AppendLine(""); sb.AppendLine("LineNo|Invoice No. |Invoice Date|Invoice Value|Error Desc With Code"); foreach (DataRow dr in dtresponse.Rows) { sb.AppendLine(dr["LineNo"].ToString().PadRight(6, ' ') + "|" + dr["CurrInvoiceNo"].ToString().PadRight(15, ' ') + "|" + dr["InvoiceDate"].ToString().PadRight(12, ' ') + "|" + dr["TotInvoiceValue"].ToString().PadRight(13, ' ') + "|" + dr["ErrorCode"].ToString() + " - " + dr["ErrorDesc"].ToString()); } sb.AppendLine(""); sb.AppendLine("******************************************END OF THE RECORDS***************************************************"); System.IO.File.WriteAllText(Server.MapPath("~/ErrorTextFile/" + ExcelNo + ".txt"), sb.ToString()); lnkbtnViewError.Attributes.Add("href", "../ErrorTextFile/" + ExcelNo + ".txt"); lnkbtnViewError.Attributes.Add("download", "GSTR1_ErrorFile_" + ExcelNo); //lnkbtnViewError.Attributes.Add("target", "_blanck"); lnkbtnViewError.Visible = true; } else { Panels.Visible = true; Panels.Attributes.Add("class", "alert alert-warning"); lblTotalRecords.Text = "0"; lblImported.Text = "0"; lblMessage.Text = dtresponse.Rows[0]["ErrorMessage"].ToString().Replace("{{MonthYear}}", Session["MonthYearDesc"].ToString()); } } else { lblTotalRecords.Text = "0"; lblImported.Text = "0"; Panels.Visible = true; Panels.Attributes.Add("class", "alert alert-danger"); lblMessage.Text = "The File is not in the correct format."; Page.ClientScript.RegisterStartupScript(this.GetType(), "CallMyFunction", "$(document).ready(function(){$('#inputModal').modal('show');});", true); } // Page.ClientScript.RegisterStartupScript(this.GetType(), "CallMyFunction", "$(document).ready(function(){$('#inputModal').modal('show');});", true); } else { lblTotalRecords.Text = "0"; lblImported.Text = "0"; Panels.Visible = true; Panels.Attributes.Add("class", "alert alert-danger"); lblMessage.Text = "The File is not in the correct format."; Page.ClientScript.RegisterStartupScript(this.GetType(), "CallMyFunction", "$(document).ready(function(){$('#inputModal').modal('show');});", true); } } catch (Exception ex) { connExcel.Close(); lblTotalRecords.Text = "0"; lblImported.Text = "0"; Panels.Visible = true; Panels.Attributes.Add("class", "alert alert-danger"); lblMessage.Text = ex.Message;//"The File is not in the correct format."; } }
protected void Submit_Click(object sender, EventArgs e) { plobj = new PL_CARegis(); plobj.Ind = 1; plobj.CA_Name = Txt_CaName.Text.Trim().ToUpper(); plobj.CA_OrganizationName = Txt_OrganizationName.Text; plobj.CA_MobileNo = Txt_MobNo.Text; // plobj.CA_LandlineNo = Txt_LandLineNo.Text; plobj.CA_EmailId = Txt_EmailId.Text; plobj.DemoInd = 1; DataTable dt = CLSCommon.CallApiPost("api/CARegis/SaveData/", plobj); if (dt.Rows.Count > 0) { if (dt.Rows[0]["res"].ToString() == "1") { string errormsg = dt.Rows[0]["ErrorMsg"].ToString(); string Mobileno = dt.Rows[0]["CaMobileNo1"].ToString(); string emailid = dt.Rows[0]["CaEmailid"].ToString(); string Password = dt.Rows[0]["Password"].ToString(); StringBuilder sbmail = new StringBuilder(); sbmail.AppendLine("Dear " + Txt_CaName.Text.Trim().ToUpper()); sbmail.AppendLine(""); sbmail.AppendLine("Thank you for showing interest in \"GST-SAATHI\" Return Filing Portal."); sbmail.AppendLine(""); sbmail.AppendLine("To access the application please go to : http://www.gstsaathifiling.com."); sbmail.AppendLine(""); sbmail.AppendLine("UserId :- " + Mobileno); sbmail.AppendLine("Password : "******""); // sb.AppendLine("Valid Only For 48 Hour" ); sbmail.AppendLine("Regards"); sbmail.AppendLine("Team-\"GST-SAATHI\""); sbmail.AppendLine("Missed Call No. : 08030-63-63-48"); sbmail.AppendLine("Phone No. : +91-975502-44-44"); sbmail.AppendLine("60, Electronics Complex"); sbmail.AppendLine("Pardeshipura"); sbmail.AppendLine("Indore-452010 (M.P.)"); sbmail.AppendLine("India."); sbmail.AppendLine("http://www.gstsaathi.com"); CLSCommon.SendMessage(Mobileno, sbmail.ToString()); CLSCommon.SendHtmlFormattedEmail(sbmail.ToString(), Txt_EmailId.Text); Label_ErrorMsg.Visible = true; Label_ErrorMsg.Text = "Thank You for showing interest in \"GST-Saathi\" . Login details have been sent to you via sms & email!"; Txt_CaName.Text = ""; // Txt_LandLineNo.Text = ""; Txt_MobNo.Text = ""; Txt_OrganizationName.Text = ""; Txt_EmailId.Text = ""; } else if (dt.Rows[0]["res"].ToString() == "0") { Label_ErrorMsg.Visible = true; Label_ErrorMsg.Text = dt.Rows[0]["Message"].ToString(); } } }
protected void BtnExcelMapping_Click(object sender, EventArgs e) { if (txtMappingName.Text.Trim() == "") { lblmsg.Text = "Enter Mapping Name."; return; } else if (GridDdl.Rows.Count > 0) { int Flage = 0; foreach (GridViewRow row in GridDdl.Rows) { DropDownList ddlOdpExcel = (DropDownList)row.FindControl("DropDownList1"); if (ddlOdpExcel.SelectedValue.ToString() == "-1") { Flage++; ddlOdpExcel.Focus(); row.Focus(); break; } } if (Flage > 0) { lblmsg.Text = "Please Map All Fields With Database."; return; } else { objpl = new PL_ExcelMapping(); objpl.Ind = 2; objpl.ClientCode = Convert.ToInt32(Session["ClientCode"]); objpl.MappingName = txtMappingName.Text.Trim(); foreach (GridViewRow row in GridDdl.Rows) { Label lblClientExcel = (Label)row.FindControl("lblHeader"); DropDownList ddlOdpExcel = (DropDownList)row.FindControl("DropDownList1"); objpl.ClientExcelField = ddlOdpExcel.SelectedItem.Text.ToString(); objpl.OdpExcelField = lblClientExcel.Text; DataTable dtresponse = new DataTable(); dtresponse = CLSCommon.CallApiPost("api/ExcelMapping/InsertExcelMapping", objpl); if (dtresponse != null && dtresponse.Rows.Count > 0) { if (dtresponse.Rows[0]["Result"].ToString() == "1") { objpl.MappingId = int.Parse(dtresponse.Rows[0]["MappingId"].ToString()); lblmsg.Text = "Excel File Mapped Successfully Complete"; } else { } } else { lblmsg.Text = "Excel File Not Mapped"; } } } } }