private void DoSave()
{
var data = new employeetbl
{
employeeName = TxtEmployeeName.Text,
position = TxtPosition.Text,
employeeEmail = TxtEmpEmail.Text,
derivativeToEmployee = ParseInt(TxtDerivativeEmp.SelectedValue),
creaBy = currentUser,
creaDate = DatetimeHelper.GetDatetimeNow()
};
if (TxtAccountNo.SelectedValue != "-1")
{
data.accountNo = ParseInt(TxtAccountNo.SelectedValue);
}
var ret = employeeControl.AddData(data);
if (ret.Result)
{
ClearFields();
SetLayout(ModeForm.ViewData);
Alert("data berhasil disimpan");
}
else
{
Alert("Gagal menyimpan data");
}
}
private void DoUpdate()
{
int id = ParseInt(TxtEmployeeNo.Text);
var data = new employeetbl
{
employeeNo = id,
employeeName = TxtEmployeeName.Text,
position = TxtPosition.Text,
employeeEmail = TxtEmpEmail.Text,
derivativeToEmployee = ParseInt(TxtDerivativeEmp.SelectedValue),
modBy = currentUser,
modDate = DatetimeHelper.GetDatetimeNow()
};
if (TxtAccountNo.SelectedValue != "-1")
{
data.accountNo = ParseInt(TxtAccountNo.SelectedValue);
}
var ret = employeeControl.UpdateData(id.ToString(), data);
if (ret.Result)
{
ClearFields();
SetLayout(ModeForm.ViewData);
Alert("Data berhasil diubah");
}
else
{
Alert("Gagal mengubah data");
}
}
public async Task <bool> UpdateData(string id, employeetbl obj)
{
try
{
if (id != obj.employeeNo.ToString())
{
return(false);
}
using (var context = new smlpobDB())
{
context.employeetbls.Attach(obj);
context.Entry(obj).Property(x => x.employeeName).IsModified = true;
context.Entry(obj).Property(x => x.position).IsModified = true;
context.Entry(obj).Property(x => x.employeeEmail).IsModified = true;
context.Entry(obj).Property(x => x.derivativeToEmployee).IsModified = true;
context.Entry(obj).Property(x => x.accountNo).IsModified = true;
context.Entry(obj).Property(x => x.modBy).IsModified = true;
context.Entry(obj).Property(x => x.modDate).IsModified = true;
await context.SaveChangesAsync();
return(true);
}
}
catch (Exception ex)
{
LogHelpers.source = this.GetType().Name;
LogHelpers.message = ex.Message;
LogHelpers.user = "";
LogHelpers.WriteLog();
}
return(false);
}
private void BtnSubmit_Click(object sender, EventArgs e)
{
try
{
//update
if (!string.IsNullOrEmpty(TxtID.Value))
{
var IDS = int.Parse(TxtID.Value);
var NewItem = (from x in context.employeetbls
where x.employeeNo == IDS
select x).FirstOrDefault();
NewItem.modBy = User.Identity.Name;
NewItem.modDate = DateTime.Now;
NewItem.employeeName = TxtEmployeeName.Text;
NewItem.position = TxtPosition.Text;
NewItem.employeeEmail = TxtEmpEmail.Text;
NewItem.derivativeToEmployee = Convert.ToInt32(Txtdvemp.Text);
NewItem.accountNo = Convert.ToInt32(TxtAccountNo.Text);
}
else //add new
{
var NewItem = new employeetbl()
{
};
NewItem.creaBy = "test";
NewItem.creaDate = DateTime.Now;
NewItem.employeeName = TxtEmployeeName.Text;
NewItem.position = TxtPosition.Text;
NewItem.employeeEmail = TxtEmpEmail.Text;
NewItem.derivativeToEmployee = Convert.ToInt32(Txtdvemp.Text);
NewItem.accountNo = Convert.ToInt32(TxtAccountNo.Text);
context.employeetbls.Add(NewItem);
}
context.SaveChanges();
PanelGrid.Visible = true;
PanelInput.Visible = false;
RefreshGrid();
}
catch (Exception ex)
{
TxtStatus.Text = "gagal save --> " + ex.Message;
}
}
public async Task <bool> AddData(employeetbl obj)
{
try
{
using (var context = new smlpobDB())
{
context.employeetbls.Add(obj);
await context.SaveChangesAsync();
return(true);
}
}
catch (Exception ex)
{
LogHelpers.source = this.GetType().Name;
LogHelpers.message = ex.Message;
LogHelpers.user = "";
LogHelpers.WriteLog();
}
return(false);
}
