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();
}