public Users GetMapper(SqlDataReader reader)
{
Users UsersObj = new Users();
if (reader["user_id"] != DBNull.Value) { UsersObj.UserId= (int)reader["user_id"]; }
if (reader["first_name"] != DBNull.Value) { UsersObj.FirstName = (string)reader["first_name"]; }
if (reader["last_name"] != DBNull.Value) { UsersObj.LastName = (string)reader["last_name"]; }
if (reader["email"] != DBNull.Value) { UsersObj.Email = (string)reader["email"]; }
if (reader["password"] != DBNull.Value) { UsersObj.Password = (string)reader["password"]; }
if (reader["experience"] != DBNull.Value) { UsersObj.Experience = (string)reader["experience"]; }
if (reader["postion"] != DBNull.Value) { UsersObj.Postion = (int)reader["postion"]; }
if (reader["postion_name"] != DBNull.Value) { UsersObj.PostionName = (string)reader["postion_name"]; }
if (reader["skills"] != DBNull.Value) { UsersObj.Skills = (int)reader["skills"]; }
if (reader["skills_name"] != DBNull.Value) { UsersObj.SkillsName = (string)reader["skills_name"]; }
if (reader["education"] != DBNull.Value) { UsersObj.Education = (string)reader["education"]; }
if (reader["note"] != DBNull.Value) { UsersObj.Note = (string)reader["note"]; }
if (reader["location"] != DBNull.Value) { UsersObj.Location = (string)reader["location"]; }
if (reader["image_name"] != DBNull.Value) { UsersObj.ImageName = (string)reader["image_name"]; }
if (reader["active_status"] != DBNull.Value) { UsersObj.ActiveStatus = (bool)reader["active_status"]; }
if (reader["role_id"] != DBNull.Value) { UsersObj.RoleId = (int)reader["role_id"]; }
if (reader["role_name"] != DBNull.Value) { UsersObj.RoleName = (string)reader["role_name"]; }
if (reader["created_by"] != DBNull.Value) { UsersObj.CreatedBy = (int)reader["created_by"]; }
if (reader["created_date"] != DBNull.Value) { UsersObj.CreatedDate = (DateTime)reader["created_date"]; }
if (reader["updated_by"] != DBNull.Value) { UsersObj.UpdatedBy = (int)reader["updated_by"]; }
if (reader["updated_date"] != DBNull.Value) { UsersObj.UpdatedDate = (DateTime)reader["updated_date"]; }
if (reader["flag_deleted"] != DBNull.Value) { UsersObj.FlagDeleted = (bool)reader["flag_deleted"]; }
if (reader["is_system"] != DBNull.Value) { UsersObj.IsSystem = (bool)reader["is_system"]; }
return UsersObj;
}
public void Add(Users users)
{
SqlConnection conn = sqlHelper.GetConnection(false);
sqlHelper.AddOutParameter("@user_id", SqlDbType.Int);
sqlHelper.AddInParameter("@first_name", SqlDbType.NVarChar, users.FirstName);
sqlHelper.AddInParameter("@last_name", SqlDbType.NVarChar, users.LastName);
sqlHelper.AddInParameter("@email", SqlDbType.NVarChar,users.Email);
sqlHelper.AddInParameter("@password", SqlDbType.NVarChar, users.Password);
sqlHelper.AddInParameter("@experience", SqlDbType.NVarChar,users.Experience);
sqlHelper.AddInParameter("@postion", SqlDbType.Int, users.Postion);
sqlHelper.AddInParameter("@skills", SqlDbType.Int,users.Skills);
sqlHelper.AddInParameter("@education", SqlDbType.NVarChar, users.Education);
sqlHelper.AddInParameter("@note", SqlDbType.NVarChar, users.Note);
sqlHelper.AddInParameter("@location", SqlDbType.NVarChar, users.Location);
sqlHelper.AddInParameter("@image_name", SqlDbType.NVarChar, users.ImageName);
sqlHelper.AddInParameter("@active_status", SqlDbType.Bit, users.ActiveStatus);
sqlHelper.AddInParameter("@role_id", SqlDbType.Int, users.RoleId);
sqlHelper.AddInParameter("@created_by", SqlDbType.Int, users.CreatedBy);
sqlHelper.ExecuteNonQuery("dbo.SP_User_Add", conn, false);
users.UserId = Convert.ToInt32( sqlHelper.GetOutParameterValue("@user_id"));
}