public async Task <bool> UpdateData(string id, elementservicestbl obj) { try { if (id != obj.elementCode) { return(false); } using (var context = new smlpobDB()) { context.elementservicestbls.Attach(obj); context.Entry(obj).Property(x => x.analysisTypeName).IsModified = true; context.Entry(obj).Property(x => x.serviceGroup).IsModified = true; context.Entry(obj).Property(x => x.serviceRate).IsModified = true; context.Entry(obj).Property(x => x.serviceStatus).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 DoUpdate() { string id = TxtElementCode.Text; var data = new elementservicestbl { elementCode = TxtElementCode.Text, analysisTypeName = TxtAnalysisTypeName.SelectedValue, serviceGroup = TxtServiceGroup.Text ?? "", serviceRate = Formater.ToNumber(TxtServiceRate.Text), serviceStatus = TxtServiceStatus.SelectedValue, modBy = currentUser, modDate = DatetimeHelper.GetDatetimeNow() }; var ret = elementServicesControl.UpdateData(id, data); if (ret.Result) { ClearFields(); SetLayout(ModeForm.ViewData); Alert("Data berhasil diubah"); } else { Alert("Gagal mengubah data"); } }
private void DoSave() { var data = new elementservicestbl { elementCode = TxtElementCode.Text, analysisTypeName = TxtAnalysisTypeName.SelectedValue, serviceGroup = TxtServiceGroup.Text ?? "", serviceRate = Formater.ToNumber(TxtServiceRate.Text), serviceStatus = TxtServiceStatus.SelectedValue, creaBy = currentUser, creaDate = DatetimeHelper.GetDatetimeNow() }; var ret = elementServicesControl.AddData(data); if (ret.Result) { ClearFields(); SetLayout(ModeForm.ViewData); Alert("data berhasil disimpan"); } else { Alert("Gagal menyimpan data"); } }
private void BtnSubmit_Click(object sender, EventArgs e) { try { //update if (!string.IsNullOrEmpty(TxtElementCode.Text)) { var IDS = TxtElementCode.Text; var NewItem = (from x in context.elementservicestbls where x.elementCode == IDS select x).FirstOrDefault(); NewItem.modBy = User.Identity.Name; NewItem.modDate = DateTime.Now; NewItem.elementCode = TxtElementCode.Text; NewItem.analysisTypeName = AnaylysisName.SelectedValue; NewItem.serviceGroup = TxtServiceGroup.Text; NewItem.serviceRate = Convert.ToInt32(TxtServiceRate.Text); NewItem.serviceStatus = TxtServiceStatus.Text; } else //add new { var NewItem = new elementservicestbl() { }; NewItem.creaBy = "test"; NewItem.creaDate = DateTime.Now; NewItem.elementCode = TxtElementCode.Text; NewItem.analysisTypeName = AnaylysisName.SelectedValue; NewItem.serviceGroup = TxtServiceGroup.Text; NewItem.serviceRate = Convert.ToInt32(TxtServiceRate.Text); NewItem.serviceStatus = TxtServiceStatus.Text; context.elementservicestbls.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(elementservicestbl obj) { try { using (var context = new smlpobDB()) { context.elementservicestbls.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); }