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; } } }