public ActionResult Create([Bind(Include = "VersionId,BuidDate,Version,UpdateMessage,Notes")] tblAppVersion tblAppVersion)
{
if (ModelState.IsValid)
{
db.tblAppVersions.Add(tblAppVersion);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(tblAppVersion));
}
public JsonResult UpdateToken(long UserId, string SenderId)
{
var User = db.tblAppLogins.Where(x => x.Id == UserId).Select(y => y).SingleOrDefault();
User.SenderId = SenderId;
db.Entry(User).State = EntityState.Modified;
db.SaveChanges();
return(Json(new { status = true }, JsonRequestBehavior.AllowGet));
}
public JsonResult SaveAttendance(long OrgId, string StudentId, string scanDateTime, bool IsPicUp)
{
string Status = string.Empty;
string message = string.Empty;
try
{
var datee = ConvertToDateTime(scanDateTime);
string[] arrlong = StudentId.Split(',');
foreach (var temp in arrlong)
{
DbContext.tblAttendanceHourlies.Add(new tblAttendanceHourly()
{
StudentId = Convert.ToInt64(temp),
IsPickUp = IsPicUp,
Time = new TimeSpan(datee.Hour, datee.Minute, datee.Second),
Date = new DateTime(datee.Year, datee.Month, datee.Day),
OrgId = OrgId
});
DbContext.SaveChanges();
var Student = DbContext.tblStudents.Where(x => x.Id.ToString() == StudentId).Select(y => y).FirstOrDefault();
string Number = "+91" + Student.ContactNo;
string Username = "******";
string Password = "******";
string Source = "SSGBLR";
if (IsPicUp == true)
{
Status = "Pickedup";
}
if (IsPicUp == false)
{
Status = "Dropped";
}
string Content = "Its Here By To Notify Your Kid Master. " + Student.FirstName + " " + Student.MiddleName + " " + Student.LastName + " " + "Has " + Status;
string strUrl = "http://103.16.101.52:8080/sendsms/bulksms?username="******"&password="******"&type=0&dlr=1&destination=" + Number + "&source=" + Source + "&message=" + Content;
HttpWebRequest _createRequest = (HttpWebRequest)WebRequest.Create(strUrl);
HttpWebResponse response = (HttpWebResponse)_createRequest.GetResponse();
Stream s = (Stream)response.GetResponseStream();
StreamReader readStream = new StreamReader(s);
string dataString = readStream.ReadToEnd();
response.Close();
s.Close();
readStream.Close();
}
return(Json(new { status = true }, JsonRequestBehavior.AllowGet));
}
catch (Exception e)
{
return(Json(new { status = false, message = e.ToString() }, JsonRequestBehavior.AllowGet));
}
}
public JsonResult VerifyLogin(string Username, string Password)
{
webSchoolContext db = new webSchoolContext();
db.tblAppLogins.Add(new tblAppLogin()
{
Email = Username,
Password = Password
});
db.SaveChanges();
return(Json("Saved Successfully", JsonRequestBehavior.AllowGet));
}
public JsonResult UpdateRouteLocation(long Routecode, long OrgId, string Lattitude, string Longitude)
{
try
{
var datee = DateTime.Now;
db.tblGPSDatas.Add(new tblGPSData()
{
RouteCode = Routecode,
OrgId = OrgId,
Latitude = float.Parse(Lattitude),
Longitude = float.Parse(Longitude),
Time = new DateTime(datee.Year, datee.Month, datee.Day, datee.Hour, datee.Minute, datee.Second)
});
db.SaveChanges();
return(Json("Saved Successfully", JsonRequestBehavior.AllowGet));
}
catch (Exception e)
{
return(Json(e.ToString(), JsonRequestBehavior.AllowGet));
}
}
public JsonResult SaveAttendance(long OrgId, string StudentId, string scanDateTime, bool IsCheckIn)
{
try
{
DuplicateAttendance DuplicateAttendanceObj = new DuplicateAttendance();
var datee = ConvertToDateTime(scanDateTime);
var NowDate = new DateTime(datee.Year, datee.Month, datee.Day);
string[] arrlong = null;
if (StudentId.Contains(','))
{
arrlong = StudentId.Split(',');
}
else
{
arrlong = new string[] { StudentId };
}
DuplicateAttendanceObj.DuplicatesList = new List <Dupicates>();
if (IsCheckIn == true)
{
foreach (var temp in arrlong)
{
long StudId = Convert.ToInt64(temp);
var DuplicateCheckIn = DbContext.tblAttendanceHourlies.Where(x => x.OrgId == OrgId && x.StudentId == StudId && x.Date == NowDate && x.IsAttendance == true).OrderByDescending(x => x.Time).Take(1).Select(y => y).FirstOrDefault();
if (DuplicateCheckIn == null || DuplicateCheckIn.IsPickUp == false)
{
DbContext.tblAttendanceHourlies.Add(new tblAttendanceHourly()
{
StudentId = Convert.ToInt64(temp),
IsPickUp = IsCheckIn,
IsAttendance = true,
Time = new TimeSpan(datee.Hour, datee.Minute, datee.Second),
Date = new DateTime(datee.Year, datee.Month, datee.Day),
OrgId = OrgId
});
DbContext.SaveChanges();
}
else
{
var StudnetDuplicate = new Dupicates();
DuplicateAttendanceObj.DuplicatesList.Add(StudnetDuplicate);
StudnetDuplicate.StudentId = Convert.ToInt64(temp);
DuplicateAttendanceObj.ReasonDuplicate = "Already Checked In";
}
}
return(Json(new { status = true, DuplicateAttendanceObj }, JsonRequestBehavior.AllowGet));
}
else
{
foreach (var temp in arrlong)
{
long StudId = Convert.ToInt64(temp);
var Dup = DbContext.tblAttendanceHourlies.Where(x => x.OrgId == OrgId && x.StudentId == StudId && x.Date == NowDate && x.IsAttendance == true && x.IsPickUp == true).OrderByDescending(x => x.Time).Take(1).Select(y => y).FirstOrDefault();
if (Dup != null)
{
var d = new TimeSpan(Dup.Time.Hours, Dup.Time.Minutes, Dup.Time.Seconds);
var e = new TimeSpan(datee.Hour, datee.Minute, datee.Second);
TimeSpan f = e.Subtract(d);
if (f.Hours >= 2)
{
DbContext.tblAttendanceHourlies.Add(new tblAttendanceHourly()
{
StudentId = Convert.ToInt64(temp),
IsPickUp = IsCheckIn,
IsAttendance = true,
Time = new TimeSpan(datee.Hour, datee.Minute, datee.Second),
Date = new DateTime(datee.Year, datee.Month, datee.Day),
OrgId = OrgId
});
DbContext.SaveChanges();
}
else
{
var StudnetDuplicate = new Dupicates();
DuplicateAttendanceObj.DuplicatesList.Add(StudnetDuplicate);
StudnetDuplicate.StudentId = Convert.ToInt64(temp);
DuplicateAttendanceObj.ReasonDuplicate = "Below 2 Hrs Checkin";
}
}
else
{
var StudnetDuplicate = new Dupicates();
DuplicateAttendanceObj.DuplicatesList.Add(StudnetDuplicate);
StudnetDuplicate.StudentId = Convert.ToInt64(temp);
DuplicateAttendanceObj.ReasonDuplicate = "Not Checkin can't CheckOut";
}
}
return(Json(new { status = true, DuplicateAttendanceObj }, JsonRequestBehavior.AllowGet));
}
}
catch (Exception e)
{
return(Json(new { status = false, message = e.ToString() }, JsonRequestBehavior.AllowGet));
}
}
public JsonResult SendEmailVerificationCode(string Email)
{
try
{
string message = string.Empty;
var HasStudent = db.tblStudents.Where(x => x.FatherEmail == Email || x.MotherEmail == Email).Select(u => u.StudentId).ToList();
if (HasStudent.Count != 0)
{
var HasDuplicate = db.tblAppLogins.Where(x => x.Email == Email && x.IsRegistered == true).Select(x => new { x.Email }).SingleOrDefault();
if (HasDuplicate == null)
{
var Duplicate = db.tblAppLogins.Where(x => x.Email == Email).SingleOrDefault();
if (Duplicate == null)
{
tblAppLoginobj.Email = Email;
string Alphabet = "ABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789";
Random rand = new Random();
int size = 6;
StringBuilder Passcode = new StringBuilder();
char[] chars = new char[size];
for (int i = 0; i < size; i++)
{
chars[i] = Alphabet[rand.Next(Alphabet.Length)];
Passcode.Append(chars[i]);
}
tblAppLoginobj.IsRegistered = false;
tblAppLoginobj.Passcode = Passcode.ToString();
db.tblAppLogins.Add(tblAppLoginobj);
db.SaveChanges();
string Body = "<html><body> Hi there! <br /><br /> Your Verification Code is:" + Passcode + "</body></html>";
string subject = "Verification Code";
EmailHelper.TrySendEmail(subject, Body, Email);
return(Json(new { status = true }, JsonRequestBehavior.AllowGet));
}
else
{
string Alphabet = "ABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789";
Random rand = new Random();
int size = 6;
StringBuilder Passcode = new StringBuilder();
char[] chars = new char[size];
for (int i = 0; i < size; i++)
{
chars[i] = Alphabet[rand.Next(Alphabet.Length)];
Passcode.Append(chars[i]);
}
tblAppLoginobj.IsRegistered = false;
Duplicate.Passcode = Passcode.ToString();
tblAppLoginobj.Passcode = Passcode.ToString();
db.Entry(Duplicate).State = EntityState.Modified;
db.SaveChanges();
string Body = "<html><body> Hi there! <br /><br /> Your Verification Code is:" + Passcode + "</body></html>";
string subject = "Verification Code";
EmailHelper.TrySendEmail(subject, Body, Email);
return(Json(new { status = true }, JsonRequestBehavior.AllowGet));
}
}
else
{
message = string.Format("Already Registered!");
return(Json(new { status = false, Message = message }, JsonRequestBehavior.AllowGet));
}
}
else
{
message = string.Format("Email Not Saved As Parents Email");
return(Json(new { status = false, Message = message }, JsonRequestBehavior.AllowGet));
}
}
catch (Exception e)
{
return(Json(new { status = false, Message = e.ToString() }, JsonRequestBehavior.AllowGet));
}
}
