/// <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); }