public CRMSystem Save(CRMSystem entity)
{
if (this.dataCtx.Connection != null)
if (this.dataCtx.Connection.State == ConnectionState.Closed)
this.dataCtx.Connection.Open();
DbTransaction tran = this.dataCtx.Connection.BeginTransaction();
dataCtx.Transaction = tran;
try
{
var qry = from t in CRMSystems
where t.SYSID == entity.SYSID
select t;
var obj = qry.SingleOrDefault();
if (obj != null)
this.CopyEntity(obj, entity);
else
this.CRMSystems.InsertOnSubmit(entity);
this.dataCtx.SubmitChanges();
tran.Commit();
return entity;
}
catch (Exception ex)
{
tran.Rollback();
throw ex;
}
finally
{
dataCtx.Connection.Close();
}
}
public CRMSystem Save(CRMSystem entity)
{
if (this.dataCtx.Connection != null)
{
if (this.dataCtx.Connection.State == ConnectionState.Closed)
{
this.dataCtx.Connection.Open();
}
}
DbTransaction tran = this.dataCtx.Connection.BeginTransaction();
dataCtx.Transaction = tran;
try
{
var qry = from t in CRMSystems
where t.SYSID == entity.SYSID
select t;
var obj = qry.SingleOrDefault();
if (obj != null)
{
this.CopyEntity(obj, entity);
}
else
{
this.CRMSystems.InsertOnSubmit(entity);
}
this.dataCtx.SubmitChanges();
tran.Commit();
return(entity);
}
catch (Exception ex)
{
tran.Rollback();
throw ex;
}
finally
{
dataCtx.Connection.Close();
}
}
private CRMSystem GetSaveEntity()
{
var entity = new CRMSystem();
if (string.IsNullOrEmpty(txtSYSID.Text.Trim()) == false)
{
entity.SYSID = int.Parse(txtSYSID.Text.Trim());
}
if (string.IsNullOrEmpty(txtSYSName.Text.Trim()) == false)
{
entity.SYSName = txtSYSName.Text.Trim();
}
if (string.IsNullOrEmpty(txtSYSWeb.Text.Trim()) == false)
{
entity.SYSWeb = txtSYSWeb.Text.Trim();
}
if (string.IsNullOrEmpty(txtSYSContact.Text.Trim()) == false)
{
entity.SYSContact = txtSYSContact.Text.Trim();
}
if (string.IsNullOrEmpty(txtSYSContactTel.Text.Trim()) == false)
{
entity.SYSContactTel = txtSYSContactTel.Text.Trim();
}
if (string.IsNullOrEmpty(txtSYSCDate.Text.Trim()) == false)
{
entity.SYSCDate = DateTime.Parse(txtSYSCDate.Text.Trim());
}
if (string.IsNullOrEmpty(txtSYSBeginDate.Text.Trim()) == false)
{
entity.SYSBeginDate = DateTime.Parse(txtSYSBeginDate.Text.Trim());
}
if (string.IsNullOrEmpty(txtSYSExpiryDate.Text.Trim()) == false)
{
entity.SYSExpiryDate = DateTime.Parse(txtSYSExpiryDate.Text.Trim());
}
return(entity);
}
private CRMSystem GetSaveEntity()
{
var entity = new CRMSystem();
if (string.IsNullOrEmpty(txtSYSID.Text.Trim()) == false)
entity.SYSID = int.Parse(txtSYSID.Text.Trim());
if (string.IsNullOrEmpty(txtSYSName.Text.Trim()) == false)
entity.SYSName = txtSYSName.Text.Trim();
if (string.IsNullOrEmpty(txtSYSWeb.Text.Trim()) == false)
entity.SYSWeb = txtSYSWeb.Text.Trim();
if (string.IsNullOrEmpty(txtSYSContact.Text.Trim()) == false)
entity.SYSContact = txtSYSContact.Text.Trim();
if (string.IsNullOrEmpty(txtSYSContactTel.Text.Trim()) == false)
entity.SYSContactTel = txtSYSContactTel.Text.Trim();
if (string.IsNullOrEmpty(txtSYSCDate.Text.Trim()) == false)
entity.SYSCDate = DateTime.Parse(txtSYSCDate.Text.Trim());
if (string.IsNullOrEmpty(txtSYSBeginDate.Text.Trim()) == false)
entity.SYSBeginDate = DateTime.Parse(txtSYSBeginDate.Text.Trim());
if (string.IsNullOrEmpty(txtSYSExpiryDate.Text.Trim()) == false)
entity.SYSExpiryDate = DateTime.Parse(txtSYSExpiryDate.Text.Trim());
return entity;
}
