public async Task <bool> UpdateData(string id, standardtbl obj) { try { if (id != obj.stdId.ToString()) { return(false); } using (var context = new smlpobDB()) { context.standardtbls.Attach(obj); context.Entry(obj).Property(x => x.stdNo).IsModified = true; context.Entry(obj).Property(x => x.comodityNo).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() { int id = 0; int.TryParse(TxtStdId.Text, out id); var data = new standardtbl { stdId = id, stdNo = TxtStdNo.Text, comodityNo = ParseInt(TxtComodityNo.SelectedValue), modBy = currentUser, modDate = DatetimeHelper.GetDatetimeNow() }; if (TxtComodityNo.SelectedValue == "-1") { data.comodityNo = null; } var ret = standardControl.UpdateData(id.ToString(), data); if (ret.Result) { ClearFields(); SetLayout(ModeForm.ViewData); Alert("Data berhasil diubah"); } else { Alert("Gagal mengubah data"); } }
private void DoSave() { var data = new standardtbl { stdNo = TxtStdNo.Text, comodityNo = ParseInt(TxtComodityNo.SelectedValue), creaBy = currentUser, creaDate = DatetimeHelper.GetDatetimeNow() }; if (TxtComodityNo.SelectedValue == "-1") { data.comodityNo = null; } var ret = standardControl.AddData(data); if (ret.Result) { ClearFields(); SetLayout(ModeForm.ViewData); Alert("data berhasil disimpan"); } else { Alert("Gagal menyimpan data"); } }
public async Task <bool> AddData(standardtbl obj) { try { using (var context = new smlpobDB()) { context.standardtbls.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); }
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.standardtbls where x.stdId == IDS select x).FirstOrDefault(); NewItem.modBy = User.Identity.Name; NewItem.modDate = DateTime.Now; NewItem.stdNo = TxtStandardNo.Text; NewItem.comodityNo = Convert.ToInt32(DDComodity.SelectedValue); } else //add new { var NewItem = new standardtbl() { }; NewItem.creaBy = "test"; NewItem.creaDate = DateTime.Now; NewItem.stdNo = TxtStandardNo.Text; NewItem.comodityNo = Convert.ToInt32(DDComodity.SelectedValue); context.standardtbls.Add(NewItem); } context.SaveChanges(); PanelGrid.Visible = true; PanelInput.Visible = false; RefreshGrid(); } catch (Exception ex) { TxtStatus.Text = "gagal save --> " + ex.Message; } }