public KeyValuePair <int, String> NonCustomer_Delete(NonCustomer model) { var param = new SqlParameter[] { new SqlParameter("@NonCustomerID", SqlDbType.UniqueIdentifier) { Value = model.NonCustomerID }, new SqlParameter("@ModifiedBy", SqlDbType.UniqueIdentifier) { Value = CheckForDbNull(model.ModifiedBy) }, new SqlParameter("@RetVal", SqlDbType.Int) { Direction = ParameterDirection.Output }, new SqlParameter("@Message", SqlDbType.NVarChar, 100) { Direction = ParameterDirection.Output } }; int rc = ((IObjectContextAdapter)this).ObjectContext.ExecuteStoreCommand("exec [CRM].[NonCustomer_Delete] @NonCustomerID, @ModifiedBy, @RetVal out, @Message out", param); int retVal = (int)param[2].Value; string valueRes = param[3].Value.ToString(); return(new KeyValuePair <int, string>(retVal, valueRes)); }
public KeyValuePair <int, String> NonCustomer_Update(NonCustomer model) { var param = new SqlParameter[] { new SqlParameter("@nonCustomerID", SqlDbType.UniqueIdentifier) { Value = model.NonCustomerID }, new SqlParameter("@BirthDate", SqlDbType.DateTime) { Value = CheckForDbNull(model.BirthDate) }, new SqlParameter("@Salutation", CheckForDbNull(model.Salutation)), new SqlParameter("@Firstname", CheckForDbNull(model.FirstName)), new SqlParameter("@LastName", CheckForDbNull(model.LastName)), new SqlParameter("@fullname", CheckForDbNull(model.FullName)), new SqlParameter("@Phone", CheckForDbNull(model.PhoneNo)), new SqlParameter("@city", CheckForDbNull(model.City)), new SqlParameter("@Email", CheckForDbNull(model.Email)), new SqlParameter("@zipcode", CheckForDbNull(model.Zipcode)), new SqlParameter("@HandphoneNo", CheckForDbNull(model.HandphoneNo)), new SqlParameter("@address3", CheckForDbNull(model.Address3)), new SqlParameter("@address2", CheckForDbNull(model.Address2)), new SqlParameter("@address1", CheckForDbNull(model.Address1)), new SqlParameter("@country", CheckForDbNull(model.Country)), new SqlParameter("@AddressType", SqlDbType.Int) { Value = CheckForDbNull(model.AddressType) }, new SqlParameter("@Fax", CheckForDbNull(model.FaxNo)), new SqlParameter("@ModifiedBy", SqlDbType.UniqueIdentifier) { Value = CheckForDbNull(model.ModifiedBy) }, new SqlParameter("@BusinessUnit", SqlDbType.UniqueIdentifier) { Value = CheckForDbNull(model.BusinessUnitID) }, new SqlParameter("@RetVal", SqlDbType.Int) { Direction = ParameterDirection.Output }, new SqlParameter("@Message", SqlDbType.NVarChar, 100) { Direction = ParameterDirection.Output } }; int rc = ((IObjectContextAdapter)this).ObjectContext.ExecuteStoreCommand("exec [CRM].[NonCustomer_Update] @nonCustomerID, @BirthDate, @Salutation, @Firstname, @LastName, @fullname, @Phone, @city, @Email, @zipcode, @HandphoneNo, @address3, @address2, @address1, @country, @AddressType, @Fax, @ModifiedBy, @BusinessUnit, @RetVal out, @Message out", param); int retVal = (int)param[19].Value; string valueRes = param[20].Value.ToString(); return(new KeyValuePair <int, string>(retVal, valueRes)); }
public ActionResult Edit(int id, NonCustomer contact) { try { _cRepository = new ContactRepository(_uow); _cRepository.Attach(contact); _uow.Save(); return(RedirectToAction("Index")); } catch { return(View(contact)); } }
public void Add(int id, string firstName, string lastName, DateTime addDate, byte[] rowVersion, String title) { var c = new NonCustomer { ContactID = id, FirstName = firstName, LastName = lastName, AddDate = addDate, ModifiedDate = DateTime.Now, RowVersion = rowVersion, Title = title }; _context.Contacts.AddObject(c); }
public ActionResult Edit(Guid id) { NonCustomer model = db.noncustomer.Find(id); StringMapController dropDown = new StringMapController(); //buat hide save and new di form ViewBag.hideSaveAndOpen = true; //buat notes ViewBag.BusinessUnitID = model.BusinessUnitID; //buat dropdown di form ViewBag.SL_AddressType = dropDown.getDropDown(entityName, "addresstype", model.AddressType == null ? 0 : (int)model.AddressType); return(View(model)); }
public ActionResult Create(string customerID = null, string customerName = null) { StringMapController dropDown = new StringMapController(); NonCustomer model = new NonCustomer(); model.CreatedBy = new Guid(Session["CurrentUserID"].ToString()); model.CreatedByName = Session["Fullname"].ToString(); model.Owner = new Guid(Session["CurrentUserID"].ToString()); model.OwnerName = Session["Fullname"].ToString(); model.CreatedOn = DateTime.Now; //buat hide save and new di form ViewBag.hideSaveAndOpen = true; //buat dropdown di form ViewBag.SL_AddressType = dropDown.getDropDown(entityName, "addresstype", model.AddressType == null ? 0 : (int)model.AddressType); return(View(model)); }
public ActionResult Create(LetterEntryView model) { JSONResponse result = new JSONResponse(); result.Value = false; result.Response = string.Empty; try { if (Session["BusinessUnitID"] == null | Session["CurrentUserID"] == null) { throw new Exception(Resources.LetterEntry.Alert_SessionIsNull); } var businessunitid = new Guid(Convert.ToString(Session["BusinessUnitID"])); var systemuserid = new Guid(Convert.ToString(Session["CurrentUserID"])); var userid = db.systemUser.Single(p => p.SystemUserId == systemuserid); if (ModelState.IsValid) { StringBuilder errorMessages = new StringBuilder(), successMessages = new StringBuilder(); KeyValuePair <int, string> results = new KeyValuePair <int, string>(1, string.Empty); List <string> IdsList = string.IsNullOrEmpty(model.RequestIds) ? new List <string>() : new JavaScriptSerializer().Deserialize <List <string> >(model.RequestIds); if (IdsList.Count.Equals(0)) { throw new Exception(Resources.LetterEntry.Alert_NoRequest); } if (IdsList.Count > 5) { throw new Exception(Resources.LetterEntry.Alert_RequestMoreThanFive); } if (!model.LetterEntry.TemplateID.HasValue) { throw new Exception(Resources.LetterEntry.Alert_ChooseTemplate); } LetterTemplate lettertemplate = db.letterTemplate.Where(x => x.LetterTemplateId == model.LetterEntry.TemplateID).FirstOrDefault(); if (lettertemplate == null) { throw new Exception(Resources.LetterEntry.Alert_TemplateUndefined); } for (int i = 0; i <= IdsList.Count - 1; i++) { Guid requestId = new Guid(IdsList.ElementAt(i)); Request request = db.request.Where(x => x.RequestID == requestId).FirstOrDefault(); /* * Jika kondisi nya multiple-request, maka branch yang diambil adalah branch dari Request. * Sebaliknya, jika field CC diisi oleh user maka branch yang diambil adalah branch dari CC tersebut. * Sebaliknya, jika field UserBranch pada Request tidak null, maka branch yang diambil adalah branch dari Request. * Sebaliknya, branch sama dengan null. */ Guid branchID = (model.IsMultipleLetter) ? (request.BranchID.HasValue ? request.BranchID.Value : Guid.Empty) : (model.LetterEntry.CC_ID.HasValue ? model.LetterEntry.CC_ID.Value : (request.UserBranchID.HasValue ? request.UserBranchID.Value : Guid.Empty)); Branch branch = branchID.Equals(Guid.Empty) ? null : db.branch.Where(x => x.BranchID == branchID).FirstOrDefault(); string address1 = null, address2 = null, address3 = null, city = null, postalcode = null; if (request.Location != null) { StringMap stringmap = db.pickList .Where(x => x.EntityName.Equals("CustomerAddress") && x.AttributeName.Equals("addresstypecode") && x.AttributeValue.Equals(request.Location.Value)) .FirstOrDefault(); if (stringmap != null & stringmap.label.ToUpper().Equals("OTHER")) { address1 = request.Address1; address2 = request.Address2; city = request.City; postalcode = request.PostalCode; } else if (request.CustomerID != null) { CCARE.Models.Customer customer = db.customer.Where(x => x.CustomerID == request.CustomerID.Value).FirstOrDefault(); if (customer != null) { address1 = customer.Line1; address2 = customer.Line2; address3 = customer.Line3; city = customer.City; postalcode = customer.PostalCode; } } } else if (request.NonCustomerID != null) { NonCustomer noncustomer = db.noncustomer.Where(x => x.NonCustomerID == request.NonCustomerID.Value).FirstOrDefault(); if (noncustomer != null) { address1 = noncustomer.Address1; address2 = noncustomer.Address2; address3 = noncustomer.Address3; city = noncustomer.City; postalcode = noncustomer.Zipcode; } } LetterEntry letterentry = new LetterEntry(); letterentry.AccountNo = request.AccountNo; letterentry.Address1 = address1; letterentry.Address2 = address2; letterentry.Address3 = address3; letterentry.AttchATM = model.LetterEntry.AttchATM; letterentry.AttchATMSwitching = model.LetterEntry.AttchATMSwitching; letterentry.AttchCirrus = model.LetterEntry.AttchCirrus; letterentry.AttchDebit = model.LetterEntry.AttchDebit; letterentry.AttchMaestro = model.LetterEntry.AttchMaestro; letterentry.AttchDuration = model.LetterEntry.AttchDuration; letterentry.BusinessUnitID = businessunitid; letterentry.CardNo = request.CardNo; if (branch != null) { if (branch.BranchID != null) { letterentry.CC_ID = branch.BranchID; } if (!string.IsNullOrEmpty(branch.Name)) { letterentry.CC_Name = branch.Name; } } letterentry.City = city; letterentry.Description1 = model.LetterEntry.Description1; letterentry.Description2 = model.LetterEntry.Description2; letterentry.Description3 = model.LetterEntry.Description3; letterentry.Description4 = model.LetterEntry.Description4; letterentry.FullName = request.CustomerName; letterentry.LetterDate = model.LetterEntry.LetterDate == null ? DateTime.Now : model.LetterEntry.LetterDate.Value; letterentry.LetterEntryID = Guid.NewGuid(); if (lettertemplate.Type.Equals((int)LetterType.SPC)) { letterentry.LetterNo = Convert.ToString(Convert.ToDouble(model.LetterEntry.LetterNo) + i).PadLeft(4, '0'); } else { string bcaNo = db.AutoNumber_GetNext("Letter Entry", DateTime.Now.Year); if (bcaNo != "") { letterentry.LetterNo = string.Format("{0}/BHB/{1}/{2}", bcaNo.PadLeft(5, '0'), arrRomans.ElementAt(letterentry.LetterDate.Value.Month - 1), letterentry.LetterDate.Value.Year.ToString()); } else { errorMessages.AppendLine("Unable to generate letter entry. Auto Number record does not exist. "); continue; } } letterentry.ModifiedBy = systemuserid; letterentry.RequestID = request.RequestID.Value; letterentry.TicketNumber = request.TicketNumber; letterentry.TemplateID = lettertemplate.LetterTemplateId; letterentry.ZIPPostalCode = postalcode; results = db.LetterEntry_Insert(letterentry); if (results.Key == 0 || results.Key == 16 || results.Key == 6) { MergeDocument aMergeDocument = new MergeDocument(); JSONResponse mergeResult = aMergeDocument.Merge(letterentry.LetterEntryID); if (Convert.ToBoolean(mergeResult.Value)) { successMessages.Append(letterentry.LetterEntryID.ToString()); } else { errorMessages.AppendLine(string.Format(Resources.LetterEntry.Alert_GenerateLetterError, request.TicketNumber, mergeResult.Response)); } continue; } else { errorMessages.AppendLine(results.Value.ToString()); continue; } } string strAnyErrors = errorMessages.ToString(); string strAnySuccess = successMessages.ToString(); successMessages.AppendLine(strAnyErrors); if (string.IsNullOrEmpty(strAnyErrors)) { UrlHelper u = new UrlHelper(this.ControllerContext.RequestContext); string url = u.Action("Edit", "LetterEntry", new { id = successMessages.ToString().Trim() }); result.Value = true; result.Response = url; } else { throw new Exception(successMessages.ToString()); } } else { foreach (var key in ModelState.Keys) { var error = ModelState[key].Errors.FirstOrDefault(); if (error != null) { throw new Exception(error.ErrorMessage); } } } } catch (Exception e) { result.Value = false; result.Response = e.Message; } return(Json(result)); }
public ActionResult CallWrapUpNonCustomer(Guid id) { NonCustomer model = db.noncustomer.Find(id); return(View(model)); }
public ActionResult Delete(NonCustomer model) { return(formSubmit(model, "Delete")); }
public ActionResult ChangeStatus(NonCustomer model) { return(formSubmit(model, "ChangeStatus")); }
public ActionResult RequestList(Guid id) { NonCustomer model = db.noncustomer.Find(id); return(View(model)); }
public ActionResult Edit(NonCustomer model) { return(formSubmit(model, "Edit")); }
public ActionResult formSubmit(NonCustomer model, string actionType) { List <string> errorMessage = new List <string>(); string successMessage = Resources.NotifResource.RequestSuccess; if (ModelState.IsValid) { KeyValuePair <int, string> results = new KeyValuePair <int, string>(1, ""); model.BusinessUnitID = new Guid(Session["BusinessUnitID"].ToString()); switch (actionType) { case "Create": model.NonCustomerID = Guid.NewGuid(); model.CreatedBy = new Guid(Session["CurrentUserID"].ToString()); model.ModifiedBy = new Guid(Session["CurrentUserID"].ToString()); results = db.NonCustomer_Insert(model); break; case "Edit": model.ModifiedBy = new Guid(Session["CurrentUserID"].ToString()); results = db.NonCustomer_Update(model); break; case "ChangeStatus": model.ModifiedBy = new Guid(Session["CurrentUserID"].ToString()); results = db.NonCustomer_ChangeStatus(model); break; case "Delete": model.ModifiedBy = new Guid(Session["CurrentUserID"].ToString()); results = db.NonCustomer_Delete(model); break; } if (results.Key == 0 || results.Key == 16 || results.Key == 6) { UrlHelper u = new UrlHelper(this.ControllerContext.RequestContext); string url = u.Action("Edit", "NonCustomer", new { id = model.NonCustomerID, success = successMessage }); string urlNew = u.Action("Create", "NonCustomer"); var jsonData = new { flag = true, Message = url, urlNew = urlNew }; return(Json(jsonData)); } else { var jsonData = new { flag = false, Message = results.Value.ToString() }; return(Json(jsonData)); } } else { foreach (var key in ModelState.Keys) { var error = ModelState[key].Errors.FirstOrDefault(); if (error != null) { errorMessage.Add(error.ErrorMessage); } } var jsonData = new { flag = false, Message = errorMessage.First() }; return(Json(jsonData)); } }
public ActionResult Create(NonCustomer model, string TransactionTimeFormat = null) { return(formSubmit(model, "Create")); }