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