internal static void UpdateEmployee(User employee) { try { SqlParameter[] MyParams = new SqlParameter[9]; MyParams[0] = new SqlParameter("@ID", employee.ID); MyParams[1] = new SqlParameter("@FirstName", employee.FirstName); MyParams[2] = new SqlParameter("@LastName", employee.LastName); MyParams[3] = new SqlParameter("@Gender", employee.Gender); MyParams[4] = new SqlParameter("@DOB", employee.DOB); MyParams[5] = new SqlParameter("@Language", employee.Language); MyParams[6] = new SqlParameter("@Nationality", employee.Nationality); MyParams[7] = new SqlParameter("@Address", employee.Address); MyParams[8] = new SqlParameter("@Mode", "UPDATE"); SqlHelper.ExecuteNonQuery(AppConstants.getConnectionString(), CommandType.StoredProcedure, "[dbo].[uspInsertUser]", MyParams); MessageBox.Show("Data Updated Successfully."); } catch (SqlException ex) { throw ex; } finally { } }
public static List <User> GetEmployeeFromDatabase() { try { DataTable dt = SqlHelper.ExecuteDataTable(AppConstants.getConnectionString(), CommandType.StoredProcedure, "[dbo].[uspGetUser]"); var Employee = new List <User>(); foreach (DataRow row in dt.Rows) { var obj = new User() { ID = (string)row["ID"], FirstName = (string)row["FirstName"], LastName = (string)row["LastName"], DOB = (string)row["DOB"], Gender = (string)row["Gender"], Nationality = (string)row["Nationality"], Language = ((string)row["Language"]), Address = (string)row["Address"], Male = (bool)row["Male"], Female = (bool)row["Female"], Hindi = (bool)row["Hindi"], English = (bool)row["English"], French = (bool)row["French"], }; Employee.Add(obj); } return(Employee); } catch (Exception ex) { throw ex; } }
internal static void DeleteEmployee(User employee) { try { SqlParameter[] MyParams = new SqlParameter[1]; MyParams[0] = new SqlParameter("@ID", employee.ID); SqlHelper.ExecuteNonQuery(AppConstants.getConnectionString(), CommandType.StoredProcedure, "[dbo].[uspDeletetUser]", MyParams); MessageBox.Show("Data Deleted Successfully."); } catch (SqlException ex) { throw ex; } finally { } }
public static List <NationalityCollection> GetNationality() { try { DataTable dt = SqlHelper.ExecuteDataTable(AppConstants.getConnectionString(), CommandType.StoredProcedure, "[dbo].[uspGetNationality]"); var NationalityList = new List <NationalityCollection>(); foreach (DataRow row in dt.Rows) { var obj = new NationalityCollection() { Nationality = (string)row["Nationality"] }; NationalityList.Add(obj); } return(NationalityList); // return dt; } catch (Exception ex) { throw ex; } }