public IHttpActionResult SaveGps(string Latitude, string Longitude, int deviceid, string devicename)
{
try
{
using (kernels1_itiEntities DB = new kernels1_itiEntities())
{
DATA.VehicleTracking gps = new VehicleTracking();
gps.Latitude = Latitude;
gps.Longitude = Longitude;
gps.deviceid = deviceid;
gps.DeviceTime = devicename;
TimeZoneInfo timeZoneInfo = TimeZoneInfo.FindSystemTimeZoneById("India Standard Time");
DateTime timeUtc = DateTime.UtcNow;
DateTime result = TimeZoneInfo.ConvertTimeFromUtc(timeUtc, timeZoneInfo);
gps.updatedDate = result;
DB.VehicleTrackings.Add(gps);
DB.SaveChanges();
}
var response = new
{
Success = true,
Message = "GPS Coorinates saved Successfully",
};
return(Ok(response));
}
catch (Exception)
{
return(Content(HttpStatusCode.BadRequest, "Error Found"));
}
}
public IHttpActionResult SaveEnergy(decimal v, decimal c, decimal pf, decimal f, int deviceid, string devicename)
{
try
{
using (kernels1_itiEntities DB = new kernels1_itiEntities())
{
DATA.SmartEnergy se = new SmartEnergy();
se.voltage = v;
se.currentamp = c;
se.frequency = f;
se.powerfactor = pf;
se.updatedDate = DateTime.UtcNow;
se.deviceid = deviceid;
se.devicename = devicename;
DB.SmartEnergies.Add(se);
DB.SaveChanges();
}
var response = new
{
Success = true,
Message = "Energy data posted",
};
return(Ok(response));
}
catch (Exception ex)
{
return(Content(HttpStatusCode.BadRequest, "Error Found"));
}
}
public IHttpActionResult SaveElectricity(decimal v, decimal c, decimal units, int deviceid, string devicename)
{
try
{
using (kernels1_itiEntities DB = new kernels1_itiEntities())
{
BiharITI.DATA.ElectricityMeter se = new ElectricityMeter();
se.voltage = v;
se.currentamp = c;
se.Units = units;
TimeZoneInfo timeZoneInfo = TimeZoneInfo.FindSystemTimeZoneById("India Standard Time");
DateTime timeUtc = DateTime.UtcNow;
DateTime result = TimeZoneInfo.ConvertTimeFromUtc(timeUtc, timeZoneInfo);
se.updatedDate = result;
se.deviceid = deviceid;
se.devicename = devicename;
DB.ElectricityMeters.Add(se);
DB.SaveChanges();
}
var response = new
{
Success = true,
Message = "Electricity data saved",
};
return(Ok(response));
}
catch (Exception ex)
{
return(Content(HttpStatusCode.BadRequest, "Error Found"));
}
}
public IHttpActionResult SaveGps(string Latitude, string Longitude)
{
try
{
using (kernels1_itiEntities DB = new kernels1_itiEntities())
{
DATA.GP gps = new GP();
gps.lat = Latitude;
gps.longitude = Longitude;
gps.updatedDate = DateTime.UtcNow;
gps.deviceid = "1";
DB.GPS.Add(gps);
DB.SaveChanges();
}
var response = new
{
Success = true,
Message = "GPS Coorinates saved Successfully",
};
return(Ok(response));
}
catch (Exception)
{
return(Content(HttpStatusCode.BadRequest, "Error Found"));
}
}
public IHttpActionResult SaveElecMeter(int v, int c, int u)
{
try
{
using (kernels1_itiEntities DB = new kernels1_itiEntities())
{
DATA.SmartElectricityMeter sem = new SmartElectricityMeter();
sem.Voltage = v;
sem.CurrentValue = c;
sem.Units = u;
sem.updatedDate = DateTime.UtcNow;
sem.deviceid = 1;
DB.SmartElectricityMeters.Add(sem);
DB.SaveChanges();
}
var response = new
{
Success = true,
Message = "Elect Meter data posted",
};
return(Ok(response));
}
catch (Exception)
{
return(Content(HttpStatusCode.BadRequest, "Error Found"));
}
}
public IHttpActionResult SaveTemperature(decimal temp, decimal faht, int deviceid, string devicename)
{
try
{
using (kernels1_itiEntities DB = new kernels1_itiEntities())
{
BiharITI.DATA.Temperature se = new Temperature();
se.temp = temp;
se.faht = faht;
TimeZoneInfo timeZoneInfo = TimeZoneInfo.FindSystemTimeZoneById("India Standard Time");
DateTime timeUtc = DateTime.UtcNow;
DateTime result = TimeZoneInfo.ConvertTimeFromUtc(timeUtc, timeZoneInfo);
se.updatedDate = result;
se.deviceid = deviceid;
se.devicename = devicename;
DB.Temperatures.Add(se);
DB.SaveChanges();
}
var response = new
{
Success = true,
Message = "Temperature data posted",
};
return(Ok(response));
}
catch (Exception ex)
{
return(Content(HttpStatusCode.BadRequest, "Error Found"));
}
}
public ActionResult Login(string Username, string Password, bool?IsRememberMe)
{
try
{
using (kernels1_itiEntities DB = new kernels1_itiEntities())
{
IsRememberMe = IsRememberMe == null ? false : (bool)IsRememberMe;
var user = DB.Users.FirstOrDefault(x => x.Username == Username && x.Password == Password);
if (user != null)
{
UserDetails userDetails = new UserDetails();
userDetails.UserID = user.UserID;
// userDetails.DisplayName = user.FullName;
Response.SetAuthCookie(userDetails.UserID.ToString(), (bool)IsRememberMe, userDetails);
return(RedirectToAction("Index", "Home"));
}
else
{
ViewBag.Error = "Error";
}
}
}
catch (Exception Ex)
{
ViewBag.error = Ex.Message;
}
return(View());
}
public IHttpActionResult SaveFingerprintID(int fingerID, string message, int deviceid, string devicename)
{
try
{
using (kernels1_itiEntities DB = new kernels1_itiEntities())
{
DATA.attendance attendance = new attendance();
attendance.deviceid = deviceid;
attendance.devicename = devicename;
attendance.fingerid = fingerID;
attendance.message = message;
TimeZoneInfo timeZoneInfo = TimeZoneInfo.FindSystemTimeZoneById("India Standard Time");
DateTime timeUtc = DateTime.UtcNow;
DateTime result = TimeZoneInfo.ConvertTimeFromUtc(timeUtc, timeZoneInfo);
attendance.updatedDate = result;
// var status = DB.attendances.ToList().Where(x=>x.deviceid==deviceid).OrderByDescending(x=>x.id).Take(1);
var latesttime_fingerId = (from a in DB.attendances
where a.fingerid == fingerID
select a)
.OrderByDescending(x => x.id)
.Take(1)
.Select(x => x.updatedDate).FirstOrDefault();
var lateststatus_fingerid = (from a in DB.attendances
where a.fingerid == fingerID
select a)
.OrderByDescending(x => x.id)
.Take(1)
.Select(x => x.status).FirstOrDefault();
DateTime latesttime = Convert.ToDateTime(latesttime_fingerId);
if (latesttime.Day == result.Day && lateststatus_fingerid == "IN")
{
attendance.status = "OUT";
}
else if (latesttime.Day < result.Day)
{
attendance.status = "IN";
}
else
{
attendance.status = "INVALID";
}
DB.attendances.Add(attendance);
DB.SaveChanges();
}
var response = new
{
Success = true,
Message = "attendance saved",
};
return(Ok(response));
}
catch (Exception Ex)
{
return(Content(HttpStatusCode.BadRequest, "Error Found"));
}
}
/// <summary>
/// Get Employee With Id
/// </summary>
/// <param name="Id"></param>
/// <returns></returns>
public JsonResult Get_EmployeeById(string Id)
{
using (kernels1_itiEntities Obj = new kernels1_itiEntities())
{
int EmpId = int.Parse(Id);
return(Json(Obj.Users.Find(EmpId), JsonRequestBehavior.AllowGet));
}
}
/// <summary>
///
/// Get All Employee
/// </summary>
/// <returns></returns>
public JsonResult Get_AllEmployee()
{
using (kernels1_itiEntities Obj = new kernels1_itiEntities())
{
List <User> Emp = Obj.Users.ToList();
return(Json(Emp, JsonRequestBehavior.AllowGet));
}
}
public ActionResult loaddata()
{
using (kernels1_itiEntities dc = new kernels1_itiEntities())
{
var data = dc.attendances.OrderBy(a => a.id).ToList();
return(Json(new
{
data = data
}, JsonRequestBehavior.AllowGet));
}
}
/// <summary>
/// Insert New Employee
/// </summary>
/// <param name="Employe"></param>
/// <returns></returns>
public string Insert_Employee(User Employe)
{
if (Employe != null)
{
using (kernels1_itiEntities Obj = new kernels1_itiEntities())
{
Obj.Users.Add(Employe);
Obj.SaveChanges();
return("Employee Added Successfully");
}
}
else
{
return("Employee Not Inserted! Try Again");
}
}
/// <summary>
/// Update Employee Information
/// </summary>
/// <param name="Emp"></param>
/// <returns></returns>
public string Update_Employee(User Emp)
{
if (Emp != null)
{
using (kernels1_itiEntities Obj = new kernels1_itiEntities())
{
var Emp_ = Obj.Entry(Emp);
User EmpObj = Obj.Users.Where(x => x.UserID == Emp.UserID).FirstOrDefault();
EmpObj.Username = Emp.Username;
EmpObj.Password = Emp.Password;
Obj.SaveChanges();
return("Employee Updated Successfully");
}
}
else
{
return("Employee Not Updated! Try Again");
}
}
public HttpResponseMessage GetSmartElectricityMeter()
{
try
{
var gpsJson = "";
using (kernels1_itiEntities DB = new kernels1_itiEntities())
{
var gps = DB.ElectricityMeters.ToList();
gpsJson = JsonConvert.SerializeObject(gps);
}
var response = this.Request.CreateResponse(HttpStatusCode.OK, gpsJson);
response.Content = new StringContent(gpsJson, Encoding.UTF8, "application/json");
return(response);
}
catch (Exception ex)
{
return(Request.CreateResponse(HttpStatusCode.InternalServerError));
}
}
/// <summary>
/// Delete Employee Information
/// </summary>
/// <param name="Emp"></param>
/// <returns></returns>
public string Delete_Employee(User Emp)
{
if (Emp != null)
{
using (kernels1_itiEntities Obj = new kernels1_itiEntities())
{
var Emp_ = Obj.Entry(Emp);
if (Emp_.State == System.Data.Entity.EntityState.Detached)
{
Obj.Users.Attach(Emp);
Obj.Users.Remove(Emp);
}
Obj.SaveChanges();
return("Employee Deleted Successfully");
}
}
else
{
return("Employee Not Deleted! Try Again");
}
}
public ActionResult Index()
{
var watch = System.Diagnostics.Stopwatch.StartNew();
// the code that you want to measure comes here
using (kernels1_itiEntities dc = new kernels1_itiEntities())
{
var data = dc.attendances.OrderByDescending(a => a.id).ToList().Take(1).SingleOrDefault();
string attandance_Status = data.status;
int? attenance_fingerid = data.fingerid;
ViewBag.attendance_Status = attandance_Status;
ViewBag.attendance_fingerid = attenance_fingerid;
DateTime dt = DateTime.ParseExact(data.updatedDate.ToString(), "M/d/yyyy h:m:s tt", CultureInfo.InvariantCulture);
ViewBag.attendance_time = dt.ToString("h:m:s tt", CultureInfo.InvariantCulture);
ViewBag.attendance_date = dt.ToString("d-MM-yyyy", CultureInfo.InvariantCulture);
//electricity data
var Electricity_data = dc.ElectricityMeters.OrderByDescending(a => a.id).ToList().Take(1).SingleOrDefault();
ViewBag.Electric_Meter_Voltage = Electricity_data.voltage;
ViewBag.Electric_Meter_Current = Electricity_data.currentamp;
ViewBag.Electric_Meter_units = Electricity_data.Units;
DateTime Electric_time = DateTime.ParseExact(Electricity_data.updatedDate.ToString(), "MM/d/yyyy h:m:s tt", CultureInfo.InvariantCulture);
ViewBag.Electric_Meter_time = Electric_time.ToString("h:m:s tt", CultureInfo.InvariantCulture);
ViewBag.Electric_Meter_date = Electric_time.ToString("d-M-yyyy", CultureInfo.InvariantCulture);
//smart energy
var Smartenergy_data = dc.SmartEnergies.OrderByDescending(a => a.id).ToList().Take(1).SingleOrDefault();
ViewBag.Smartenergy_Voltage = Smartenergy_data.voltage;
ViewBag.Smartenergy_Current = Smartenergy_data.currentamp;
ViewBag.Smartenergy_units = Smartenergy_data.frequency;
ViewBag.Smartenergy_powerfactor = Smartenergy_data.powerfactor;
DateTime Smartenergy_time = DateTime.ParseExact(Smartenergy_data.updatedDate.ToString(), "MM/d/yyyy h:m:s tt", CultureInfo.InvariantCulture);
ViewBag.Smartenergy_time = Smartenergy_time.ToString("h:m:s tt", CultureInfo.InvariantCulture);
ViewBag.Smartenergy_date = Smartenergy_time.ToString("d-M-yyyy", CultureInfo.InvariantCulture);
//smart temperature
var SmartTemperature_data = dc.Temperatures.OrderByDescending(a => a.id).ToList().Take(1).SingleOrDefault();
ViewBag.SmartTemperature_Temp = SmartTemperature_data.temp;
ViewBag.SmartTemperature_faht = SmartTemperature_data.faht;
DateTime Smarttemptime = DateTime.ParseExact(SmartTemperature_data.updatedDate.ToString(), "MM/d/yyyy h:m:s tt", CultureInfo.InvariantCulture);
ViewBag.SmartTemperature_time = Smarttemptime.ToString("h:m:s tt", CultureInfo.InvariantCulture);
ViewBag.SmartTemperature_date = Smarttemptime.ToString("d-M-yyyy", CultureInfo.InvariantCulture);
//Vehicle tracker
var SmartTracker_data = dc.VehicleTrackings.OrderByDescending(a => a.id).ToList().Take(1).SingleOrDefault();
ViewBag.SmartTracker_lat = SmartTracker_data.Latitude;
ViewBag.SmartTracker_long = SmartTracker_data.Longitude;
DateTime SmartVehclletracker = DateTime.ParseExact(SmartTracker_data.updatedDate.ToString(), "MM/d/yyyy h:m:s tt", CultureInfo.InvariantCulture);
ViewBag.SmartTracker_time = SmartVehclletracker.ToString("h:m:s tt", CultureInfo.InvariantCulture);
ViewBag.SmartTracker_date = SmartVehclletracker.ToString("d-M-yyyy", CultureInfo.InvariantCulture);
watch.Stop();
var elapsedMs = watch.ElapsedMilliseconds;
ViewBag.executiontime = elapsedMs;
return(View());
}
}
