classss

using System;
using System.Data;
using System.Configuration;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;
using System.Data.SqlClient;
using System.Collections.Generic;
using DBLibrary;

/// <summary>
/// Summary description for clsWorkerDetail
/// </summary>
public class clsWorkerDetail
{
    private string ConnStr;
    clsCommon clsObjCommon = new clsCommon();

    public clsWorkerDetail()
    {
        CnSettings clsObjSetting = new CnSettings();
        ConnStr = clsObjSetting.ConnectionStr;
    }
    public Int32 ID { get; set; }
    public String Name { get; set; }
    public String DOB { get; set; }
    public int AdminID { get; set; }
    public int WType { get; set; }
    public String Mobileno { get; set; }
    public String Address1 { get; set; }
    public String Address2 { get; set; }
    public String EmailID { get; set; }
    public String Refrence1 { get; set; }
    public String Refrence2 { get; set; }
    public String IdentificationMark { get; set; }
    public String TrainningDocument { get; set; }
    public String UplTrainning { get; set; }
    public String Image { get; set; }
    public String Experience { get; set; }
    public String IDproof { get; set; }
    public String PolVerificationDoc { get; set; }
    public String Remark { get; set; }
    public string WorkType { get; set; }
    public System.Collections.Generic.List<clsWorkerDetail> SaveDetail(Int16 ID, String Name, String DOB, String Mobileno, String Address1, String Address2, String EmailID, String Refrence1, String Refrence2, String IdentificationMark, String TrainningDocument, String Image, String Experience, String IDproof, String PolVerificationDoc, String Remark, int AdminID,int WType)
    {
        SqlDataReader sqlRdr = null;
        SqlParameter[] paramlist = new SqlParameter[19];
        System.Collections.Generic.List<clsWorkerDetail> lstDetail = new System.Collections.Generic.List<clsWorkerDetail>();
        paramlist[0] = new SqlParameter("@ID", ID);
        paramlist[1] = new SqlParameter("@Name", Name);
        paramlist[2] = new SqlParameter("@DOB", DOB);
        paramlist[3] = new SqlParameter("@Mobileno", Mobileno);
        paramlist[4] = new SqlParameter("@Address1", Address1);
        paramlist[5] = new SqlParameter("@Address2", Address2);
        paramlist[6] = new SqlParameter("@EmailID", EmailID);
        paramlist[7] = new SqlParameter("@Refrence1", Refrence1);
        paramlist[8] = new SqlParameter("@Refrence2", Refrence2);
        paramlist[9] = new SqlParameter("@IdentificationMark", IdentificationMark);
        paramlist[10] = new SqlParameter("@TrainningDocument", TrainningDocument);
        paramlist[11] = new SqlParameter("@Image", Image);
        paramlist[12] = new SqlParameter("@Experience", Experience);
        paramlist[13] = new SqlParameter("@IDproof", IDproof);
        paramlist[14] = new SqlParameter("@PolVerificationDoc", PolVerificationDoc);
        paramlist[15] = new SqlParameter("@Remark", Remark);
        paramlist[16] = new SqlParameter("@QueryType", "Insert");
        paramlist[17] = new SqlParameter("@AdminID", AdminID);
        paramlist[18] = new SqlParameter("@WType", WType);
        sqlRdr = SqlHelper.ExecuteReader(ConnStr, CommandType.StoredProcedure, "Proc_M_WorkerDetail", paramlist);
        while (sqlRdr.Read())
        {
            clsWorkerDetail obj = new clsWorkerDetail();
            obj.ID = Convert.ToInt16(sqlRdr["ID"]);
            obj.Name = sqlRdr["Name"].ToString();
            obj.DOB = sqlRdr["DOB"].ToString();
            obj.Mobileno = sqlRdr["Mobileno"].ToString();
            obj.Address1 = sqlRdr["Address1"].ToString();
            obj.Address2 = sqlRdr["Address2"].ToString();
            obj.EmailID = sqlRdr["EmailID"].ToString();
            obj.Refrence1 = sqlRdr["Refrence1"].ToString();
            obj.Refrence2 = sqlRdr["Refrence2"].ToString();
            obj.IdentificationMark = sqlRdr["IdentificationMark"].ToString();
            obj.TrainningDocument = sqlRdr["TrainningDocument"].ToString();
            obj.Image = sqlRdr["Image"].ToString();
            obj.Experience = sqlRdr["Experience"].ToString();
            obj.IDproof = sqlRdr["IDproof"].ToString();
            obj.PolVerificationDoc = sqlRdr["PolVerificationDoc"].ToString();
            obj.Remark = sqlRdr["Remark"].ToString();
            obj.AdminID =Convert.ToInt32(sqlRdr["AdminID"].ToString());
            obj.WType = Convert.ToInt32(sqlRdr["WType"].ToString());
            lstDetail.Add(obj);
        }
        return lstDetail;


       


    }
    public System.Collections.Generic.List<clsWorkerDetail> ReadALLDataByAdmin(int ID)
    {
        SqlDataReader sqlRdr = null;
        System.Collections.Generic.List<clsWorkerDetail> lstDetail = new System.Collections.Generic.List<clsWorkerDetail>();
        clsCommon objCommon = new clsCommon();
        try
        {
            SqlParameter[] paramList = new SqlParameter[2];
            paramList[0] = new SqlParameter("@QueryType", "ReadALLDataByAdmin");
            paramList[1] = new SqlParameter("@AdminID", ID);

            sqlRdr = SqlHelper.ExecuteReader(ConnStr, CommandType.StoredProcedure, "Proc_M_WorkerDetail", paramList);
            while (sqlRdr.Read())
            {
                clsWorkerDetail obj = new clsWorkerDetail();
                obj.ID = Convert.ToInt16(sqlRdr["ID"]);
                obj.Name = sqlRdr["Name"].ToString();
                obj.DOB = sqlRdr["DOB"].ToString();
                obj.Mobileno = sqlRdr["Mobileno"].ToString();
                obj.Address1 = sqlRdr["Address1"].ToString();
                obj.Address2 = sqlRdr["Address2"].ToString();
                obj.EmailID = sqlRdr["EmailID"].ToString();
                obj.Refrence1 = sqlRdr["Refrence1"].ToString();
                obj.Refrence2 = sqlRdr["Refrence2"].ToString();
               obj.IdentificationMark = sqlRdr["IdentificationMark"].ToString();
                obj.TrainningDocument = sqlRdr["TrainningDocument"].ToString();
                obj.Image = sqlRdr["Image"].ToString();
               obj.Experience = sqlRdr["Experience"].ToString();
               obj.IDproof = sqlRdr["IDproof"].ToString();
                obj.PolVerificationDoc = sqlRdr["PolVerificationDoc"].ToString();
                obj.Remark = sqlRdr["Remark"].ToString();
                obj.AdminID = Convert.ToInt32(sqlRdr["AdminID"].ToString());
                obj.WType = Convert.ToInt32(sqlRdr["WType"].ToString());
                lstDetail.Add(obj);
            }
            return lstDetail;
        }
        finally
        {
            if (sqlRdr != null)
                sqlRdr.Close();
        }
    }
    public System.Collections.Generic.List<clsWorkerDetail> WorkerByWorkType(Int32 WorkType)
    {
        SqlDataReader sqlRdr = null;
        System.Collections.Generic.List<clsWorkerDetail> lstDetail = new System.Collections.Generic.List<clsWorkerDetail>();
        clsCommon objCommon = new clsCommon();
        try
        {
            SqlParameter[] paramList = new SqlParameter[2];
            paramList[0] = new SqlParameter("@QueryType", "WorkerByWorkType");
            paramList[1] = new SqlParameter("@ID", WorkType);
            sqlRdr = SqlHelper.ExecuteReader(ConnStr, CommandType.StoredProcedure, "Proc_M_WorkerDetail", paramList);
            while (sqlRdr.Read())
            {
                clsWorkerDetail obj = new clsWorkerDetail();
                obj.ID = Convert.ToInt16(sqlRdr["ID"]);
                obj.Name = sqlRdr["Name"].ToString();
                obj.DOB = sqlRdr["DOB"].ToString();
                obj.Mobileno = sqlRdr["Mobileno"].ToString();
                obj.Address1 = sqlRdr["Address1"].ToString();
                obj.Address2 = sqlRdr["Address2"].ToString();
                obj.EmailID = sqlRdr["EmailID"].ToString();
                obj.Refrence1 = sqlRdr["Refrence1"].ToString();
                obj.Refrence2 = sqlRdr["Refrence2"].ToString();
               obj.IdentificationMark = sqlRdr["IdentificationMark"].ToString();
                obj.TrainningDocument = sqlRdr["TrainningDocument"].ToString();
                obj.Image = sqlRdr["Image"].ToString();
               obj.Experience = sqlRdr["Experience"].ToString();
               obj.IDproof = sqlRdr["IDproof"].ToString();
                obj.PolVerificationDoc = sqlRdr["PolVerificationDoc"].ToString();
                obj.Remark = sqlRdr["Remark"].ToString();
                obj.WorkType = sqlRdr["WorkType"].ToString();
                lstDetail.Add(obj);
            }
            return lstDetail;
        }
        finally
        {
            if (sqlRdr != null)
                sqlRdr.Close();
        }
    }  public List<string> ReadData(string SearchD)
    {
        SqlDataReader sqlRdr = null;
        List<string> lstresult = new List<string>();
        clsCommon objCommon = new clsCommon();
        try
        {
            SqlParameter[] paramList = new SqlParameter[2];
            paramList[0] = new SqlParameter("@QueryType", "ReadSearch");
            paramList[1] = new SqlParameter("@Name", SearchD);
            sqlRdr = SqlHelper.ExecuteReader(ConnStr, CommandType.StoredProcedure, "Proc_M_WorkerDetail", paramList);
            while (sqlRdr.Read())
            {
               // clsWorkerDetail obj = new clsWorkerDetail();
                //obj.Name = ;
                //obj.DOB = sqlRdr["DOB"].ToString();
                //obj.Mobileno = sqlRdr["Mobileno"].ToString();
                //obj.EmailID = sqlRdr["EmailID"].ToString();
                //obj.WorkType = sqlRdr["WorkType"].ToString();
                lstresult.Add(sqlRdr["Name"].ToString());
            }
            return lstresult;
        }
        finally
        {
            if (sqlRdr != null)
                sqlRdr.Close();
        }
    }
    public Boolean DeleteWorker(Int32 ID)
    {
        SqlParameter[] paramlist = new SqlParameter[2];
        paramlist[0] = new SqlParameter("@ID", ID);
        paramlist[1] = new SqlParameter("@QueryType", "DeleteAdmin");
        object obj = SqlHelper.ExecuteNonQuery(ConnStr, CommandType.StoredProcedure, "Proc_M_WorkerDetail", paramlist);
        if (obj != null)
            return true;
        return false;
    }
}