public static List<MonHoc> LoadListFromReader(IDataReader reader) { List<MonHoc> items = new List<MonHoc>(); try { while (reader.Read()) { MonHoc item = new MonHoc(); try { item.MonHocGuid = new Guid(reader["MonHocGuid"].ToString()); } catch { } item.MonHocName = reader["MonHocName"].ToString(); item.MonHocID = reader["MonHocID"].ToString(); try { item.Userid = Convert.ToInt32(reader["Userid"].ToString()); } catch { } items.Add(item); } } catch { } finally { reader.Close(); } return items; }
/// <summary> /// Inserts a row in the gv_MonHoc table. Returns rows affected count. /// </summary> /// <returns>int</returns> public int Create(MonHoc item) { SqlParameterHelper sph = new SqlParameterHelper(ConnectionStringStatic.GetWriteConnectionString(), "gv_MonHoc_Chuongtv31072015_Insert", 5); sph.DefineSqlParameter("@MonHocGuid", SqlDbType.UniqueIdentifier, ParameterDirection.Input, item.MonHocGuid); sph.DefineSqlParameter("@MonHocName", SqlDbType.NVarChar, 256, ParameterDirection.Input, item.MonHocName); sph.DefineSqlParameter("@MonHocID", SqlDbType.NVarChar, 256, ParameterDirection.Input, item.MonHocID); sph.DefineSqlParameter("@Userid", SqlDbType.Int, ParameterDirection.Input, item.Userid); sph.DefineSqlParameter("@SoBuoiGiangDay", SqlDbType.Int, ParameterDirection.Input, item.SoBuoiGiangDay); int rowsAffected = sph.ExecuteNonQuery(); return rowsAffected; }
public ActionResult CreateChuongTrinhGiangDay(MonHoc item) { var flagCreate = false; if (item.MonHocGuid == null || item.MonHocGuid == Guid.Empty) { item.MonHocGuid = Guid.Empty; flagCreate = true; } Guid trangThai = itemBAL.Save(item); if (trangThai != Guid.Empty) if (flagCreate) return JavaScript("ClosePopupAndLoadDataChuong('#modalCreateMon','#thongtindanhsachmonhoc','Thực hiện thành công')"); else return JavaScript("ClosePopupAndLoadDataEditChuong('#modalEditMon','#thongtindanhsachmonhoc','Thực hiện thành công')"); return View(); }
public static MonHoc PopulateFromReader(IDataReader reader) { MonHoc item = new MonHoc(); if (reader.Read()) { try { item.MonHocGuid = new Guid(reader["MonHocGuid"].ToString()); } catch { } item.MonHocName = reader["MonHocName"].ToString(); item.MonHocID = reader["MonHocID"].ToString(); try { item.Userid = Convert.ToInt32(reader["Userid"].ToString()); } catch { } try { item.SoBuoiGiangDay = Convert.ToInt32(reader["SoBuoiGiangDay"].ToString()); } catch { } } return item; }
internal static List<MonHoc> LoadListFromReaderForList(IDataReader reader) { List<MonHoc> items = new List<MonHoc>(); try { while (reader.Read()) { MonHoc item = new MonHoc(); try { item.MonHocGuid = new Guid(reader["MonHocGuid"].ToString()); } catch { } item.MonHocName = reader["MonHocName"].ToString(); item.MonHocID = reader["MonHocID"].ToString(); try { item.Userid = Convert.ToInt32(reader["Userid"].ToString()); } catch { } try { item.BuoiGiangGuid = new Guid(reader["BuoiGiangGuid"].ToString()); } catch { } item.BuoiGiangID = reader["BuoiGiangID"].ToString(); item.BuoiGiangName = reader["BuoiGiangName"].ToString(); item.ClientFileName = reader["ClientFileName"].ToString(); item.ServerFileName = reader["ServerFileName"].ToString(); item.FileSize = reader["FileSize"].ToString(); try { item.FileSystemGuid = new Guid(reader["FileSystemGuid"].ToString()); } catch { } items.Add(item); } } catch { } finally { reader.Close(); } List<MonHoc> Returnitems = new List<MonHoc>(); int i = 0; bool flag = false; int count = items.Count; if (count > 0) { MonHoc m = new MonHoc(); BuoiGiangDay b; while (i < count) { if (flag == false) { m = new MonHoc(); m.MonHocGuid = items[i].MonHocGuid; m.MonHocName = items[i].MonHocName; m.MonHocID = items[i].MonHocID; m.DanhSachBuoiGiangDay = new List<BuoiGiangDay>(); b = new BuoiGiangDay(); b.BuoiGiangGuid = items[i].BuoiGiangGuid; b.BuoiGiangID = items[i].BuoiGiangID; b.BuoiGiangName = items[i].BuoiGiangName; b.ClientFileName = items[i].ClientFileName; b.ServerFileName = items[i].ServerFileName; b.FileSize = items[i].FileSize; b.FileSystemGuid = items[i].FileSystemGuid; m.DanhSachBuoiGiangDay.Add(b); i++; if (i >= count) { Returnitems.Add(m); break; } } if (items[i].MonHocGuid == items[i - 1].MonHocGuid) { b = new BuoiGiangDay(); b.BuoiGiangGuid = items[i].BuoiGiangGuid; b.BuoiGiangID = items[i].BuoiGiangID; b.BuoiGiangName = items[i].BuoiGiangName; b.ClientFileName = items[i].ClientFileName; b.ServerFileName = items[i].ServerFileName; b.FileSize = items[i].FileSize; b.FileSystemGuid = items[i].FileSystemGuid; m.DanhSachBuoiGiangDay.Add(b); flag = true; i++; if (i >= count) Returnitems.Add(m); } else { flag = false; } if (flag == false) Returnitems.Add(m); } } return Returnitems; }
private Guid Create(MonHoc item) { MonHocDAL itemDAL = new MonHocDAL(); item.MonHocGuid = Guid.NewGuid(); int rowsAffected = itemDAL.Create(item); return rowsAffected > 0 ? item.MonHocGuid : Guid.Empty; }
// <summary> /// Saves this instance of MonHoc. Returns a new Guid on success. /// </summary> public Guid Save(MonHoc item) { if (item.MonHocGuid == Guid.Empty) return Create(item); return Update(item); }
private Guid Update(MonHoc item) { MonHocDAL itemDAL = new MonHocDAL(); return itemDAL.Update(item) ? item.MonHocGuid : Guid.Empty; }
public ActionResult CreateMon_View(int? id) { MonHoc item = new MonHoc(); item.Userid = id == null ? 0 : Convert.ToInt32(id); return PartialView("_PartialThemMoiMonGiangDay", item); }