private Guid Create(GiangVien item)
{
GiangVienDAL itemDAL=new GiangVienDAL();
item.GiangVienGuid = Guid.NewGuid();
int rowsAffected = itemDAL.Create(item);
return rowsAffected > 0 ? item.GiangVienGuid : Guid.Empty;
}
/// <summary>
/// Inserts a row in the gv_GiangVien table. Returns rows affected count.
/// </summary>
/// <returns>int</returns>
public int Create(GiangVien item)
{
SqlParameterHelper sph = new SqlParameterHelper(ConnectionStringStatic.GetWriteConnectionString(), "gv_GiangVien_Insert", 3);
sph.DefineSqlParameter("@GiangVienGuid", SqlDbType.UniqueIdentifier, ParameterDirection.Input, item.GiangVienGuid);
sph.DefineSqlParameter("@GiangvienName", SqlDbType.NVarChar, 256, ParameterDirection.Input, item.GiangvienName);
sph.DefineSqlParameter("@GiangVienID", SqlDbType.NVarChar, 256, ParameterDirection.Input, item.GiangVienID);
int rowsAffected = sph.ExecuteNonQuery();
return rowsAffected;
}
public static GiangVien PopulateFromReader(IDataReader reader)
{
GiangVien item = new GiangVien();
if(reader.Read())
{
try{item.GiangVienGuid = new Guid(reader["GiangVienGuid"].ToString());}catch{}
item.GiangvienName = reader["GiangvienName"].ToString();
item.GiangVienID = reader["GiangVienID"].ToString();
}
return item;
}
public static List<GiangVien> LoadListFromReader(IDataReader reader)
{
List<GiangVien> items = new List<GiangVien>();
try
{
while (reader.Read())
{
GiangVien item = new GiangVien();
try{item.GiangVienGuid = new Guid(reader["GiangVienGuid"].ToString());}catch{}
item.GiangvienName = reader["GiangvienName"].ToString();
item.GiangVienID = reader["GiangVienID"].ToString();
items.Add(item);
}
}
catch
{}
finally
{
reader.Close();
}
return items;
}
private Guid Update(GiangVien item)
{
GiangVienDAL itemDAL=new GiangVienDAL();
return itemDAL.Update(item) ? item.GiangVienGuid : Guid.Empty;
}
// <summary>
/// Saves this instance of GiangVien. Returns a new Guid on success.
/// </summary>
public Guid Save(GiangVien item)
{
if (item.GiangVienGuid == Guid.Empty)
return Create(item);
return Update(item);
}