Professor6T9 Web SheLL

Windows NT WEB-23 10.0 build 17763 (Windows Server 2016) i586
Microsoft-IIS/10.0
103.118.16.173

File Name : FinalConveyance.aspx.cs

using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using IOBMobile.DataAccessLayer;

public partial class FinalConveyance : System.Web.UI.Page
{
    DataTable dtBranch;
    protected void Page_Load(object sender, EventArgs e)
    {
        try
        {
            if (!IsPostBack)
            {
                bool bol = DBTask.useraccess("ApproveConvenes.aspx");
                if (bol == false)
                    Response.Redirect("error.aspx");
                //string datestring = DateTime.Now.ToString("yyyy-MM-dd");
                ////string datestring = DateTime.Now.ToString("dd-MM-yyyy");
                //txtDate.Text = datestring;
                //txtFare.Text = txtMode.SelectedValue.ToString();
                Bind_Combo_Emp();
                tr1.Style.Add("display", "none");
                hdn1.Style.Add("display", "none");
                //fare1.Style.Add("display", "none");ind
                bind_year();
            }
        }
        catch (Exception ex)
        {
            lblError.Text = ex.Message.ToString();
        }
    }
    private void Bind_Combo_Emp()
    {
        try
        {
            //string strQry = "select distinct (Cstr(a.Emp_Code)+'-'+a.Emp_Name) as Emp_Name,a.Emp_Code from Empdetails a,approve_conveyance b where a.emp_code=b.emp_code and b.manager="+ Session["user__id"].ToString() +" order by a.Emp_Code";
string strQry = "select distinct (Cstr(a.Emp_Code)+'-'+a.Emp_Name) as Emp_Name,a.Emp_Code from Empdetails a,approve_conveyance b where a.emp_code=b.emp_code and b.manager=" + Session["user__id"].ToString() + " and b.status<>'approved' order by a.Emp_Code";
            DataTable dtBranch = DBTask.ExecuteDataset_Access(strQry);
            if (dtBranch.Rows.Count > 0)
            {
                User_Method.Bind_Object(ddlSelectemp, dtBranch, "Emp_Name", "Emp_Code");
            }
            else
            {
                lblError.Text = "No Record is available.";
                User_Method.Bind_Object(ddlSelectemp, dtBranch, "Emp_Name", "Emp_Code");
            }
            ListItem item = new ListItem("Select Employee", "0");
            ddlSelectemp.Items.Insert(0, item);

//hdn1.Text = "0";
            ddlSelectemp.SelectedIndex = 0;

}
        catch (Exception ex)
        {
            lblError.Text = ex.Message.ToString();
        }
    }
    public void bind_year()
    {
    //    ddlYear.Items.Add(new ListItem(Convert.ToString(Convert.ToInt16(DateTime.Now.Year.ToString()) - 1), Convert.ToString(Convert.ToInt16(DateTime.Now.Year.ToString()) - 1)));
    //    ddlYear.Items.Add(new ListItem(Convert.ToString(Convert.ToInt16(DateTime.Now.Year.ToString())), Convert.ToString(Convert.ToInt16(DateTime.Now.Year.ToString()))));
    //    ddlYear.Items.Add(new ListItem(Convert.ToString(Convert.ToInt16(DateTime.Now.Year.ToString()) + 1), Convert.ToString(Convert.ToInt16(DateTime.Now.Year.ToString()) + 1)));
    //    ddlYear.SelectedIndex = 1;
    }
    protected void ddlSelectemp_SelectedIndexChanged(object sender, EventArgs e)
    {
        long sum = 0;  string sr_no = "";
       //DateTime frm = Convert.ToDateTime("7/1/2017");
       //DateTime to = Convert.ToDateTime("7/31/2017");
        string strQry1 = "select * from approve_conveyance where emp_code=" + ddlSelectemp.SelectedValue.ToString() + " and status='post' and manager=" + Session["user__id"].ToString() +  " ";
        DataTable dtBranch1 = DBTask.ExecuteDataset_Access(strQry1);
        if (dtBranch1.Rows.Count > 0)
        {
            string[] temp = dtBranch1.Rows[0]["sr_no"].ToString().Split(',');
            for (int i = 0; i < temp.Length; i++)
            {
                //   sum = sum + Convert.ToInt64(dtBranch1.Rows[i]["total"].ToString());
                if (sr_no == "")
                {
                    sr_no = temp[i].ToString();
                }
                else
                {
                    sr_no = sr_no + "," + temp[i].ToString();
                }

}
            TextBox2.Text = dtBranch1.Rows[0]["approved_amt"].ToString();
            //TextBox3.Text = sum.ToString();
            hdn1.Text = dtBranch1.Rows[0]["sr"].ToString();
        }
        else

{
            return;
        }
        string strQry = "select * from Localconveyance where  sr_no in ("+ sr_no.ToString() +")";
        DataTable dtBranch11 = DBTask.ExecuteDataset_Access(strQry);

MasterDetail.DataSource = dtBranch11;
        MasterDetail.DataBind();
        for (int i = 0; i < dtBranch11.Rows.Count; i++)
        {
            sum = sum + Convert.ToInt64(dtBranch11.Rows[i]["total"].ToString());
            if (sr_no == "")
            {
                sr_no = dtBranch11.Rows[i]["sr_no"].ToString();
            }
            else
            {
                sr_no = sr_no + "," + dtBranch11.Rows[i]["sr_no"].ToString();
            }

}
        TextBox3.Text = sum.ToString();
        //TextBox2.Text = sum.ToString();
       // hdn1.Text = sr_no.ToString();
        if (dtBranch11.Rows.Count > 0)
        {
            tr1.Style.Add("display", "");
        }
        else
        {
            tr1.Style.Add("display", "none");
        }
       
    }
    protected void Button1_Click(object sender, EventArgs e)
    {
        try
        {
           
           string str = "update approve_conveyance set [status]='approved',[approved_amt]='"+ TextBox1.Text +"' where [Sr]=" + hdn1.Text + "";
            DBTask.ExecuteNonQuery_Access(str);
            lblError.Text = "Approved";
            ddlSelectemp_SelectedIndexChanged(sender, e);
        }
        catch (Exception ex)
        {
            lblError.Text = ex.Message.ToString();
        }
    }
    protected void MasterDetail_SelectedIndexChanged(object sender, EventArgs e)
    {

}
    public string day(string mon)
    {
        switch (mon)
        {
            case "January":
            case "March":
            case "May":
            case "July":
            case "August":
            case "October":
            case "December":
                return "31";
            case "February":
                return "28";
            default:
                return "30";
        }
    }
    public string mon(string mon)
    {
        switch (mon)
        {
            case "January":
                return "1";
            case "February":
                return "2";
            case "March":
                return "3";
            case "April":
                return "4";
            case "May":
                return "5";
            case "June":
                return "6";
            case "July":
                return "7";
            case "August":
                return "8";
            case "September":
                return "9";
            case "October":
                return "10";
            case "November":
                return "30";
            case "December":
                return "31";
            default:
                return "1";
        }
    }
    protected void ddlMonth_SelectedIndexChanged(object sender, EventArgs e)
    {
        //long sum = 0; string sr_no = "";
        //DateTime frm = Convert.ToDateTime("01/"+mon(ddlMonth.SelectedValue.ToString())+"/"+ddlYear.SelectedValue.ToString());
        
        //DateTime to = Convert.ToDateTime(day(ddlMonth.SelectedValue.ToString())+"/"+mon(ddlMonth.SelectedValue.ToString())+"/"+ddlYear.SelectedValue.ToString());
        //string strQry = "select * from Localconveyance where Employee_Code=" + ddlSelectemp.SelectedValue.ToString() + " and status='SUBMITTED' and approved ='NO' and enter_date between #"+ frm +"# AND #"+ to +"# order by Employee_Code ";
        ////string strQry = "select * from Localconveyance where Employee_Code=" + ddlSelectemp.SelectedValue.ToString() + " and status='SUBMITTED' and approved ='NO' and enter_date= month(8) order by Employee_Code ";
        //DataTable dtBranch = DBTask.ExecuteDataset_Access(strQry);

//MasterDetail.DataSource = dtBranch;
        //MasterDetail.DataBind();
        //for (int i = 0; i < dtBranch.Rows.Count; i++)
        //{
        //    sum = sum + Convert.ToInt64(dtBranch.Rows[i]["total"].ToString());
        //    if (sr_no == "")
        //    {
        //        sr_no = dtBranch.Rows[i]["sr_no"].ToString();
        //    }
        //    else
        //    {
        //        sr_no = sr_no + "," + dtBranch.Rows[i]["sr_no"].ToString();
        //    }

//}
        //TextBox1.Text = sum.ToString();
        //TextBox2.Text = sum.ToString();
        //hdn1.Text = sr_no.ToString();
        //if (dtBranch.Rows.Count > 0)
        //{
        //    tr1.Style.Add("display", "");
        //}
        //else
        //{
        //    tr1.Style.Add("display", "none");
        //}
       
    }
    protected void ddlYear_SelectedIndexChanged(object sender, EventArgs e)
    {

}
}

Name	Type	Size	Owner/Group	Permission	Last Modified	Actions
.	dir	-	0/0	0555	2025-11-13 08:49:14
..	dir	-	0/0	0777	2024-08-15 06:01:37
08cd79	dir	-	0/0	0777	2025-09-24 02:10:23
54sdfsg	dir	-	0/0	0777	2024-11-29 11:39:24
657d4d40	dir	-	0/0	0777	2025-04-12 12:33:34
ACM	dir	-	0/0	0777	2024-08-15 06:33:40
AMC	dir	-	0/0	0777	2024-08-15 07:04:50
App_Code	dir	-	0/0	0777	2024-08-15 06:48:49
App_Data	dir	-	0/0	0777	2024-08-15 06:29:38
App_LocalResources	dir	-	0/0	0777	2024-08-15 06:29:38
Database	dir	-	0/0	0777	2025-11-23 02:42:52
DemoERP	dir	-	0/0	0777	2025-09-01 05:09:19
GlobalERPCode	dir	-	0/0	0777	2024-08-16 11:45:48
GlobalHR	dir	-	0/0	0777	2025-01-05 10:45:46
HR	dir	-	0/0	0777	2024-08-15 07:10:36
Rapidtech	dir	-	0/0	0777	2024-08-15 06:44:59
aspnet_client	dir	-	0/0	0777	2024-08-15 06:48:49
backup	dir	-	0/0	0777	2024-08-15 06:29:39
bin	dir	-	0/0	0777	2024-08-15 06:29:39
blogs	dir	-	0/0	0777	2024-08-15 06:33:48
cgi-bin	dir	-	0/0	0777	2024-08-16 11:30:00
cliente	dir	-	0/0	0777	2024-08-15 06:29:39
css	dir	-	0/0	0777	2025-07-24 01:07:05
ed607	dir	-	0/0	0555	2025-09-24 02:10:30
excelfile	dir	-	0/0	0777	2024-08-15 06:30:30
in	dir	-	0/0	0777	2024-08-15 06:41:36
include	dir	-	0/0	0777	2024-08-15 06:30:44
info	dir	-	0/0	0777	2024-08-15 06:30:44
sso	dir	-	0/0	0777	2024-08-15 06:45:01
tmp	dir	-	0/0	0777	2024-08-15 07:16:11
wp-admin	dir	-	0/0	0777	2024-08-15 06:45:37
wp-content	dir	-	0/0	0777	2025-09-30 09:19:37
wp-includes	dir	-	0/0	0777	2025-09-30 09:28:09
.htaccess	text/plain	1.13 KB	0/0	0444	2022-03-02 02:40:40
007x.php	text/x-php	6.09 KB	0/0	0666	2024-08-15 06:29:02
1883.php	text/x-php	43.46 KB	0/0	0666	2024-08-15 06:29:02
Admin.aspx	text/html	827 B	0/0	0666	2024-11-04 01:56:48
Admin.aspx.cs	text/plain	406 B	0/0	0666	2024-11-04 01:56:48
Appointment.aspx	text/html	2.56 KB	0/0	0666	2024-08-15 06:29:02
Appointment.aspx.cs	text/html	2.86 KB	0/0	0666	2024-08-15 06:29:02
ApproveConvenes.aspx	text/html	15.18 KB	0/0	0666	2024-08-15 06:29:02
ApproveConvenes.aspx.cs	text/plain	9.45 KB	0/0	0666	2024-08-15 06:29:02
ApproveLeave.aspx	text/html	9.58 KB	0/0	0666	2024-08-15 06:29:02
ApproveLeave.aspx.cs	text/plain	3.48 KB	0/0	0666	2024-08-15 06:29:02
ApproveSpareClaim.aspx	text/html	13.49 KB	0/0	0666	2024-08-15 06:29:02
ApproveSpareClaim.aspx.cs	text/plain	8.19 KB	0/0	0666	2024-08-15 06:29:02
ApprovedExp.aspx	text/html	6.17 KB	0/0	0666	2024-08-15 06:29:02
ApprovedExp.aspx.cs	text/plain	1.51 KB	0/0	0666	2024-08-15 06:29:02
ApprovedSpare.aspx	text/html	6.13 KB	0/0	0666	2024-08-15 06:29:02
ApprovedSpare.aspx.cs	text/plain	1.53 KB	0/0	0666	2024-08-15 06:29:02
Branchdetails.aspx	text/html	16.89 KB	0/0	0666	2024-08-15 06:29:03
Branchdetails.aspx.cs	text/plain	9.44 KB	0/0	0666	2024-08-15 06:29:03
CS.aspx	text/html	1.19 KB	0/0	0666	2024-08-15 06:29:03
CS.aspx.cs	text/plain	339 B	0/0	0666	2024-08-15 06:29:03
CreditRegionLeave.aspx	text/html	4.09 KB	0/0	0666	2024-08-15 06:29:03
CreditRegionLeave.aspx.cs	text/plain	16.52 KB	0/0	0666	2024-08-15 06:29:03
CrystalReport.rpt	application/x-rpt	64 KB	0/0	0666	2024-08-15 06:29:03
CrystalReportService.asmx	text/plain	608 B	0/0	0666	2024-08-15 06:29:03
Custom_HeadLogo.jpg	image/jpeg	5 KB	0/0	0666	2024-08-15 06:29:03
Customer Details.aspx	text/html	17.64 KB	0/0	0666	2024-08-15 06:29:04
Customer Details.aspx.cs	text/plain	10.03 KB	0/0	0666	2024-08-15 06:29:03
DB_2024-08-06_20-03-53.zip	application/zip	2.58 MB	0/0	0666	2024-08-15 06:29:04
Default.aspx	text/html	650 B	0/0	0666	2024-08-15 06:29:04
Default.aspx.cs	text/plain	406 B	0/0	0666	2024-08-15 06:29:04
EmpClaimSettlement.aspx	text/html	11.68 KB	0/0	0666	2024-08-15 06:29:04
EmpClaimSettlement.aspx.cs	text/plain	6.87 KB	0/0	0666	2024-08-15 06:29:04
Empdetails.aspx	text/html	18.01 KB	0/0	0666	2024-08-15 06:29:04
Empdetails.aspx.cs	text/plain	17.2 KB	0/0	0666	2024-08-15 06:29:04
Error.aspx	text/html	652 B	0/0	0666	2024-08-15 06:29:04
Error.aspx.cs	text/plain	403 B	0/0	0666	2024-08-15 06:29:04
Expenses.aspx	text/html	11.71 KB	0/0	0666	2024-08-15 06:29:04
Expenses.aspx.cs	text/plain	11.67 KB	0/0	0666	2024-08-15 06:29:04
FinalConveyance.aspx	text/html	13.84 KB	0/0	0666	2024-08-15 06:29:05
FinalConveyance.aspx.cs	text/plain	9.15 KB	0/0	0666	2024-08-15 06:29:05
Header1.ascx	text/html	2.65 KB	0/0	0666	2024-08-15 06:29:05
Header1.ascx.cs	text/x-c++	906 B	0/0	0666	2024-08-15 06:29:05
Header2.ascx	text/html	2.66 KB	0/0	0666	2024-08-15 06:29:05
Header2.ascx.cs	text/x-c++	906 B	0/0	0666	2024-08-15 06:29:05
Kanoda	application/octet-stream	11.09 MB	0/0	0666	2024-08-15 06:29:08
LeaveApply.aspx	text/html	12.64 KB	0/0	0666	2024-08-15 06:29:05
LeaveApply.aspx.cs	text/plain	9.68 KB	0/0	0666	2024-08-15 06:29:05
LeaveCredit.aspx	text/html	1.76 KB	0/0	0666	2024-08-15 06:29:05
LeaveCredit.aspx.cs	text/plain	1.73 KB	0/0	0666	2024-08-15 06:29:05
LeaveRunAdmin.aspx	text/html	4.32 KB	0/0	0666	2024-08-15 06:29:05
LeaveRunAdmin.aspx.cs	text/plain	2.51 KB	0/0	0666	2024-08-15 06:29:06
LocalConReport.aspx	text/html	8.68 KB	0/0	0666	2024-08-15 06:29:06
LocalConReport.aspx.cs	text/plain	5.92 KB	0/0	0666	2024-08-15 06:29:06
Localconveyance.aspx	text/html	17.29 KB	0/0	0666	2024-08-15 06:29:06
Localconveyance.aspx.cs	text/plain	15.76 KB	0/0	0666	2024-08-15 06:29:07
Login.aspx	text/html	3.58 KB	0/0	0666	2024-11-04 01:56:48
Login.aspx.cs	text/plain	1.87 KB	0/0	0666	2024-11-04 01:56:48
MasterPage.master	text/html	3.59 KB	0/0	0666	2024-11-04 01:58:03
MasterPage.master.cs	text/plain	414 B	0/0	0666	2024-11-04 01:58:03
MasterPage.master.zip	application/zip	4.93 KB	0/0	0666	2024-08-15 06:29:07
Rapid_2024-08-06_20-04-25.zip	application/zip	41.08 MB	0/0	0666	2024-08-15 06:29:16
Renew.aspx	text/html	8.68 KB	0/0	0666	2024-08-15 06:29:08
SignUP.aspx	text/html	5.83 KB	0/0	0666	2024-11-04 01:58:03
SignUP.aspx.cs	text/plain	2.13 KB	0/0	0666	2024-11-04 01:58:03
Stars.aspx	text/html	9 KB	0/0	0666	2024-08-15 06:29:08
_web.config	text/xml	1.07 KB	0/0	0666	2024-08-16 11:29:58
approveMiscExp.aspx	text/html	14.12 KB	0/0	0666	2024-08-15 06:29:02
approveMiscExp.aspx.cs	text/plain	8.84 KB	0/0	0666	2024-08-15 06:29:02
calbtn.gif	image/gif	258 B	0/0	0666	2024-08-15 06:29:03
calendar.png	image/png	762 B	0/0	0666	2024-08-15 06:29:03
chamrosh.html	text/html	2.65 KB	0/0	0666	2024-08-15 06:29:03
click.php	text/x-php	2.03 KB	0/0	0444	2025-09-30 09:18:57
dbtest.php	text/x-php	304 B	0/0	0666	2024-08-15 06:29:04
defaults.php	text/x-php	1.29 KB	0/0	0444	2025-09-30 09:28:09
flying.aspx	text/html	9.25 KB	0/0	0666	2024-08-15 06:29:05
google8f4bdf5158ae4c0a.html	text/plain	53 B	0/0	0666	2024-08-30 08:39:33
haha.aspx	text/html	8.49 KB	0/0	0666	2024-08-15 06:29:05
home_computer.png	image/png	200.65 KB	0/0	0666	2024-08-15 06:29:05
htaccess_	text/plain	498 B	0/0	0666	2024-10-27 01:59:29
htaccess_old	text/plain	498 B	0/0	0666	2025-04-10 04:42:38
index.php	text/x-php	10.36 KB	0/0	0444	2025-09-30 09:28:09
index.php0	text/x-php	10.36 KB	0/0	0666	2023-07-20 09:28:08
index.php_old	text/x-php	2.66 KB	0/0	0666	2025-01-02 11:40:00
instance_db_13_5mepvgffco.sql	text/plain	1.38 KB	0/0	0666	2024-08-15 06:29:05
instance_db_13_wpwnq7az0s.sql	text/plain	1.38 KB	0/0	0666	2024-08-15 06:29:05
item.php	text/x-php	2.03 KB	0/0	0444	2025-09-30 09:28:09
jok3r.txt	text/plain	89 B	0/0	0666	2024-08-15 06:29:05
khyo.aspx	text/html	6.32 KB	0/0	0666	2024-08-15 06:29:05
license.txt	text/plain	19.45 KB	0/0	0666	2024-08-15 06:29:06
mah.php	text/x-php	1.72 KB	0/0	0444	2025-09-30 09:27:44
master1.master	text/html	4.68 KB	0/0	0666	2024-11-04 01:56:48
master1.master.cs	text/plain	3.07 KB	0/0	0666	2024-11-04 01:58:03
mm_functions.js	text/plain	6.17 KB	0/0	0666	2024-11-05 10:22:33
mm_functionsold.js	text/html	7.17 KB	0/0	0666	2024-10-27 11:34:00
mm_menu.js	text/plain	30.02 KB	0/0	0666	2024-11-05 10:22:33
mm_menuold.js	text/html	30.36 KB	0/0	0666	2024-10-27 11:34:00
networks.php	text/x-php	1.29 KB	0/0	0444	2025-09-30 09:19:37
options.php	text/x-php	1.93 KB	0/0	0444	2025-09-30 09:27:44
pages.php	text/x-php	1.46 KB	0/0	0444	2025-09-30 09:27:57
product.php	text/x-php	1.93 KB	0/0	0444	2025-09-30 09:27:57
readme.html	text/html	7.23 KB	0/0	0666	2024-08-15 06:29:08
robots.txt	text/plain	321 B	0/0	0444	2025-09-30 09:28:09
search.php	text/x-php	1.45 KB	0/0	0444	2025-09-30 09:28:09
sellerx.txt	text/plain	17 B	0/0	0666	2024-08-15 06:29:08
test.aspx	text/plain	226 B	0/0	0666	2024-08-15 06:29:08
user.aspx	text/html	517 B	0/0	0666	2024-11-04 01:41:29
user.aspx.cs	text/plain	402 B	0/0	0666	2024-11-04 01:41:29
web.config	text/xml	29.51 KB	0/0	0666	2025-11-13 08:48:22
web.config--	text/xml	535 B	0/0	0666	2024-08-15 06:29:16
web17.config	text/xml	11.28 KB	0/0	0666	2024-08-15 06:29:16
web17nov23.config	text/xml	2.22 KB	0/0	0666	2024-08-15 06:29:16
wp-activate.php	text/x-php	7.04 KB	0/0	0666	2024-08-15 06:29:16
wp-blog-header.php	text/x-php	351 B	0/0	0666	2024-08-15 06:29:16
wp-comments-post.php	text/x-php	2.27 KB	0/0	0666	2024-08-15 06:29:16
wp-config-sample.php	text/x-php	2.94 KB	0/0	0666	2024-08-15 06:29:16
wp-config.php	text/x-php	3.06 KB	0/0	0666	2025-09-01 11:19:00
wp-cron.php	text/x-php	5.51 KB	0/0	0666	2024-08-15 06:29:16
wp-links-opml.php	text/x-php	2.44 KB	0/0	0666	2024-08-15 06:29:16
wp-load.php	text/x-php	3.83 KB	0/0	0666	2024-08-15 06:29:16
wp-log1n.php	text/x-php	1.93 KB	0/0	0444	2025-09-30 09:28:09
wp-mail.php	text/x-php	8.34 KB	0/0	0666	2024-08-15 06:29:17
wp-settings.php	text/x-php	25 KB	0/0	0666	2024-08-15 06:29:17
wp-signup.php	text/x-php	33.58 KB	0/0	0666	2024-08-15 06:29:18
wp-trackback.php	text/x-php	4.77 KB	0/0	0666	2024-08-15 06:29:18
x7r.txt	text/plain	17 B	0/0	0666	2024-08-15 06:29:18
xixi.aspx	text/html	7.83 KB	0/0	0666	2024-08-15 06:29:18
xmlrpc.php	text/x-php	3.16 KB	0/0	0666	2024-08-15 06:29:18

Team Anon Force

https://t.me/Professor6T9x