public ContactPreferenceModel GetContactPreferenceModelExistDB(ContactPreferenceModel contactPreferenceModel)
{
ContactPreferenceModel contactPreferenceModelRet = (from c in db.ContactPreferences
where c.ContactID == contactPreferenceModel.ContactID &&
c.TVType == (int)contactPreferenceModel.TVType
select new ContactPreferenceModel
{
Error = "",
ContactPreferenceID = c.ContactPreferenceID,
DBCommand = (DBCommandEnum)c.DBCommand,
ContactID = c.ContactID,
TVType = (TVTypeEnum)c.TVType,
MarkerSize = c.MarkerSize,
LastUpdateDate_UTC = c.LastUpdateDate_UTC,
LastUpdateContactTVItemID = c.LastUpdateContactTVItemID,
}).FirstOrDefault <ContactPreferenceModel>();
if (contactPreferenceModelRet == null)
{
return(ReturnError(string.Format(ServiceRes.CouldNotFind_With_Equal_, ServiceRes.ContactID,
ServiceRes.ContactID + "," +
ServiceRes.TVType,
contactPreferenceModel.ContactID.ToString() + "," +
contactPreferenceModel.TVType.ToString())));
}
return(contactPreferenceModelRet);
}
// Check
public string ContactPreferenceModelOK(ContactPreferenceModel contactPreferenceModel)
{
string retStr = FieldCheckNotZeroInt(contactPreferenceModel.ContactID, ServiceRes.ContactID);
if (!string.IsNullOrWhiteSpace(retStr))
{
return(retStr);
}
retStr = _BaseEnumService.TVTypeOK(contactPreferenceModel.TVType);
if (!string.IsNullOrWhiteSpace(retStr))
{
return(retStr);
}
retStr = FieldCheckNotNullAndWithinRangeInt(contactPreferenceModel.MarkerSize, ServiceRes.MarkerSize, 1, 200);
if (!string.IsNullOrWhiteSpace(retStr))
{
return(retStr);
}
retStr = _BaseEnumService.DBCommandOK(contactPreferenceModel.DBCommand);
if (!string.IsNullOrWhiteSpace(retStr))
{
return(retStr);
}
return("");
}
public ContactPreferenceModel PostAddContactPreferenceDB(ContactPreferenceModel contactPreferenceModel)
{
string retStr = ContactPreferenceModelOK(contactPreferenceModel);
if (!string.IsNullOrWhiteSpace(retStr))
{
return(ReturnError(retStr));
}
ContactOK contactOK = IsContactOK();
if (!string.IsNullOrEmpty(contactOK.Error))
{
return(ReturnError(contactOK.Error));
}
ContactModel contactModel = _ContactService.GetContactModelWithContactIDDB(contactPreferenceModel.ContactID);
if (!string.IsNullOrWhiteSpace(contactModel.Error))
{
return(ReturnError(contactModel.Error));
}
ContactPreference contactPreferenceNew = new ContactPreference();
retStr = FillContactPreference(contactPreferenceNew, contactPreferenceModel, contactOK);
if (!string.IsNullOrWhiteSpace(retStr))
{
return(ReturnError(retStr));
}
using (TransactionScope ts = new TransactionScope())
{
db.ContactPreferences.Add(contactPreferenceNew);
retStr = DoAddChanges();
if (!string.IsNullOrWhiteSpace(retStr))
{
return(ReturnError(retStr));
}
LogModel logModel = _LogService.PostAddLogForObj("ContactPreferences", contactPreferenceNew.ContactPreferenceID, LogCommandEnum.Add, contactPreferenceNew);
if (!string.IsNullOrWhiteSpace(logModel.Error))
{
return(ReturnError(logModel.Error));
}
ts.Complete();
}
return(GetContactPreferenceModelWithContactPreferenceIDDB(contactPreferenceNew.ContactPreferenceID));
}
public ContactPreferenceModel PostUpdateContactPreferenceDB(ContactPreferenceModel contactPreferenceModel)
{
string retStr = ContactPreferenceModelOK(contactPreferenceModel);
if (!string.IsNullOrWhiteSpace(retStr))
{
return(ReturnError(retStr));
}
ContactOK contactOK = IsContactOK();
if (!string.IsNullOrEmpty(contactOK.Error))
{
return(ReturnError(contactOK.Error));
}
ContactPreference contactPreferenceToUpdate = GetContactPreferenceWithContactPreferenceIDDB(contactPreferenceModel.ContactPreferenceID);
if (contactPreferenceToUpdate == null)
{
return(ReturnError(string.Format(ServiceRes.CouldNotFind_ToUpdate, ServiceRes.ContactPreference)));
}
retStr = FillContactPreference(contactPreferenceToUpdate, contactPreferenceModel, contactOK);
if (!string.IsNullOrWhiteSpace(retStr))
{
return(ReturnError(retStr));
}
using (TransactionScope ts = new TransactionScope())
{
retStr = DoUpdateChanges();
if (!string.IsNullOrWhiteSpace(retStr))
{
return(ReturnError(retStr));
}
LogModel logModel = _LogService.PostAddLogForObj("ContactPreferences", contactPreferenceToUpdate.ContactPreferenceID, LogCommandEnum.Change, contactPreferenceToUpdate);
if (!string.IsNullOrWhiteSpace(logModel.Error))
{
return(ReturnError(logModel.Error));
}
ts.Complete();
}
return(GetContactPreferenceModelWithContactPreferenceIDDB(contactPreferenceToUpdate.ContactPreferenceID));
}
// Fill
public string FillContactPreference(ContactPreference contactPreference, ContactPreferenceModel contactPreferenceModel, ContactOK contactOK)
{
contactPreference.DBCommand = (int)contactPreferenceModel.DBCommand;
contactPreference.ContactPreferenceID = contactPreferenceModel.ContactPreferenceID;
contactPreference.ContactID = (int)contactPreferenceModel.ContactID;
contactPreference.TVType = (int)contactPreferenceModel.TVType;
contactPreference.MarkerSize = contactPreferenceModel.MarkerSize;
contactPreference.LastUpdateDate_UTC = DateTime.UtcNow;
if (contactOK == null)
{
contactPreference.LastUpdateContactTVItemID = 2;
}
else
{
contactPreference.LastUpdateContactTVItemID = contactOK.ContactTVItemID;
}
return("");
}
public ContactPreferenceModel GetContactPreferenceModelWithContactPreferenceIDDB(int ContactPreferenceID)
{
ContactPreferenceModel contactPreferenceModel = (from c in db.ContactPreferences
where c.ContactPreferenceID == ContactPreferenceID
select new ContactPreferenceModel
{
Error = "",
ContactPreferenceID = c.ContactPreferenceID,
DBCommand = (DBCommandEnum)c.DBCommand,
ContactID = c.ContactID,
TVType = (TVTypeEnum)c.TVType,
MarkerSize = c.MarkerSize,
LastUpdateDate_UTC = c.LastUpdateDate_UTC,
LastUpdateContactTVItemID = c.LastUpdateContactTVItemID,
}).FirstOrDefault <ContactPreferenceModel>();
if (contactPreferenceModel == null)
{
return(ReturnError(string.Format(ServiceRes.CouldNotFind_With_Equal_, ServiceRes.ContactPreference, ServiceRes.ContactPreferenceID, ContactPreferenceID)));
}
return(contactPreferenceModel);
}
// Post
public ContactPreferenceModel PostAddOrModifyDB(FormCollection fc)
{
ContactOK contactOK = IsContactOK();
if (!string.IsNullOrWhiteSpace(contactOK.Error))
{
return(ReturnError(contactOK.Error));
}
int ContactPreferenceID = 0;
int ContactID = 0;
int TVTypeInt = 0;
TVTypeEnum TVType = TVTypeEnum.Error;
int MarkerSize = 0;
int.TryParse(fc["ContactPreferenceID"], out ContactPreferenceID);
// if 0 then want to add new TVItem else want to modify
int.TryParse(fc["ContactID"], out ContactID);
if (ContactID == 0)
{
return(ReturnError(string.Format(ServiceRes._IsRequired, ServiceRes.ContactID)));
}
int.TryParse(fc["TVType"], out TVTypeInt);
if (TVTypeInt == 0)
{
return(ReturnError(string.Format(ServiceRes._IsRequired, ServiceRes.TVType)));
}
TVType = (TVTypeEnum)TVTypeInt;
int.TryParse(fc["MarkerSize"], out MarkerSize);
if (MarkerSize == 0)
{
return(ReturnError(string.Format(ServiceRes._IsRequired, ServiceRes.MarkerSize)));
}
ContactPreferenceModel contactPreferenceModel = new ContactPreferenceModel();
using (TransactionScope ts = new TransactionScope())
{
if (ContactPreferenceID == 0)
{
ContactModel contactModel = _ContactService.GetContactModelWithContactIDDB(ContactID);
if (!string.IsNullOrWhiteSpace(contactModel.Error))
{
return(ReturnError(contactModel.Error));
}
ContactPreferenceModel contactPreferenceModelNew = new ContactPreferenceModel()
{
DBCommand = DBCommandEnum.Original,
ContactID = ContactID,
TVType = TVType,
MarkerSize = MarkerSize,
};
contactPreferenceModel = GetContactPreferenceModelExistDB(contactPreferenceModelNew);
if (!string.IsNullOrWhiteSpace(contactPreferenceModel.Error))
{
return(ReturnError(contactPreferenceModel.Error));
}
ContactPreferenceModel contactPreferenceModelRet = PostAddContactPreferenceDB(contactPreferenceModelNew);
if (!string.IsNullOrWhiteSpace(contactPreferenceModelRet.Error))
{
return(ReturnError(contactPreferenceModelRet.Error));
}
}
else
{
ContactPreferenceModel contactPreferenceModelNew = new ContactPreferenceModel()
{
DBCommand = DBCommandEnum.Original,
ContactID = ContactID,
TVType = TVType,
MarkerSize = MarkerSize,
};
ContactPreferenceModel contactPreferenceModelToChange = GetContactPreferenceModelExistDB(contactPreferenceModelNew);
if (!string.IsNullOrWhiteSpace(contactPreferenceModelToChange.Error))
{
return(ReturnError(contactPreferenceModelToChange.Error));
}
contactPreferenceModelToChange.MarkerSize = MarkerSize;
contactPreferenceModel = PostUpdateContactPreferenceDB(contactPreferenceModelToChange);
if (!string.IsNullOrWhiteSpace(contactPreferenceModel.Error))
{
return(ReturnError(contactPreferenceModel.Error));
}
}
ts.Complete();
}
return(contactPreferenceModel);
}
