public ActionResult AddNewComplain(AddComplainInDatabaseTable d, HttpPostedFileBase imgfile)
{
var list = new List <string> {
"Main Hall Missing", "Draingae", "Road Damage", "Dustbin Problem"
};
ViewBag.list = list;
var ComplainArea = new List <string> {
"Mohammadpur", "MirPur-1", "Dhamondli"
};
ViewBag.ComplainArea = ComplainArea;
// ViewBag.list = list;
AddComplainInDatabaseTable di = new AddComplainInDatabaseTable();
string path = uploadimage(imgfile);
if (ComplainIsExist(d))
{
ViewBag.msg = "Complain is exist";
return(View());
}
if (path.Equals("-1"))
{
}
else
{
di.Id = d.Id;
di.ComplainCategory = d.ComplainCategory;
di.ComplainaArea = d.ComplainaArea;
di.RoadNumber = d.RoadNumber;
di.ComplainDeatils = d.ComplainDeatils;
di.Photo = path;
//di.Photo = d.path;
di.ComplainerName = d.ComplainerName;
d.GiveStatus = "Pending";
di.GiveStatus = d.GiveStatus;
di.Email = d.Email;
di.ContractNumber = d.ContractNumber;
// db.AddComplains.Add(di);
db.AddComplainInDatabaseTables.Add(di);
EmailId = di.Email;
db.SaveChanges();
ModelState.Clear();
ViewBag.ComplainId = di.Id;
ViewBag.msg2 = "Your Complain Id Is Given Below";
ViewBag.msg = "Complain Submited";
//string sendEmail = ConfigurationManager.AppSettings["SendEmail"];
//SendEmail(di.Id.ToString());
}
return(View());
}
public bool ComplainIsExist(AddComplainInDatabaseTable addComplain)
{
int i = db.AddComplainInDatabaseTables.Where(c => c.ComplainCategory == addComplain.ComplainCategory && c.ComplainaArea == addComplain.ComplainaArea && c.RoadNumber == addComplain.RoadNumber).Count();
if (i > 0)
{
return(true);
}
return(false);
}
public ActionResult Details(int id)
{
if (Session["UserName"] == null)
{
return(RedirectToAction("AdminLogin", "Complain"));
}
AddComplainInDatabaseTable d = new AddComplainInDatabaseTable();
d = db.AddComplainInDatabaseTables.Where(x => x.Id == id).FirstOrDefault();
return(View(d));
}
public ActionResult UploadStatus(AddComplainInDatabaseTable edit)
{
if (Session["UserName"] == null)
{
return(RedirectToAction("AdminLogin", "Complain"));
}
if (ModelState.IsValid)
{
db.Entry(edit).State = EntityState.Modified;
if (db.SaveChanges() > 0)
{
ViewBag.msg = "Update Work Status";
return(RedirectToAction("Report", "Complain"));
}
}
return(View());
}
