public ActionResult addDocDesc(string oper, DocDescGridModel DocDesc, string vbPropertyId)
{
var context = new EFRepository();
//int propId = Convert.ToInt32(ViewData["vbPropertyId"]);
int propId = Convert.ToInt32(vbPropertyId);
if (oper.Equals("add"))
{
EFDocDesc doc = new EFDocDesc();
doc.Id = 0;
doc.PropertyId = Convert.ToInt32(vbPropertyId);
doc.Type = DocDesc.Type;
doc.Desc = DocDesc.Desc;
doc.ExpireDate = Convert.ToDateTime(DocDesc.ExpireDate);
doc.CreateDate = Convert.ToDateTime(DocDesc.CreateDate);
doc.FileName = DocDesc.FileName;
context.EFDocDescs.Add(doc);
context.SaveChanges();
EFDocHist hist = new EFDocHist();
hist.EFDocDescId = doc.Id;
hist.Date = DateTime.Now;
hist.Action = "request";
context.EFDocHists.Add(hist);
context.SaveChanges();
}
return(Json(JSONResponseFactory.SuccessResponse()));
}
public ActionResult genericDocDescList(string vbPropertyId)
{
var context = new EFRepository();
//int propId = Convert.ToInt32(ViewData["vbPropertyId"]);
int propId = Convert.ToInt32(vbPropertyId);
DateTime now = DateTime.Now;
for (int x = 0; x < 4; x++)
{
EFDocDesc doc = new EFDocDesc();
doc.Id = 0;
doc.PropertyId = Convert.ToInt32(vbPropertyId);
doc.Type = "Paystub";
doc.Desc = "Most Recent";
doc.ExpireDate = now;
doc.CreateDate = now;
doc.FileName = "";
context.EFDocDescs.Add(doc);
context.SaveChanges();
EFDocHist hist = new EFDocHist();
hist.EFDocDescId = doc.Id;
hist.Date = now;
hist.Action = "Request";
context.EFDocHists.Add(hist);
context.SaveChanges();
}
return(Json(JSONResponseFactory.SuccessResponse()));
}
public ActionResult addLien(string oper, LienSumGridModel addLien, string vbPropertyId)
{
var context = new EFRepository();
if (oper.Equals("add"))
{
EFLien lien = new EFLien();
lien.Id = 0;
lien.PropertyId = Convert.ToInt32(vbPropertyId);
lien.ReviewDate = addLien.ReviewDate == null ? (DateTime?)null : Convert.ToDateTime(addLien.ReviewDate);
lien.Type = addLien.Type;
lien.Servicer = addLien.Servicer;
lien.AccountNo = addLien.AccountNo;
lien.LienPosition = addLien.LienPosition;
lien.SettlementAmt = Convert.ToDecimal(addLien.SettlementAmt);
lien.SettlementDate = addLien.SettlementDate == null ? (DateTime?)null : Convert.ToDateTime(addLien.SettlementDate);
lien.Status = addLien.Status;
lien.MinNetProceeds = Convert.ToDecimal(addLien.MinNetProceeds);
lien.MaxNetProceeds = Convert.ToDecimal(addLien.MaxNetProceeds);
lien.Valuation = Convert.ToDecimal(addLien.Valuation);
lien.ValuationDate = addLien.ValuationDate == null ? (DateTime?)null : Convert.ToDateTime(addLien.ValuationDate);
lien.PayoffAmt = Convert.ToDecimal(addLien.PayoffAmt);
lien.PayoffDate = addLien.PayoffDate == null ? (DateTime?)null : Convert.ToDateTime(addLien.PayoffDate);
lien.SettlementProgram = addLien.SettlementProgram;
lien.FHA = addLien.FHA;
lien.Investor = addLien.Investor;
context.EFLiens.Add(lien);
context.SaveChanges();
}
return(Json(JSONResponseFactory.SuccessResponse()));
}
public ActionResult addContact(string oper, SellerSumGridModel addContact, string vbPropertyId)
{
var context = new EFRepository();
if (oper.Equals("add"))
{
EFContact contact = new EFContact();
contact.Id = 0;
contact.PropertyId = Convert.ToInt32(vbPropertyId);
contact.FirstName = addContact.FirstName;
contact.LastName = addContact.LastName;
contact.Role = addContact.Role;
contact.Email = addContact.Email;
if (addContact.AutoStatusUpdate == "True")
{
contact.AutoStatusUpdate = true;
}
else
{
contact.AutoStatusUpdate = false;
}
context.EFContacts.Add(contact);
context.SaveChanges();
}
return(Json(JSONResponseFactory.SuccessResponse()));
}
public ActionResult editLien(string oper, LienSumGridModel editLien, string id)
{
var context = new EFRepository();
if (oper.Equals("edit"))
{
EFLien lien = new EFLien();
lien.Id = Convert.ToInt32(editLien.Id);
lien.PropertyId = Convert.ToInt32(editLien.PropertyId);
lien.ReviewDate = editLien.ReviewDate == null ? (DateTime?)null : Convert.ToDateTime(editLien.ReviewDate);
lien.Type = editLien.Type;
lien.Servicer = editLien.Servicer;
lien.AccountNo = editLien.AccountNo;
lien.LienPosition = editLien.LienPosition;
lien.SettlementAmt = Convert.ToDecimal(editLien.SettlementAmt);
lien.SettlementDate = editLien.SettlementDate == null ? (DateTime?)null : Convert.ToDateTime(editLien.SettlementDate);
lien.Status = editLien.Status;
lien.MinNetProceeds = Convert.ToDecimal(editLien.MinNetProceeds);
lien.MaxNetProceeds = Convert.ToDecimal(editLien.MaxNetProceeds);
lien.Valuation = Convert.ToDecimal(editLien.Valuation);
lien.ValuationDate = editLien.ValuationDate == null ? (DateTime?)null : Convert.ToDateTime(editLien.ValuationDate);
lien.PayoffAmt = Convert.ToDecimal(editLien.PayoffAmt);
lien.PayoffDate = editLien.PayoffDate == null ? (DateTime?)null : Convert.ToDateTime(editLien.PayoffDate);
lien.SettlementProgram = editLien.SettlementProgram;
lien.FHA = editLien.FHA;
lien.Investor = editLien.Investor;
context.EFLiens.Attach(lien);
context.Entry(lien).State = EntityState.Modified;
context.SaveChanges();
}
return(Json(JSONResponseFactory.SuccessResponse()));
}
public ActionResult editContact(string oper, SellerSumGridModel editContact)
{
var context = new EFRepository();
if (oper.Equals("edit"))
{
EFContact contact = new EFContact();
contact.Id = Convert.ToInt32(editContact.Id);
contact.PropertyId = Convert.ToInt32(editContact.PropertyId);
contact.FirstName = editContact.FirstName;
contact.LastName = editContact.LastName;
contact.Role = editContact.Role;
contact.Email = editContact.Email;
if (editContact.AutoStatusUpdate == "True")
{
contact.AutoStatusUpdate = true;
}
else
{
contact.AutoStatusUpdate = false;
}
context.Entry(contact).State = EntityState.Modified;
context.SaveChanges();
}
return(Json(JSONResponseFactory.SuccessResponse()));
}
// id is rowid and primary key of DocDesc record
public ActionResult editDocDesc(string oper, EFDocDesc editDocDesc, string id)
{
var context = new EFRepository();
if (oper.Equals("edit"))
{
editDocDesc.Id = Convert.ToInt32(id);
context.EFDocDescs.Attach(editDocDesc);
context.Entry(editDocDesc).State = EntityState.Modified;
context.SaveChanges();
}
return(Json(JSONResponseFactory.SuccessResponse()));
}
// id is rowid and primary key of DocDesc record
public ActionResult deleteDocDesc(string oper, string id)
{
var context = new EFRepository();
if (oper.Equals("del"))
{
EFDocDesc deleteDocDesc = new EFDocDesc()
{
Id = Convert.ToInt32(id)
};
context.EFDocDescs.Attach(deleteDocDesc);
context.EFDocDescs.Remove(deleteDocDesc);
context.SaveChanges();
}
return(Json(JSONResponseFactory.SuccessResponse()));
}
public ActionResult addContact(string oper, LienContactGridModel addContact, string selectedLienId)
{
var context = new EFRepository();
if (oper.Equals("add"))
{
EFLienContact contact = new EFLienContact();
contact.Id = 0;
contact.LienId = Convert.ToInt32(selectedLienId);
contact.FirstName = addContact.FirstName;
contact.LastName = addContact.LastName;
contact.Role = addContact.Role;
context.EFLienContacts.Add(contact);
context.SaveChanges();
}
return(Json(JSONResponseFactory.SuccessResponse()));
}
public ActionResult editContact(string oper, LienContactGridModel editContact)
{
var context = new EFRepository();
if (oper.Equals("edit"))
{
EFLienContact contact = new EFLienContact();
contact.Id = Convert.ToInt32(editContact.Id);
contact.LienId = Convert.ToInt32(editContact.LienId);
contact.FirstName = editContact.FirstName;
contact.LastName = editContact.LastName;
contact.Role = editContact.Role;
context.Entry(contact).State = EntityState.Modified;
context.SaveChanges();
}
return(Json(JSONResponseFactory.SuccessResponse()));
}
public ActionResult addProperty(string oper, EFProperty addProperty)
{
var context = new EFRepository();
if (oper.Equals("add"))
{
EFProperty p = new EFProperty();
p.Id = 0;
p.Type = addProperty.Type;
p.Address = addProperty.Address;
p.City = addProperty.City;
p.State = addProperty.State;
p.Zip = addProperty.Zip;
context.EFProperties.Add(p);
context.SaveChanges();
}
return(Json(JSONResponseFactory.SuccessResponse()));
}
public ActionResult editProperty(string oper, PropSumGridModel editProperty)
{
var context = new EFRepository();
if (oper.Equals("edit"))
{
EFProperty p = new EFProperty();
p.Id = Convert.ToInt32(editProperty.Id);
p.Type = editProperty.Type;
p.Address = editProperty.Address;
p.City = editProperty.City;
p.State = editProperty.State;
p.Zip = editProperty.Zip;
context.Entry(p).State = EntityState.Modified;
context.SaveChanges();
}
return(Json(JSONResponseFactory.SuccessResponse()));
}
public ActionResult addOffer(string oper, OfferSumGridModel addOffer, string vbPropertyId)
{
var context = new EFRepository();
if (oper.Equals("add"))
{
EFOffer offer = new EFOffer();
offer.Id = 0;
offer.PropertyId = Convert.ToInt32(vbPropertyId);
offer.OfferDate = Convert.ToDateTime(addOffer.OfferDate);
offer.OfferAmt = Convert.ToDecimal(addOffer.OfferAmt);
offer.ExpireDate = Convert.ToDateTime(addOffer.ExpireDate);
offer.Status = addOffer.Status;
context.EFOffers.Add(offer);
context.SaveChanges();
}
return(Json(JSONResponseFactory.SuccessResponse()));
}
// id is rowid and primary key of Offer record
public ActionResult editOffer(string oper, OfferSumGridModel editOffer, string id)
{
var context = new EFRepository();
if (oper.Equals("edit"))
{
EFOffer offer = new EFOffer();
offer.Id = Convert.ToInt32(editOffer.Id);
offer.PropertyId = Convert.ToInt32(editOffer.PropertyId);
offer.OfferDate = Convert.ToDateTime(editOffer.OfferDate);
offer.OfferAmt = Convert.ToDecimal(editOffer.OfferAmt);
offer.ExpireDate = Convert.ToDateTime(editOffer.ExpireDate);
offer.Status = editOffer.Status;
context.EFOffers.Attach(offer);
context.Entry(offer).State = EntityState.Modified;
context.SaveChanges();
}
return(Json(JSONResponseFactory.SuccessResponse()));
}
public ActionResult deleteProperty(string oper, string id)
{
var context = new EFRepository();
if (oper.Equals("del"))
{
int propId = Convert.ToInt32(id);
var property = (from p
in context.EFProperties
where p.Id == propId
select p).Single();
property.isDeleted = true;
context.Entry(property).State = EntityState.Modified;
context.SaveChanges();
//EFProperty deleteProperty = new EFProperty() { Id = Convert.ToInt32(id) };
//context.EFProperties.Attach(deleteProperty);
//context.EFProperties.Remove(deleteProperty);
//context.SaveChanges();
}
return(Json(JSONResponseFactory.SuccessResponse()));
}
