public ActionResult DeleteConfirmed(int id)
{
tblsms tblsms = db.tblsms.Find(id);
db.tblsms.Remove(tblsms);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Edit([Bind(Include = "id,Username,Senderid,Type,Api,alertno,Status")] tblsms tblsms)
{
if (ModelState.IsValid)
{
db.Entry(tblsms).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(tblsms));
}
public ActionResult Create([Bind(Include = "id,Username,Senderid,Type,Api,alertno,Status")] tblsms tblsms)
{
if (ModelState.IsValid)
{
db.tblsms.Add(tblsms);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(tblsms));
}
// GET: Auth/SMS/Delete/5
public ActionResult Delete(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
tblsms tblsms = db.tblsms.Find(id);
if (tblsms == null)
{
return(HttpNotFound());
}
return(View(tblsms));
}
public void sendsms(string phone, string Message)
{
tblsms sms = new tblsms();
sms = db.tblsms.FirstOrDefault();
if (sms != null)
{
if (phone != null)
{
string msg = Message;
string result = apicall("http://sms.sms.officialsolutions.in/sendSMS?username="******"&message=" + msg + "&sendername=" + sms.Senderid + "&smstype=TRANS&numbers=" + phone + "&apikey=" + sms.Api + "");
}
}
}
public ActionResult SMS(int id, Helper Help)
{
tblstudentdata ss = db.tblstudentdata.FirstOrDefault(x => x.rollno == id);
Fees_Master fm = db.Fees_Master.FirstOrDefault(x => x.RollNo == id);
tblsms sms = db.tblsms.FirstOrDefault();
float pending = fm.TotalFees - fm.PaidFees;
if (ss.phone != null)
{
string msg = "Dear, " + Convert.ToString(ss.name) + ". Reminder That Your Course Fee is still Due Rs." + pending + ". Thanks for Joining Us. visit www.englishtreemoga.com.";
string result = Help.apicall("http://sms.officialsolutions.in/sendSMS?username="******"&message=" + msg + "&sendername=" + sms.Senderid + "&smstype=TRANS&numbers=" + ss.phone + "&apikey=" + sms.Api + "");
TempData["Success"] = "SMS Send Successfully";
}
return(RedirectToAction("Index"));
}
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 Create([Bind(Include = "Type")] Recipt_Details receiptdetail, int Amount, int Discount, int CourseId, DateTime?Alert, DateTime date, Helper Help)
{
using (TransactionScope ts = new TransactionScope())
{
try
{
DateTime today = System.DateTime.Now;
DataTable dt = objsql.GetTable("select * from expenselocks where lockdate='" + today + "'");
if (dt.Rows.Count > 0)
{
TempData["danger"] = "Sorry DayEnd";
return(View());
}
else
{
string franchid = help.Permission();
tblreceptionist re = db.tblreceptionists.FirstOrDefault(x => x.rid == franchid);
if (re.StartTime != null || re.EndTime != null)
{
if (help.Checklock() == true)
{
#region data
string a = User.IsInRole("Franchisee") ? help.Franchisee() : help.Receptionist();
// TODO: Add insert logic here
Fees_Master feesmaster = db.Fees_Master.FirstOrDefault(x => x.RollNo == rollno && x.franchid == a && x.Status == true && x.CourseId == CourseId);
int pending = (Convert.ToInt32(feesmaster.TotalFees) - Convert.ToInt32(feesmaster.PaidFees));
if (feesmaster.PaidFees < feesmaster.TotalFees)
{
#region condition greater than
feesmaster.discount = (Convert.ToInt32(feesmaster.discount) + Convert.ToInt32(Discount));
feesmaster.Date = date;
feesmaster.AlertDate = Alert;
feesmaster.PaidFees += Amount;
feesmaster.Status = true;
db.Entry(feesmaster).State = EntityState.Modified;
db.SaveChanges();
receiptdetail.RollNo = rollno;
receiptdetail.ReciptNo = receiptno;
receiptdetail.discount = Discount;
receiptdetail.CourseId = CourseId;
receiptdetail.Date = date;
receiptdetail.role = HttpContext.User.Identity.Name;
receiptdetail.Amount = Amount;
receiptdetail.Active = true;
receiptdetail.franchid = User.IsInRole("Franchisee") ? Help.Franchisee() : Help.Receptionist();
db.Recipt_Details.Add(receiptdetail);
db.SaveChanges();
TempData["roll"] = rollno;
ViewData["Receipt"] = recp1;
TempData["Success"] = "Saved Successfully";
tblsms sms = db.tblsms.FirstOrDefault();
tblstudentdata ss = db.tblstudentdata.FirstOrDefault(x => x.rollno == rollno);
if (ss.phone != null)
{
if (sms != null)
{
string msg = "Dear, " + Convert.ToString(ss.name) + ". Thank You for Deposit Rs." + Amount + ". Thanks for Joining Us.";
string result = Help.apicall("http://sms.sms.officialsolutions.in/sendSMS?username="******"&message=" + msg + "&sendername=" + sms.Senderid + "&smstype=TRANS&numbers=" + ss.phone + "&apikey=" + sms.Api + "");
}
TempData["Success"] = "SMS Send Successfully";
}
StudentCourse course = db.StudentCourses.Where(x => x.RollNo == rollno && x.Status == true).FirstOrDefault();
var courses = db.Courses.Where(x => x.CourseId == course.CourseId);
ViewBag.CourseId = new SelectList(courses, "CourseId", "CourseName");
ts.Complete();
ts.Dispose();
return(RedirectToAction("invoice", new { id = receiptno }));
#endregion
}
else
{
TempData["danger"] = "Please Check Amount First";
return(View());
}
#endregion
}
else
{
TempData["danger"] = "Sorry DayEnd";
return(View());
}
}
else
{
#region data
string a = User.IsInRole("Franchisee") ? help.Franchisee() : help.Receptionist();
// TODO: Add insert logic here
Fees_Master feesmaster = db.Fees_Master.FirstOrDefault(x => x.RollNo == rollno && x.franchid == a && x.Status == true && x.CourseId == CourseId);
int pending = (Convert.ToInt32(feesmaster.TotalFees) - Convert.ToInt32(feesmaster.PaidFees));
if (feesmaster.PaidFees < feesmaster.TotalFees)
{
#region condition greater than
feesmaster.discount = (Convert.ToInt32(feesmaster.discount) + Convert.ToInt32(Discount));
feesmaster.Date = date;
feesmaster.AlertDate = Alert;
feesmaster.PaidFees += Amount;
feesmaster.Status = true;
db.Entry(feesmaster).State = EntityState.Modified;
db.SaveChanges();
receiptdetail.RollNo = rollno;
receiptdetail.ReciptNo = receiptno;
receiptdetail.discount = Discount;
receiptdetail.CourseId = CourseId;
receiptdetail.Date = date;
receiptdetail.Amount = Amount;
receiptdetail.Active = true;
receiptdetail.franchid = User.IsInRole("Franchisee") ? Help.Franchisee() : Help.Receptionist();
db.Recipt_Details.Add(receiptdetail);
db.SaveChanges();
TempData["roll"] = rollno;
ViewData["Receipt"] = recp1;
TempData["Success"] = "Saved Successfully";
tblsms sms = db.tblsms.FirstOrDefault();
tblstudentdata ss = db.tblstudentdata.FirstOrDefault(x => x.rollno == rollno);
if (ss.phone != null)
{
if (sms != null)
{
string msg = "Dear " + Convert.ToString(ss.name) + ". Thank You for Deposit Rs." + Amount + ". Thanks for Joining Us.";
string result = Help.apicall("http://sms.sms.officialsolutions.in/sendSMS?username="******"&message=" + msg + "&sendername=" + sms.Senderid + "&smstype=TRANS&numbers=" + ss.phone + "&apikey=" + sms.Api + "");
}
TempData["Success"] = "SMS Send Successfully";
}
StudentCourse course = db.StudentCourses.Where(x => x.RollNo == rollno && x.Status == true).FirstOrDefault();
var courses = db.Courses.Where(x => x.CourseId == course.CourseId);
ViewBag.CourseId = new SelectList(courses, "CourseId", "CourseName");
ts.Complete();
ts.Dispose();
return(RedirectToAction("invoice", new { id = receiptno }));
#endregion
}
else
{
TempData["danger"] = "Please Check Amount First";
return(View());
}
#endregion
}
}
}
catch (Exception a)
{
return(View());
}
}
}
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;
}
}
}
}
