private void btnSave_Click(object sender, EventArgs e)
{
try
{
txtID.Text = txtID.Text.ToUpper();
if (ValidData())
{
switch (vAction)
{
case action.Insert:
var obj = new LObjectType();
obj.SName = Utility.sDbnull(txtName.Text);
obj.SDesc = Utility.sDbnull(txtDesc.Text);
obj.IsNew = true;
obj.Save();
drList = dtList.NewRow();
drList[LObjectType.Columns.Id] =
LObjectType.CreateQuery().GetMax(LObjectType.Columns.Id);
ApplyData2Datarow();
dtList.Rows.InsertAt(drList, 0);
dtList.AcceptChanges();
txtID.Text = Utility.sDbnull(drList[LObjectType.Columns.Id]);
vAction = action.Update;
break;
case action.Update:
new Update(LObjectType.Schema.Name).Set(LObjectType.Columns.SName).EqualTo(txtName.Text).
Set(LObjectType.Columns.SDesc).EqualTo(txtDesc.Text).
Where(LObjectType.Columns.Id).IsEqualTo(Utility.Int32Dbnull(txtID.Text)).
Execute();
ApplyData2Datarow();
drList.AcceptChanges();
break;
}
}
}
catch (Exception ex)
{
Utility.ShowMsg(ex.Message);
}
}
private void btnSave_Click(object sender, EventArgs e)
{
try
{
txtID.Text = txtID.Text.ToUpper();
if (ValidData())
switch (vAction)
{
case action.Insert:
var obj = new LObjectType();
obj.SName = Utility.sDbnull(txtName.Text);
obj.SDesc = Utility.sDbnull(txtDesc.Text);
obj.IsNew = true;
obj.Save();
drList = dtList.NewRow();
drList[LObjectType.Columns.Id] =
LObjectType.CreateQuery().GetMax(LObjectType.Columns.Id);
ApplyData2Datarow();
dtList.Rows.InsertAt(drList, 0);
dtList.AcceptChanges();
txtID.Text = Utility.sDbnull(drList[LObjectType.Columns.Id]);
vAction = action.Update;
break;
case action.Update:
new Update(LObjectType.Schema.Name).Set(LObjectType.Columns.SName).EqualTo(txtName.Text).
Set(LObjectType.Columns.SDesc).EqualTo(txtDesc.Text).
Where(LObjectType.Columns.Id).IsEqualTo(Utility.Int32Dbnull(txtID.Text)).
Execute();
ApplyData2Datarow();
drList.AcceptChanges();
break;
}
}
catch (Exception ex)
{
Utility.ShowMsg(ex.Message);
}
}
public void Insert(string SName,string SDesc)
{
LObjectType item = new LObjectType();
item.SName = SName;
item.SDesc = SDesc;
item.Save(UserName);
}
public void Update(short Id,string SName,string SDesc)
{
LObjectType item = new LObjectType();
item.MarkOld();
item.IsLoaded = true;
item.Id = Id;
item.SName = SName;
item.SDesc = SDesc;
item.Save(UserName);
}
