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