public List <Entites.Employee> SalryGrid(int EmpID) { try { using (SqlConnection con = new SqlConnection(HRMConString)) { con.Open(); using (SqlCommand cmd = new SqlCommand()) { cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "SPEmpID"; cmd.Connection = con; SqlParameter prm = new SqlParameter(); prm = cmd.Parameters.Add("@EmpID", SqlDbType.Int); prm.Direction = ParameterDirection.Input; prm.Value = EmpID; //forward onnly,read only online cursors SqlDataReader dr = cmd.ExecuteReader(); List <Entites.Employee> Salgrd = new List <Entites.Employee>(); while (dr.Read()) { Entites.Employee ES = new Entites.Employee(); ES.EmpFirstName = dr.GetString(0); ES.EmpLastName = dr.GetString(1); ES.DOJ = dr.GetDateTime(2); // ES.Cname = dr.GetString(2); ES.Gender = dr.GetString(3); ES.Address = dr.GetString(4); ES.City = dr.GetString(5); ES.State = dr.GetString(6); ES.Email = dr.GetString(7); Salgrd.Add(ES); } dr.Close(); con.Close(); con.Dispose(); //dis is jst below dataredr obj return(Salgrd); } } } catch { throw; } }
public List <Entites.Employee> RetriveEmpIDImage(int EmpID) { try { using (SqlConnection con = new SqlConnection(HRMConString)) { con.Open(); using (SqlCommand cmd = new SqlCommand()) { cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "RetriveImage"; cmd.Connection = con; SqlParameter prm = new SqlParameter(); prm = cmd.Parameters.Add("@Empid", SqlDbType.Int); prm.Direction = ParameterDirection.Input; prm.Value = EmpID; //forward onnly,read only online cursors SqlDataReader dr = cmd.ExecuteReader(); List <Entites.Employee> empidimage = new List <Entites.Employee>(); while (dr.Read()) { Entites.Employee Emp = new Entites.Employee(); Emp.EmpID = dr.GetInt32(0); Emp.Photo = ((byte[])dr["Photo"]); empidimage.Add(Emp); } dr.Close(); con.Close(); con.Dispose(); return(empidimage); } } } catch { throw; } }
public void AddEmployee(Entites.Employee emp) { try { using (SqlConnection con = new SqlConnection()) { con.ConnectionString = HRMConString; con.Open(); string str = "SPAddEmployee"; using (SqlCommand cmd = new SqlCommand()) { cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = str; cmd.Connection = con; SqlParameter sprm = new SqlParameter(); sprm = cmd.Parameters.Add("@empid", SqlDbType.Int); sprm.Direction = ParameterDirection.Input; sprm.Value = emp.EmpID; sprm = cmd.Parameters.Add("@efname", SqlDbType.NChar, 50); sprm.Direction = ParameterDirection.Input; sprm.Value = emp.EmpFirstName; sprm = cmd.Parameters.Add("@elname", SqlDbType.NChar, 50); sprm.Direction = ParameterDirection.Input; sprm.Value = emp.EmpLastName; sprm = cmd.Parameters.Add("@cname", SqlDbType.NChar, 50); sprm.Direction = ParameterDirection.Input; sprm.Value = emp.CompanyName; sprm = cmd.Parameters.Add("@doj", SqlDbType.DateTime); sprm.Direction = ParameterDirection.Input; sprm.Value = emp.DOJ; sprm = cmd.Parameters.Add("@dob", SqlDbType.DateTime); sprm.Direction = ParameterDirection.Input; sprm.Value = emp.DOB; sprm = cmd.Parameters.Add("@gen", SqlDbType.NChar, 10); sprm.Direction = ParameterDirection.Input; sprm.Value = emp.Gender; sprm = cmd.Parameters.Add("@addr", SqlDbType.NChar, 50); sprm.Direction = ParameterDirection.Input; sprm.Value = emp.Address; sprm = cmd.Parameters.Add("@city", SqlDbType.NChar, 50); sprm.Direction = ParameterDirection.Input; sprm.Value = emp.City; sprm = cmd.Parameters.Add("@state", SqlDbType.NChar, 50); sprm.Direction = ParameterDirection.Input; sprm.Value = emp.State; sprm = cmd.Parameters.Add("@phne", SqlDbType.Decimal); sprm.Direction = ParameterDirection.Input; sprm.Value = emp.Phone; sprm = cmd.Parameters.Add("@email", SqlDbType.NVarChar, 50); sprm.Direction = ParameterDirection.Input; sprm.Value = emp.Email; sprm = cmd.Parameters.Add("@phot", SqlDbType.Image); sprm.Direction = ParameterDirection.Input; sprm.Value = emp.Photo; sprm = cmd.Parameters.Add("@role", SqlDbType.Int); sprm.Direction = ParameterDirection.Input; sprm.Value = emp.RoleID; sprm = cmd.Parameters.Add("@pass", SqlDbType.NVarChar, 50); sprm.Direction = ParameterDirection.Input; sprm.Value = emp.Pass; cmd.ExecuteNonQuery(); } } } catch { throw; } }