protected void GridViewPengajaran_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
using (var context = new akademik_dbEntities())
{
var kode_pengajaranBeingUpdate = Convert.ToInt32(e.Keys[0]);
var NamaMatakuliah2 = (from o in context.pengajarans where o.kode_pengajaran == kode_pengajaranBeingUpdate select o).FirstOrDefault();
try
{
//MENGUBAH FIELD NAMA_KULIAH
if (String.IsNullOrWhiteSpace(NamaMatakuliahTextBox.Text) == false)
{
if (NamaMatakuliah2 == null)
{
context.matakuliahs.Add(new DAL.matakuliah
{
kode_matakuliah = NamaMatakuliah2.kode_matakuliah,
kode_program = null,
nama_matakuliah = NamaMatakuliahTextBox.Text,
sks = 0,
semester = 0
});
}
else
{
var NamaMatakuliah3 = (from n in context.matakuliahs where n.kode_matakuliah == NamaMatakuliah2.kode_matakuliah select n).FirstOrDefault();
NamaMatakuliah3.nama_matakuliah = NamaMatakuliahTextBox.Text;
}
}
else
{
if (NamaMatakuliah2 != null)
{
context.pengajarans.Remove(NamaMatakuliah2);
}
}
context.SaveChanges();
}
catch (Exception)
{
e.Cancel = true;
ErrorMsgLabel.Visible = true;
ErrorMsgLabel.Text = "Update failed.";
}
}
}
protected void Login_Click(object sender, EventArgs e)
{
akademik_dbEntities db = new akademik_dbEntities();
String username = UserName.Text;
String password = Password.Text;
string query = (from u in db.users
where u.username == username && u.password == password
select u.username).FirstOrDefault();
if (query != null)
{
this.Session["username"] = username;
Response.Redirect("Mahasiswa.aspx");
}
else
{
Response.Write("Invalid User");
}
}
protected void EntityDataSourceCari_ContextCreating(object sender, EntityDataSourceContextCreatingEventArgs e)
{
var db = new akademik_dbEntities();
e.Context = (db as IObjectContextAdapter).ObjectContext;
}
