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; }