public void CreateContact()
{
var contact = new PermitLandlordContact()
{
ROWID = _landlordID,
CONTACT_ACTIVE = true,
};
_db.PermitLandlordContacts.Add(contact);
_db.SaveChanges();
NewlyInsertedContactID = contact.CONTACT_ID;
}
private string GetFullName(PermitLandlordContact contact)
{
string s1 = "";
string s2 = "";
string s3 = "";
if (MyString.IsStringLengthLongerThan(1, contact.CONTACT_HONORIFIC))
{
s1 = contact.CONTACT_HONORIFIC + " ";
}
if (MyString.IsStringLengthLongerThan(1, contact.CONTACT_FIRST_NAME))
{
s2 = contact.CONTACT_FIRST_NAME + " ";
}
if (MyString.IsStringLengthLongerThan(1, contact.CONTACT_LAST_NAME))
{
s3 = contact.CONTACT_LAST_NAME;
}
return(s1 + s2 + s3);
}
private void HandleLandlord(string sfLandlordID, string addr, string city, string state, string zipCode, string landlordContactName, string phone, string landlordName)
{
try
{
int landlordID = CommonMethods.GetMISID(TableName.PermitLandlord, sfLandlordID, salesForceProjectID);
if (landlordID == 0)
{
// insert to PermitLandlord
PermitLandlord pl = new PermitLandlord();
pl.NAME = landlordName;
pl.ADDR_1 = addr;
pl.CITY = city;
pl.STATE = state;
pl.ZIPCODE = zipCode;
pl.Active = true;
_db.PermitLandlords.Add(pl);
_db.SaveChanges();
int id = SqlCommon.GetNewlyInsertedRecordID(TableName.PermitLandlord);
landlordID = id;
if (id > 0)
{
CommonMethods.InsertToMISSalesForceMapping(TableName.PermitLandlord, sfLandlordID, id.ToString(), salesForceProjectID);
}
}
else
{
var item = _db.PermitLandlords.Where(x => x.ROWID == landlordID).FirstOrDefault();
if (item != null)
{
item.NAME = landlordName;
item.ADDR_1 = addr;
item.CITY = city;
item.STATE = state;
item.ZIPCODE = zipCode;
_db.Entry(item).State = EntityState.Modified;
_db.SaveChanges();
}
}
/* landlord contact */
int landlordContactID = CommonMethods.GetMISID(TableName.PermitLandlordContact, sfLandlordID, salesForceProjectID);
if (landlordContactID == 0)
{
/* add landloard contact */
PermitLandlordContact plc = new PermitLandlordContact();
plc.ROWID = landlordID;
plc.CONTACT_FIRST_NAME = landlordContactName;
plc.CONTACT_PHONE = phone;
_db.PermitLandlordContacts.Add(plc);
_db.SaveChanges();
int id = SqlCommon.GetNewlyInsertedRecordID(TableName.PermitLandlordContact);
if (id > 0)
{
CommonMethods.InsertToMISSalesForceMapping(TableName.PermitLandlordContact, sfLandlordID, id.ToString(), salesForceProjectID);
}
}
else
{
var item = _db.PermitLandlordContacts.Where(x => x.CONTACT_ID == landlordContactID).FirstOrDefault();
if (item != null)
{
item.CONTACT_FIRST_NAME = landlordContactName;
item.CONTACT_PHONE = phone;
_db.Entry(item).State = EntityState.Modified;
_db.SaveChanges();
}
}
}
catch (Exception e)
{
LogMethods.Log.Error("HandleLandLord:Error:" + e.Message);
}
}
