public bool RemoveDataProyek(int id)
{
methodName = "RemoveDataProyek";
traceID = 1;
using (var uow = new UnitOfWork(AppConfig.Current.ContextName))
{
using (var trans = uow.BeginTransaction())
{
try
{
traceID = 2;
DataProyek oDBDataProyek = uow.DataProyek.SingleOrDefault(m => m.Id == id);
if (oDBDataProyek != null)
{
traceID = 3;
uow.DataProyek.Remove(id);
uow.Save();
}
traceID = 5;
trans.Commit();
}
catch (Exception ex)
{
trans.Rollback();
throw new AppException(500, methodName, traceID, ex);
}
}
}
return(true);
}
private DataProyek GetData()
{
DataProyek oData = new DataProyek();
oData.NomorProyek = txtProjectno.Text;
oData.NamaProyek = txtProjectName.Text;
oData.NilaiProyek = double.Parse(txtContractPrice.Text);
oData.TanggalMulai = DateTime.Parse(DpStartDate.Text);
oData.TanggalBerakhir = DateTime.Parse(DpEndDate.Text);
if (this.CustomerSelected != null)
{
oData.IdKontakPemesan = this.CustomerSelected.IdKontak;
oData.PemesanKontak = this.CustomerSelected.NamaA;
}
if (this.PICSelected != null)
{
oData.IdKontakPIC = this.PICSelected.IdKontak;
oData.PICKontak = this.PICSelected.NamaA;
}
if (this.MataUangSelected != null)
{
oData.IdMataUang = this.MataUangSelected.IdDataMataUang;
oData.MataUang = this.MataUangSelected.NamaMataUang;
}
oData.idStatus = this.Status.Value;
oData.Status = this.Status.Text;
oData.Keterangan = txtRemarks.Text;
oData.CheckboxInAtive = ChkInactive.IsChecked;
if (this.ProjectForm.DataProyekSelected != null)
{
oData.Id = this.ProjectForm.DataProyekSelected.Id;
}
return(oData);
}
public bool EditDataProyek(DataProyek oData)
{
methodName = "EditDataProyek";
traceID = 1;
using (var uow = new UnitOfWork(AppConfig.Current.ContextName))
{
traceID = 2;
var oDBData = uow.DataProyek.Get(oData.Id);
if (oDBData != null)
{
using (var trans = uow.BeginTransaction())
{
try
{
traceID = 3;
oDBData.MapFrom(oData);
uow.DataProyek.Update(oDBData);
uow.Save();
traceID = 4;
trans.Commit();
}
catch (Exception ex)
{
trans.Rollback();
throw new AppException(500, methodName, traceID, ex);
}
}
}
}
return(true);
}
public int AddDataProyek(DataProyek oData)
{
methodName = "AddDataProyek";
traceID = 1;
using (var uow = new UnitOfWork(AppConfig.Current.ContextName))
{
using (var trans = uow.BeginTransaction())
{
try
{
traceID = 2;
DataProyek oNewDataProyek = new DataProyek();
oNewDataProyek.MapFrom(oData);
oNewDataProyek = uow.DataProyek.Add(oNewDataProyek);
uow.Save();
traceID = 3;
oData.Id = oNewDataProyek.Id;
trans.Commit();
}
catch (Exception ex)
{
trans.Rollback();
throw new AppException(500, methodName, traceID, ex);
}
}
}
return(oData.Id);
}
private void LIProject_SelectionChanged(object sender, SelectionChangedEventArgs e)
{
this.ClearForm();
if (LIProject.SelectedItem != null)
{
this.DataProyekSelected = (DataProyek)LIProject.SelectedItem;
if (this.DataProyekSelected != null)
{
txtProjectNo.Text = this.DataProyekSelected.NomorProyek;
txtProjectName.Text = this.DataProyekSelected.NamaProyek;
txtCustomer.Text = this.DataProyekSelected.PemesanKontak;
txtPIC.Text = this.DataProyekSelected.PICKontak;
txtCurrency.Text = this.DataProyekSelected.MataUang;
txtContractprice.Text = this.DataProyekSelected.NilaiProyek.ToString();
txtStartProject.Text = this.DataProyekSelected.TanggalMulai.ToString();
txtEndProject.Text = this.DataProyekSelected.TanggalBerakhir.ToString();
txtStatus.Text = this.DataProyekSelected.Status;
txtRemarks.Text = this.DataProyekSelected.Keterangan;
using (var uow = new UnitOfWork(AppConfig.Current.ContextName))
{
var teams = uow.Kontak.Find(m => m.TypeKontak.ToLower() == "employee" && m.IdProyek == this.DataProyekSelected.Id).ToList();
DGTeam.ItemsSource = teams;
}
}
}
}
private void proyek_selectionchange(object sender, SelectionChangedEventArgs e)
{
this.dataProyekSelected = null;
if (cbProyek.SelectedItem != null)
{
dataProyekSelected = (DataProyek)cbProyek.SelectedItem;
}
}
private void cbproyek_SelectionChanged(object sender, SelectionChangedEventArgs e)
{
this.dataProyekSelected = null;
if (cbproject.SelectedItem != null)
{
this.dataProyekSelected = (DataProyek)cbproject.SelectedItem;
}
}
private void ClearForm()
{
this.DataProyekSelected = null;
txtProjectNo.Text = "";
txtProjectName.Text = "";
txtCustomer.Text = "";
txtPIC.Text = "";
txtCurrency.Text = "";
txtContractprice.Text = "";
txtStartProject.Text = "";
txtEndProject.Text = "";
txtStatus.Text = "";
txtRemarks.Text = "";
}
private void Delete_Click(object sender, RoutedEventArgs e)
{
if (this.DataProyekSelected == null)
{
MessageBox.Show("Project not selected !");
}
else
{
DataProyekBLL DataProyekBLL = new DataProyekBLL();
this.DataProyekSelected.CheckboxInAtive = true;
if (DataProyekBLL.EditDataProyek(this.DataProyekSelected) == true)
{
MessageBox.Show("Project successfully deleted");
this.LoadDataProyek("");
this.DataProyekSelected = null;
}
}
}