public GuResult <string> DeleteContacts(MCrmContacts Obj, string user, string flag)
{
GuResult <string> ret = new GuResult <string>();
StringBuilder sb = new StringBuilder();
IDbCommand cmd1 = null;
sb.Append("UPDATE CRM_CONTACTS SET CONTACT_ST = 'I',MODIFYUSER = :USER, MODIFYDATE = :MDATE,PROGRAMCODE = :PROGRAMCODE WHERE CONTACT_ID = :CONID");
try
{
Database database = CRM_Controller.GetDB();
using (IDbConnection conn = database.CreateOpenConnection())
{
cmd1.Connection = conn;
cmd1.CommandText = sb.ToString();
cmd1.Parameters.Clear();
}
}
catch (Exception ex)
{
ret.result = null;
ret.IsComplete = false;
ret.MsgText = ex.Message;
throw ex;
}
return(ret);
}
public GuResult <string> SaveContacts(MCrmContacts Obj, string user, string flag)
{
GuResult <string> ret = new GuResult <string>();
if (flag == "N")
{
InsertContacts(Obj, user, ref ret);
}
else
{
UpdateContacts(Obj, user, ref ret);
}
return(ret);
}
private void InsertContacts(MCrmContacts Obj, string user, ref GuResult <string> ret)
{
StringBuilder sb = new StringBuilder();
sb.Append("select SEQ_CRM_CONTACTS.nextval from dual");
IDbCommand cmd1 = null;
IDbCommand cmd2 = null;
IDbCommand cmd3 = null;
IDbCommand cmd4 = null;
IDbCommand cmd5 = null;
IDbCommand cmd6 = null;
IDbCommand cmdSeq = null;
IDbTransaction trn = null;
try
{
Database database = CRM_Controller.GetDB();
using (IDbConnection conn = database.CreateOpenConnection())
{
trn = conn.BeginTransaction();
//Get Seq. for CONTACT_ID
cmdSeq = conn.CreateCommand();
cmdSeq.CommandText = sb.ToString();
object tmp = cmdSeq.ExecuteScalar();
if (!(tmp is DBNull))
{
int id;
id = Convert.ToInt32(tmp);
Obj.ContactId = id;
}
//Get Seq. for CONTACT_ID
//Insert CRM_CONTACTS
Obj.Createuser = user;
Obj.Createdate = DateTime.Now;
cmd1 = Obj.InsertCommand(conn);
cmd1.Transaction = trn;
cmd1.ExecuteNonQuery();
//Insert CRM_CONTACTS_Ani
if (Obj.ConAnniversarylst != null && Obj.ConAnniversarylst.Count > 0)
{
foreach (CrmContactsAnniversary a in Obj.ConAnniversarylst)
{
a.ContactId = Obj.ContactId;
a.Createuser = user;
a.Createdate = DateTime.Now;
cmd2 = a.InsertCommand(conn);
cmd2.Transaction = trn;
cmd2.ExecuteNonQuery();
}
}
//Insert CRM_CONTACTS_Link
if (Obj.ConLinklst != null && Obj.ConLinklst.Count > 0)
{
foreach (CrmContactsLink b in Obj.ConLinklst)
{
b.ContactId = Obj.ContactId;
b.Createuser = user;
b.Createdate = DateTime.Now;
cmd3 = b.InsertCommand(conn);
cmd3.Transaction = trn;
cmd3.ExecuteNonQuery();
}
}
//Insert CRM_CONTACTS_Relate
if (Obj.ConRelatelst != null && Obj.ConRelatelst.Count > 0)
{
foreach (CrmContactsRelative c in Obj.ConRelatelst)
{
c.ContactId = Obj.ContactId;
c.Createuser = user;
c.Createdate = DateTime.Now;
cmd4 = c.InsertCommand(conn);
cmd4.Transaction = trn;
cmd4.ExecuteNonQuery();
}
}
//Insert CRM_CONTACTS_Social
if (Obj.ConSociallst != null && Obj.ConSociallst.Count > 0)
{
foreach (CrmContactsSocial d in Obj.ConSociallst)
{
d.ContactId = Obj.ContactId;
d.Createuser = user;
d.Createdate = DateTime.Now;
cmd5 = d.InsertCommand(conn);
cmd5.Transaction = trn;
cmd5.ExecuteNonQuery();
}
}
//Insert CRM_CONTACTS Visibility
if (Obj.ConVisiblelst != null && Obj.ConVisiblelst.Count > 0)
{
foreach (CrmContactsVisibility e in Obj.ConVisiblelst)
{
e.ContactId = Obj.ContactId;
e.Createuser = user;
e.Createdate = DateTime.Now;
cmd6 = e.InsertCommand(conn);
cmd6.Transaction = trn;
cmd6.ExecuteNonQuery();
}
}
trn.Commit();
cmd1.Dispose();
cmd2.Dispose();
cmd3.Dispose();
cmd4.Dispose();
cmd5.Dispose();
cmd6.Dispose();
conn.Close();
ret.result = CRMMessageEnum.MessageEnum.MessageDataResponse.SaveCompleted.ToString();
}
}
catch (Exception ex)
{
if (trn != null)
{
trn.Rollback();
}
ret.result = null;
ret.IsComplete = false;
ret.MsgText = ex.Message;
throw ex;
}
}
private void UpdateContacts(MCrmContacts Obj, string user, ref GuResult <string> ret)
{
StringBuilder sb = new StringBuilder();
sb.Append("select SEQ_CRM_CONTACTS.nextval from dual");
IDbCommand cmd1 = null;
IDbCommand cmd2 = null;
IDbCommand cmd3 = null;
IDbCommand cmd4 = null;
IDbCommand cmd5 = null;
IDbCommand cmd6 = null;
IDbTransaction trn = null;
try
{
Database database = CRM_Controller.GetDB();
using (IDbConnection conn = database.CreateOpenConnection())
{
trn = conn.BeginTransaction();
//Update CRM_CONTACTS
Obj.Modifyuser = user;
Obj.Modifydate = DateTime.Now;
cmd1 = Obj.UpdateCommand(conn, "Createuser,Createdate");
cmd1.Transaction = trn;
cmd1.ExecuteNonQuery();
//Update CRM_CONTACTS_Ani
if (Obj.ConAnniversarylst != null && Obj.ConAnniversarylst.Count > 0)
{
foreach (CrmContactsAnniversary a in Obj.ConAnniversarylst)
{
if (a.EntityState == SsCommon.EntityStateLocal.Added)
{
a.Createuser = user;
a.Createdate = DateTime.Now;
cmd2 = a.InsertCommand(conn);
}
else if (a.EntityState == SsCommon.EntityStateLocal.Modified)
{
a.Modifyuser = user;
a.Modifydate = DateTime.Now;
cmd2 = a.UpdateCommand(conn, "Createuser,Createdate");
}
cmd2.Transaction = trn;
cmd2.ExecuteNonQuery();
}
}
//Insert CRM_CONTACTS_Link
if (Obj.ConLinklst != null && Obj.ConLinklst.Count > 0)
{
foreach (CrmContactsLink b in Obj.ConLinklst)
{
if (b.EntityState == SsCommon.EntityStateLocal.Added)
{
b.Createuser = user;
b.Createdate = DateTime.Now;
cmd3 = b.InsertCommand(conn);
}
else if (b.EntityState == SsCommon.EntityStateLocal.Modified)
{
b.Modifyuser = user;
b.Modifydate = DateTime.Now;
cmd3 = b.UpdateCommand(conn, "Createuser,Createdate");
}
cmd3.Transaction = trn;
cmd3.ExecuteNonQuery();
}
}
//Insert CRM_CONTACTS_Relate
if (Obj.ConRelatelst != null && Obj.ConRelatelst.Count > 0)
{
foreach (CrmContactsRelative c in Obj.ConRelatelst)
{
if (c.EntityState == SsCommon.EntityStateLocal.Added)
{
c.Createuser = user;
c.Createdate = DateTime.Now;
cmd4 = c.InsertCommand(conn);
}
else if (c.EntityState == SsCommon.EntityStateLocal.Modified)
{
c.Modifyuser = user;
c.Modifydate = DateTime.Now;
cmd4 = c.UpdateCommand(conn, "Createuser,Createdate");
}
cmd4.Transaction = trn;
cmd4.ExecuteNonQuery();
}
}
//Insert CRM_CONTACTS_Social
if (Obj.ConSociallst != null && Obj.ConSociallst.Count > 0)
{
foreach (CrmContactsSocial d in Obj.ConSociallst)
{
if (d.EntityState == SsCommon.EntityStateLocal.Added)
{
d.Createuser = user;
d.Createdate = DateTime.Now;
cmd5 = d.InsertCommand(conn);
}
else if (d.EntityState == SsCommon.EntityStateLocal.Modified)
{
d.Modifyuser = user;
d.Modifydate = DateTime.Now;
cmd5 = d.UpdateCommand(conn, "Createuser,Createdate");
}
cmd5.Transaction = trn;
cmd5.ExecuteNonQuery();
}
}
//Insert CRM_CONTACTS Visibility
if (Obj.ConVisiblelst != null && Obj.ConVisiblelst.Count > 0)
{
foreach (CrmContactsVisibility e in Obj.ConVisiblelst)
{
if (e.EntityState == SsCommon.EntityStateLocal.Added)
{
e.Createuser = user;
e.Createdate = DateTime.Now;
cmd6 = e.InsertCommand(conn);
}
else if (e.EntityState == SsCommon.EntityStateLocal.Modified)
{
e.Modifyuser = user;
e.Modifydate = DateTime.Now;
cmd6 = e.UpdateCommand(conn, "Createuser,Createdate");
}
cmd6.Transaction = trn;
cmd6.ExecuteNonQuery();
}
}
trn.Commit();
cmd1.Dispose();
cmd2.Dispose();
cmd3.Dispose();
cmd4.Dispose();
cmd5.Dispose();
cmd6.Dispose();
conn.Close();
ret.result = CRMMessageEnum.MessageEnum.MessageDataResponse.SaveCompleted.ToString();
}
}
catch (Exception ex)
{
if (trn != null)
{
trn.Rollback();
}
ret.result = null;
ret.IsComplete = false;
ret.MsgText = ex.Message;
throw ex;
}
}
