예제 #1
0
    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();
    }
예제 #2
0
 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();
             }
         }
     }
 }
예제 #3
0
    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();
        }
    }
예제 #5
0
    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.";
            }
        }
    }
예제 #7
0
    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();
    }
예제 #8
0
    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);
        }
    }
예제 #9
0
    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();
    }
예제 #10
0
 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);
     }
 }
예제 #11
0
    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();
        }
    }
예제 #12
0
    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();
    }
예제 #13
0
    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();
    }
예제 #14
0
    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());
    }
예제 #15
0
    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();
    }
예제 #16
0
 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();
     }
 }
예제 #17
0
    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;
             }
         }
     }
 }
예제 #20
0
 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();
    }
예제 #22
0
 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...";
        }
    }
예제 #26
0
    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;
            }
        }
    }
예제 #27
0
    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();
    }