private void btnSave_Click(object sender, EventArgs e) { try { txtID.Text = txtID.Text.ToUpper().Replace(" ", ""); txtName.Text = txtName.Text.Trim(); LAssemblyReport obj; if (ValidData()) { if (txtID.Enabled) { obj = new LAssemblyReport(); obj.AssemblyReportId = Utility.sDbnull(txtID.Text); obj.ReportName = Utility.sDbnull(txtName.Text); obj.SDLLname = Utility.sDbnull(txtDll.Text); obj.SAssemblyName = Utility.sDbnull(cboASM.SelectedValue); obj.Desc = Utility.sDbnull(txtDesc.Text); obj.IsNew = true; obj.Save(); obj = LAssemblyReport.FetchByID(Utility.sDbnull(txtID.Text)); if (obj != null) { DataRow newDr = dtList.NewRow(); Utility.FromObjectToDatarow(obj, ref newDr); dtList.Rows.Add(newDr); txtID.Enabled = false; } } else { new Update(LAssemblyReport.Schema.Name).Set(LAssemblyReport.Columns.ReportName).EqualTo(txtName.Text). Set(LAssemblyReport.Columns.Desc).EqualTo(txtDesc.Text). Set(LAssemblyReport.Columns.SAssemblyName).EqualTo(Utility.sDbnull(cboASM.SelectedValue)). Set(LAssemblyReport.Columns.SDLLname).EqualTo(txtDll.Text). Where(LAssemblyReport.Columns.AssemblyReportId).IsEqualTo(Utility.sDbnull(txtID.Text)). Execute(); obj = LAssemblyReport.FetchByID(Utility.sDbnull(txtID.Text)); if (obj != null) { DataRow newDr = Utility.GetDataRow(dtList, LAssemblyReport.Columns.AssemblyReportId, Utility.sDbnull(txtID.Text)); Utility.FromObjectToDatarow(obj, ref newDr); newDr.AcceptChanges(); } } } } catch (Exception ex) { Utility.ShowMsg(ex.Message); } }
private void LoadData() { LAssemblyReport objManufacture = LAssemblyReport.FetchByID(txtID.Text); if (objManufacture != null) { txtName.Text = Utility.sDbnull(objManufacture.ReportName); txtDll.Text = Utility.sDbnull(objManufacture.SDLLname); LoadCrptListToComboBox(txtDll.Text); cboASM.SelectedValue = Utility.sDbnull(objManufacture.SAssemblyName); txtDesc.Text = Utility.sDbnull(objManufacture.Desc); txtID.Enabled = false; } }
private void btnSave_Click(object sender, EventArgs e) { try { txtID.Text = txtID.Text.ToUpper().Replace(" ", ""); txtName.Text = txtName.Text.Trim(); LAssemblyReport obj; if (ValidData()) if (txtID.Enabled) { obj = new LAssemblyReport(); obj.AssemblyReportId = Utility.sDbnull(txtID.Text); obj.ReportName = Utility.sDbnull(txtName.Text); obj.SDLLname = Utility.sDbnull(txtDll.Text); obj.SAssemblyName = Utility.sDbnull(cboASM.SelectedValue); obj.Desc = Utility.sDbnull(txtDesc.Text); obj.IsNew = true; obj.Save(); obj = LAssemblyReport.FetchByID(Utility.sDbnull(txtID.Text)); if (obj != null) { DataRow newDr = dtList.NewRow(); Utility.FromObjectToDatarow(obj, ref newDr); dtList.Rows.Add(newDr); txtID.Enabled = false; } } else { new Update(LAssemblyReport.Schema.Name).Set(LAssemblyReport.Columns.ReportName).EqualTo(txtName.Text). Set(LAssemblyReport.Columns.Desc).EqualTo(txtDesc.Text). Set(LAssemblyReport.Columns.SAssemblyName).EqualTo(Utility.sDbnull(cboASM.SelectedValue)). Set(LAssemblyReport.Columns.SDLLname).EqualTo(txtDll.Text). Where(LAssemblyReport.Columns.AssemblyReportId).IsEqualTo(Utility.sDbnull(txtID.Text)). Execute(); obj = LAssemblyReport.FetchByID(Utility.sDbnull(txtID.Text)); if(obj!=null) { DataRow newDr = Utility.GetDataRow(dtList, LAssemblyReport.Columns.AssemblyReportId, Utility.sDbnull(txtID.Text)); Utility.FromObjectToDatarow(obj, ref newDr); newDr.AcceptChanges(); } } } catch (Exception ex) { Utility.ShowMsg(ex.Message); } }
public void Insert(string AssemblyReportId,string ReportName,string SDLLname,string SAssemblyName,string Desc) { LAssemblyReport item = new LAssemblyReport(); item.AssemblyReportId = AssemblyReportId; item.ReportName = ReportName; item.SDLLname = SDLLname; item.SAssemblyName = SAssemblyName; item.Desc = Desc; item.Save(UserName); }
public void Update(string AssemblyReportId,string ReportName,string SDLLname,string SAssemblyName,string Desc) { LAssemblyReport item = new LAssemblyReport(); item.MarkOld(); item.IsLoaded = true; item.AssemblyReportId = AssemblyReportId; item.ReportName = ReportName; item.SDLLname = SDLLname; item.SAssemblyName = SAssemblyName; item.Desc = Desc; item.Save(UserName); }