//-----------Add products to cart-----------// public static void AddtoCartPL() { ECEntities ec = new ECEntities(); try { Console.Clear(); Console.WriteLine("*******************************************************************************"); Console.WriteLine(" Add to Cart "); Console.WriteLine("********************************************************************************"); Console.WriteLine("Enter the Name of the product:"); ec.ProdName = Console.ReadLine(); Console.WriteLine("Add to cart(Yes or No): "); ec.Addtocart = Console.ReadLine(); bool added = ECBL.AddtoCartBL(ec); if (added) { Console.WriteLine("Product added to cart successfully"); } else { Console.WriteLine("Product not added "); } } catch (ECExceptions ex) { Console.WriteLine(ex.Message); } catch (Exception ex) { Console.WriteLine(ex.Message); } }
//Update product---admin// public bool UpdateProductDAL(ECEntities ec) { bool updated = false; try { for (int i = 0; i < ProductList.Count; i++) { if (ProductList[i].ProductID == ec.ProductID) { ProductList[i].ProductName = ec.ProductName; ProductList[i].Description = ec.Description; ProductList[i].Quantity = ec.Quantity; ProductList[i].Price = ec.Price; updated = true; } } Serialization(); } catch (SystemException cex) { throw new ECExceptions(cex.Message); } return(updated); }
//Delete product--Admin// public bool RemoveProductDAL(String id) { bool removed = false; ProductList.Clear(); Deserialization(); ECEntities product = new ECEntities(); try { product = ProductList.Find(ec => ec.ProductID == id); if (product != null) { ProductList.Remove(product); removed = true; Serialization(); } } catch (SystemException cex) { throw new ECExceptions(cex.Message); } return(removed); }
public ActionResult UpdateUser([Bind(Include = "id,first_nm,last_nm,title_ds,email,company_department_id,user_permissions_approve_case_closure,user_permissions_change_settings,company_location_id")] user _user) { if (!(_user.company_location_id.HasValue) || (_user.company_location_id == 0)) { ModelState.AddModelError("company_location_id", @GlobalRes.Location); } if (ModelState.IsValid) { using (var db1 = new ECEntities()) { user _updateuser = db1.user.Where(item => item.id == _user.id).FirstOrDefault(); _updateuser.first_nm = _user.first_nm; _updateuser.last_nm = _user.last_nm; _updateuser.title_ds = _user.title_ds; _updateuser.company_location_id = _user.company_location_id; //_updateuser.notepad_tx = _user.notepad_tx; _updateuser.email = _user.email; //_updateuser.notification_messages_actions_flag = _user.notification_messages_actions_flag; //_updateuser.notification_new_reports_flag = _user.notification_new_reports_flag; _updateuser.company_department_id = _user.company_department_id; _updateuser.user_permissions_approve_case_closure = _user.user_permissions_approve_case_closure; _updateuser.user_permissions_change_settings = _user.user_permissions_change_settings; db1.SaveChanges(); return(RedirectToAction("Index")); } //TODO: Save your model and redirect // _user.Save(); // return RedirectToAction("Index"); } user user = (user)Session[ECGlobalConstants.CurrentUserMarcker]; if (user == null || user.id == 0) { return(RedirectToAction("Index", "Account")); } int user_id = user.id; UserModel um = new UserModel(user_id); Company ecModelCompany = new Company(); um.listDepartments = ecModelCompany.CompanyDepartments(user.company_id, 1, true); ViewBag.um = um; ViewBag.page_subtitle = GlobalRes.Settings; ViewBag.user_id = user_id; um._user.user_permissions_approve_case_closure = um._user.user_permissions_approve_case_closure == null ? 2 : um._user.user_permissions_approve_case_closure; um._user.user_permissions_change_settings = um._user.user_permissions_change_settings == null ? 2 : um._user.user_permissions_change_settings; return(View("Index", _user)); }
//Search product--Admin// public ECEntities SearchProductDAL(String id) { Deserialization(); ECEntities product = new ECEntities(); try { product = ProductList.Find(ec => ec.ProductID == id); } catch (SystemException cex) { throw new ECExceptions(cex.Message); } return(product); }
//-----------Update products-----------// public static void UpdateProductPL() { string productid; try { Console.Clear(); Console.WriteLine("*******************************************************************************"); Console.WriteLine(" Update Product Details "); Console.WriteLine("******************************************************************************"); Console.WriteLine("Enter the Product:(ID)"); productid = Console.ReadLine(); ECEntities product = ECBL.SearchProductBL(productid); if (product != null) { Console.WriteLine("Enter the Name of product:"); product.ProductName = Console.ReadLine(); Console.WriteLine("Enter the Description:"); product.Description = Console.ReadLine(); Console.WriteLine("Enter the quantity:"); product.Quantity = Console.ReadLine(); Console.WriteLine("Enter the price:"); product.Price = Console.ReadLine(); bool updated = ECBL.UpdateProductBL(product); if (updated) { Console.WriteLine("Product is updated"); } else { Console.WriteLine("Product is not updated"); } } else { Console.WriteLine("Product ID not found"); } } catch (ECExceptions ex) { Console.WriteLine(ex.Message); } catch (Exception ex) { Console.WriteLine(ex.Message); } }
//Add product---Admin// public bool AddProductDAL(ECEntities plan) { bool added = false; try { ProductList.Add(plan); Serialization(); added = true; } catch (SystemException cex) { throw new ECExceptions(cex.Message); } return(added); }
//Search product---Admin// public static ECEntities SearchProductBL(string ec) { ECEntities product = new ECEntities(); try { ECDAL ed = new ECDAL(); product = ed.SearchProductDAL(ec); } catch (ECExceptions ex) { throw ex; } catch (Exception ex) { throw ex; } return(product); }
//-------------Adding products---------// public static void AddProductPL() { ECEntities ec = new ECEntities(); try { Console.Clear(); Console.WriteLine("*******************************************************************************"); Console.WriteLine(" Add product Details "); Console.WriteLine("********************************************************************************"); Console.WriteLine("Enter the ID"); ec.ProductID = Console.ReadLine(); Console.WriteLine("Enter the Name "); ec.ProductName = Console.ReadLine(); Console.WriteLine("Enter the Description "); ec.Description = Console.ReadLine(); Console.WriteLine("Enter the quantity"); ec.Quantity = Console.ReadLine(); Console.WriteLine("Enter the price"); ec.Price = Console.ReadLine(); bool added = ECBL.AddProductBL(ec); if (added) { Console.WriteLine("Product added successfully"); } else { Console.WriteLine("Product not added "); } } catch (ECExceptions ex) { Console.WriteLine(ex.Message); } catch (Exception ex) { Console.WriteLine(ex.Message); } }
//Update product---Admin// public static bool UpdateProductBL(ECEntities product) { bool updated = false; try { if (Validate(product)) { ECDAL ed = new ECDAL(); updated = ed.UpdateProductDAL(product); } } catch (ECExceptions ex) { throw ex; } catch (Exception ex) { throw ex; } return(updated); }
//Add product--Admin// public static bool AddProductBL(ECEntities ec) { bool added = false; try { if (Validate(ec)) { ECDAL ed = new ECDAL(); added = ed.AddProductDAL(ec); } } catch (ECExceptions ex) { throw ex; } catch (Exception ex) { throw ex; } return(added); }
public static bool Validate(ECEntities ec) { StringBuilder sb = new StringBuilder(); bool validate = true; try { if (!validate) { throw new ECExceptions(sb.ToString()); } } catch (ECExceptions ex) { throw ex; } catch (Exception ex) { throw ex; } return(validate); }
//[HttpPost] //EC.Windows.Task.Scheduler.exe http://localhost:8093/Service/Scheduler1?param1=197 public ActionResult Scheduler1(int param1) { //Allow sec /*if (this.Request.UserHostAddress != "") * { * return new JsonResult * { * JsonRequestBehavior = JsonRequestBehavior.AllowGet, * Data = new * { * ok = false, * } * }; * }*/ using (var db = new ECEntities()) { var reports = db.report.ToList(); ReportModel rm = new ReportModel(); string email = ""; Business.Actions.Email.EmailManagement em = new Business.Actions.Email.EmailManagement(); Business.Actions.Email.EmailBody eb = new Business.Actions.Email.EmailBody(1, 1, Request.Url.AbsoluteUri.ToLower()); foreach (var _report in reports) { rm = new ReportModel(_report.id); if ((rm.GetThisStepDaysLeft() <= 0) && (!db.unread_report_reminder_sent.Any(t => t.report_id == _report.id && t.investigation_status_id == rm._investigation_status))) { eb.Scheduler1(rm._report.display_name); // days are exceeded - reminder never sent - need to send reminder foreach (var user in rm.MediatorsWhoHasAccessToReport()) { email = user.email; if ((email != null) && (email.Length > 0)) { try { // em.Send(email, "Case Management Deadline is past due", eb.Body, true); } catch { } } } try { unread_report_reminder_sent _reminder = new unread_report_reminder_sent(); _reminder.last_update_dt = DateTime.Now; _reminder.report_id = _report.id; _reminder.sent_dt = DateTime.Now; _reminder.investigation_status_id = rm._investigation_status; db.unread_report_reminder_sent.Add(_reminder); } catch { } } } } return(new JsonResult { JsonRequestBehavior = JsonRequestBehavior.AllowGet, Data = new { ok = true, } }); }
public string Email(string email) { if (email != null && email.Length > 0) { if (m_EmailHelper.IsValidEmail(email.Trim())) { ECEntities db = new ECEntities(); if (db.user.Any(t => (t.email.ToLower().Trim() == email.ToLower().Trim()) && (t.role_id != 8))) { user _user = (db.user.Where(t => t.email.ToLower().Trim() == email.ToLower().Trim())).First(); if (_user != null) { string password_token = Convert.ToBase64String(Guid.NewGuid().ToByteArray()); user_change_password _ucp = new user_change_password(); _ucp.password_token = password_token; _ucp.user_id = _user.id; _ucp.user_ip = ""; _ucp.password_updated = 0; _ucp.created_on = DateTime.Today; db.user_change_password.Add(_ucp); try { db.SaveChanges(); #region Email Sending List <string> to = new List <string>(); List <string> cc = new List <string>(); List <string> bcc = new List <string>(); to.Add(email.Trim()); /// bcc.Add("*****@*****.**"); EC.Business.Actions.Email.EmailManagement em = new EC.Business.Actions.Email.EmailManagement(); EC.Business.Actions.Email.EmailBody eb = new EC.Business.Actions.Email.EmailBody(1, 1, Request.Url.AbsoluteUri.ToLower()); eb.ForgetPasswordNew(Request.Url.AbsoluteUri.ToLower(), email, password_token); string body = eb.Body; em.Send(to, cc, App_LocalResources.GlobalRes.ChangePasswordRequest, body, true); #endregion } catch (Exception ex) { logger.Error(ex.ToString()); return(ex.ToString()); } return(GlobalRes.Success.ToLower()); } } return(GlobalRes.NoUserFound); } else { return(GlobalRes.EmailInvalid); } } else { return(GlobalRes.EnterYourEmail); } }
public ActionResult UpdateMediator([Bind(Include = "id,status_id,role_id")] user _user) { user session_user = (user)Session[ECGlobalConstants.CurrentUserMarcker]; if (session_user == null || session_user.id == 0) { return(RedirectToAction("Index", "Account")); } if (ModelState.IsValid) { using (var db1 = new ECEntities()) { user _updateuser = db1.user.Where(item => item.id == _user.id).FirstOrDefault(); _updateuser.status_id = _user.status_id; _updateuser.role_id = _user.role_id; bool _status_change = false; if ((_user.status_id == 2) && (_updateuser.status_id != 2)) { _status_change = true; } bool _role_change = false; if (_user.role_id != _updateuser.role_id) { _role_change = true; } List <string> to = new List <string>(); List <string> cc = new List <string>(); List <string> bcc = new List <string>(); CompanyModel cm = new CompanyModel(_user.company_id); EC.Business.Actions.Email.EmailManagement em = new EC.Business.Actions.Email.EmailManagement(); EC.Business.Actions.Email.EmailBody eb = new EC.Business.Actions.Email.EmailBody(1, 1, Request.Url.AbsoluteUri.ToLower()); string body = ""; if (_role_change) { if ((_updateuser.email.Trim().Length > 0) && m_EmailHelper.IsValidEmail(_updateuser.email.Trim())) { to = new List <string>(); cc = new List <string>(); bcc = new List <string>(); to.Add(_updateuser.email.Trim()); /// bcc.Add("*****@*****.**"); string new_role = ""; user_role new_roledb = db.user_role.Where(t => t.id == _user.role_id).FirstOrDefault(); if (new_roledb != null) { new_role = new_roledb.role_en; } eb.MediatorRoleChange(_updateuser.first_nm, _updateuser.last_nm, session_user.first_nm, session_user.last_nm, new_role); body = eb.Body; em.Send(to, cc, App_LocalResources.GlobalRes.Email_Title_MediatorRoleChanged, body, true); } } if (_status_change) { if ((_updateuser.email.Trim().Length > 0) && m_EmailHelper.IsValidEmail(_updateuser.email.Trim())) { to = new List <string>(); cc = new List <string>(); bcc = new List <string>(); to.Add(_updateuser.email.Trim()); /// bcc.Add("*****@*****.**"); string new_status = ""; status new_roledb = db.status.Where(t => t.id == _user.status_id).FirstOrDefault(); if (new_status != null) { new_status = new_roledb.status_en; } eb.MediatorStatusChange(_updateuser.first_nm, _updateuser.last_nm, session_user.first_nm, session_user.last_nm, new_status); body = eb.Body; em.Send(to, cc, App_LocalResources.GlobalRes.Email_Title_MediatorStatusChanged, body, true); } } db1.SaveChanges(); return(RedirectToAction("User", new { id = _user.id })); } } return(RedirectToAction("User", new { id = _user.id })); }
public bool AcceptOrReopenCase() { int report_id = Convert.ToInt16(Request["report_id"]); int user_id = Convert.ToInt16(Request["user_id"]); string description = "";// Request["description"]; int scopeId = Convert.ToInt32(Request["scopeId"]); int severityId = Convert.ToInt32(Request["severityId"]); //int departmentId = Convert.ToInt32(Request["departmentId"]); //int incidentId = Convert.ToInt32(Request["incidentId"]); int ownerId = Convert.ToInt32(Request["ownerId"]); bool lifeThreat = Convert.ToBoolean(Request["isLifeThreat"]); using (ECEntities adv = new ECEntities()) { report_investigation_status addStatus = new report_investigation_status() { report_id = report_id, investigation_status_id = 3, created_date = DateTime.Now, user_id = user_id, description = description }; adv.report_investigation_status.Add(addStatus); var item = db.report_mediator_assigned.FirstOrDefault(x => x.report_id == report_id & x.mediator_id == ownerId); if (item == null) { //Remove owner foreach (var rem_owner in db.report_owner.Where(x => x.report_id == report_id).ToList()) { rem_owner.status_id = 1; } //New owner var owner = new report_owner { report_id = report_id, status_id = 2, user_id = ownerId, created_on = DateTime.Now, }; db.report_owner.Add(owner); db.SaveChanges(); //Add to mediators var report_mediator_assigned = new report_mediator_assigned { mediator_id = ownerId, case_owner_id = owner.id, assigned_dt = DateTime.Now, last_update_dt = DateTime.Now, report_id = report_id, status_id = 2, user_id = user_id, }; db.report_mediator_assigned.Add(report_mediator_assigned); db.SaveChanges(); } adv.SaveChanges(); } using (ECEntities adv = new ECEntities()) { user user = (user)Session[ECGlobalConstants.CurrentUserMarcker]; var report = adv.report.FirstOrDefault(x => x.id == report_id); report.scope_id = scopeId; report.severity_id = severityId; report.severity_user_id = user.id; report.scope_user_id = user.id; report.cc_is_life_threating = lifeThreat; report.cc_is_life_threating_created_date = DateTime.Now; report.cc_is_life_threating_user_id = user.id; adv.SaveChanges(); } // Case accepted glb.UpdateReportLog(user_id, 17, report_id, description, null, ""); glb.UpdateReportLog(user_id, 20, report_id, App_LocalResources.GlobalRes._Completed, null, ""); glb.UpdateReportLog(user_id, 21, report_id, App_LocalResources.GlobalRes._Started, null, ""); report_log _log = new report_log(); ReportModel rm = new ReportModel(report_id); CompanyModel cm = new CompanyModel(rm._report.company_id); UserModel um = new UserModel(user_id); #region Email Ready List <string> to = new List <string>(); List <string> cc = new List <string>(); List <string> bcc = new List <string>(); EC.Business.Actions.Email.EmailManagement em = new EC.Business.Actions.Email.EmailManagement(); EC.Business.Actions.Email.EmailBody eb = new EC.Business.Actions.Email.EmailBody(1, 1, Request.Url.AbsoluteUri.ToLower()); string body = ""; #endregion if (EC.Common.Util.DomainUtil.IsCC(Request)) { if (lifeThreat) { glb.UpdateReportLog(user_id, 16, report_id, "", null, ""); glb.CampusSecurityAlertEmail(rm._report, Request.Url, db, cm._company.cc_campus_alert_manager_email); glb.CampusSecurityAlertEmail(rm._report, Request.Url, db, cm._company.cc_daily_crime_log_manager_email); } } if (!db.report_log.Any(item => ((item.action_id == 19) && (item.report_id == report_id)))) { //case opened glb.UpdateReportLog(user_id, 19, report_id, description, null, ""); #region Email To Mediators About Case Approved foreach (user _user in rm.MediatorsWhoHasAccessToReport()) { if ((_user.email.Trim().Length > 0) && m_EmailHelper.IsValidEmail(_user.email.Trim())) { to = new List <string>(); cc = new List <string>(); bcc = new List <string>(); to.Add(_user.email.Trim()); eb.NextStep(_user.first_nm, _user.last_nm, rm._report.display_name); body = eb.Body; /// em.Send(to, cc, App_LocalResources.GlobalRes.Email_Title_NextStep, body, true); } } #endregion #region Email to Reporter About case been Approved if ((rm._reporter_user.email.Trim().Length > 0) && m_EmailHelper.IsValidEmail(rm._reporter_user.email.Trim())) { to = new List <string>(); cc = new List <string>(); bcc = new List <string>(); to.Add(rm._reporter_user.email.Trim()); eb.NextStep(um._user.first_nm, um._user.last_nm, rm._report.display_name); body = eb.Body; em.Send(to, cc, App_LocalResources.GlobalRes.Email_Title_NextStep, body, true); } #endregion } else { // case re-opened glb.UpdateReportLog(user_id, 29, report_id, description, null, ""); #region Email To Mediators About Case re-opening foreach (user _user in rm.MediatorsWhoHasAccessToReport()) { if ((_user.email.Trim().Length > 0) && m_EmailHelper.IsValidEmail(_user.email.Trim())) { to = new List <string>(); cc = new List <string>(); bcc = new List <string>(); to.Add(_user.email.Trim()); /// bcc.Add("*****@*****.**"); eb.CaseReopened(_user.first_nm, _user.last_nm, rm._report.display_name, um._user.first_nm, um._user.last_nm); body = eb.Body; em.Send(to, cc, App_LocalResources.GlobalRes.Email_Title_CaseReopened, body, true); } } #endregion #region Email to Reporter About case been reopened if ((rm._reporter_user.email.Trim().Length > 0) && m_EmailHelper.IsValidEmail(rm._reporter_user.email.Trim())) { to = new List <string>(); cc = new List <string>(); bcc = new List <string>(); to.Add(rm._reporter_user.email.Trim()); /// bcc.Add("*****@*****.**"); eb.ReporterCaseReopened(rm._report.display_name); body = eb.Body; em.Send(to, cc, App_LocalResources.GlobalRes.Email_Title_CaseReopened, body, true); } #endregion } ///// glb.UpdateReportLog(user_id, 20, report_id, App_LocalResources.GlobalRes._Completed, null, description); ////// glb.UpdateReportLog(user_id, 21, report_id, App_LocalResources.GlobalRes._Started, null, ""); return(true); }