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 : RoleMaster.aspx.cs

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using Microsoft.ApplicationBlocks.Data;
using System.Data.SqlClient;
using System.Data;
using System.IO;

public partial class RoleMaster : System.Web.UI.Page
{
    #region Common Fields

DataSet DSRecords = new DataSet();
    DataTable DTRecords = new DataTable();

#endregion

#region ALERT Methods For Alert Messages Section
    public enum MessageType { Success, Error, Info, Warning };
    protected void ShowMessage(string Message, MessageType type)
    {
        ScriptManager.RegisterStartupScript(this, this.GetType(), System.Guid.NewGuid().ToString(), "ShowMessage('" + Message + "','" + type + "');", true);
    }
    #endregion

protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            BindGVRole();
            Page.Title = "Role Master";
        }
    }

private void BindGVRole()
    {
        try
        {
            string strselect = "SELECT * FROM role_master";
            DSRecords = clsConnectionSql.fillds(strselect);
            DTRecords = DSRecords.Tables[0];
            if (DTRecords.Rows.Count > 0)
            {
                GVRole.DataSource = DTRecords;
                GVRole.DataBind();
            }
            foreach (GridViewRow Row in GVRole.Rows)
            {
                Label lblStatus = (Label)Row.FindControl("lblStatus");
                LinkButton LBEdit = (LinkButton)Row.FindControl("LBEdit");
                LinkButton LBDelete = (LinkButton)Row.FindControl("LBDelete");
                if (lblStatus.Text == "Active")
                {
                    lblStatus.CssClass = "label label-success";
                    LBEdit.Enabled = true;
                    LBDelete.Enabled = true;
                }
                else
                {
                    lblStatus.CssClass = "label label-danger";
                    LBEdit.Enabled = false;
                    LBDelete.Enabled = false;
                }
            }
        }
        catch (Exception ex)
        {
            ShowMessage(ex.Message, MessageType.Error);
        }
    }

// Method For GridView Payment Terms Row Command
    protected void GVRole_RowCommand(object sender, GridViewCommandEventArgs e)
    {
        try
        {
            int recordId = Convert.ToInt32(e.CommandArgument);
            Session["RecordId"] = recordId;

#region For Edit Record
            if (e.CommandName == "EditRecord")
            {
                string stredit = "SELECT * FROM role_master WHERE ID='" + recordId + "'";
                DataSet DSRecords2 = clsConnectionSql.fillds(stredit);
                DataTable DTRecords2 = DSRecords2.Tables[0];
                if (DTRecords2.Rows.Count > 0)
                {
                    TBRole.Text = DTRecords2.Rows[0]["Role"].ToString();
                    btnforSubmit.Text = "Update";
                }
            }
            #endregion

#region For Delete Record
            if (e.CommandName == "DeleteRecord")
            {
                string strSelect = "SELECT * FROM role_master WHERE ID='" + recordId + "'";
                DataSet DSReason = clsConnectionSql.fillds(strSelect);
                if (DSReason.Tables[0].Rows.Count > 0)
                {
                    Session["Role"] = DSReason.Tables[0].Rows[0]["Role"].ToString();
                }

string strdelete = "DELETE FROM role_master WHERE ID='" + recordId + "'";
                int Result = clsConnectionSql.IUDRet(strdelete);
                if (Result > 0)
                {
                    string StrMsg = DateTime.Now.ToString() + "  ";
                    StrMsg += "DELETE Role  '" + Session["Role"].ToString() + "' By User '" + Session["UserName"] + "'" + "  ";
                    LogFile.Log(StrMsg);
                }
            }
            #endregion

#region For Change Status
            if (e.CommandName == "ChangeStatus")
            {
                string SelQry = "SELECT * FROM role_master WHERE ID='" + recordId + "'";
                DSRecords = clsConnectionSql.fillds(SelQry);
                DTRecords = DSRecords.Tables[0];
                if (DTRecords.Rows.Count > 0)
                {
                    #region Change Status True To False
                    if (DTRecords.Rows[0]["Status"].ToString() == "1")
                    {
                        string ChangeStatus = "UPDATE role_master SET Status='" + 0 + "' WHERE ID='" + recordId + "'";
                        int Result = clsConnectionSql.IUDRet(ChangeStatus);
                        if (Result > 0)
                        {
                            string Qry = "SELECT * FROM users WHERE UserRole='" + DTRecords.Rows[0]["Role"].ToString() + "'";
                            DataTable DTUser = clsConnectionSql.filldt(Qry);
                            if (DTUser.Rows.Count > 0)
                            {
                                for (int i = 0; i < DTUser.Rows.Count; i++)
                                {
                                    string UpdateUser = "UPDATE users SET Status='" + 0 + "' WHERE ID='" + DTUser.Rows[i]["ID"] + "'";
                                    int Result2 = clsConnectionSql.IUDRet(UpdateUser);
                                }
                            }
                        }
                        else
                        {
                            ShowMessage("Some Technical Error Occur!!!", MessageType.Error);
                        }
                    }
                    #endregion

#region Change Status False TO True
                    if (DTRecords.Rows[0]["Status"].ToString() == "0")
                    {
                        string ChangeStatus = "UPDATE role_master SET Status='" + 1 + "' WHERE ID='" + recordId + "'";
                        int Result = clsConnectionSql.IUDRet(ChangeStatus);
                        if (Result > 0)
                        {
                            string Qry = "SELECT * FROM users WHERE UserRole='" + DTRecords.Rows[0]["Role"].ToString() + "'";
                            DataTable DTUser = clsConnectionSql.filldt(Qry);
                            if (DTUser.Rows.Count > 0)
                            {
                                for (int i = 0; i < DTUser.Rows.Count; i++)
                                {
                                    string UpdateUser = "UPDATE users SET Status='" + 1 + "' WHERE ID='" + DTUser.Rows[i]["ID"] + "'";
                                    int Result2 = clsConnectionSql.IUDRet(UpdateUser);
                                }
                            }
                        }
                        else
                        {
                            ShowMessage("Some Technical Error Occur!!!", MessageType.Error);
                        }
                    }
                    #endregion
                }
            }
            #endregion

BindGVRole();
        }
        catch (Exception ex)
        {
            ShowMessage(ex.Message, MessageType.Error);
        }
    }

// Method for Paging in GridView Bank
    protected void GVRole_PageIndexChanging(object sender, GridViewPageEventArgs e)
    {
        GVRole.PageIndex = e.NewPageIndex;
        BindGVRole();
        GVRole.DataBind();
    }

// Method For Button For Fiscal Year Form
    protected void SubmitMethod(object sender, EventArgs e)
    {
        if (Page.IsValid)
        {
            if (sender == btnforSubmit)
            {
                if (btnforSubmit.Text == "Submit")
                {
                    string strinsert = "INSERT INTO role_master (Role) VALUES('" + TBRole.Text + "')";
                    int result = clsConnectionSql.IUDRet(strinsert);
                    if (result > 0)
                    {
                        string StrMsg = DateTime.Now.ToString() + "  ";
                        StrMsg += "INSERT Role  '" + TBRole.Text + "' By User '" + Session["UserName"] + "'" + "  ";
                        LogFile.Log(StrMsg);
                        ShowMessage("Record Successfully Added", MessageType.Success);
                    }
                    else
                        ShowMessage("Some Technical Error Occur!!!", MessageType.Error);
                }

if (btnforSubmit.Text == "Update")
                {
                    string strup = "UPDATE role_master SET Role='" + TBRole.Text + "' WHERE ID='" + Session["RecordId"] + "'";
                    int result = clsConnectionSql.IUDRet(strup);
                    if (result > 0)
                    {
                        string StrMsg = DateTime.Now.ToString() + "  ";
                        StrMsg += "UPDATE Role  '" + TBRole.Text + "' By User '" + Session["UserName"] + "'" + "  ";
                        LogFile.Log(StrMsg);
                        ShowMessage("Record Successfully Updated", MessageType.Success);
                    }
                    else
                        ShowMessage("Some Technical Error Occur!!!", MessageType.Error);
                }
                ClearFYForm();
                BindGVRole();
            }

if (sender == btnforCancel)
            {
                ClearFYForm();
            }
        }
    }

// Method For Clear Warhouse Form Data
    private void ClearFYForm()
    {
        TBRole.Text = string.Empty;
        btnforSubmit.Text = "Submit";
    }

protected void SearchEvent(object sender, EventArgs e)
    {
        try
        {
            string strdel = "SELECT * FROM role_master WHERE Role LIKE '" + TBSearch.Text.Trim() + "%'";
            DataSet DSFY = clsConnectionSql.fillds(strdel);
            if (DSFY.Tables[0].Rows.Count > 0)
            {
                GVRole.DataSource = DSFY.Tables[0];
                GVRole.DataBind();
            }
            else
            {
                GVRole.EmptyDataText = "No Record Found !";
                GVRole.DataBind();
            }
            foreach (GridViewRow Row in GVRole.Rows)
            {
                Label lblStatus = (Label)Row.FindControl("lblStatus");
                LinkButton LBEdit = (LinkButton)Row.FindControl("LBEdit");
                LinkButton LBDelete = (LinkButton)Row.FindControl("LBDelete");
                if (lblStatus.Text == "Active")
                {
                    lblStatus.CssClass = "label label-success";
                    LBEdit.Enabled = true;
                    LBDelete.Enabled = true;
                }
                else
                {
                    lblStatus.CssClass = "label label-danger";
                    LBEdit.Enabled = false;
                    LBDelete.Enabled = false;
                }
            }
        }
        catch (Exception ex)
        {
            ShowMessage(ex.Message, MessageType.Error);
        }
    }
}

Name	Type	Size	Owner/Group	Permission	Last Modified	Actions
.	dir	-	0/0	0777	2025-07-03 03:16:05
..	dir	-	0/0	0777	2025-03-26 06:12:51
Account	dir	-	0/0	0777	2025-07-03 03:15:44
AdminDocument	dir	-	0/0	0777	2025-07-03 03:16:04
AdminImages	dir	-	0/0	0777	2025-07-03 03:16:05
App_Code	dir	-	0/0	0777	2025-07-03 03:15:51
App_Data	dir	-	0/0	0777	2025-07-03 03:15:51
Bin	dir	-	0/0	0777	2025-07-03 03:15:58
Scripts	dir	-	0/0	0777	2025-07-03 03:16:03
Styles	dir	-	0/0	0777	2025-07-03 03:16:04
angular	dir	-	0/0	0777	2025-07-03 03:15:49
assets	dir	-	0/0	0777	2025-07-03 03:17:10
css	dir	-	0/0	0777	2025-07-03 03:16:00
js	dir	-	0/0	0777	2025-07-03 03:16:01
About.aspx	text/plain	431 B	0/0	0666	2025-07-03 03:15:11
About.aspx.cs	text/plain	279 B	0/0	0666	2025-07-03 03:15:11
AllocateMaterial.aspx	text/html	36.81 KB	0/0	0666	2025-07-03 03:15:12
AllocateMaterial.aspx.cs	text/plain	43.49 KB	0/0	0666	2025-07-03 03:15:12
BabaMain.master	text/html	9 KB	0/0	0666	2025-07-03 03:15:12
BabaMain.master.cs	text/plain	3.41 KB	0/0	0666	2025-07-03 03:15:13
Company.aspx	text/html	34.35 KB	0/0	0666	2025-07-03 03:15:13
Company.aspx.cs	text/plain	28.03 KB	0/0	0666	2025-07-03 03:15:13
DCULocationChange.aspx	text/html	7.89 KB	0/0	0666	2025-07-03 03:15:14
DCULocationChange.aspx.cs	text/plain	6.36 KB	0/0	0666	2025-07-03 03:15:14
DCUPickUp.aspx	text/html	15.21 KB	0/0	0666	2025-07-03 03:15:14
DCUPickUp.aspx.cs	text/plain	33.9 KB	0/0	0666	2025-07-03 03:15:14
Dashboard.aspx	text/html	16.07 KB	0/0	0666	2025-07-03 03:15:13
Dashboard.aspx.cs	text/plain	9.5 KB	0/0	0666	2025-07-03 03:15:14
DispatchReport.aspx	text/html	39.69 KB	0/0	0666	2025-07-03 03:15:15
DispatchReport.aspx.cs	text/html	29.01 KB	0/0	0666	2025-07-03 03:15:15
DispatchReport02.aspx	text/html	39.9 KB	0/0	0666	2025-07-03 03:15:16
DispatchReport02.aspx.cs	text/plain	29.01 KB	0/0	0666	2025-07-03 03:15:16
DispatchReport03.aspx	text/html	39.87 KB	0/0	0666	2025-07-03 03:15:16
DispatchReport03.aspx.cs	text/html	28.99 KB	0/0	0666	2025-07-03 03:15:16
DispatchReturn.aspx	text/html	24.82 KB	0/0	0666	2025-07-03 03:15:17
DispatchReturn.aspx.cs	text/plain	26.8 KB	0/0	0666	2025-07-03 03:15:17
DisptachEmployee.aspx	text/html	10.74 KB	0/0	0666	2025-07-03 03:15:17
DisptachEmployee.aspx.cs	text/plain	5.89 KB	0/0	0666	2025-07-03 03:15:17
EngineDispatch.aspx	text/html	24.91 KB	0/0	0666	2025-07-03 03:15:18
EngineDispatch.aspx.cs	text/plain	45.46 KB	0/0	0666	2025-07-03 03:15:18
ExportReport.aspx	text/html	11.8 KB	0/0	0666	2025-07-03 03:15:18
ExportReport.aspx.cs	text/plain	9.98 KB	0/0	0666	2025-07-03 03:15:18
Global.asax	text/html	951 B	0/0	0666	2025-07-03 03:15:19
GradeMaster.aspx	text/html	9.74 KB	0/0	0666	2025-07-03 03:15:19
GradeMaster.aspx.cs	text/plain	5.85 KB	0/0	0666	2025-07-03 03:15:19
Home.aspx	text/html	4.16 KB	0/0	0666	2025-07-03 03:15:19
Home.aspx.cs	text/plain	276 B	0/0	0666	2025-07-03 03:15:19
InchargeMaster.aspx	text/html	9.27 KB	0/0	0666	2025-07-03 03:15:20
InchargeMaster.aspx.cs	text/plain	5.91 KB	0/0	0666	2025-07-03 03:15:20
Location.aspx	text/html	25.02 KB	0/0	0666	2025-07-03 03:15:20
Location.aspx.cs	text/plain	30.81 KB	0/0	0666	2025-07-03 03:15:20
LocationChange.aspx	text/html	8.14 KB	0/0	0666	2025-07-03 03:15:21
LocationChange.aspx.cs	text/plain	6.02 KB	0/0	0666	2025-07-03 03:15:21
LocationMaster.aspx	text/html	10.89 KB	0/0	0666	2025-07-03 03:15:21
LocationMaster.aspx.cs	text/plain	7.57 KB	0/0	0666	2025-07-03 03:15:21
Login.aspx	text/html	7.56 KB	0/0	0666	2025-07-03 03:15:22
Login.aspx.cs	text/html	2.12 KB	0/0	0666	2025-07-03 03:15:22
OperatorMaster.aspx	text/html	8.77 KB	0/0	0666	2025-07-03 03:15:22
OperatorMaster.aspx.cs	text/plain	5.9 KB	0/0	0666	2025-07-03 03:15:22
Palletisation.aspx	text/html	15.46 KB	0/0	0666	2025-07-03 03:15:23
Palletisation.aspx.cs	text/plain	32.11 KB	0/0	0666	2025-07-03 03:15:23
PalletisationReport.aspx	text/html	22.8 KB	0/0	0666	2025-07-03 03:15:23
PalletisationReport.aspx.cs	text/plain	24.51 KB	0/0	0666	2025-07-03 03:15:23
PickUp.aspx	text/html	35.54 KB	0/0	0666	2025-07-03 03:15:24
PickUp.aspx.cs	text/plain	45.25 KB	0/0	0666	2025-07-03 03:15:24
ProductCreate.aspx	text/html	26.72 KB	0/0	0666	2025-07-03 03:15:24
ProductCreate.aspx.cs	text/plain	19.38 KB	0/0	0666	2025-07-03 03:15:24
ProductCreation.aspx	text/html	35.3 KB	0/0	0666	2025-07-03 03:15:25
ProductCreation.aspx.cs	text/plain	29.67 KB	0/0	0666	2025-07-03 03:15:25
ProductMaster.aspx	text/html	8.98 KB	0/0	0666	2025-07-03 03:15:25
ProductMaster.aspx.cs	text/plain	6.08 KB	0/0	0666	2025-07-03 03:15:25
ProductWiseReport.aspx	text/html	11.79 KB	0/0	0666	2025-07-03 03:15:26
ProductWiseReport.aspx.cs	text/plain	25.23 KB	0/0	0666	2025-07-03 03:15:26
RoleMaster.aspx	text/html	10.22 KB	0/0	0666	2025-07-03 03:15:26
RoleMaster.aspx.cs	text/plain	11.07 KB	0/0	0666	2025-07-03 03:15:26
Rpt_DispatchReport.aspx	text/html	24.43 KB	0/0	0666	2025-07-03 03:15:27
Rpt_DispatchReport.aspx.cs	text/plain	7.13 KB	0/0	0666	2025-07-03 03:15:27
Rpt_Engine.aspx	text/html	11.78 KB	0/0	0666	2025-07-03 03:15:27
Rpt_Engine.aspx.cs	text/html	6.1 KB	0/0	0666	2025-07-03 03:15:27
Rpt_EngineHistory.aspx	text/html	12.32 KB	0/0	0666	2025-07-03 03:15:27
Rpt_EngineHistory.aspx.cs	text/plain	5.38 KB	0/0	0666	2025-07-03 03:15:27
Rpt_LoginReport.aspx	text/html	5.48 KB	0/0	0666	2025-07-03 03:15:28
Rpt_LoginReport.aspx.cs	text/html	3.69 KB	0/0	0666	2025-07-03 03:15:28
Rpt_PickUpReport.aspx	text/html	20.15 KB	0/0	0666	2025-07-03 03:15:28
Rpt_PickUpReport.aspx.cs	text/plain	6.66 KB	0/0	0666	2025-07-03 03:15:28
Rpt_RightTagReport.aspx	text/html	21.61 KB	0/0	0666	2025-07-03 03:15:29
Rpt_RightTagReport.aspx.cs	text/plain	20.07 KB	0/0	0666	2025-07-03 03:15:29
Rpt_StockTrackReport.aspx	text/html	16.88 KB	0/0	0666	2025-07-03 03:15:29
Rpt_StockTrackReport.aspx.cs	text/plain	11.89 KB	0/0	0666	2025-07-03 03:15:29
Rpt_StockTrackReports.aspx	text/html	19.31 KB	0/0	0666	2025-07-03 03:15:30
Rpt_StockTrackReports.aspx.cs	text/plain	14.77 KB	0/0	0666	2025-07-03 03:15:30
Rpt_TagLocator.aspx	text/html	22.41 KB	0/0	0666	2025-07-03 03:15:30
Rpt_TagLocator.aspx.cs	text/plain	32.88 KB	0/0	0666	2025-07-03 03:15:31
Rpt_WarehouseEngine.aspx	text/html	11.65 KB	0/0	0666	2025-07-03 03:15:31
Rpt_WarehouseEngine.aspx.cs	text/plain	10.87 KB	0/0	0666	2025-07-03 03:15:31
Rpt_WarehouseWise.aspx	text/html	11.74 KB	0/0	0666	2025-07-03 03:15:31
Rpt_WarehouseWise.aspx.cs	text/plain	13.52 KB	0/0	0666	2025-07-03 03:15:31
SetLocation.aspx	text/html	6.59 KB	0/0	0666	2025-07-03 03:15:32
SetLocation.aspx.cs	text/plain	11.31 KB	0/0	0666	2025-07-03 03:15:32
ShiftMaster.aspx	text/html	11.93 KB	0/0	0666	2025-07-03 03:15:32
ShiftMaster.aspx.cs	text/plain	6.33 KB	0/0	0666	2025-07-03 03:15:32
Site.master	text/html	35.2 KB	0/0	0666	2025-07-03 03:15:33
Site.master.cs	text/plain	4.25 KB	0/0	0666	2025-07-03 03:15:33
SlabCompareReport.aspx	text/html	32.79 KB	0/0	0666	2025-07-03 03:15:33
SlabCompareReport.aspx.cs	text/plain	25.82 KB	0/0	0666	2025-07-03 03:15:33
SlabReport.aspx	text/html	23.67 KB	0/0	0666	2025-07-03 03:15:34
SlabReport.aspx.cs	text/plain	27.89 KB	0/0	0666	2025-07-03 03:15:34
StockTaking.aspx	text/html	16.62 KB	0/0	0666	2025-07-03 03:15:34
StockTaking.aspx.cs	text/plain	8.75 KB	0/0	0666	2025-07-03 03:15:34
ThickNessMaster.aspx	text/html	13.3 KB	0/0	0666	2025-07-03 03:15:35
ThickNessMaster.aspx.cs	text/plain	5.93 KB	0/0	0666	2025-07-03 03:15:35
Thicknesswise_Report.aspx	text/html	10.39 KB	0/0	0666	2025-07-03 03:15:35
Thicknesswise_Report.aspx.cs	text/plain	25.52 KB	0/0	0666	2025-07-03 03:15:35
UserMaster.aspx	text/html	20.8 KB	0/0	0666	2025-07-03 03:15:36
UserMaster.aspx.cs	text/plain	17.09 KB	0/0	0666	2025-07-03 03:15:36
UserRights.aspx	text/html	10.26 KB	0/0	0666	2025-07-03 03:15:36
UserRights.aspx.cs	text/plain	8.22 KB	0/0	0666	2025-07-03 03:15:36
ViewSlabDetail.aspx	text/html	21.52 KB	0/0	0666	2025-07-03 03:15:37
ViewSlabDetail.aspx.cs	text/plain	10.45 KB	0/0	0666	2025-07-03 03:15:37
WHPanel.aspx	text/html	449.88 KB	0/0	0666	2025-07-03 03:15:39
WHPanel.aspx.cs	text/plain	7.13 KB	0/0	0666	2025-07-03 03:15:38
WHPanel2.aspx	text/html	450.12 KB	0/0	0666	2025-07-03 03:15:39
WHPanel2.aspx.cs	text/plain	8.52 KB	0/0	0666	2025-07-03 03:15:39
WHPanel3.aspx	text/html	533.71 KB	0/0	0666	2025-07-03 03:15:40
WHPanel3.aspx.cs	text/plain	7.12 KB	0/0	0666	2025-07-03 03:15:40
WarhouseMaster.aspx	text/html	10.86 KB	0/0	0666	2025-07-03 03:15:38
WarhouseMaster.aspx.cs	text/plain	6.07 KB	0/0	0666	2025-07-03 03:15:38
Web.config	text/xml	2.13 KB	0/0	0666	2025-07-03 03:15:38
allocate_material.aspx	text/html	11.35 KB	0/0	0666	2025-07-03 03:15:11
allocate_material.aspx.cs	text/plain	10.2 KB	0/0	0666	2025-07-03 03:15:11
favicon.ico	image/vnd.microsoft.icon	1.12 KB	0/0	0666	2025-07-03 03:15:18
warhouseLocation.aspx	text/html	95.63 KB	0/0	0666	2025-07-03 03:15:37
warhouseLocation.aspx.cs	text/plain	17.51 KB	0/0	0666	2025-07-03 03:15:37
whrack.aspx	text/html	278.7 KB	0/0	0666	2025-07-03 03:15:41
whrack.aspx.cs	text/plain	93.49 KB	0/0	0666	2025-07-03 03:15:41

Team Anon Force

https://t.me/Professor6T9x