private List <SelectListItem> GetBranches()
{
var BranchesList = new List <SelectListItem>();
try
{
using (DSRCManagementSystemEntities1 db = new DSRCManagementSystemEntities1())
{
List <Master_Branches> BranchList = db.Master_Branches.ToList();
foreach (var item in BranchList)
{
BranchesList.Add(new SelectListItem {
Text = item.BranchName, Value = item.BranchID.ToString()
});
}
}
}
catch (Exception Ex)
{
string actionName = this.ControllerContext.RouteData.Values["action"].ToString();
string controllerName = this.ControllerContext.RouteData.Values["controller"].ToString();
ExceptionHandlingController.ExceptionDetails(Ex, actionName, controllerName);
}
return(BranchesList);
}
public ActionResult GetAvailEmployees(int BranchID)
{
DSRCManagementSystemEntities1 db = new DSRCManagementSystemEntities1();
IEnumerable <SelectListItem> Employees = new List <SelectListItem>();
try
{
if (BranchID != 0)
{
Employees = (from data in db.Users
where data.IsActive == true && data.EmpID != null && data.BranchId == BranchID
select new DSRCEmployees
{
Name = (data.FirstName + " " + (data.LastName ?? "")).Trim(),
UserId = data.UserID,
EmployeeId = data.EmpID
}).OrderBy(x => x.Name).AsEnumerable().Select(m => new SelectListItem()
{
Value = Convert.ToString(m.UserId), Text = m.Name
});
}
}
catch (Exception Ex)
{
string actionName = this.ControllerContext.RouteData.Values["action"].ToString();
string controllerName = this.ControllerContext.RouteData.Values["controller"].ToString();
ExceptionHandlingController.ExceptionDetails(Ex, actionName, controllerName);
}
return(Json(new SelectList(Employees, "Value", "Text"), JsonRequestBehavior.AllowGet));
}
public ActionResult EditTime(EditTimeEntry model)
{
DSRCManagementSystemEntities1 db = new DSRCManagementSystemEntities1();
try
{
if (ModelState.IsValid)
{
var obj = (from tim_mng in db.TimeManagements
where tim_mng.EmpID == model.EmployeeId && tim_mng.BranchId == model.BranchID && EntityFunctions.TruncateTime(tim_mng.Date) == EntityFunctions.TruncateTime(model.Date)
select tim_mng
).FirstOrDefault();
obj.InTime = model.InTime;
obj.OutTime = model.OutTime;
var inTime = DateTime.Parse(model.InTime);
var outTime = DateTime.Parse(model.OutTime);
obj.InTimeMin = (inTime.Hour * 60) + inTime.Minute;
obj.OutTimeMin = (outTime.Hour * 60) + outTime.Minute;
obj.TotalTime = obj.OutTimeMin - obj.InTimeMin;
db.SaveChanges();
return(Json(true, JsonRequestBehavior.AllowGet));
}
}
catch (Exception Ex)
{
string actionName = this.ControllerContext.RouteData.Values["action"].ToString();
string controllerName = this.ControllerContext.RouteData.Values["controller"].ToString();
ExceptionHandlingController.ExceptionDetails(Ex, actionName, controllerName);
}
return(View(model));
}
public ActionResult EditTime(EditTimeEntry Model, string EmployeeId, string Date, int BranchId)
{
DSRCManagementSystemEntities1 db = new DSRCManagementSystemEntities1();
EditTimeEntry model = new EditTimeEntry();
try
{
var fromDate = DateTime.Parse(Date);
var obj = (from tim_mng in db.TimeManagements.Where(o => o.EmpID == Model.EmployeeId && o.BranchId == Model.BranchID &&
EntityFunctions.TruncateTime(o.Date) == EntityFunctions.TruncateTime(fromDate))
join usr in db.Users on tim_mng.EmpID equals usr.EmpID
select new
{
userID = usr.UserID,
EmployeeName = usr.FirstName + " " + usr.LastName,
EmpID = usr.EmpID,
Date = tim_mng.Date,
InTime = tim_mng.InTime,
OutTime = tim_mng.OutTime,
BranchId = tim_mng.BranchId
}).FirstOrDefault();
if (obj != null)
{
model.UserID = obj.userID;
model.EmployeeId = obj.EmpID;
model.Date = obj.Date;
model.EmployeeName = obj.EmployeeName;
model.InTime = obj.InTime;
model.OutTime = obj.OutTime;
model.BranchID = (int)obj.BranchId;
}
}
catch (Exception Ex)
{
string actionName = this.ControllerContext.RouteData.Values["action"].ToString();
string controllerName = this.ControllerContext.RouteData.Values["controller"].ToString();
ExceptionHandlingController.ExceptionDetails(Ex, actionName, controllerName);
}
return(View(model));
}
// [DSRCAuthorize(Roles = "Attendant")]
public ActionResult UploadAttendance()
{
ViewBag.Lbl_branch = CommonLogic.getLabelName(1).ToString();
TimeEntry model = new TimeEntry();
try
{
List <SelectListItem> Branches = GetBranches();
Branches.Insert(0, new SelectListItem {
Text = "--Select--", Value = "0"
});
model.BranchList = Branches;
}
catch (Exception Ex)
{
string actionName = this.ControllerContext.RouteData.Values["action"].ToString();
string controllerName = this.ControllerContext.RouteData.Values["controller"].ToString();
ExceptionHandlingController.ExceptionDetails(Ex, actionName, controllerName);
}
return(View(model));
}
public ActionResult Attendance()
{
ViewBag.Lbl_branch = CommonLogic.getLabelName(1).ToString();
EditTimeEntry ObjPM = new EditTimeEntry();
try
{
ObjPM.IsSubmit = false;
ObjPM.EmployeeList = GetNames(1);
ObjPM.BranchList = GetBranches();
ObjPM.Date = null;
ObjPM.EmployeeId = null;
}
catch (Exception Ex)
{
string actionName = this.ControllerContext.RouteData.Values["action"].ToString();
string controllerName = this.ControllerContext.RouteData.Values["controller"].ToString();
ExceptionHandlingController.ExceptionDetails(Ex, actionName, controllerName);
}
return(View(ObjPM));
}
private List <SelectListItem> GetNames(int BranchID)
{
try
{
var NameList = new List <SelectListItem>();
using (DSRCManagementSystemEntities1 db = new DSRCManagementSystemEntities1())
{
List <DSRCEmployees> Names = (from data in db.Users
where data.IsActive == true && data.EmpID != null && data.BranchId == BranchID && data.UserStatus != 6
select new DSRCEmployees
{
Name = (data.FirstName + " " + (data.LastName ?? "")).Trim(),
UserId = data.UserID,
EmployeeId = data.EmpID
}).OrderBy(x => x.Name).ToList();
foreach (var item in Names)
{
NameList.Add(new SelectListItem {
Text = item.Name, Value = item.EmployeeId.ToString()
});
}
NameList.Insert(0, new SelectListItem {
Text = "--Select--", Value = "0"
});
}
return(NameList);
}
catch (Exception Ex)
{
string actionName = this.ControllerContext.RouteData.Values["action"].ToString();
string controllerName = this.ControllerContext.RouteData.Values["controller"].ToString();
ExceptionHandlingController.ExceptionDetails(Ex, actionName, controllerName);
throw Ex;
}
}
public ActionResult Attendance(EditTimeEntry Model)
{
ViewBag.Lbl_branch = CommonLogic.getLabelName(1).ToString();
DSRCManagementSystemEntities1 DBHRMS = new DSRCManagementSystemEntities1();
string ServerName = AppValue.GetFromMailAddress("ServerName");
EditTimeEntry model = new EditTimeEntry();
Model.EmployeeList = GetNames(1);
try
{
if (Model.EmployeeId != null)
{
var obj = (from tim_mng in DBHRMS.TimeManagements.Where(o => o.EmpID == Model.EmployeeId && o.BranchId == Model.BranchID && EntityFunctions.TruncateTime(o.Date) == EntityFunctions.TruncateTime(Model.Date))
join usr in DBHRMS.Users on tim_mng.EmpID equals usr.EmpID
select new
{
userID = usr.UserID,
EmployeeName = usr.FirstName + " " + usr.LastName,
EmpID = usr.EmpID,
Date = tim_mng.Date,
InTime = tim_mng.InTime,
OutTime = tim_mng.OutTime
}).FirstOrDefault();
//SelectList EmpList = (SelectList)GetNames(Model.BranchID).Data;
//model.EmployeeList = EmpList.Select(x => new SelectListItem { Text = x.Text, Value = x.Value }).ToList();
model.BranchList = GetBranches();
model.EmployeeList = GetNames(Model.BranchID);
model.EmployeeId = Model.EmployeeId;
if (obj != null)
{
model.IsRecordAvail = true;
model.UserID = obj.userID;
model.EmployeeName = obj.EmployeeName;
model.EmployeeId = obj.EmpID;
model.Date = obj.Date;
model.InTime = obj.InTime;
model.OutTime = obj.OutTime;
model.TotalMin = 000;
model.BranchID = Model.BranchID;
model.IsSubmit = true;
}
else
{
model.IsRecordAvail = false;
model.IsSubmit = true;
}
model.EmployeeList = GetNames(1);
//model.BranchList = GetBranches();
//model.Date = null;
//model.EmployeeId = null;
return(View(model));
}
//TimeEntry Model
else
{
Model.EmployeeList = GetNames(1);
int userId = Convert.ToInt32(Session["UserID"]);
string folderPath = Server.MapPath("~/FileManager/" + userId + Session.SessionID + "/" + userId + DateTime.Now.ToString("dd-MM-yyyy hh-MM-ss"));
var Excelfile = Model.excelFile;
List <SelectListItem> Branches = GetBranches();
Branches.Insert(0, new SelectListItem {
Text = "--Select--", Value = "0"
});
Model.BranchList = Branches;
// string errorMessage = string.Empty;
if (Model.BranchID != 0)
{
if (Excelfile != null)
{
//var Extension = Excelfile.FileName.Substring(Excelfile.FileName.LastIndexOf(".") + 1);
var Extension = Path.GetExtension(Excelfile.FileName);
if ((Extension == ".xlsx") || Extension == ".xls")
{
if (!Directory.Exists(folderPath))
{
Directory.CreateDirectory(folderPath);
}
var fileName = Path.GetFileName(Excelfile.FileName);
var path = Path.Combine(folderPath, fileName);
Excelfile.SaveAs(path);
ExcelUtility objExcelUtility = new ExcelUtility();
try
{
objExcelUtility.ImportExcelToDatabase(path, Model.BranchID);
int BranchID = Model.BranchID;
communicationHelper.DeleteDuplicateTimeEntry(Model.BranchID);
Model.ErrorSuccessMessage = "Excel file uploaded successfully.";
Model.EmployeeList = GetNames(1);
// string ServerName = WebConfigurationManager.AppSettings["SeverName"];
var check = db.EmailTemplates.Where(x => x.TemplatePurpose == "Upload Attendance").Select(o => o.EmailTemplateID).FirstOrDefault();
var folder = db.EmailTemplates.Where(o => o.TemplatePurpose == "Upload Attendance").Select(x => x.TemplatePath).FirstOrDefault();
if ((check != null) && (check != 0))
{
var AttendanceUpload = (from p in db.EmailPurposes.Where(x => x.EmailPurposeName == "Upload Attendance")
join q in db.EmailTemplates on p.EmailTemplateID equals q.EmailTemplateID
select new DSRCManagementSystem.Models.Email
{
To = p.To,
CC = p.CC,
BCC = p.BCC,
Subject = p.Subject,
Template = q.TemplatePath
}).FirstOrDefault();
var company = db.Master_ApplicationSettings.Where(x => x.AppKey == "Company Name").Select(o => o).FirstOrDefault();
string TemplatePathAttendanceUpload = Server.MapPath(AttendanceUpload.Template);
string Attendance = System.IO.File.ReadAllText(TemplatePathAttendanceUpload);
int LoginUser = (int)Session["UserId"];
var user = db.Users.Where(o => o.UserID == LoginUser && o.IsActive == true).Select(o => o).FirstOrDefault();
Attendance = Attendance.Replace("#ServerName", ServerName);
Attendance = Attendance.Replace("#CompanyName", company.AppValue);
string date = TimeZoneInfo.ConvertTimeFromUtc(DateTime.UtcNow, INDIAN_ZONE).ToString("dd-mm-yyyy hh:mm:ss tt");
Attendance = Attendance.Replace("#IndianTime", date);
var BranchName = db.Master_Branches.Where(x => x.BranchID == BranchID).Select(o => o.BranchName).FirstOrDefault();
var logo = CommonLogic.getLogoPath();
if (ServerName != "http://*****:*****@dsrc.co.in ";
Task.Factory.StartNew(() =>
{
DsrcMailSystem.MailSender.SendMail(null, AttendanceUpload.Subject + " - Test Mail Please Ignore", null, Attendance + " - Testing Please ignore", "*****@*****.**", EmailAddress, "*****@*****.**", BCCMailId, Server.MapPath(logo.ToString()));
});
}
else
{
Task.Factory.StartNew(() =>
{
DsrcMailSystem.MailSender.SendMail(null, AttendanceUpload.Subject, null, Attendance, "*****@*****.**", user.EmailAddress, "*****@*****.**", null, null, Server.MapPath(logo.ToString()));
});
}
}
//string Subject = "Regarding Attendance upload";
//string pathvalue = CommonLogic.getLogoPath();
//var company = db.Master_ApplicationSettings.Where(x => x.AppKey == "Company Name").Select(o => o.AppValue).FirstOrDefault();
//DateTime indianTime = TimeZoneInfo.ConvertTimeFromUtc(DateTime.UtcNow, INDIAN_ZONE);
//var BranchName = db.Master_Branches.Where(x => x.BranchID == BranchID).Select(o => o.BranchName).FirstOrDefault();
//var imagePath = new List<string>() { Server.MapPath("~/Content/Template/images/Circle_Red.png"), Server.MapPath("~/Content/Template/images/Circle_Orange.png"), Server.MapPath("~/Content/Template/images/Circle_Green.png"), Server.MapPath(pathvalue) };
//string Message = "Thanks for uploading Attendance on" + " " + indianTime + " " + "<br>" + "for" + BranchName + " " + "branch" + "<br/><br/>This email has been automatically generated.</br>Please do not reply to this email address as all responses are directed to an unattended,<br/>mailbox, and you will not receive a response</p><br/><br/><p style=font-size:15px>Thanks,<br/>" + company + "Management Portal</p>";
//if (ServerName != "http://*****:*****@dsrc.co.in";
// string BCCMailId = "[email protected] ";
// Task.Factory.StartNew(() =>
// {
// DsrcMailSystem.MailSender.SendMail(null, Subject + " - Test Mail Please Ignore", null, Message + " - Testing Plaese ignore", "*****@*****.**", EmailAddress,"*****@*****.**", BCCMailId, Server.MapPath(pathvalue.ToString()));
// });
//}
//else
//{
// Task.Factory.StartNew(() =>
// {
// DsrcMailSystem.MailSender.SendMail(null, Subject, null, Message, "*****@*****.**", "[email protected] , [email protected]", null, null, Server.MapPath(pathvalue.ToString()));
// });
//}
//SendMail(BranchID);
}
catch (Exception Ex)
{
string actionName = this.ControllerContext.RouteData.Values["action"].ToString();
string controllerName = this.ControllerContext.RouteData.Values["controller"].ToString();
ExceptionHandlingController.ExceptionDetails(Ex, actionName, controllerName);
Model.ErrorSuccessMessage = "Error: " + Ex.Message;
return(View(Model));
}
}
else
{
Model.ErrorSuccessMessage = "Please upload excel files only.";
}
}
else
{
Model.ErrorSuccessMessage = "Please upload the excel file.";
}
}
else
{
Model.ErrorSuccessMessage = "Please select branch";
}
//Model.IsSubmit = false;
Model.EmployeeList = GetNames(1);
//Model.IsSubmit = false;
//Model.EmployeeList = GetNames(1);
//Model.BranchList = GetBranches();
//Model.Date = null;
//Model.EmployeeId = null;
}
}
catch (Exception Ex)
{
string actionName = this.ControllerContext.RouteData.Values["action"].ToString();
string controllerName = this.ControllerContext.RouteData.Values["controller"].ToString();
ExceptionHandlingController.ExceptionDetails(Ex, actionName, controllerName);
}
return(View(Model));
}