private static KhoahocInfo CreateEntityFromReader(IDataReader reader)
{
var item = new KhoahocInfo();
try { if (!reader.IsDBNull(reader.GetOrdinal("Khoahoc_ID")))
{
item.Khoahoc_ID = ConvertUtility.ToInt32(reader["Khoahoc_ID"]);
}
}
catch { }
try { if (!reader.IsDBNull(reader.GetOrdinal("Content_ID")))
{
item.Content_ID = ConvertUtility.ToInt32(reader["Content_ID"]);
}
}
catch { }
try { if (!reader.IsDBNull(reader.GetOrdinal("Zone_ID")))
{
item.Zone_ID = ConvertUtility.ToInt32(reader["Zone_ID"]);
}
}
catch { }
try { if (!reader.IsDBNull(reader.GetOrdinal("Khoehoc_NoiDungHoc")))
{
item.Khoehoc_NoiDungHoc = ConvertUtility.ToString(reader["Khoehoc_NoiDungHoc"]);
}
}
catch { }
try { if (!reader.IsDBNull(reader.GetOrdinal("Khoahoc_DoTuoi")))
{
item.Khoahoc_DoTuoi = ConvertUtility.ToString(reader["Khoahoc_DoTuoi"]);
}
}
catch { }
try { if (!reader.IsDBNull(reader.GetOrdinal("Khoahoc_DoTuoiText")))
{
item.Khoahoc_DoTuoiText = ConvertUtility.ToString(reader["Khoahoc_DoTuoiText"]);
}
}
catch { }
try { if (!reader.IsDBNull(reader.GetOrdinal("Khoahoc_GioHoc")))
{
item.Khoahoc_GioHoc = ConvertUtility.ToString(reader["Khoahoc_GioHoc"]);
}
}
catch { }
try { if (!reader.IsDBNull(reader.GetOrdinal("Khoahoc_KhaiGiang")))
{
item.Khoahoc_KhaiGiang = ConvertUtility.ToString(reader["Khoahoc_KhaiGiang"]);
}
}
catch { }
try { if (!reader.IsDBNull(reader.GetOrdinal("Khoahoc_Avaiable")))
{
item.Khoahoc_Avaiable = ConvertUtility.ToBoolean(reader["Khoahoc_Avaiable"]);
}
}
catch { }
return(item);
}
public static int Insert(KhoahocInfo khoahocInfo)
{
var dbConn = new SqlConnection(AppEnv.ConnectionString);
var dbCmd = new SqlCommand("Solart_Khoahoc_Insert", dbConn)
{
CommandType = CommandType.StoredProcedure
};
dbCmd.Parameters.AddWithValue("@Content_ID", khoahocInfo.Content_ID);
dbCmd.Parameters.AddWithValue("@Zone_ID", khoahocInfo.Zone_ID);
dbCmd.Parameters.AddWithValue("@Khoehoc_NoiDungHoc", khoahocInfo.Khoehoc_NoiDungHoc);
dbCmd.Parameters.AddWithValue("@Khoahoc_DoTuoi", khoahocInfo.Khoahoc_DoTuoi);
dbCmd.Parameters.AddWithValue("@Khoahoc_DoTuoiText", khoahocInfo.Khoahoc_DoTuoiText);
dbCmd.Parameters.AddWithValue("@Khoahoc_GioHoc", khoahocInfo.Khoahoc_GioHoc);
dbCmd.Parameters.AddWithValue("@Khoahoc_KhaiGiang", khoahocInfo.Khoahoc_KhaiGiang);
dbCmd.Parameters.AddWithValue("@Khoahoc_Avaiable", khoahocInfo.Khoahoc_Avaiable);
dbCmd.Parameters.AddWithValue("@RETURN_VALUE", SqlDbType.Int).Direction = ParameterDirection.ReturnValue;
try
{
dbConn.Open();
dbCmd.ExecuteNonQuery();
return((int)dbCmd.Parameters["@RETURN_VALUE"].Value);
}
finally
{
dbConn.Close();
}
}
public static void Update(KhoahocInfo khoahocInfo)
{
var dbConn = new SqlConnection(AppEnv.ConnectionString);
var dbCmd = new SqlCommand("Solart_Khoahoc_Update", dbConn)
{
CommandType = CommandType.StoredProcedure
};
dbCmd.Parameters.AddWithValue("@Khoahoc_ID", khoahocInfo.Khoahoc_ID);
dbCmd.Parameters.AddWithValue("@Content_ID", khoahocInfo.Content_ID);
dbCmd.Parameters.AddWithValue("@Zone_ID", khoahocInfo.Zone_ID);
dbCmd.Parameters.AddWithValue("@Khoehoc_NoiDungHoc", khoahocInfo.Khoehoc_NoiDungHoc);
dbCmd.Parameters.AddWithValue("@Khoahoc_DoTuoi", khoahocInfo.Khoahoc_DoTuoi);
dbCmd.Parameters.AddWithValue("@Khoahoc_DoTuoiText", khoahocInfo.Khoahoc_DoTuoiText);
dbCmd.Parameters.AddWithValue("@Khoahoc_GioHoc", khoahocInfo.Khoahoc_GioHoc);
dbCmd.Parameters.AddWithValue("@Khoahoc_KhaiGiang", khoahocInfo.Khoahoc_KhaiGiang);
dbCmd.Parameters.AddWithValue("@Khoahoc_Avaiable", khoahocInfo.Khoahoc_Avaiable);
try
{
dbConn.Open();
dbCmd.ExecuteNonQuery();
}
finally
{
dbConn.Close();
}
}
public static KhoahocInfo GetInfo(int contentId)
{
KhoahocInfo retVal = null;
var dbConn = new SqlConnection(AppEnv.ConnectionString);
var dbCmd = new SqlCommand("Solart_Khoahoc_GetInfo", dbConn)
{
CommandType = CommandType.StoredProcedure
};
dbCmd.Parameters.AddWithValue("@Content_ID", contentId);
try
{
dbConn.Open();
var dr = dbCmd.ExecuteReader();
if (dr.Read())
{
retVal = new KhoahocInfo();
retVal.Khoahoc_ID = ConvertUtility.ToInt32(dr["Khoahoc_ID"]);
retVal.Content_ID = ConvertUtility.ToInt32(dr["Content_ID"]);
retVal.Zone_ID = ConvertUtility.ToInt32(dr["Zone_ID"]);
retVal.Khoehoc_NoiDungHoc = ConvertUtility.ToString(dr["Khoehoc_NoiDungHoc"]);
retVal.Khoahoc_DoTuoi = ConvertUtility.ToString(dr["Khoahoc_DoTuoi"]);
retVal.Khoahoc_DoTuoiText = ConvertUtility.ToString(dr["Khoahoc_DoTuoiText"]);
retVal.Khoahoc_GioHoc = ConvertUtility.ToString(dr["Khoahoc_GioHoc"]);
retVal.Khoahoc_KhaiGiang = ConvertUtility.ToString(dr["Khoahoc_KhaiGiang"]);
retVal.Khoahoc_Avaiable = ConvertUtility.ToBoolean(dr["Khoahoc_Avaiable"]);
}
if (dr != null)
{
dr.Close();
}
}
finally
{
dbConn.Close();
}
return(retVal);
}
protected void cmdUpdate_Click(object sender, EventArgs e)
{
var dtitems = KhoahocDB.GetContentCount(_contentid);
//try
//{
if (dtitems.Rows.Count > 0)
{
var info = KhoahocDB.GetInfo(_contentid);
var khoahocId = info.Khoahoc_ID;
info.Zone_ID = ConvertUtility.ToInt32(dropLopHoc.SelectedValue);
info.Khoehoc_NoiDungHoc = txtNoiDungHocText.Text;
//dotuoi
var zoneFocus = "|";
foreach (ListItem item in lstDoTuoi.Items)
{
if (item.Selected)
{
zoneFocus += item.Value + "|";
}
}
info.Khoahoc_DoTuoi = zoneFocus;
info.Khoahoc_DoTuoiText = txtDoTuoiText.Text;
info.Khoahoc_GioHoc = txtGioHoc.Text;
info.Khoahoc_KhaiGiang = txtKhaiGiang.Text;
info.Khoahoc_Avaiable = Convert.ToBoolean(chkVisible.Checked);
foreach (ListItem item in chklCoso.Items)
{
if (item.Selected)
{
KhoahocCosoDB.Remover(khoahocId, Convert.ToInt32(item.Value));
var khoahoccosoInfo = new KhoahocCosoInfo();
khoahoccosoInfo.Khoahoc_ID = khoahocId;
khoahoccosoInfo.Coso_ID = Convert.ToInt32(item.Value);
KhoahocCosoDB.Insert(khoahoccosoInfo);
lblStatusUpdate.Text += item.Text + ",<br>";
}
else
{
KhoahocCosoDB.Remover(khoahocId, Convert.ToInt32(item.Value));
}
}
foreach (ListItem item2 in chklMonHoc.Items)
{
if (item2.Selected)
{
KhoahocMonhocDB.Remover(khoahocId, Convert.ToInt32(item2.Value));
KhoahocMonhocDB.Insert(khoahocId, ConvertUtility.ToInt32(item2.Value));
}
else
{
KhoahocMonhocDB.Remover(khoahocId, Convert.ToInt32(item2.Value));
}
}
KhoahocDB.Update(info);
}
else
{
var info = new KhoahocInfo();
info.Content_ID = _contentid;
info.Zone_ID = ConvertUtility.ToInt32(dropLopHoc.SelectedValue);
info.Khoehoc_NoiDungHoc = txtNoiDungHocText.Text;
//dotuoi
var zoneFocus = "|";
foreach (ListItem item in lstDoTuoi.Items)
{
if (item.Selected)
{
zoneFocus += item.Value + "|";
}
}
info.Khoahoc_DoTuoi = zoneFocus;
info.Khoahoc_DoTuoiText = txtDoTuoiText.Text;
info.Khoahoc_GioHoc = txtGioHoc.Text;
info.Khoahoc_KhaiGiang = txtKhaiGiang.Text;
info.Khoahoc_Avaiable = Convert.ToBoolean(chkVisible.Checked);
var khoahocId = KhoahocDB.Insert(info);
foreach (ListItem item in chklCoso.Items)
{
if (item.Selected)
{
KhoahocCosoDB.Remover(khoahocId, Convert.ToInt32(item.Value));
var khoahoccosoInfo = new KhoahocCosoInfo();
khoahoccosoInfo.Khoahoc_ID = khoahocId;
khoahoccosoInfo.Coso_ID = Convert.ToInt32(item.Value);
KhoahocCosoDB.Insert(khoahoccosoInfo);
lblStatusUpdate.Text += item.Text + ",<br>";
}
else
{
KhoahocCosoDB.Remover(khoahocId, Convert.ToInt32(item.Value));
}
}
foreach (ListItem item2 in chklMonHoc.Items)
{
if (item2.Selected)
{
KhoahocMonhocDB.Remover(khoahocId, Convert.ToInt32(item2.Value));
KhoahocMonhocDB.Insert(khoahocId, ConvertUtility.ToInt32(item2.Value));
}
else
{
KhoahocMonhocDB.Remover(khoahocId, Convert.ToInt32(item2.Value));
}
}
}
//Response.Redirect(Request.RawUrl + "#idTab7");
lblSuccess.Visible = true;
lblStatusUpdate.Text = lblSuccess.Text = MiscUtility.UPDATE_SUCCESS;
//}
//catch
//{
// lblStatusUpdate.Text = MiscUtility.UPDATE_ERROR;
//}
}
