Professor6T9 Web SheLL

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

MeasuringUnitControl.ascx.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 MyControls_MeasuringUnitControl : System.Web.UI.UserControl
{
    #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)
        {
            BindGVMeasuringUnit();
        }
    }

private void BindGVMeasuringUnit()
    {
        SqlParameter[] arrparm = new SqlParameter[1];
        arrparm[0] = new SqlParameter("@Action", "SELECT");
        DataSet DSRecord = SqlHelper.ExecuteDataset(Connection.connect(), CommandType.StoredProcedure, "SP_MeasuringUnit_CRUD", arrparm);
        if (DSRecord.Tables[0].Rows.Count > 0)
        {
            GVMeasuringUnit.DataSource = DSRecord.Tables[0];
            GVMeasuringUnit.DataBind();
        }
        else
        {
            GVMeasuringUnit.EmptyDataText = "No Record Found !";
            GVMeasuringUnit.DataBind();
        }
        foreach (GridViewRow Row in GVMeasuringUnit.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;
            }
        }
    }

protected void BtnAddNewClick(object sender, EventArgs e)
    {
        MVMeasuringUnit.ActiveViewIndex = 1;
    }

protected void BtnSubmitCancel(object sender, EventArgs e)
    {
        if (sender == btnSubmit)
        {
            string ImagePath = GetImagePath(FULogo);

if (btnSubmit.Text == "Submit")
            {
                SqlParameter[] arrParam = new SqlParameter[4];
                arrParam[0] = new SqlParameter("@Action", "INSERT");
                arrParam[1] = new SqlParameter("@Image", ImagePath);
                arrParam[2] = new SqlParameter("@Name", TBName.Text);
                arrParam[3] = new SqlParameter("@DisplayIndex", TBDisplayIndex.Text);

int result = SqlHelper.ExecuteNonQuery(Connection.connect(), CommandType.StoredProcedure, "SP_MeasuringUnit_CRUD", arrParam);
                if (result > 0)
                    ShowMessage("Added Suceess", MessageType.Success);
                else
                    ShowMessage("Some Technical Error Occur!!!", MessageType.Error);
                ClearForm();
                MVMeasuringUnit.ActiveViewIndex = 0;
                BindGVMeasuringUnit();
            }
            else if (btnSubmit.Text == "Update")
            {
                SqlParameter[] arrParam = new SqlParameter[5];
                arrParam[0] = new SqlParameter("@Action", "UPDATE");
                arrParam[1] = new SqlParameter("@Image", ImagePath);
                arrParam[2] = new SqlParameter("@Name", TBName.Text);
                arrParam[3] = new SqlParameter("@DisplayIndex", TBDisplayIndex.Text);
                arrParam[4] = new SqlParameter("@ID", Session["RecordId"]);

int result = SqlHelper.ExecuteNonQuery(Connection.connect(), CommandType.StoredProcedure, "SP_MeasuringUnit_CRUD", arrParam);

if (result > 0)
                    ShowMessage("Updated Successfully", MessageType.Success);
                else
                    ShowMessage("Error", MessageType.Error);

ClearForm();
                MVMeasuringUnit.ActiveViewIndex = 0;
                BindGVMeasuringUnit();
                btnSubmit.Text = "Submit";
            }
        }

else if (sender == btnCancel)
        {
            ClearForm();
            MVMeasuringUnit.ActiveViewIndex = 0;
            BindGVMeasuringUnit();
        }
    }

private string GetImagePath(FileUpload FULogo)
    {
        string ImagePath = "";
        if (FULogo.HasFile)
        {
            string NameImage = DateTime.Now.Millisecond + FULogo.FileName;
            FULogo.SaveAs(Server.MapPath("~/AdminImages/MeasuringUnit/" + NameImage));
            ImagePath = "~/AdminImages/MeasuringUnit/" + NameImage;
            return ImagePath;
        }
        if (ImgLogo.ImageUrl != "")
        {
            return ImgLogo.ImageUrl;
        }
        else
        {
            return ImagePath = "~/AdminImages/noimg.png";
        }
    }

private void ClearForm()
    {
        TBName.Text = string.Empty;
        TBDisplayIndex.Text = string.Empty;
    }

protected void GVMeasuringUnit_RowCommand(object sender, GridViewCommandEventArgs e)
    {
        try
        {
            int recordId = Convert.ToInt32(e.CommandArgument);
            Session["RecordId"] = recordId;

#region For Edit Record
            if (e.CommandName == "EditRecord")
            {
                SqlParameter[] arrParam = new SqlParameter[2];
                arrParam[0] = new SqlParameter("@Action", "SELECT_ByID");
                arrParam[1] = new SqlParameter("@ID", recordId);
                DataSet DSRecords = SqlHelper.ExecuteDataset(Connection.connect(), CommandType.StoredProcedure, "SP_MeasuringUnit_CRUD", arrParam);
                DataTable DTRecords = DSRecords.Tables[0];
                if (DTRecords.Rows.Count > 0)
                {
                    MVMeasuringUnit.ActiveViewIndex = 1;
                    TBName.Text = DTRecords.Rows[0]["Name"].ToString();
                    TBDisplayIndex.Text = DTRecords.Rows[0]["DisplayIndex"].ToString();
                    ImgLogo.ImageUrl = DTRecords.Rows[0]["Image"].ToString();
                    btnSubmit.Text = "Update";
                }
            }
            #endregion

#region For Delete Record
            if (e.CommandName == "DeleteRecord")
            {
                // Delete Image From Folder
                SqlParameter[] arrParamDel = new SqlParameter[2];
                arrParamDel[0] = new SqlParameter("@Action", "SELECT_ByID");
                arrParamDel[1] = new SqlParameter("@ID", recordId);
                DataSet DSRecords = SqlHelper.ExecuteDataset(Connection.connect(), CommandType.StoredProcedure, "SP_MeasuringUnit_CRUD", arrParamDel);
                if (DSRecords.Tables[0].Rows[0]["Image"].ToString() != "" && DSRecords.Tables[0].Rows[0]["Image"].ToString() != "~/AdminImages/noimg.png")
                {
                    File.Delete(Server.MapPath(DSRecords.Tables[0].Rows[0]["Image"].ToString()));
                }

SqlParameter[] arrParam = new SqlParameter[2];
                arrParam[0] = new SqlParameter("@Action", "DELETE");
                arrParam[1] = new SqlParameter("@ID", recordId);
                int Result = SqlHelper.ExecuteNonQuery(Connection.connect(), CommandType.StoredProcedure, "SP_MeasuringUnit_CRUD", arrParam);
            }
            #endregion

#region For Change Status
            if (e.CommandName == "ChangeStatus")
            {
                SqlParameter[] arrParam = new SqlParameter[2];
                arrParam[0] = new SqlParameter("@Action", "SELECT_ByID");
                arrParam[1] = new SqlParameter("@ID", recordId);
                DataSet DSRecords = SqlHelper.ExecuteDataset(Connection.connect(), CommandType.StoredProcedure, "SP_MeasuringUnit_CRUD", arrParam);
                DataTable DTRecords = DSRecords.Tables[0];
                if (DTRecords.Rows.Count > 0)
                {
                    #region Change Status True To False
                    if (DTRecords.Rows[0]["Status"].ToString() == "True")
                    {
                        SqlParameter[] arrParam2 = new SqlParameter[3];
                        arrParam2[0] = new SqlParameter("@Action", "UPDATE_Status");
                        arrParam2[1] = new SqlParameter("@Status", false);
                        arrParam2[2] = new SqlParameter("@ID", recordId);
                        int Result = SqlHelper.ExecuteNonQuery(Connection.connect(), CommandType.StoredProcedure, "SP_MeasuringUnit_CRUD", arrParam2);
                    }
                    #endregion

#region Change Status False TO True
                    if (DTRecords.Rows[0]["Status"].ToString() == "False")
                    {
                        SqlParameter[] arrParam2 = new SqlParameter[3];
                        arrParam2[0] = new SqlParameter("@Action", "UPDATE_Status");
                        arrParam2[1] = new SqlParameter("@Status", true);
                        arrParam2[2] = new SqlParameter("@ID", recordId);
                        int Result = SqlHelper.ExecuteNonQuery(Connection.connect(), CommandType.StoredProcedure, "SP_MeasuringUnit_CRUD", arrParam2);
                    }
                    #endregion
                }
            }
            #endregion

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

protected void GVMeasuringUnit_PageIndexChanging(object sender, GridViewPageEventArgs e)
    {
        GVMeasuringUnit.PageIndex = e.NewPageIndex;
        BindGVMeasuringUnit();
        GVMeasuringUnit.DataBind();
    }

protected void SearchCategoryEvent(object sender, EventArgs e)
    {
        SqlParameter[] arrParam = new SqlParameter[2];
        arrParam[0] = new SqlParameter("@Action", "SEARCH");
        arrParam[1] = new SqlParameter("@SearchText", TBSearch.Text);
        DataSet ds = SqlHelper.ExecuteDataset(Connection.connect(), CommandType.StoredProcedure, "SP_MeasuringUnit_CRUD", arrParam);
        if (ds.Tables[0].Rows.Count > 0)
        {
            GVMeasuringUnit.DataSource = ds.Tables[0];
            GVMeasuringUnit.DataBind();
        }
        else
        {
            GVMeasuringUnit.EmptyDataText = "No Record Found !!";
            GVMeasuringUnit.DataBind();
        }
    }

protected void ShowHideImageEvent(object sender, EventArgs e)
    {
        if (CBShowImage.Checked)
            GVMeasuringUnit.Columns[1].Visible = true;
        else
            GVMeasuringUnit.Columns[1].Visible = false;
    }

}

Name	Type	Size	Owner/Group	Permission	Last Modified	Actions
.	dir	-	0/0	0777	2025-07-30 01:35:33
..	dir	-	0/0	0777	2025-11-10 12:02:19
Agent.ascx	text/html	20.84 KB	0/0	0666	2025-07-30 01:35:27
Agent.ascx.cs	text/plain	35.5 KB	0/0	0666	2025-07-30 01:35:27
CourierCompany.ascx	text/html	9.19 KB	0/0	0666	2025-07-30 01:35:28
CourierCompany.ascx.cs	text/plain	10.89 KB	0/0	0666	2025-07-30 01:35:28
CustomerGroup.ascx	text/plain	5.9 KB	0/0	0666	2025-07-30 01:35:28
CustomerGroup.ascx.cs	text/plain	9.8 KB	0/0	0666	2025-07-30 01:35:28
DriverManager.ascx	text/html	9.17 KB	0/0	0666	2025-07-30 01:35:28
DriverManager.ascx.cs	text/plain	10.61 KB	0/0	0666	2025-07-30 01:35:28
EmployeeDepartment.ascx	text/plain	8.01 KB	0/0	0666	2025-07-30 01:35:29
EmployeeDepartment.ascx.cs	text/plain	11.56 KB	0/0	0666	2025-07-30 01:35:29
EmployeeDesignation.ascx	text/plain	8.14 KB	0/0	0666	2025-07-30 01:35:29
EmployeeDesignation.ascx.cs	text/plain	11.6 KB	0/0	0666	2025-07-30 01:35:29
EmployeeWorkShift.ascx	text/plain	10.92 KB	0/0	0666	2025-07-30 01:35:29
EmployeeWorkShift.ascx.cs	text/plain	10.7 KB	0/0	0666	2025-07-30 01:35:29
HSNMaster.ascx	text/plain	10.64 KB	0/0	0666	2025-07-30 01:35:30
HSNMaster.ascx.cs	text/plain	24.08 KB	0/0	0666	2025-07-30 01:35:30
ItemCategoryControl.ascx	text/plain	9 KB	0/0	0666	2025-07-30 01:35:30
ItemCategoryControl.ascx.cs	text/plain	11.78 KB	0/0	0666	2025-07-30 01:35:30
ItemManager.ascx	text/html	94.86 KB	0/0	0666	2025-07-30 01:35:30
ItemManager.ascx.cs	text/plain	82.22 KB	0/0	0666	2025-07-30 01:35:31
MeasuringUnitControl.ascx	text/html	8.18 KB	0/0	0666	2025-07-30 01:35:31
MeasuringUnitControl.ascx.cs	text/plain	10.88 KB	0/0	0666	2025-07-30 01:35:31
PaymentTerms.ascx	text/plain	5.46 KB	0/0	0666	2025-07-30 01:35:31
PaymentTerms.ascx.cs	text/plain	9.13 KB	0/0	0666	2025-07-30 01:35:31
SubCategory.ascx	text/plain	7.12 KB	0/0	0666	2025-07-30 01:35:32
SubCategory.ascx.cs	text/plain	12.37 KB	0/0	0666	2025-07-30 01:35:32
Supplier.ascx	text/html	25.12 KB	0/0	0666	2025-07-30 01:35:32
Supplier.ascx.cs	text/plain	36.01 KB	0/0	0666	2025-07-30 01:35:32
TaxControl.ascx	text/html	6.45 KB	0/0	0666	2025-07-30 01:35:32
TaxControl.ascx.cs	text/plain	8.71 KB	0/0	0666	2025-07-30 01:35:32
VehicleNoMaster.ascx	text/html	9.19 KB	0/0	0666	2025-07-30 01:35:32
VehicleNoMaster.ascx.cs	text/plain	10.7 KB	0/0	0666	2025-07-30 01:35:33
WebUserControl.ascx	text/html	1.06 KB	0/0	0666	2025-07-30 01:35:33
WebUserControl.ascx.cs	text/plain	1.06 KB	0/0	0666	2025-07-30 01:35:33
beech.prn	text/plain	958 B	0/0	0666	2025-07-30 01:35:28
price.prn	text/plain	640 B	0/0	0666	2025-07-30 01:35:31

Team Anon Force

https://t.me/Professor6T9x