public JsonResult SaveForm()
{
List <string> RequestKeys = Request.Form.AllKeys.ToList();
RejectDbEntities DatabaseConnection = new RejectDbEntities();
tbRejectRecord Rejectrecord;
PropertyInfo FormProperty;
int RejectNo = -1;
for (int i = 0; i < RequestKeys.Count; i++)
{
if (RequestKeys.ElementAt(i).ToString() == "RejectNo")
{
RejectNo = Int32.Parse(Request.Form.Get(i));
}
}
//try
//{
if (RejectNo != -1)
{
Rejectrecord = DatabaseConnection.tbRejectRecords.Find(RejectNo);
for (int i = 0; i < RequestKeys.Count; i++)
{
FormProperty = Rejectrecord.GetType().GetProperty(RequestKeys.ElementAt(i));
FormProperty.SetValue(Rejectrecord, Convert.ChangeType(Request.Form.Get(i).Replace("'", "''"), FormProperty.PropertyType));
}
DatabaseConnection.SaveChanges();
}
//}
//catch
//{
// return Json("Error Caught", JsonRequestBehavior.AllowGet);
//}
//return RedirectToAction("Tickets", "TicketGrid");
return(Json("Success", JsonRequestBehavior.AllowGet));
}
public JsonResult SubmitForm()
{
List <string> RequestKeys = Request.Form.AllKeys.ToList();
RejectDbEntities DatabaseConnection = new RejectDbEntities();
tbRejectRecord NewRejectrecord = new tbRejectRecord();
PropertyInfo FormProperty;
for (int i = 0; i < RequestKeys.Count; i++)
{
FormProperty = NewRejectrecord.GetType().GetProperty(RequestKeys.ElementAt(i));
FormProperty.SetValue(NewRejectrecord, Convert.ChangeType(Request.Form.Get(i).Replace("'", "''"), FormProperty.PropertyType));
}
NewRejectrecord.DateRaised = DateTime.Now;
NewRejectrecord.ProNo = "Test";
NewRejectrecord.ReplacementPo = "Test";
NewRejectrecord.RejectedPoNo = "Test";
NewRejectrecord.ShippingMethod = "Test";
NewRejectrecord.TrackingNo = "Test";
NewRejectrecord.RmaNo = "Test";
//NewRejectrecord.ProNo = "";
//NewRejectrecord.ReplacementPo = "";
//NewRejectrecord.RejectedPoNo = "";
NewRejectrecord.CreditNoteReceived = "NO";
NewRejectrecord.GoodsShipped = "NO";
DatabaseConnection.tbRejectRecords.Add(NewRejectrecord);
DatabaseConnection.SaveChanges();
//Added POR, return Rejection Note
//Buyer Email must be in the correct format.
//MailMessage mailMessage = new MailMessage();
//mailMessage.To.Add("*****@*****.**");
//mailMessage.CC.Add(NewRejectrecord.BuyerEmail);
//mailMessage.From = new MailAddress("*****@*****.**");
//mailMessage.Subject = "New Reject Note: " + NewRejectrecord.RejectNo;
//mailMessage.Body = NewRejectrecord.BuyerName + ",\n\nNew Reject Note " + NewRejectrecord.RejectNo + " raised: "
// + "\n\nVendor: " + NewRejectrecord.Vendor
// + "\n\nVendor No: " + NewRejectrecord.VendorNo
// + "\n\nPart No: " + NewRejectrecord.PartNo
// + "\nDescription: " + NewRejectrecord.PartDescription
// + "\nQty: " + NewRejectrecord.QtyRejected
// + "\nTotal Value: " + NewRejectrecord.TotalValue
// + "\n\nReturn Code: " + NewRejectrecord.ReasonCode
// + "\nDescription: " + NewRejectrecord.ReturnDescription
// + "\nRaised By: " + NewRejectrecord.EmployeeName
// + "\n\nReplacement Required: " + NewRejectrecord.ReplacementRequired;
//SmtpClient smtpClient = new SmtpClient("uk-leic1.ametek.com");
//smtpClient.Send(mailMessage);
return(Json(NewRejectrecord.RejectNo, JsonRequestBehavior.AllowGet));
}
