// GET api/<controller>/5
public string Get(int id)
{
GInfraEntities db = new GInfraEntities();
db.Database.ExecuteSqlCommand("exec deletedata " + id + "");
return("Done");
}
public ActionResult Forgotten(ForgetPortalModel _forget)
{
GInfraEntities db = new GInfraEntities();
if (_forget.Emailid == null || _forget.Emailid == "")
{
ViewBag.ErrorMsg = "Enter Valid EmailID";
}
else
{
string userid = db.EmployeeMasters.Where(a => a.EmpEmailId == _forget.Emailid).OrderByDescending(z => z.EmpEmailId).Take(1).Select(b => b.EmployeeId).DefaultIfEmpty("-").SingleOrDefault().ToString();
if (userid == "-" || userid == null)
{
ViewBag.ErrorMsg = "This EmailID does not exist";
}
else
{
var detail = (from p in db.EmployeeMasters
join o in db.MasterPasswords on p.EmployeeId equals o.UserID
where p.EmployeeId == userid
select new
{
password = o.UserPassword,
MemberName = p.EmpName,
Email = p.EmpEmailId,
}).SingleOrDefault();
string newpassword = CreatePassword(6);
int i = ApplyLeaveMail(_forget.Emailid, detail.MemberName, userid, detail.password);
if (i == 1)
{
//MasterPassword updatedCustomer = (from c in db.MasterPasswords
// where c.UserID == userid
// select c).FirstOrDefault();
//updatedCustomer.UserPassword = newpassword;
//int insertedRecords = db.SaveChanges();
//if(insertedRecords==1)
//{
ViewBag.ErrorMsg = "Hi " + detail.MemberName + ", Please Look into your Mail Inbox";
ModelState.Clear();
//}
}
else
{
ViewBag.ErrorMsg = "Something Wrong With your EmailID";
}
}
}
return(View("Forgotten"));
}
public ActionResult Index(ChangePassword chng)
{
GInfraEntities db = new GInfraEntities();
if ((chng.OldPassword == "" || chng.OldPassword == null) && (chng.NewPassword == "" || chng.NewPassword == null) && (chng.ConfirmPassword == "" || chng.ConfirmPassword == null))
{
ViewBag.ErrorMsg = "Please Fill All the fields";
}
else
{
if (chng.NewPassword == chng.ConfirmPassword)
{
string loginid = Session["LoginId"].ToString();
string userid = db.MasterPasswords.Where(x => x.UserID == loginid && x.UserPassword == chng.OldPassword).OrderByDescending(z => z.UserID).Take(1).Select(b => b.UserID).DefaultIfEmpty("-").SingleOrDefault().ToString();
if (userid != "-")
{
MasterPassword updatedCustomer = (from c in db.MasterPasswords
where c.UserID == loginid
select c).FirstOrDefault();
updatedCustomer.UserPassword = chng.ConfirmPassword;
int insertedRecords = db.SaveChanges();
if (insertedRecords == 1)
{
ViewBag.ErrorMsg = "Your password has been changed sucecssfully ";
ModelState.Clear();
}
else
{
ViewBag.ErrorMsg = "Something wrong";
}
}
else
{
ViewBag.ErrorMsg = "Old Password is Incorrect";
}
}
else
{
ViewBag.ErrorMsg = "Your Confirm Password Does not match";
}
}
return(View());
}
public ActionResult ActiveUser(string id)
{
string LoginId = Session["LoginId"].ToString();
if (LoginId == "" || LoginId == null)
{
return(RedirectToAction("LogOut", "LoginPortal"));
}
GInfraEntities GInfraEntities = new GInfraEntities();
GInfraEntities.sp_mobiledevice(id);
return(RedirectToAction("Index"));
}
public ActionResult Login(LoginPortalModel _login)
{
if (ModelState.IsValid) //validating the user inputs
{
bool isExist = false;
using (GInfraEntities _entity = new GInfraEntities()) // out Entity name is "EventManagementDB_Entities"
{
isExist = _entity.MasterPasswords.Where(x => x.UserID.Trim() == _login.UserId.Trim() && x.UserPassword == _login.password && x.isactive == true).Any(); //validating the user name in tblLogin table whether the user name is exist or not
if (isExist)
{
MasterPassword masterPassword = _entity.MasterPasswords.Where(x => x.UserID.Trim() == _login.UserId.Trim() && x.UserPassword == _login.password).FirstOrDefault();
//Get the Menu details from entity and bind it in MenuModels list.
FormsAuthentication.SetAuthCookie(_login.UserId.Trim(), false); // set the formauthentication cookie
Session["LoginId"] = _login.UserId;
if (masterPassword.Super == true)
{
Session["Role"] = "RL01";
}
else
{
if (masterPassword.Role == "RL04")
{
ViewBag.ErrorMsg = "UnAuthorized Credentials! Contact Super Admin";
return(View());
}
Session["Role"] = masterPassword.Role;
}
return(RedirectToAction("DashBoard", "DashBoard"));
}
else
{
ViewBag.ErrorMsg = "Please enter the Valid Credentials!...";
return(View());
}
}
}
return(View());
}
public bool ImportData()
{
var result = false;
try
{
string path = Server.MapPath("~/UploadFiles") + "\\attendance.xlsx";
FileInfo file = new FileInfo(path);
//var package = new ExcelPackage(new System.IO.FileInfo(path));
//int startColumn = 1;
//int startRow = 2;
//ExcelWorksheet workSheet = package.Workbook.Worksheets[0];
//object data = null;
GInfraEntities db = new GInfraEntities();
using (ExcelPackage package = new ExcelPackage(file))
{
ExcelWorksheet workSheet = package.Workbook.Worksheets["attendance"];
int totalRows = workSheet.Dimension.Rows;
for (int i = 3; i <= totalRows; i++)
{
BiometricAttendance biometric = new BiometricAttendance();
BiometricAttendance biometricCheck = new BiometricAttendance();
string EmployeeId = workSheet.Cells[i, 2].Value.ToString();
DateTime StartDate = Convert.ToDateTime(workSheet.Cells[i, 3].Value);
biometricCheck = db.BiometricAttendances.Where(x => x.EmployeeId == EmployeeId && x.StartDate == StartDate).FirstOrDefault();
if (biometricCheck == null)
{
biometric.EmployeeId = workSheet.Cells[i, 2].Value.ToString();
biometric.StartDate = Convert.ToDateTime(workSheet.Cells[i, 3].Value);
if (workSheet.Cells[i, 4].Value == null)
{
biometric.PunchInDate = null;
}
else
{
biometric.PunchInDate = Convert.ToDateTime(workSheet.Cells[i, 4].Value);
}
if (workSheet.Cells[i, 5].Value == null)
{
biometric.PunchInTime = null;
}
else
{
DateTime temp = Convert.ToDateTime(workSheet.Cells[i, 5].Value);
biometric.PunchInTime = temp.TimeOfDay;
}
if (workSheet.Cells[i, 6].Value == null)
{
biometric.PunchOutDate = null;
}
else
{
biometric.PunchOutDate = Convert.ToDateTime(workSheet.Cells[i, 6].Value);
}
if (workSheet.Cells[i, 7].Value == null)
{
biometric.PunchOutTime = null;
}
else
{
DateTime temp = Convert.ToDateTime(workSheet.Cells[i, 7].Value);
biometric.PunchOutTime = temp.TimeOfDay;
}
if (workSheet.Cells[i, 8].Value == null)
{
biometric.CustRegularized = null;
}
else
{
biometric.CustRegularized = workSheet.Cells[i, 8].Value.ToString();
}
db.BiometricAttendances.Add(biometric);
db.SaveChanges();
}
else
{
if (workSheet.Cells[i, 4].Value == null)
{
biometricCheck.PunchInDate = null;
}
else
{
DateTime temp = Convert.ToDateTime(workSheet.Cells[i, 4].Value);
if (biometricCheck.PunchInDate != null)
{
if (temp <= biometricCheck.PunchInDate)
{
biometricCheck.PunchInDate = temp;
}
}
else
{
biometricCheck.PunchInDate = temp;
}
}
if (workSheet.Cells[i, 5].Value == null)
{
biometricCheck.PunchInTime = null;
}
else
{
DateTime temp = Convert.ToDateTime(workSheet.Cells[i, 5].Value);
TimeSpan t = temp.TimeOfDay;
if (biometricCheck.PunchInTime != null)
{
if (t <= biometricCheck.PunchInTime)
{
biometricCheck.PunchInTime = temp.TimeOfDay;
}
}
else
{
biometricCheck.PunchInTime = temp.TimeOfDay;
}
}
if (workSheet.Cells[i, 6].Value == null)
{
biometricCheck.PunchOutDate = null;
}
else
{
DateTime temp = Convert.ToDateTime(workSheet.Cells[i, 6].Value);
if (biometricCheck.PunchOutDate != null)
{
if (temp >= biometricCheck.PunchOutDate)
{
biometricCheck.PunchOutDate = temp;
}
}
else
{
biometricCheck.PunchOutDate = temp;
}
}
if (workSheet.Cells[i, 7].Value == null)
{
biometricCheck.PunchOutTime = null;
}
else
{
DateTime temp = Convert.ToDateTime(workSheet.Cells[i, 7].Value);
TimeSpan t = temp.TimeOfDay;
if (biometricCheck.PunchOutTime != null)
{
if (t >= biometricCheck.PunchOutTime)
{
biometricCheck.PunchOutTime = temp.TimeOfDay;
}
}
else
{
biometricCheck.PunchOutTime = temp.TimeOfDay;
}
}
if (workSheet.Cells[i, 8].Value == null)
{
biometric.CustRegularized = null;
}
else
{
biometric.CustRegularized = workSheet.Cells[i, 8].Value.ToString();
}
db.SaveChanges();
}
}
}
}
catch (Exception)
{
}
return(result);
}
public async Task <HttpResponseMessage> PostFormData()
{
string foldername = DateTime.Now.ToString("dd-MM-yyyy");
GInfraEntities GInfraEntities = new GInfraEntities();
double Timestamp = new DateTimeOffset(DateTime.UtcNow).ToUnixTimeSeconds();
AttendenceInRequest request = new AttendenceInRequest();
AttendenceIn login = new AttendenceIn();
if (!Request.Content.IsMimeMultipartContent())
{
throw new HttpResponseException(HttpStatusCode.UnsupportedMediaType);
}
var provider = await Request.Content.ReadAsMultipartAsync <InMemoryMultipartFormDataStreamProvider>(new InMemoryMultipartFormDataStreamProvider());
try
{
//access form data
NameValueCollection formData = provider.FormData;
//access files
IList <HttpContent> files = provider.Files;
if (files.Count > 0)
{
HttpContent file1 = files[0];
var thisFileName = file1.Headers.ContentDisposition.FileName.Trim('\"');
string extension = Path.GetExtension(thisFileName);
thisFileName = "";
thisFileName = formData["UserId"] + "_PunchIN_" + DateTime.Now.ToString("yyyy-MMM-dd") + extension;
string filename = String.Empty;
Stream input = await file1.ReadAsStreamAsync();
string directoryName = String.Empty;
string URL = String.Empty;
string tempDocUrl = WebConfigurationManager.AppSettings["DocsUrl"];
var path = HttpRuntime.AppDomainAppPath;
directoryName = System.IO.Path.Combine(path, "ClientDocument\\" + foldername + "\\");
filename = System.IO.Path.Combine(directoryName, thisFileName);
string filepath1 = "/" + "ClientDocument" + "/" + foldername + "/" + thisFileName;
//Deletion exists file
//if (File.Exists(filename))
//{
// File.Delete(filename);
//}
string DocsPath = tempDocUrl + "/" + "ClientDocument" + "/" + foldername + "/";
URL = DocsPath + thisFileName;
// formData["Name"];
// await Request.Content.ReadAsMultipartAsync(provider);
request.AddressIn = formData["AddressIn"];
request.UserId = formData["UserId"];
request.HeadId = formData["HeadId"];
request.InTime = formData["InTime"];
request.AddressIn = formData["AddressIn"];
request.LattitudeIn = formData["LattitudeIn"];
request.LongitudeIn = formData["LongitudeIn"];
request.mode = formData["mode"];
request.PolygonIn = formData["PolygonIn"];
request.Filee = filepath1.ToString();
request.action = formData["action"].ToString();
if (request.InTime != "" && request.InTime != null && request.UserId != "" && request.UserId != null && request.PolygonIn != "" && request.PolygonIn != null &&
request.LattitudeIn != "" && request.LattitudeIn != null && request.LongitudeIn != "" && request.LongitudeIn != null
)
//if (request.InTime != "" && request.InTime != null)
{
DateTime dateTime = Convert.ToDateTime(DateTime.Now.ToString("yyyy-MM-dd"));
var k = GInfraEntities.InsertAttendanceIn(request.UserId, request.InTime, request.HeadId, request.AddressIn, request.LattitudeIn, request.LongitudeIn, "Pending", request.mode, request.Filee, request.PolygonIn, request.action).ToList();
foreach (var item in k)
{
if (item.returncode == "true")
{
Directory.CreateDirectory(@directoryName);
using (Stream file = File.OpenWrite(filename))
{
input.CopyTo(file);
//close file
file.Close();
}
var result = (from p in GInfraEntities.AttendanceLogsNewForMobiles
where p.EmployeeId == request.UserId && p.AttendanceDate == dateTime
select new
{
p.AttendanceLogId,
p.InTime,
p.AttendanceStatus
}).FirstOrDefault();
login.AttendanceLogId = result.AttendanceLogId;
login.InTime = String.Format("{0:yyyy/MM/dd HH:mm:ss}", Convert.ToDateTime(result.InTime));
login.OutTime = "";
login.AttendanceStatus = result.AttendanceStatus;
login.AttendanceLogId = result.AttendanceLogId;
//login.Data.Add(AttendenceInResponse);
login.Status = true;
login.Message = "Attendance Punch in Successfully";
string usermessage = "You have punched In outside the polygon.";
string headmessage = "Your team member " + request.UserId + " has punched In outside the polygon.";
try
{
if (request.PolygonIn == "Out")
{
var headid = (from a in GInfraEntities.EmployeeMasters
join b in GInfraEntities.EmployeeMasters
on a.MangerID equals b.EmployeeId
where a.EmployeeId == request.UserId
select new
{
headid = b.EmployeeId,
}).SingleOrDefault();
// string managerid = headid.ToString();
var gettoken = (from e in GInfraEntities.MasterPasswords
where e.UserID == headid.headid
select new
{
Devicetoken = e.DeviceToken,
}).SingleOrDefault();
var getusertoken = (from e in GInfraEntities.MasterPasswords
where e.UserID == request.UserId
select new
{
Devicetoken = e.DeviceToken,
}).SingleOrDefault();
string DeviceToken = gettoken.Devicetoken;
string DeviceUserToken = getusertoken.Devicetoken;
// DeviceToken = "eNkwJf36cSI:APA91bFeOCPQNRznvSk3lEqJZpCySl14Tvkafh2zjKa4zBF7cBquMZkMsD4L8OKLAt8PgsuDlztI8NfozEmUXGUigUjkdYFQDycIvN1UiG0LyM2b_D1VteRQ-0AVhIlVPT_aZG-nnXnx";
string serverKey = "AAAASLs8D7Y:APA91bFYt4IFQRR4NPLNhX0SKzd_VQjxrvTE1mlS1rYk648fhrW3KvcejHCjwpjh9rHlLkSth7ewFN7ogmJ2mo7znvQXG1nXC0ny5cP14lz4rOM1FUOlGi-ZEdnkPW3kZxk9F15wTsPa";
//string serverKey = "AAAA9-eygYA:APA91bE55q_BzvUTXY4cjjtaePYvI8-U1aq0Vqe8MnVZhsa4l1s0K7bYXyMa7puQNHP9OA8H6LzvpS3yXHWEjPbEnR8FH75TyE5Qcqi9n56cPN9yrkogUWlIoQHicelhlVpheMbu21-I";
//head
try
{
var result1 = "-1";
var webAddr = "https://fcm.googleapis.com/fcm/send";
var httpWebRequest = (HttpWebRequest)WebRequest.Create(webAddr);
httpWebRequest.ContentType = "application/json";
httpWebRequest.Headers.Add("Authorization:key=" + serverKey);
httpWebRequest.Method = "POST";
using (var streamWriter = new StreamWriter(httpWebRequest.GetRequestStream()))
{
string json = "{\"to\": \"" + DeviceToken + "\",\"data\": {\"type\": \"PolygonManager\",\"json\":{\"Title\":\"" + headmessage + "\",\"body\":\"" + headmessage + "\",\"date\":\"\"}}}";
streamWriter.Write(json);
streamWriter.Flush();
}
var httpResponse = (HttpWebResponse)httpWebRequest.GetResponse();
using (var streamReader = new StreamReader(httpResponse.GetResponseStream()))
{
result1 = streamReader.ReadToEnd();
}
var msg = new HttpResponseMessage(HttpStatusCode.OK)
{
ReasonPhrase = "Notification sended"
};
}
catch (Exception ex)
{
var msg = new HttpResponseMessage(HttpStatusCode.NotImplemented)
{
ReasonPhrase = "Error While Notification"
};
}
//user
try
{
var result1 = "-1";
var webAddr = "https://fcm.googleapis.com/fcm/send";
var httpWebRequest = (HttpWebRequest)WebRequest.Create(webAddr);
httpWebRequest.ContentType = "application/json";
httpWebRequest.Headers.Add("Authorization:key=" + serverKey);
httpWebRequest.Method = "POST";
using (var streamWriter = new StreamWriter(httpWebRequest.GetRequestStream()))
{
string json = "{\"to\": \"" + DeviceUserToken + "\",\"data\": {\"type\": \"PolygonStatus\",\"json\":{\"Title\":\"" + usermessage + "\",\"body\":\"" + usermessage + "\",\"date\":\"\"}}}";
streamWriter.Write(json);
streamWriter.Flush();
}
var httpResponse = (HttpWebResponse)httpWebRequest.GetResponse();
using (var streamReader = new StreamReader(httpResponse.GetResponseStream()))
{
result1 = streamReader.ReadToEnd();
}
var msg = new HttpResponseMessage(HttpStatusCode.OK)
{
ReasonPhrase = "Notification sended"
};
}
catch (Exception ex)
{
var msg = new HttpResponseMessage(HttpStatusCode.NotImplemented)
{
ReasonPhrase = "Error While Notification"
};
}
//head
try
{
var result1 = "-1";
var webAddr = "https://fcm.googleapis.com/fcm/send";
var httpWebRequest = (HttpWebRequest)WebRequest.Create(webAddr);
httpWebRequest.ContentType = "application/json";
httpWebRequest.Headers.Add("Authorization:key=" + serverKey);
httpWebRequest.Method = "POST";
using (var streamWriter = new StreamWriter(httpWebRequest.GetRequestStream()))
{
string json = "{\"to\": \"" + DeviceToken + "\",\"content_available\": true,\"notification\": { \"title\": \"PolygonManager\",\"body\": \"" + headmessage + "\",\"click_action\": \"fcm.ACTION.HELLO\"},\"data\": { \"extra\": \"juice\"}}";
streamWriter.Write(json);
streamWriter.Flush();
}
var httpResponse = (HttpWebResponse)httpWebRequest.GetResponse();
using (var streamReader = new StreamReader(httpResponse.GetResponseStream()))
{
result1 = streamReader.ReadToEnd();
}
var msg = new HttpResponseMessage(HttpStatusCode.OK)
{
ReasonPhrase = "Notification sended"
};
}
catch (Exception ex)
{
var msg = new HttpResponseMessage(HttpStatusCode.NotImplemented)
{
ReasonPhrase = "Error While Notification"
};
}
////user
try
{
var result1 = "-1";
var webAddr = "https://fcm.googleapis.com/fcm/send";
var httpWebRequest = (HttpWebRequest)WebRequest.Create(webAddr);
httpWebRequest.ContentType = "application/json";
httpWebRequest.Headers.Add("Authorization:key=" + serverKey);
httpWebRequest.Method = "POST";
using (var streamWriter = new StreamWriter(httpWebRequest.GetRequestStream()))
{
string json = "{\"to\": \"" + DeviceUserToken + "\",\"content_available\": true,\"notification\": { \"title\": \"PolygonStatus\",\"body\": \"" + usermessage + "\",\"click_action\": \"fcm.ACTION.HELLO\"},\"data\": { \"extra\": \"juice\"}}";
streamWriter.Write(json);
streamWriter.Flush();
}
var httpResponse = (HttpWebResponse)httpWebRequest.GetResponse();
using (var streamReader = new StreamReader(httpResponse.GetResponseStream()))
{
result1 = streamReader.ReadToEnd();
}
var msg = new HttpResponseMessage(HttpStatusCode.OK)
{
ReasonPhrase = "Notification sended"
};
}
catch (Exception ex)
{
var msg = new HttpResponseMessage(HttpStatusCode.NotImplemented)
{
ReasonPhrase = "Error While Notification"
};
}
GInfraEntities.sp_notification(headid.headid, "PolygonManager", headmessage, headmessage);
GInfraEntities.sp_notification(request.UserId, "PolygonStatus", usermessage, usermessage);
}
}
catch (Exception e)
{
}
}
if (item.returncode == "false")
{
var result = (from p in GInfraEntities.AttendanceLogsNewForMobiles
where p.EmployeeId == request.UserId && p.AttendanceDate == dateTime
select new
{
p.AttendanceLogId,
p.InTime,
p.AttendanceStatus
}).FirstOrDefault();
login.AttendanceLogId = result.AttendanceLogId;
login.InTime = String.Format("{0:yyyy/MM/dd HH:mm:ss}", Convert.ToDateTime(result.InTime));
login.OutTime = "";
login.AttendanceStatus = result.AttendanceStatus;
login.AttendanceLogId = result.AttendanceLogId;
//login.Data.Add(AttendenceInResponse);
login.Status = false;
login.Message = "User already Punch in";
}
}
return(Request.CreateResponse(HttpStatusCode.OK, login));
}
else
{
//File.Delete(filename);
login.Status = false;
login.Message = "" + HttpStatusCode.BadRequest + "";
return(Request.CreateResponse(HttpStatusCode.OK, login));
}
// return Request.CreateResponse(HttpStatusCode.InternalServerError, login);
}
else
{
login.Status = false;
login.Message = "Image File is missing";
return(Request.CreateResponse(HttpStatusCode.OK, login));
}
}
catch (Exception ex)
{
login.Status = false;
login.Message = "Can't punch in, as your shift hasn't started yet";
return(Request.CreateResponse(HttpStatusCode.InternalServerError, login));
}
}
