public static IEnumerable<EmpState> GetList()
{
var dt = Db.Stuff.ExecuteQueryStoredProcedure("get_emp_state");
var lst = new List<EmpState>();
foreach (DataRow row in dt.Rows)
{
var empSt = new EmpState(row);
lst.Add(empSt);
}
return lst;
}
private void FillSelf(DataRow row)
{
Id = Db.DbHelper.GetValueInt(row["id"]);
AdSid = row.Table.Columns.Contains("ad_sid") ? row["ad_sid"].ToString() : String.Empty;
Manager = new Employee() { Id = row.Table.Columns.Contains("id_manager") ? Db.DbHelper.GetValueInt(row["id_manager"]) : 0, DisplayName = row.Table.Columns.Contains("manager") ? row["manager"].ToString() : String.Empty, Email = row.Table.Columns.Contains("manager_email") ? row["manager_email"].ToString() : String.Empty };
Surname = row.Table.Columns.Contains("surname") ? row["surname"].ToString() : String.Empty;
Name = row.Table.Columns.Contains("name") ? row["name"].ToString() : String.Empty;
Patronymic = row.Table.Columns.Contains("patronymic") ? row["patronymic"].ToString() : String.Empty;
FullName = row.Table.Columns.Contains("full_name") ? row["full_name"].ToString() : String.Empty;
DisplayName = row.Table.Columns.Contains("display_name") ? row["display_name"].ToString() : String.Empty;
Position = new Position() { Id = row.Table.Columns.Contains("id_position") ? Db.DbHelper.GetValueInt(row["id_position"]) : 0, Name = row.Table.Columns.Contains("position") ? row["position"].ToString() : String.Empty };
Organization = new Organization() { Id = row.Table.Columns.Contains("id_organization") ? Db.DbHelper.GetValueInt(row["id_organization"]) : 0, Name = row.Table.Columns.Contains("organization") ? row["organization"].ToString() : String.Empty };
Email = row.Table.Columns.Contains("email") ? row["email"].ToString() : String.Empty;
WorkNum = row.Table.Columns.Contains("work_num") ? row["work_num"].ToString() : String.Empty;
MobilNum = row.Table.Columns.Contains("mobil_num") ? row["mobil_num"].ToString() : String.Empty;
EmpState = new EmpState() { Id = row.Table.Columns.Contains("id_emp_state") ? Db.DbHelper.GetValueInt(row["id_emp_state"]) : 0, Name = row.Table.Columns.Contains("emp_state") ? row["emp_state"].ToString() : String.Empty };
Department = new Department() { Id = row.Table.Columns.Contains("id_department") ? Db.DbHelper.GetValueInt(row["id_department"]) : 0, Name = row.Table.Columns.Contains("department") ? row["department"].ToString() : String.Empty };
City = new City() { Id = row.Table.Columns.Contains("id_city") ? Db.DbHelper.GetValueInt(row["id_city"]) : 0, Name = row.Table.Columns.Contains("city") ? row["city"].ToString() : String.Empty };
DateCame = row.Table.Columns.Contains("date_came") ? Db.DbHelper.GetValueDateTimeOrNull(row["date_came"]) : new DateTime();
BirthDate = row.Table.Columns.Contains("birth_date") ? Db.DbHelper.GetValueDateTimeOrNull(row["birth_date"]) : new DateTime();
Photo = row.Table.Columns.Contains("photo") ? row["photo"] == DBNull.Value ? null : Db.DbHelper.GetByteArr(row["photo"]) : null;
IsChief = row.Table.Columns.Contains("is_chief") ? row["is_chief"].ToString().Equals("0") : false;
Male = row.Table.Columns.Contains("male") ? row["male"].ToString().Equals("1") : true;
PositionOrg = new Position() { Id = row.Table.Columns.Contains("id_position_org") ? Db.DbHelper.GetValueInt(row["id_position_org"]) : 0, Name = row.Table.Columns.Contains("position_org") ? row["position_org"].ToString() : String.Empty };
HasAdAccount = row.Table.Columns.Contains("has_ad_account") ? row["has_ad_account"].ToString().Equals("1") : false;
AdLogin = row.Table.Columns.Contains("ad_login") ? row["ad_login"].ToString() : String.Empty;
FullNameDat = row.Table.Columns.Contains("full_name_dat") ? row["full_name_dat"].ToString() : String.Empty;
FullNameRod = row.Table.Columns.Contains("full_name_rod") ? row["full_name_rod"].ToString() : String.Empty;
ShortNameDat = ShortName(FullNameDat);
ShortNameRod = ShortName(FullNameRod);
IsHidden = row.Table.Columns.Contains("is_hidden") && Db.DbHelper.GetValueBool(row["is_hidden"].ToString());
DateFired = Db.DbHelper.GetValueDateTimeOrNull(row, "date_fired");
IdBudget = Db.DbHelper.GetValueIntOrNull(row, "id_budget");
}
public EmpState Get(int id)
{
var model = new EmpState(id);
return model;
}
