public void Add(ESTATEMENT oESTATEMENT)
{
using (var db = Factory.DbEntities)
{
try
{
oESTATEMENT.Insert(db);
}
catch (Exception ex)
{
StringBuilder sb = new StringBuilder();
sb.AppendLine(ex.Message);
}
}
}
public int CountEmail(ESTATEMENT oESTATEMENT)
{
int totalEmail = 0;
using (var db = Factory.DbEntities)
{
try
{
totalEmail = oESTATEMENT.Get(db).Count();
}
catch (Exception ex)
{
StringBuilder sb = new StringBuilder();
sb.AppendLine(ex.Message);
}
}
return(totalEmail);
}
public bool SubmitData(ESTATEMENT oESTATEMENT, string MaxSubmit)
{
int countEmail = CountEmail(oESTATEMENT);
if (countEmail >= int.Parse(MaxSubmit))
{
return(false);
}
else
{
//methodsendEmail
EmailContent EmailContent = GetEmailContent(Variables._emailTemplateEStatement);
EmailContent.EmailBody = EmailContent.EmailBody.Replace("[Customer Name]", oESTATEMENT.EMAIL);
Library.Helpers.LibraryHelpers.SendEmail(oESTATEMENT.EMAIL, EmailContent.EmailFrom, EmailContent.Subject, EmailContent.EmailBody);
Add(oESTATEMENT);
return(true);
}
}
public ActionResult SubmitESTATEMENT(FormCollection formCollection)
{
if (System.Web.HttpContext.Current.Session[Variables._varEncryptedKey] == null)
{
return(SessionExpired());
}
var formData = DecryptObject(formCollection[PAYLOAD]);
// decrypt from js
string randomKey = System.Web.HttpContext.Current.Session[Variables._varEncryptedKey].ToString();
string MaxSubmit = AESEncrytDecry.DecryptStringAES(randomKey, formData["MaxSubmit"]);
ESTATEMENT oESTATEMENT = new ESTATEMENT();
var culture = new System.Globalization.CultureInfo(SC.Context.Language.Name);
var properties = oESTATEMENT.GetType().GetProperties();
for (int i = 0; i < properties.Length; i++)
{
try
{
if (!string.IsNullOrWhiteSpace(AESEncrytDecry.DecryptStringAES(randomKey, formData[properties[i].Name])))
{
properties[i].SetValue(oESTATEMENT, Convert.ChangeType(AESEncrytDecry.DecryptStringAES(randomKey, formData[properties[i].Name]), properties[i].PropertyType, culture), null);
}
}
catch { /* just continue ignore this error */ }
}
oESTATEMENT.IDESTATEMENT = Guid.NewGuid();
oESTATEMENT.CREATED = DateTime.Now;
bool result = SubmitData(oESTATEMENT, MaxSubmit);
return(Json(new { success = result }));
}
