protected void Page_Load(object sender, EventArgs e) { CLSCommon.CACheckSession(); CLSCommon.ClientCheckSession(); if (!IsPostBack) { } // DropDownList ddl1 = (DropDownList)wucTaxPayerStrip.FindControl("ddlMonthYear"); DataSet ds = CLSCommon.CallApiGet("api/GSTR3b/GetAllData?Ind=0&ClientCode=" + Session["ClientCode"].ToString() + "&ClientCodeOdp=" + Session["ClientCodeOdp"].ToString() + "&CaCode=" + Session["CaCode"].ToString() + "&CaCodeOdp=" + Session["CaCodeOdp"].ToString() + "&ClientGSTIN=" + Session["ClientGSTNNO"].ToString() + "&MonthCD=" + Session["MonthYrCode"].ToString()); grd3_1.DataSource = ds.Tables[0]; grd3_1.DataBind(); grd3_2.DataSource = ds.Tables[1]; grd3_2.DataBind(); grd4A.DataSource = ds.Tables[2]; grd4A.DataBind();; grd5.DataSource = ds.Tables[3]; grd5.DataBind(); grd6_1.DataSource = ds.Tables[4]; grd6_1.DataBind(); grd4B.DataSource = ds.Tables[5]; grd4B.DataBind(); grd4C.DataSource = ds.Tables[6]; grd4C.DataBind(); Grd4D.DataSource = ds.Tables[7]; Grd4D.DataBind(); }
protected void Page_Load(object sender, EventArgs e) { CLSCommon.CommonCheckSession(); CLSCommon.ClientCheckSession(); if (!IsPostBack) { DataSet ds = CLSCommon.CallApiGet("api/TaxPayer/SearchTaxPayer?Ind=1&ClientId=" + Session["ClientCode"].ToString() + "&ClientIdOdp=" + Session["ClientCodeOdp"].ToString() + "&ClientGSTIN=" + Session["ClientGSTNNO"].ToString()); if (ds.Tables.Count > 0) { if (ds.Tables[0].Rows.Count > 0) { //lblFirmName.Text = ds.Tables[0].Rows[0]["FirmName"].ToString(); lblClientName.Text = ds.Tables[0].Rows[0]["ClientNameE"].ToString(); lblEmailId.Text = ds.Tables[0].Rows[0]["EmailId"].ToString(); lblGSTINNo.Text = ds.Tables[0].Rows[0]["GSTNNO"].ToString(); lblMobileNo.Text = ds.Tables[0].Rows[0]["ClientMobileNo1"].ToString(); Session["ClientUserID"] = ds.Tables[0].Rows[0]["ClientUserID"].ToString(); lblMonthYear.Text = Session["MonthYearDesc"].ToString(); //ddlMonthYear.DataSource = ds.Tables[1]; //ddlMonthYear.DataTextField = "MonthYearDesc"; //ddlMonthYear.DataValueField = "MonthYrCode"; //ddlMonthYear.DataBind(); } } } }
protected void Page_Load(object sender, EventArgs e) { UnobtrusiveValidationMode = UnobtrusiveValidationMode.None; // CLSCommon.CheckSession(); if (Session["RegNo"] != null) { if (!IsPostBack) { DataSet dS = new DataSet(); dS = CLSCommon.CallApiGet("api/SearchReg/GetRecordByRegNo?Ind=1&RegNo=" + Session["RegNo"].ToString()); if (dS.Tables.Count > 0) { if (dS.Tables[0].Rows.Count > 0) { lblRegNo.Text = Session["RegNo"].ToString(); txtName.Text = dS.Tables[0].Rows[0]["EnqName"].ToString(); txtOrganisationName.Text = dS.Tables[0].Rows[0]["OrgName"].ToString(); txtPanNo.Text = dS.Tables[0].Rows[0]["PanNo"].ToString(); txtMobileNo.Text = dS.Tables[0].Rows[0]["MobileNo"].ToString(); txtEmailId.Text = dS.Tables[0].Rows[0]["EmailId"].ToString(); txtCategory.Text = dS.Tables[0].Rows[0]["EnqCatDesc"].ToString(); } } FillDDlState(); } } else { Response.Redirect("frmSearchReg.aspx"); } }
public void GetClientGstStatus() { DropDownList ddl = (DropDownList)wucTaxPayerStrip.FindControl("ddlMonthYear"); objpl = new PL_TaxPayerDashboard(); objpl.ClientCode = Convert.ToInt32(Session["ClientCode"]); objpl.ClientCodeOdp = Convert.ToInt32(Session["ClientCodeOdp"]); objpl.Ind = 1; objpl.GSTIN = Session["ClientGSTNNO"].ToString().Trim(); ds = new DataSet(); ds = CLSCommon.CallApiGet("api/TaxPayerDashboard/GetClientGstStatus?Ind=1&ClientCode=" + objpl.ClientCode + "&ClientCodeOdp=" + objpl.ClientCodeOdp + "&GSTIN=" + objpl.GSTIN + "&MonthYrCode=" + ddl.SelectedValue.ToString()); if (ds == null || ds.Tables.Count == 0 || ds.Tables[0].Rows.Count == 0) { GridDashboard.DataSource = null; GridDashboard.DataBind(); // lblErrorMsg.Text = "Invalid login Id And Password."; } else { ViewState["DashboardStatus"] = ds.Tables[0]; GridDashboard.DataSource = ds.Tables[0]; GridDashboard.DataBind(); } }
void FillDDl() { DataSet ds = CLSCommon.CallApiGet("api/ClientProfile/FillDdl?Ind=2"); if (ds.Tables.Count > 0) { ddlState.DataSource = ds.Tables[0]; ddlState.DataTextField = "StateDesc"; ddlState.DataValueField = "StateCode"; ddlState.DataBind(); ddlState.Items.Insert(0, new ListItem("Select", "0")); ddlBussinessType.DataSource = ds.Tables[1]; ddlBussinessType.DataTextField = "BussinesTypeDesc"; ddlBussinessType.DataValueField = "BussinessTypeId"; ddlBussinessType.DataBind(); ddlBussinessType.Items.Insert(0, new ListItem("Select", "0")); ddlBussinessNature.DataSource = ds.Tables[2]; ddlBussinessNature.DataTextField = "BussinessNatureDesc"; ddlBussinessNature.DataValueField = "BussinessNatureId"; ddlBussinessNature.DataBind(); ddlBussinessNature.Items.Insert(0, new ListItem("Select", "0")); } }
void GetRecord() { DataSet ds = new DataSet(); ds = CLSCommon.CallApiGet("api/SearchReg/GetRecordByRegNo?Ind=1&RegNo=" + txtRegNo.Text); if (ds.Tables.Count > 0) { if (ds.Tables[0].Rows.Count > 0) { Session["RegNo"] = txtRegNo.Text; if (ds.Tables[0].Rows[0]["CatgoryId"].ToString() == "4") { Response.Redirect("FrmClientProfile.aspx"); } else if (ds.Tables[0].Rows[0]["CatgoryId"].ToString() == "1") { Response.Redirect("frmCAReg.aspx"); } } else { pnlError.Visible = true; lblMsg.Text = "Registration Number not found."; } } }
void FillGrid() { DataSet ds = CLSCommon.CallApiGet("api/ViewAllClients/GetAllClients?Ind=1&CaCode=" + Session["CaCode"].ToString() + "&CaCodeOdp=" + Session["CaCodeOdp"].ToString()); grdAllClients.DataSource = ds.Tables[0]; grdAllClients.DataBind(); }
void FillDDlState() { try { DataSet ds = CLSCommon.CallApiGet("api/CARegis/FillDdlState?Ind=2"); if (ds.Tables.Count > 0) { ddlState.DataSource = ds.Tables[0]; ddlState.DataTextField = "StateDesc"; ddlState.DataValueField = "StateCode"; ddlState.DataBind(); ddlState.Items.Insert(0, new ListItem("Select", "0")); ddlConsultantType.DataSource = ds.Tables[1]; ddlConsultantType.DataValueField = "ConsultantId"; ddlConsultantType.DataTextField = "ConsultantDesc"; ddlConsultantType.DataBind(); ddlConsultantType.Items.Insert(0, new ListItem("Select", "0")); } } catch (Exception ex) { Console.WriteLine(ex); } }
void GetAllClient() { DataSet ds = CLSCommon.CallApiGet("api/CAAllotment/GetClientAllotment?ind=1&CaCode=" + Session["CaCode"].ToString() + "&CaCodeOdp=" + Session["CaCodeOdp"].ToString()); ViewState["CaTable"] = ds.Tables[1]; grdAllClients.DataSource = ds.Tables[0]; grdAllClients.DataBind(); }
protected void btnUpload_Click(object sender, EventArgs e) { try { if (!fuExcelImport.HasFile) { Panels.Attributes.Add("class", "alert alert-danger"); lblTotalRecords.Text = "0"; lblImported.Text = "0"; Panels.Visible = true; lblMessage.Text = "Please Select Excel File."; return; } else if (Path.GetExtension(fuExcelImport.FileName) != ".xls" && Path.GetExtension(fuExcelImport.FileName) != ".xlsx" && Path.GetExtension(fuExcelImport.FileName) != ".xlsm") { Panels.Attributes.Add("class", "alert alert-danger"); lblTotalRecords.Text = "0"; lblImported.Text = "0"; Panels.Visible = true; lblMessage.Text = "Please Select Only Excel File."; return; } else { DataSet ds = CLSCommon.CallApiGet("api/GenerateExcelNo/GenerateExcelNo?Ind=1&ClientCode=" + Session["ClientCode"].ToString() + "&ClientCodeOdp=" + Session["ClientCodeOdp"].ToString() + "&ClientGSTNNO=" + Session["ClientGSTNNO"].ToString() + "&GSTRInd=1&MonthCD=" + Session["MonthYrCode"].ToString()); if (ds != null) { if (ds.Tables[0].Rows[0]["res"].ToString() == "1") { string FileName = Path.GetFileName(fuExcelImport.PostedFile.FileName); string Extension = Path.GetExtension(fuExcelImport.PostedFile.FileName); string FolderPath = "~/GSTR1Excel/"; string FilePath = Server.MapPath(FolderPath + ds.Tables[0].Rows[0]["ExcelNo"].ToString()); ExcelNo = ds.Tables[0].Rows[0]["ExcelNo"].ToString(); fuExcelImport.SaveAs(FilePath + Extension); Import_To_Grid(FilePath, Extension, ExcelNo); } else { Panels.Visible = true; Panels.Attributes.Add("class", "alert alert-warning"); lblTotalRecords.Text = "0"; lblImported.Text = "0"; lblMessage.Text = "Data Already Imported for " + Session["MonthYearDesc"].ToString(); //lnkbtn1.Visible = false; } } } } catch (Exception ex) { Panels.Attributes.Add("class", "alert alert-danger"); Panels.Visible = true; lblMessage.Text = ex.Message; Page.ClientScript.RegisterStartupScript(this.GetType(), "CallMyFunction", "$(document).ready(function(){$('#inputModal').modal('show');});", true); } }
void GetGSTIN() { DataSet ds = CLSCommon.CallApiGet("api/ClientHome/GetClientGSTIN?Ind=1&ClientCode=" + Session["ClientCode"].ToString() + "&ClientCodeOdp=" + Session["ClientCodeOdp"].ToString()); if (ds != null) { grdRegisteredGSTIN.DataSource = ds.Tables[0]; grdRegisteredGSTIN.DataBind(); } }
void FillGrid() { var cacodes = Session["CaCode"]; var cacodeopd = Session["CaCodeOdp"]; DataSet ds = CLSCommon.CallApiGet("api/ViewAllCA/GetAllCA?Ind=1&CaCode=" + Session["CaCode"].ToString() + "&CaCodeOdp=" + Session["CaCodeOdp"].ToString()); // ds = CLSCommon.CallApiGet("api/ViewAllCA/GetAllCA?Ind=3&CaCode=" + Session["CaCode"].ToString() + "&CaCodeOdp=" + Session["CaCodeOdp"].ToString()); grdAllClients.DataSource = ds.Tables[0]; grdAllClients.DataBind(); }
void FillMonthYear() { DataSet ds1 = CLSCommon.CallApiGet("api/ImportTaxPayerData/FillMonthYear?Ind=1"); // DropDownList ddl = (DropDownList)wucTaxPayerStrip.FindControl("ddlMonthYear"); ddlMonthYear.DataSource = ds1.Tables[0]; ddlMonthYear.DataTextField = "MonthYearDesc"; ddlMonthYear.DataValueField = "MonthYrCode"; ddlMonthYear.DataBind(); }
protected void Page_Load(object sender, EventArgs e) { hfUrl.Value = HttpContext.Current.Request.Url.AbsoluteUri; Page.Form.Attributes.Add("enctype", "multipart/form-data"); CLSCommon.CommonCheckSession(); if (Session["UserLevel"].ToString() == "1") { divAdminCA.Visible = true; } else if (Session["UserLevel"].ToString() == "3") { divArtical.Visible = true; } else if (Session["UserLevel"].ToString() == "4") { divSideContent.Visible = true; } else if (Session["UserLevel"].ToString() == "5") { divAdministrator.Visible = true; } else if (Session["UserLevel"].ToString() == "2") { divca.Visible = true; } if (!IsPostBack) { if (Session["ClientCode"] == null || Session["ClientCode"] == "" || Session["ClientCode"] == "0" || Session["ClientCodeOdp"] == null || Session["ClientCodeOdp"] == "" || Session["ClientCodeOdp"] == "0" || Session["ClientGSTNNO"] == null || Session["ClientGSTNNO"] == "" || Session["ClientGSTNNO"] == "0") { } else { if (!IsPostBack) { DataSet ds = CLSCommon.CallApiGet("api/TaxPayer/SearchTaxPayer?Ind=1&ClientId=" + Session["ClientCode"].ToString() + "&ClientIdOdp=" + Session["ClientCodeOdp"].ToString() + "&ClientGSTIN=" + Session["ClientGSTNNO"].ToString()); if (ds.Tables.Count > 0) { if (ds.Tables[0].Rows.Count > 0) { txtNameMsg.Text = ds.Tables[0].Rows[0]["ClientNameE"].ToString(); txtToEmail.Text = ds.Tables[0].Rows[0]["EmailId"].ToString(); txtMobileNoMsg.Text = ds.Tables[0].Rows[0]["ClientMobileNo1"].ToString(); } } } } } txtMessageMsg.Attributes.Add("maxlength", txtMessageMsg.MaxLength.ToString()); txtMessageEmail.Attributes.Add("maxlength", txtMessageMsg.MaxLength.ToString()); }
protected void grdAllClients_RowCommand(object sender, GridViewCommandEventArgs e) { int RowIndex = int.Parse(e.CommandArgument.ToString()); lblClientName.Text = grdAllClients.Rows[RowIndex].Cells[1].Text; DataSet ds = CLSCommon.CallApiGet("api/ViewAllCA/GetAllCA?Ind=2&CaCode=" + grdAllClients.DataKeys[RowIndex][0].ToString() + "&CaCodeOdp=" + grdAllClients.DataKeys[RowIndex][1].ToString()); grdClientDetails.DataSource = ds.Tables[0]; grdClientDetails.DataBind(); Page.ClientScript.RegisterStartupScript(this.GetType(), "CallMyFunction", "$(document).ready(function(){ $('#myModal').modal('show'); });", true); grdAllClients.Rows[RowIndex].Focus(); }
protected void Page_Load(object sender, EventArgs e) { CLSCommon.CommonCheckSession(); CLSCommon.CACheckSession(); if (!IsPostBack) { DataSet ds = CLSCommon.CallApiGet("api/SearchTaxPayer/SearchTaxPayer?Ind=4&TaxPayerName=" + txtSearch.Text + "&PanNo=" + txtSearch.Text + "&GSTINNo=" + txtSearch.Text + "&CACode=" + Session["CaCode"].ToString() + "&CACodeOdp=" + Session["CaCodeOdp"].ToString()); ddlName.DataSource = ds.Tables[0]; ddlName.DataTextField = "ClientNameE"; ddlName.DataValueField = "ClientCode"; ddlName.DataBind(); } }
protected void ddlState_SelectedIndexChanged(object sender, EventArgs e) { DataSet ds = CLSCommon.CallApiGet("api/ClientProfile/FillDdl?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(); } }
void FillCity(string StateCode, DropDownList ddlCity) { DataSet ds = CLSCommon.CallApiGet("api/ClientProfile/FillDdl?Ind=3&StateCode=" + StateCode); 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(); } }
protected void btnUpload_Click(object sender, EventArgs e) { if (!fuTallyExcelImport.HasFile) { Panels.Attributes.Add("class", "alert alert-danger"); lblTotalRecords.Text = "0"; lblImported.Text = "0"; Panels.Visible = true; lblMessage.Text = "Please Select Excel File."; return; } else if (Path.GetExtension(fuTallyExcelImport.FileName) != ".xls" && Path.GetExtension(fuTallyExcelImport.FileName) != ".xlsx" && Path.GetExtension(fuTallyExcelImport.FileName) != ".xlsm") { Panels.Attributes.Add("class", "alert alert-danger"); lblTotalRecords.Text = "0"; lblImported.Text = "0"; Panels.Visible = true; lblMessage.Text = "Please Select Only Excel File."; return; } else { DataSet ds = CLSCommon.CallApiGet("api/GenerateExcelNo/GenerateExcelNo?Ind=1&ClientCode=" + Session["ClientCode"].ToString() + "&ClientCodeOdp=" + Session["ClientCodeOdp"].ToString() + "&ClientGSTNNO=" + Session["ClientGSTNNO"].ToString() + "&GSTRInd=5&MonthCD=" + Session["MonthYrCode"].ToString()); if (ds != null) { if (ds.Tables[0].Rows[0]["res"].ToString() == "1") { string FileName = Path.GetFileName(fuTallyExcelImport.PostedFile.FileName); string Extension = Path.GetExtension(fuTallyExcelImport.PostedFile.FileName); string FolderPath = "~/GSTR1Excel/"; string FilePath = Server.MapPath(FolderPath + ds.Tables[0].Rows[0]["ExcelNo"].ToString()); ExcelNo = ds.Tables[0].Rows[0]["ExcelNo"].ToString(); fuTallyExcelImport.SaveAs(FilePath + Extension); Import_To_Grid(FilePath, Extension, ExcelNo); //GetDataFromExcel(FilePath + Extension, Extension); //Import_To_Grid } else { Panels.Visible = true; Panels.Attributes.Add("class", "alert alert-warning"); lblTotalRecords.Text = "0"; lblImported.Text = "0"; lblMessage.Text = "Data Already Imported for " + Session["MonthYearDesc"].ToString(); //lnkbtn1.Visible = false; } } } }
protected void Page_Load(object sender, EventArgs e) { CLSCommon.CommonCheckSession(); CLSCommon.ClientCheckSessionClient(); if (!IsPostBack) { GetGSTIN(); DataSet ds1 = CLSCommon.CallApiGet("api/ImportTaxPayerData/FillMonthYear?Ind=1"); foreach (GridViewRow grw in grdRegisteredGSTIN.Rows) { DropDownList ddlMonth = (DropDownList)grw.FindControl("ddlMonth"); FillDdl(ddlMonth, ds1); } } }
void FillGRID() { DataSet ds = CLSCommon.CallApiGet("api/GSTR2AAction/GetGSTR2AData?ind=1&ClientCode=" + Session["ClientCode"].ToString() + "&ClientCodeOdp=" + Session["ClientCodeOdp"].ToString() + "&GSTIN=" + Session["ClientGSTNNO"].ToString() + "&MonthCD=" + Session["MonthYrCode"].ToString()); grdMismatch.DataSource = ds.Tables[0]; grdMismatch.DataBind(); lblTotalInvoice.Text = ds.Tables[2].Rows[0]["TotalInvoices"].ToString(); lblPendingInvoice.Text = ds.Tables[3].Rows[0]["Pending"].ToString(); lblActionTaken.Text = ds.Tables[1].Rows[0]["ActionTakenCount"].ToString(); lblAccepted.Text = ds.Tables[4].Rows[0]["TotalAccept"].ToString(); lblRejected.Text = ds.Tables[4].Rows[0]["TotalReject"].ToString(); lblModify.Text = ds.Tables[4].Rows[0]["TotalModify"].ToString(); lblPending.Text = ds.Tables[4].Rows[0]["TotalPending"].ToString(); lblDelete.Text = ds.Tables[4].Rows[0]["TotalDelete"].ToString(); }
void GetHomeData() { try { DataSet ds = CLSCommon.CallApiGet("api/CaHome/GetCaHomeData?Ind=1&CaCode=" + Session["CaCode"].ToString() + "&CaCodeOdp=" + Session["CaCodeOdp"].ToString()); if (ds != null) { ddlGSTR.DataSource = ds.Tables[2]; ddlGSTR.DataTextField = "GSTRName"; ddlGSTR.DataValueField = "RecordNo"; ddlGSTR.DataBind(); } } catch { } }
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 DropDownList1_SelectedIndexChanged(object sender, EventArgs e) //{ // DropDownList drp = (DropDownList)sender; // GridViewRow gv = (GridViewRow)drp.NamingContainer; // int index = gv.RowIndex; // DropDownList DropDownList1 = (DropDownList)GridDdl.Rows[index].FindControl("DropDownList1"); // Label label1 = (Label)GridDdl.Rows[index].FindControl("lblHeader"); // label1.Text = DropDownList1.SelectedItem.Text; //} protected int DeleteRecord() { int flag = 0; ds = CLSCommon.CallApiGet("api/ExcelMapping/DeleteAfterInsertExcelMapping?Ind=" + 3); if (ds.Tables[0].Rows.Count > 0) { flag = 1; } else { flag = 0; } return(flag); }
protected void GenerateOtp_Click(object sender, EventArgs e) { var CACode = Session["CACode"]; var CACodeOdp = Session["CACodeOdp"]; var UserCode = Session["UserCode"]; var UserLevel = Session["UserLevel"]; var OldOtp = Text_OldOtp.Text; if (OldOtp != "") { DataSet ds = CLSCommon.CallApiGet("api/ChangePassword/ChangePassword?Ind=0&UserLevel=" + UserLevel + "&UserCode=" + UserCode + "&CACode=" + CACode + "&CACodeOdp=" + CACodeOdp + "&OldPassword="******"res"].ToString() == "0") { Lbl_ErrorMsg.Visible = true; Lbl_ErrorMsg.Text = "Invalid Old Password..."; Text_OldOtp.Text = ""; } else { string Mobileno =ds.Tables[0].Rows[0]["MobileNo"].ToString(); ViewState["MobileNo"] = ds.Tables[0].Rows[0]["MobileNo"].ToString(); CLSCommon.SendMessage(Mobileno, "Your OTP For GSTSaathi Password Reset Is " + ds.Tables[0].Rows[0]["OneTimePass"].ToString()); Lbl_ErrorMsg.Visible = true; Lbl_ErrorMsg.Text = "OTP Sent Successfully... "; DivOtp.Visible = true; Text_OldOtp.Text = ""; Txt_VerifyOtp.Text = ""; } } else { Lbl_ErrorMsg.Visible = true; Lbl_ErrorMsg.Text = "No Record Found..."; } } else { Lbl_ErrorMsg.Visible = true; Lbl_ErrorMsg.Text = "Please Enter Old Password..."; } }
void GetGSTr2Count() { DropDownList ddl = (DropDownList)wucTaxPayerStrip.FindControl("ddlMonthYear"); DataSet ds = CLSCommon.CallApiGet("api/GenerateMismatch/GetGstr2Count?Ind=1&ClientCode=" + Session["ClientCode"].ToString() + "&ClientCodeOdp=" + Session["ClientCodeOdp"].ToString() + "&GSTIN=" + Session["ClientGSTNNO"].ToString() + "&MonthCd=" + Session["MonthYrCode"].ToString()); if (ds != null) { btnGSTR2A.Attributes.Remove("class"); btnPurchaseData.Attributes.Remove("class"); iGSTR2a.Attributes.Remove("class"); iPurchase.Attributes.Remove("class"); if (int.Parse(ds.Tables[0].Rows[0]["GSTR2ACount"].ToString()) > 0) { btnGSTR2A.Attributes.Add("class", "btn btn-success"); iGSTR2a.Attributes.Add("class", "fa fa-check"); } else { btnGSTR2A.Attributes.Add("class", "btn btn-danger"); iGSTR2a.Attributes.Add("class", "fa fa-info"); } if (int.Parse(ds.Tables[0].Rows[0]["PurchaseCount"].ToString()) > 0) { btnPurchaseData.Attributes.Add("class", "btn btn-success"); iPurchase.Attributes.Add("class", "fa fa-check"); } else { btnPurchaseData.Attributes.Add("class", "btn btn-danger"); iPurchase.Attributes.Add("class", "fa fa-info"); } if (int.Parse(ds.Tables[0].Rows[0]["GSTR2ACount"].ToString()) > 0 && int.Parse(ds.Tables[0].Rows[0]["PurchaseCount"].ToString()) > 0) { btnGenerateMismatch.Visible = true; } else { btnGenerateMismatch.Visible = false; } } }
void GetTotalByGSTRName() { DataSet ds = CLSCommon.CallApiGet("api/CaHome/GetCaHomeData?Ind=2&CaCode=" + Session["CaCode"].ToString() + "&CaCodeOdp=" + Session["CaCodeOdp"].ToString() + "&RecordNo=" + ddlGSTR.SelectedValue.ToString()); if (ds != null) { decimal TotalRecords, TotalCompleted, PercentData, PercentSubmit, PercentFiled, PercentSaved, TotalSubmit, TotalFiled, TotalSaved; TotalRecords = decimal.Parse(ds.Tables[0].Rows[0]["TotalClient"].ToString()); TotalCompleted = decimal.Parse(ds.Tables[1].Rows[0]["TotalCompleted"].ToString()); lblTotalRecords.Text = TotalRecords.ToString(); lblCompleted.InnerHtml = TotalCompleted.ToString(); TotalSaved = decimal.Parse(ds.Tables[2].Rows[0]["TotalSaved"].ToString()); TotalSubmit = decimal.Parse(ds.Tables[3].Rows[0]["TotalSubmit"].ToString()); TotalFiled = decimal.Parse(ds.Tables[4].Rows[0]["TotalFiled"].ToString()); if (TotalRecords > 0) { PercentData = (TotalCompleted / TotalRecords) * 100; PercentSubmit = (TotalSubmit / TotalRecords) * 100; PercentSaved = (TotalSaved / TotalRecords) * 100; PercentFiled = (TotalFiled / TotalRecords) * 100; } else { PercentData = 0; PercentSubmit = 0; PercentSaved = 0; PercentFiled = 0; } // divCompleted.Attributes.Add("data-label", TotalCompleted.ToString()); divCompleted.Attributes.Add("data-percent", Math.Floor(PercentData).ToString()); divSaved.Attributes.Add("data-percent", Math.Floor(PercentSaved).ToString()); divSubmit.Attributes.Add("data-percent", Math.Floor(PercentSubmit).ToString()); divFiled.Attributes.Add("data-percent", Math.Floor(PercentFiled).ToString()); lblSaved.InnerText = TotalSaved.ToString(); lblSubmit.InnerText = TotalSubmit.ToString(); lblFiled.InnerText = TotalFiled.ToString(); } }
//string RecordNo = ""; protected void Page_Load(object sender, EventArgs e) { CLSCommon.CommonCheckSession(); CLSCommon.CACheckSession(); CLSCommon.ClientCheckSession(); if (!IsPostBack) { // DataSet ds = CLSCommon.CallApiGet("api/ImportTaxPayerData/FillMonthYear?Ind=1"); //DropDownList ddl = (DropDownList)wucTaxPayerStrip.FindControl("ddlMonthYear"); //ddl.DataSource = ds.Tables[0]; //ddl.DataTextField = "MonthYearDesc"; //ddl.DataValueField = "MonthYrCode"; //ddl.DataBind(); ////var clientcode = Session["ClientCode"]; ////var clientcodeodp = Session["ClientCodeOdp"]; ////var GSTIN = Session["ClientGSTNNO"]; DataSet ds1 = CLSCommon.CallApiGet("api/TaxPayeNew/GetALlGSTRName?Ind=0&ClientCode=" + Session["ClientCode"] + "&ClientCodeOdp=" + Session["ClientCodeOdp"] + "&ClientGSTNNO=" + Session["ClientGSTNNO"]); if (ds1.Tables.Count > 0) { grdAllGstrName.DataSource = ds1.Tables[0]; grdAllGstrName.DataBind(); } //foreach(GridViewRow grow in grdAllGstrName.Rows) //{ // LinkButton lnkbtn = (LinkButton)grow.FindControl("lnkbtn"); // if(grow.RowIndex==0) // { // lnkbtn.CssClass = "list-group-item text-center brdno active"; // }else // { // lnkbtn.Attributes.Remove("href"); // } //} //GetStatus(0); } GetStatus(0); }
protected void btnGenerateExcel_Click(object sender, EventArgs e) { // DropDownList ddlMonthYear = (DropDownList)wucTaxPayerStrip.FindControl("ddlMonthYear"); DataSet ds = CLSCommon.CallApiGet("api/GSTR1/GetGSTR1Data?ind=2&ClientCode=" + Session["ClientCode"].ToString() + "&ClientCodeOdp=" + Session["ClientCodeOdp"].ToString() + "&CaCode=" + Session["CaCode"].ToString() + "&CaCodeOdp=" + Session["CaCodeOdp"].ToString() + "&ClientGSTIN=" + Session["ClientGSTNNO"].ToString() + "&MonthCode=" + Session["MonthYrCode"].ToString()); ds.Tables[0].TableName = "HELP"; ds.Tables[1].TableName = "b2b"; ds.Tables[3].TableName = "b2cl"; ds.Tables[5].TableName = "b2cs"; ds.Tables[7].TableName = "cdnr"; ds.Tables[9].TableName = "cdnur"; ds.Tables[11].TableName = "exp"; ds.Tables[13].TableName = "at"; ds.Tables[15].TableName = "atadj"; ds.Tables[17].TableName = "exemp"; ds.Tables[19].TableName = "hsn"; ds.Tables[21].TableName = "docs"; CreateExcel(ds, "GSTR1" + Session["ClientGSTNNO"].ToString() + Session["MonthYearDesc"].ToString()); }
protected void Page_Load(object sender, EventArgs e) { ViewState["YearInd"] = null; ViewState["MonthCode"] = null; CLSCommon.CommonCheckSession(); CLSCommon.ClientCheckSession(); CLSCommon.CACheckSession(); if (!IsPostBack) { DataSet ds = CLSCommon.CallApiGet("api/ImportTaxPayerData/FillMonthYear?Ind=1"); DropDownList ddl = (DropDownList)wucTaxPayerStrip.FindControl("ddlMonthYear"); ddl.DataSource = ds.Tables[0]; ddl.DataTextField = "MonthYearDesc"; ddl.DataValueField = "MonthYrCode"; ddl.DataBind(); //ViewState["MonthCode"] = Convert.ToInt32(ddl.SelectedValue.ToString()); //string YearCode = (ddl.SelectedItem.Text.ToString()); //ViewState["YearInd"] = Convert.ToInt32((YearCode.Substring(YearCode.Length - 4, 4))).ToString(); } GetClientstatusDashboard(); }