/// <summary>
/// Inserts a row in the gv_BuoiGiangDay table. Returns rows affected count.
/// </summary>
/// <returns>int</returns>
public int Create(BuoiGiangDay item)
{
SqlParameterHelper sph = new SqlParameterHelper(ConnectionStringStatic.GetWriteConnectionString(), "gv_BuoiGiangDay_Insert", 4);
sph.DefineSqlParameter("@BuoiGiangGuid", SqlDbType.UniqueIdentifier, ParameterDirection.Input, item.BuoiGiangGuid);
sph.DefineSqlParameter("@BuoiGiangID", SqlDbType.NVarChar, 256, ParameterDirection.Input, item.BuoiGiangID);
sph.DefineSqlParameter("@BuoiGiangName", SqlDbType.NVarChar, 256, ParameterDirection.Input, item.BuoiGiangName);
sph.DefineSqlParameter("@MonHocGuid", SqlDbType.UniqueIdentifier, ParameterDirection.Input, item.MonHocGuid);
int rowsAffected = sph.ExecuteNonQuery();
return rowsAffected;
}
public static BuoiGiangDay PopulateFromReader(IDataReader reader)
{
BuoiGiangDay item = new BuoiGiangDay();
if (reader.Read())
{
try { item.BuoiGiangGuid = new Guid(reader["BuoiGiangGuid"].ToString()); }
catch { }
item.BuoiGiangID = reader["BuoiGiangID"].ToString();
item.BuoiGiangName = reader["BuoiGiangName"].ToString();
try { item.MonHocGuid = new Guid(reader["MonHocGuid"].ToString()); }
catch { }
}
return item;
}
public static List<BuoiGiangDay> LoadListFromReader(IDataReader reader)
{
List<BuoiGiangDay> items = new List<BuoiGiangDay>();
try
{
while (reader.Read())
{
BuoiGiangDay item = new BuoiGiangDay();
try { item.BuoiGiangGuid = new Guid(reader["BuoiGiangGuid"].ToString()); }
catch { }
item.BuoiGiangID = reader["BuoiGiangID"].ToString();
item.BuoiGiangName = reader["BuoiGiangName"].ToString();
try
{
item.ClientFileName = reader["ClientFileName"].ToString();
}
catch
{
}
try {
item.MonHocGuid = new Guid(reader["MonHocGuid"].ToString());
}
catch { }
try
{
item.MonHocName = reader["MonHocName"].ToString();
}
catch { }
items.Add(item);
}
}
catch
{ }
finally
{
reader.Close();
}
return items;
}
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;
}
public ActionResult EditThongTinLienHe_view(string fileguid)
{
IBuoiGiangDayBAL buoigiangdayBAL = new BuoiGiangDayBAL();
try
{
//lay len cac mon hoc thay nay day
Guid fileguida = new Guid(fileguid);
BuoiGiangDay aaa=new BuoiGiangDay();
aaa.FileSystemGuid = fileguida;
IMonHocBAL mm = new MonHocBAL();
aaa.ListMonHoc = mm.GetAllMonHocTheoGiangVien(WebSecurity.CurrentUserId);
aaa.ListMonHoc.Insert(0, new MonHoc(Guid.Empty, "---Chọn môn học---"));
return PartialView("_PartialShare", aaa);
}
catch (Exception ex)
{
//LogError.SaveLogEvent("DoanhNghiep/EditThongTinLienHe", ex.Message);
return RedirectToAction("Index");
}
}
private Guid Update(BuoiGiangDay item)
{
BuoiGiangDayDAL itemDAL=new BuoiGiangDayDAL();
return itemDAL.Update(item) ? item.BuoiGiangGuid : Guid.Empty;
}
private Guid Create(BuoiGiangDay item)
{
BuoiGiangDayDAL itemDAL=new BuoiGiangDayDAL();
item.BuoiGiangGuid = Guid.NewGuid();
int rowsAffected = itemDAL.Create(item);
return rowsAffected > 0 ? item.BuoiGiangGuid : Guid.Empty;
}
// <summary>
/// Saves this instance of BuoiGiangDay. Returns a new Guid on success.
/// </summary>
public Guid Save(BuoiGiangDay item)
{
if (item.BuoiGiangGuid == Guid.Empty)
return Create(item);
return Update(item);
}
