// GET: enquiry_info/Delete/5
/* public ActionResult Delete(long? id)
* {
* if (id == null)
* {
* return new HttpStatusCodeResult(HttpStatusCode.BadRequest);
* }
* enquiry_info enquiry_info = db.enquiry.Find(id);
* if (enquiry_info == null)
* {
* return HttpNotFound();
* }
* return View(enquiry_info);
* } */
// POST: enquiry_info/Delete/5
/* [HttpPost, ActionName("Delete")]
* [ValidateAntiForgeryToken] */
public ActionResult DeleteConfirmed(long id)
{
enquiry_info enquiry_info = db.enquiry.Find(id);
db.enquiry.Remove(enquiry_info);
var proposal_info = db.proposal.Where(m => m.eid == id);
var invoice_main = db.proposal.FirstOrDefault(m => m.eid == id);
db.proposal.RemoveRange(proposal_info);
var ff = invoice_main == null ? 0 : invoice_main.Id;
var inv = db.invoice_main.Where(m => m.pid == ff);
db.invoice_main.RemoveRange(inv);
db.SaveChanges();
return(RedirectToAction("Index"));
/* var Order = db.Orders.where(x => x.StoreId == store.StoreId)
* var OrderDetail = db.OrderDetails.where(x => x.OrderId == Order.OrderId)
* var Product = db.Products.where(x => x.StoreId == store.StoreId)
*
* db.Orders.RemoveRange(Order);
* db.OrderDetails.RemoveRange(OrderDetail);
* db.Products.RemoveRange(Product);
* db.Stores.Remove(store);*/
}
public ActionResult Edit(enquiry_info enquiry_info)
{
if (ModelState.IsValid)
{
for (int i = 0; i < Request.Files.Count; i++)
{
var file = Request.Files[i];
if (file != null && file.ContentLength > 0)
{
var fileName = Guid.NewGuid() + Path.GetFileName(file.FileName);
attachments_info attachment_info = new attachments_info()
{
fileName = fileName,
cid = enquiry_info.Id
};
var extension = Path.GetExtension(file.FileName);
var path = Path.Combine(Server.MapPath("~/App_Data/Upload/"), attachment_info.fileName);
file.SaveAs(path);
db.Entry(attachment_info).State = EntityState.Added;
}
}
db.Entry(enquiry_info).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.cid = new SelectList(db.client_info, "id", "firstname", enquiry_info.cid);
return(View(enquiry_info));
}
// GET: enquiry_info/Delete/5
/* public ActionResult Delete(long? id)
* {
* if (id == null)
* {
* return new HttpStatusCodeResult(HttpStatusCode.BadRequest);
* }
* enquiry_info enquiry_info = db.enquiry.Find(id);
* if (enquiry_info == null)
* {
* return HttpNotFound();
* }
* return View(enquiry_info);
* } */
// POST: enquiry_info/Delete/5
/* [HttpPost, ActionName("Delete")]
* [ValidateAntiForgeryToken] */
public ActionResult DeleteConfirmed(long id)
{
enquiry_info enquiry_info = db.enquiry.Find(id);
db.enquiry.Remove(enquiry_info);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Create(enquiry_info enquiry_info, string search)
{
var userexist = db.client_info.Where(m => m.email_id == search).SingleOrDefault();
if (ModelState.IsValid)
{
if (userexist != null)
{
List <attachments_info> attachment = new List <attachments_info>();
for (int i = 0; i < Request.Files.Count; i++)
{
var file = Request.Files[i];
if (file != null && file.ContentLength > 0)
{
var fileName = Guid.NewGuid() + Path.GetFileName(file.FileName);
attachments_info attachment_info = new attachments_info()
{
fileName = fileName
};
attachment.Add(attachment_info);
var extension = Path.GetExtension(file.FileName);
var path = Path.Combine(Server.MapPath("~/App_Data/Upload/"), attachment_info.fileName);
file.SaveAs(path);
}
}
var q = from c in db.client_info where c.email_id == search select c;
foreach (var cust in q)
{
enquiry_info.cid = cust.id;
}
db.enquiry.Add(enquiry_info);
enquiry_info.attachments = attachment;
db.SaveChanges();
return(RedirectToAction("Index"));
}
else
{
ModelState.AddModelError("", "Email does not exists");
return(View(enquiry_info));
}
}
ViewBag.cid = new SelectList(db.client_info, "id", "firstname", enquiry_info.cid);
return(View(enquiry_info));
}
public ActionResult Edit([Bind(Include = "Id,cid,projectname,source,remark1,status,tag")] enquiry_info enquiry_info)
{
if (ModelState.IsValid)
{
db.Entry(enquiry_info).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.cid = new SelectList(db.client_info, "id", "firstname", enquiry_info.cid);
return(View(enquiry_info));
}
// GET: enquiry_info/Edit/5
public ActionResult Edit(long?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
enquiry_info enquiry_info = db.enquiry.Find(id);
if (enquiry_info == null)
{
return(HttpNotFound());
}
ViewBag.cid = new SelectList(db.client_info, "id", "firstname", enquiry_info.cid);
return(View(enquiry_info));
}
// GET: enquiry_info/Details/5
public ActionResult Details(long?id, string search)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
enquiry_info enquiry_info = db.enquiry.Find(id);
if (enquiry_info == null)
{
return(HttpNotFound());
}
return(View(enquiry_info));
}
// GET: enquiry_info/Edit/5
public ActionResult Edit(long?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
// enquiry_info enquiry_info = db.enquiry.Find(id);
enquiry_info enquiry_info = db.enquiry.Include(s => s.attachments).SingleOrDefault(x => x.Id == id);
if (enquiry_info == null)
{
return(HttpNotFound());
}
ViewBag.cid = new SelectList(db.client_info, "id", "firstname", enquiry_info.cid);
return(View(enquiry_info));
}
public ActionResult Create([Bind(Include = "Id,eid,prop_enquiry,sentdate,sent_to,sent_via")] proposal_info proposal_info)
{
if (ModelState.IsValid)
{
/* var result = (from r in db.enquiry
* join t in db.client_info on r.cid equals t.id
* where r.projectname.ToLower().Contains(term.ToLower())
* select new { r.projectname, t.email_id, r.Id });
*
* return Json(result, JsonRequestBehavior.AllowGet); */
// if (userexist != null)
// {
List <pros_attachments_info> attachment = new List <pros_attachments_info>();
for (int i = 0; i < Request.Files.Count; i++)
{
var file = Request.Files[i];
if (file != null && file.ContentLength > 0)
{
var fileName = Guid.NewGuid() + Path.GetFileName(file.FileName);
pros_attachments_info attachment_info = new pros_attachments_info()
{
fileName = fileName
};
attachment.Add(attachment_info);
var extension = Path.GetExtension(file.FileName);
var path = Path.Combine(Server.MapPath("~/App_Data/PUpload/"), attachment_info.fileName);
file.SaveAs(path);
}
}
/* var q = from c in db.enquiry where c.projectname == proposal_info.prop_enquiry select c;
*
* if (q != null)
* {
* foreach (var cust in q)
* {
* proposal_info.eid = cust.Id;
* }
* }
* else
* {
* proposal_info.eid = null;
* } */
if (proposal_info.eid != null)
{
enquiry_info e_info = db.enquiry.Find(proposal_info.eid);
e_info.status = Status.Proposal;
db.Entry(e_info).State = EntityState.Modified;
db.SaveChanges();
}
db.proposal.Add(proposal_info);
proposal_info.pros_attachments = attachment;
db.SaveChanges();
return(RedirectToAction("Index"));
// }
/* else
* {
* ModelState.AddModelError("", "project doesnot exists");
*
* return View(proposal_info);
*
* }*/
}
ViewBag.cid = new SelectList(db.enquiry, "id", "projectname", proposal_info.eid);
return(View(proposal_info));
/* if (ModelState.IsValid)
* {
* db.proposal.Add(proposal_info);
* db.SaveChanges();
* return RedirectToAction("Index");
* }
*
* ViewBag.eid = new SelectList(db.enquiry, "Id", "projectname", proposal_info.eid);
* return View(proposal_info); */
}
