/// <summary>
/// Method to fill StatementStatus object
/// </summary>
/// <param name="statementStatusNodes">StatementStatus XML node</param>
/// <returns>StatementStatus object filled</returns>
private StatementStatus FillStatementStatus(XmlDocument xmlDoc)
{
var xPath = "OFX/BANKMSGSRSV1/STMTTRNRS/STATUS";
var statementStatusNodes = xmlDoc.SelectNodes(xPath);
var statementStatus = new StatementStatus();
foreach (XmlNode node in statementStatusNodes)
{
for (var i = 0; i < node.ChildNodes.Count; i++)
{
switch (node.ChildNodes[i].Name)
{
case "CODE":
statementStatus.Code = node.ChildNodes[i].InnerText;
break;
case "SEVERITY":
statementStatus.Severity = node.ChildNodes[i].InnerText;
break;
}
}
}
return(statementStatus);
}
public long?StatementStatus_Save(List <StatementStatus> listStatementStatus)
{
if (listStatementStatus.Count == 1)
{
StatementStatus statementStatus = listStatementStatus[0];
List <SqlParameter> parameters = new List <SqlParameter>();
parameters.AddInputParameter("@StatementID", SqlDbType.BigInt, statementStatus.StatementID);
parameters.AddInputParameter("@UserID", SqlDbType.BigInt, statementStatus.UserID);
parameters.AddInputParameter("@StatusDate", SqlDbType.DateTime, statementStatus.StatusDate);
parameters.AddInputParameter("@StatusID", SqlDbType.BigInt, statementStatus.StatusID);
parameters.AddInputParameter("@Comment", SqlDbType.NVarChar, statementStatus.Comment);
parameters.AddInputParameter("@AssignedToUserID", SqlDbType.BigInt, statementStatus.AssignedToUserID);
parameters.AddInputParameter("@ExecuteToDate", SqlDbType.DateTime, statementStatus.ExecuteToDate);
SqlParameter StatementStatusID = parameters.AddInputOutputParameter("@StatementStatusID", SqlDbType.BigInt, statementStatus.Id);
Execute_StoredProcedure("StatementStatus_Save", parameters);
return((long)StatementStatusID.Value);
}
else
{
List <SqlParameter> parameters = new List <SqlParameter>();
StatementStatusTableSet set = new StatementStatusTableSet(listStatementStatus);
parameters.AddInputParameter("@tableStatementStatus", SqlDbType.Structured, set.StatementStatusResultTable);
Execute_StoredProcedure("StatementStatus_SaveTable", parameters);
return(null);
}
}
public ActionResult DeleteConfirmed(int id)
{
StatementStatus statementStatus = db.StatementStatus.Find(id);
db.StatementStatus.Remove(statementStatus);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public StatementStatus StatementStatus_Get(long StatementStatusID)
{
List <SqlParameter> parameters = new List <SqlParameter>();
parameters.AddInputParameter("@StatementStatusID", SqlDbType.BigInt, StatementStatusID);
StatementStatus result = Execute_Get(StatementStatusMaterializer.Instance, "StatementStatus_Get", parameters);
return(result);
}
public ActionResult Edit([Bind(Include = "Id,Code,Severity")] StatementStatus statementStatus)
{
if (ModelState.IsValid)
{
db.Entry(statementStatus).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(statementStatus));
}
public ActionResult Create([Bind(Include = "Id,Code,Severity")] StatementStatus statementStatus)
{
if (ModelState.IsValid)
{
db.StatementStatus.Add(statementStatus);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(statementStatus));
}
// GET: StatementStatus/Delete/5
public ActionResult Delete(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
StatementStatus statementStatus = db.StatementStatus.Find(id);
if (statementStatus == null)
{
return(HttpNotFound());
}
return(View(statementStatus));
}
public JsonResult SaveStatus(StatementStatus status)
{
try
{
List <StatementStatus> list = new List <StatementStatus>()
{
status
};
var result = statementBusinessLogic.StatementStatus_Save(list);
Notification.SendEmailChangeStatus(status);
return(Json(new { StatementID = status.StatementID }));
}
catch (Exception ex)
{
Response.StatusCode = (int)HttpStatusCode.InternalServerError;
var exceptionDetails = new ExceptionDetails(ex, "Ошибка при сохранении статуса.");
return(Json(exceptionDetails));
}
}
/// <summary>
/// Method to fill Statement object
/// </summary>
/// <param name="statementStatusNodes">Statement XML nodes</param>
/// <param name="statementStatus">StatementStatus object filled</param>
/// <param name="bankTransaction">BankTransaction object filled</param>
/// <returns>Statement object filled</returns>
private Statement FillStatement(StatementStatus statementStatus, StatementDatails statementDatails, XmlDocument xmlDoc)
{
var xPath = "OFX/BANKMSGSRSV1/STMTTRNRS";
var statementNodes = xmlDoc.SelectNodes(xPath);
var statement = new Statement();
foreach (XmlNode node in statementNodes)
{
for (var i = 0; i < node.ChildNodes.Count; i++)
{
switch (node.ChildNodes[i].Name)
{
case "TRNUID":
statement.TransactionId = Convert.ToInt32(node.ChildNodes[i].InnerText);
break;
}
}
}
statement.StatementStatus = statementStatus;
statement.StatementDatails = statementDatails;
return(statement);
}
public void Close()
{
ClosingBalance = CurrentBalance;
CurrentBalance = 0;
Status = StatementStatus.Closed;
}
public Statement(DateTime billingDate, long incomingBalance)
{
BillingDate = billingDate;
IncomingBalance = incomingBalance;
Status = StatementStatus.Open;
}
public static bool SendEmailChangeStatus(StatementStatus status)
{
if (status == null)
{
return(false);
}
User AssignedToUser = new User();
if (status.StatusID != 1)
{
AssignedToUser = ReferencesProvider.GetUser(status.AssignedToUserID.Value);
}
List <SelectListItem> coordinators = ReferencesProvider.GetCoordinators();
Statement statement = ReferencesProvider.GetStatement(status.StatementID);
if (statement == null)
{
return(false);
}
List <ReferenceItem> listStatus = ReferencesProvider.GetReferenceItems(Constants.RefStatus);
MailDefinition md = new MailDefinition();
md.From = "*****@*****.**";
md.IsBodyHtml = true;
md.Subject = "Портал регистрации обращений";
ListDictionary replacements = new ListDictionary();
replacements.Add("{fio}", AssignedToUser?.Fullname);
replacements.Add("{StatementID}", status.StatementID.ToString());
replacements.Add("{status}", listStatus.Where(a => a.Id == status.StatusID).Select(b => b.Name).FirstOrDefault().ToString());
replacements.Add("{ExecuteToDate}", status.ExecuteToDate == null ? string.Empty : status.ExecuteToDate.Value.ToShortDateString());
replacements.Add("{CreateDate}", statement.CreateDate.ToShortDateString());
replacements.Add("{fioClient}", statement.Lastname + " " + statement.Firstname + " " + statement.Secondname);
string body = string.Empty;
body = body + "<div>Уважаемый сотрудник, {fio}.</div>" + Environment.NewLine;
body = body + "<div> </div>" + Environment.NewLine;
body = body + "<div>В системе регистрации обращений клиентов на Вас назначена заявка <a href=\" dev_complaint.uralsibins.ru/Home/Statement?id={StatementID}\">№{StatementID}</a></div>" + Environment.NewLine;
body = body + "<div>Установлен новый статус: [{status}]</div>" + Environment.NewLine;
body = body + "<div><b>Необходимо рассмотреть до {ExecuteToDate}</b></div>" + Environment.NewLine;
body = body + "<div>Дата создания заявки {CreateDate}</div>" + Environment.NewLine;
body = body + "<div>Клиент: {fioClient}</div>" + Environment.NewLine;
body = body + "<div> </div>" + Environment.NewLine;
body = body + "<div>С уважением,</div>" + Environment.NewLine;
body = body + "<div>Система регистрации заявок.</div>" + Environment.NewLine;
//smtp.uralsibins.ru - можно отправлять без авторизации
SmtpClient Smtp = new SmtpClient("smtp.uralsibins.ru", 25);
if (!string.IsNullOrEmpty(AssignedToUser.Email))
{
MailMessage msg = md.CreateMailMessage(AssignedToUser.Email.Trim(' ', ','), replacements, body, new System.Web.UI.Control());
Smtp.Send(msg);
}
if (status.StatusID == 1)
{
foreach (var item in coordinators)
{
if (!string.IsNullOrEmpty(item.Value))
{
MailMessage msgs = md.CreateMailMessage(item.Value.Trim(' ', ','), replacements, body, new System.Web.UI.Control());
Smtp.Send(msgs);
}
}
}
return(true);
}
