public ActionResult IeltsLogs(int id)
{
tblfeedback feed = new tblfeedback();
feed.inquiryid = id.ToString();
return(View(feed));
}
public ActionResult follow(int id)
{
tblfeedback feed = new tblfeedback();
var fee = db.tblfeedback.FirstOrDefault(x => x.Id == id).inquiryid;
feed.inquiryid = fee;
return(View(feed));
}
public async Task <ActionResult> DeleteConfirmed(int id)
{
tblfeedback tblfeedback = await db.tblfeedback.FindAsync(id);
db.tblfeedback.Remove(tblfeedback);
await db.SaveChangesAsync();
return(RedirectToAction("Index"));
}
public ActionResult followCreate([Bind(Include = "Id,date,inquiryid,feedback,days,type,nextfollow,status,loginid")] tblfeedback tblfeedback)
{
objsql.ExecuteNonQuery("update tblfeedbacks set status='0' where inquiryid='" + tblfeedback.inquiryid + "'");
tblfeedback.nextfollow = System.DateTime.Now.AddDays(tblfeedback.days);
tblfeedback.loginid = User.IsInRole("Franchisee") ? help.Receptionist() : help.Franchisee();
db.tblfeedback.Add(tblfeedback);
db.SaveChanges();
TempData["Success"] = "Update Inquiry Successfully";
return(RedirectToAction("Index", "Auth/Default/Index"));
}
public async Task <ActionResult> Edit([Bind(Include = "Id,date,inquiryid,feedback,days,type,nextfollow,status,loginid")] tblfeedback tblfeedback)
{
if (ModelState.IsValid)
{
db.Entry(tblfeedback).State = EntityState.Modified;
await db.SaveChangesAsync();
return(RedirectToAction("Index"));
}
return(View(tblfeedback));
}
public ActionResult Follow(int id)
{
db.Configuration.ProxyCreationEnabled = false;
tblfeedback lstcity = new tblfeedback();
var a = db.tblfeedback.Where(x => x.Id == id).First();
lstcity.inquiryid = a.inquiryid;
ViewBag.EmployeeList = lstcity;
return(PartialView("~/Areas/Auth/Views/Default/FollowUp.cshtml", lstcity));
}
// GET: Auth/tblfeedbacks/Details/5
public async Task <ActionResult> Details(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
tblfeedback tblfeedback = await db.tblfeedback.FindAsync(id);
if (tblfeedback == null)
{
return(HttpNotFound());
}
return(PartialView("pop", id));
}
// GET: Auth/tblfeedbacks/Edit/5
public async Task <ActionResult> Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
tblfeedback tblfeedback = await db.tblfeedback.FindAsync(id);
if (tblfeedback == null)
{
return(HttpNotFound());
}
return(View(tblfeedback));
}
public ActionResult Edit([Bind(Include = "Id,date,inquiryid,name,fname,contact,address,referedby,Categoryid,Type,Status")] tblinquiry tblinquiry, [Bind(Include = "Id,date,inquiryid,feedback,days,type,nexfollow,status,loginid")] tblfeedback tblfeedback)
{
try
{
if (ModelState.IsValid)
{
//db.Entry(tblinquiry).State = EntityState.Modified;
//db.SaveChanges();
tblfeedback ff = db.tblfeedback.FirstOrDefault(x => x.inquiryid == tblinquiry.inquiryid);
if (ff != null)
{
DateTime next = new DateTime();
if (tblfeedback.type == "Days")
{
next = System.DateTime.Now.AddDays(tblfeedback.days);
}
else
{
next = System.DateTime.Now;
}
objsql.ExecuteNonQuery("update tblfeedbacks set date='" + tblinquiry.date + "',nextfollow='" + next + "' where id='" + ff.Id + "'");
TempData["feedback"] = tblinquiry.inquiryid;
TempData["Success"] = "Updated Successfully";
return(RedirectToAction("Index"));
}
}
return(View(tblinquiry));
}
catch (DbEntityValidationException e)
{
foreach (var eve in e.EntityValidationErrors)
{
Console.WriteLine("Entity of type \"{0}\" in state \"{1}\" has the following validation errors:",
eve.Entry.Entity.GetType().Name, eve.Entry.State);
foreach (var ve in eve.ValidationErrors)
{
Console.WriteLine("- Property: \"{0}\", Error: \"{1}\"",
ve.PropertyName, ve.ErrorMessage);
}
}
throw;
}
}
// GET: Auth/Inquiry/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
tblinquiry tblinquiry = db.tblinquiries.Find(id);
ViewBag.Categoryid = new SelectList(db.Categories, "Categoryid", "Name", tblinquiry.Categoryid);
tblfeedback tbfeedback = db.tblfeedback.FirstOrDefault(x => x.inquiryid == tblinquiry.inquiryid);
TempData["feedback"] = tblinquiry.inquiryid;
if (tblinquiry == null)
{
return(HttpNotFound());
}
return(View(tblinquiry));
}
public ActionResult IeltsLogs(tblfeedback feed)
{
feed.date = System.DateTime.Now;
feed.type = "Days";
feed.nextfollow = System.DateTime.Now.AddDays(feed.days);
if (feed.days > 0)
{
feed.status = true;
}
else
{
feed.status = false;
}
feed.loginid = help.Teacher();
db.tblfeedback.Add(feed);
db.SaveChanges();
TempData["Success"] = "Logs Submitted Sucessfully";
return(RedirectToAction("IeltsLogs", "Consoller", new { id = feed.inquiryid }));
}
/// <summary>
/// code to insert feedback
/// </summary>
/// <param name="feedbck"></param>
/// <returns></returns>
public static int feedback(tblfeedback feedbck)
{
try
{
using (var objdata = new HavanadataclassesDataContext())
{
feedbck.Crdt = DateTime.Now;
feedbck.Updt = DateTime.Now;
feedbck.IsActive = true;
objdata.tblfeedbacks.InsertOnSubmit(feedbck);
objdata.SubmitChanges();
return(1);
}
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// code to delete feedbacks....
/// </summary>
/// <param name="ids"></param>
/// <returns></returns>
public static int DeleteFeedbacks(int ids)
{
try
{
using (var objdata = new HavanadataclassesDataContext())
{
tblfeedback fdbck = objdata.tblfeedbacks.Where(x => x.Id == ids).FirstOrDefault();
if (fdbck != null)
{
fdbck.IsActive = false;
}
objdata.SubmitChanges();
return(1);
}
}
catch (Exception ex)
{
throw ex;
}
}
public ActionResult Create([Bind(Include = "Id,date,inquiryid,name,fname,contact,address,referedby,Categoryid")] tblinquiry tblinquiry, [Bind(Include = "Id,date,inquiryid,feedback,days,type,nexfollow,status,loginid")] tblfeedback tblfeedback, Helper Help)
{
//if (ModelState.IsValid)
//{
tblinquiry.status = true;
string a = User.IsInRole("Franchisee") ? help.Franchisee() : help.Receptionist();
tblinquiry inquiry = db.tblinquiries.FirstOrDefault();
if (inquiry == null)
{
tblinquiry.inquiryid = "101";
}
else
{
// var ab = db.tblinquiries.Where(x => x.status == true && x.franchid=a).Max(x => x.inquiryid);
string max = objsql.GetSingleValue("select inquiryid from tblinquiries where status='1' and franchid='" + a + "' and id=(select max(id) from tblinquiries)").ToString();
string neww = (Convert.ToInt32(max) + Convert.ToInt32(1)).ToString();
tblinquiry.inquiryid = neww;
}
tblinquiry.franchid = a;
db.tblinquiries.Add(tblinquiry);
db.SaveChanges();
TempData["Success"] = "Saved Successfully";
tblsms sms = db.tblsms.FirstOrDefault();
if (tblinquiry.contact != null)
{
if (sms != null)
{
string msg = "Dear, " + Convert.ToString(tblinquiry.name) + ". It was a pleasure to meet you, Thanks for your visit, and I hope to see you soon!";
string result = Help.apicall("http://sms.sms.officialsolutions.in/sendSMS?username="******"&message=" + msg + "&sendername=" + sms.Senderid + "&smstype=TRANS&numbers=" + tblinquiry.contact + "&apikey=" + sms.Api + "");
TempData["Success"] = "SMS Send Successfully";
}
}
//ViewBag.Categoryid = new SelectList(db.Categories, "Categoryid", "Name");
return(RedirectToAction("Index"));
//}
//return View(tblinquiry);
}
public ActionResult Edit([Bind(Include = "Id,date,inquiryid,name,fname,contact,address,referedby,Categoryid")] tblinquiry tblinquiry, [Bind(Include = "Id,date,inquiryid,feedback,days,type,nexfollow,status,loginid")] tblfeedback tblfeedback)
{
if (ModelState.IsValid)
{
db.Entry(tblinquiry).State = EntityState.Modified;
db.SaveChanges();
DateTime next = new DateTime();
if (tblfeedback.type == "Days")
{
next = System.DateTime.Now.AddDays(tblfeedback.days);
}
else
{
next = System.DateTime.Now;
}
tblfeedback.date = tblinquiry.date;
tblfeedback.inquiryid = tblinquiry.inquiryid;
tblfeedback.loginid = Session["User"].ToString();
tblfeedback.nextfollow = next;
db.Entry(tblfeedback).State = EntityState.Modified;
db.SaveChanges();
TempData["Success"] = "Updated Successfully";
return(RedirectToAction("Index"));
}
return(View(tblinquiry));
}
public ActionResult Create([Bind(Include = "Id,date,inquiryid,name,fname,contact,address,referedby,Categoryid,Type")] tblinquiry tblinquiry, [Bind(Include = "Id,date,inquiryid,feedback,days,type,nexfollow,status,loginid")] tblfeedback tblfeedback, Helper Help)
{
using (var transaction = db.Database.BeginTransaction())
{
{
try
{
if (ModelState.IsValid)
{
tblinquiry.status = true;
tblinquiry.Type = "Offline";
string a = User.IsInRole("Franchisee") ? help.Franchisee() : help.Receptionist();
tblinquiry inquiry = db.tblinquiries.FirstOrDefault();
if (inquiry == null)
{
tblinquiry.inquiryid = "101";
}
else
{
// var ab = db.tblinquiries.Where(x => x.status == true && x.franchid=a).Max(x => x.inquiryid);
string max = objsql.GetSingleValue("select inquiryid from tblinquiries where franchid='" + a + "' and id=(select max(id) from tblinquiries)").ToString();
string neww = (Convert.ToInt32(max) + Convert.ToInt32(1)).ToString();
tblinquiry.inquiryid = neww;
}
tblinquiry.franchid = a;
db.tblinquiries.Add(tblinquiry);
db.SaveChanges();
tblfeedback.date = tblinquiry.date;
tblfeedback.inquiryid = tblinquiry.inquiryid;
tblfeedback.nextfollow = tblinquiry.date.AddDays(tblfeedback.days);
tblfeedback.status = tblinquiry.status;
tblfeedback.loginid = help.Permission();
db.tblfeedback.Add(tblfeedback);
db.SaveChanges();
transaction.Commit();
TempData["Success"] = "Saved Successfully";
tblsms sms = db.tblsms.FirstOrDefault();
if (tblinquiry.contact != null)
{
if (sms != null)
{
string msg = "Dear " + Convert.ToString(tblinquiry.name) + ". It was a pleasure to meet you, and I’m so glad we got a chance to discuss what you’re looking. Thanks for your visit, and I hope to see you soon!";
string result = Help.apicall("http://sms.sms.officialsolutions.in/sendSMS?username="******"&message=" + msg + "&sendername=" + sms.Senderid + "&smstype=TRANS&numbers=" + tblinquiry.contact + "&apikey=" + sms.Api + "");
TempData["Success"] = "SMS Send Successfully";
}
}
ViewBag.Categoryid = new SelectList(db.Categories, "Categoryid", "Name");
return(RedirectToAction("Index"));
}
ViewBag.Categoryid = new SelectList(db.Categories, "Categoryid", "Name");
return(View(tblinquiry));
}
catch (DbEntityValidationException e)
{
transaction.Dispose();
transaction.Rollback();
foreach (var eve in e.EntityValidationErrors)
{
Console.WriteLine("Entity of type \"{0}\" in state \"{1}\" has the following validation errors:",
eve.Entry.Entity.GetType().Name, eve.Entry.State);
foreach (var ve in eve.ValidationErrors)
{
Console.WriteLine("- Property: \"{0}\", Error: \"{1}\"",
ve.PropertyName, ve.ErrorMessage);
}
}
throw;
}
}
}
}
public ActionResult feedback(tblfeedback fb)
{
de.tblfeedbacks.Add(fb);
de.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Create([Bind(Include = "Id,date,inquiryid,name,fname,contact,address,referedby,Categoryid,status")] tblinquiry tblinquiry, [Bind(Include = "Id,date,inquiryid,feedback,days,type,nexfollow,status,loginid")] tblfeedback tblfeedback)
{
if (ModelState.IsValid)
{
tblinquiry inquiry = db.tblinquiries.FirstOrDefault();
if (inquiry == null)
{
tblinquiry.inquiryid = "I_101";
}
else
{
var ab = db.tblinquiries.Max(x => x.inquiryid);
string [] vall = ab.Split('_');
string neww = (Convert.ToInt32(vall[1].ToString()) + 1).ToString();
tblinquiry.inquiryid = "I_" + neww;
}
tblinquiry.status = true;
db.tblinquiries.Add(tblinquiry);
db.SaveChanges();
// tblfeedback feedback = new tblfeedback();
DateTime next = new DateTime();
if (tblfeedback.type == "Days")
{
next = System.DateTime.Now.AddDays(tblfeedback.days);
// System.DateTime.Now.AddDays(Convert.ToInt32(days)).ToString("MM/dd/yyyy");
}
//else if (option == "Month")
//{
// next = System.DateTime.Now.AddMonths(days);
//}
//else if (option == "Year")
//{
// next = System.DateTime.Now.AddYears(days);
//}
else
{
next = System.DateTime.Now;
}
tblfeedback.date = tblinquiry.date;
tblfeedback.inquiryid = tblinquiry.inquiryid;
tblfeedback.loginid = Session["User"].ToString();
tblfeedback.status = "Active";
tblfeedback.nextfollow = next;
db.tblfeedback.Add(tblfeedback);
db.SaveChanges();
TempData["Success"] = "Saved Successfully";
return(RedirectToAction("Index"));
}
return(View(tblinquiry));
}
