public string AddUpdateLeave(LeaveDetail obj, string flag, int UserId)
{
string returnResult = "";
var conn = db.Database.GetDbConnection();
try
{
conn.Open();
using (var command = conn.CreateCommand())
{
string query = @"exec spAddUpdateLeave @empId = '" + obj.EmpName + "',@Startdate = '" + obj.StartDate + "',@EndDate = '" + obj.EndDate + "',@LeavetypeId = '" + obj.LeaveType + "',@User = '******',@Flag = '" + flag + "'" +
",@LeaveId = '" + obj.LeaveId + "'";
command.CommandText = query;
returnResult = command.ExecuteScalar().ToString();
}
}
catch (Exception ex)
{
conn.Close();
}
finally
{
conn.Close();
}
return(returnResult);
}
public ActionResult Edit(LeaveDetail emp)
{
try
{
// TODO: Add update logic here
HttpClient hc = new HttpClient();
hc.BaseAddress = new Uri("https://localhost:44351/api/");
var insertrecord = hc.PutAsJsonAsync <LeaveDetail>("LeaveApplicationApi", emp);
insertrecord.Wait();
var savedata = insertrecord.Result;
if (savedata.IsSuccessStatusCode)
{
return(RedirectToAction("Index"));
}
else
{
ViewBag.message("record updated");
}
return(View());
}
catch
{
return(View("Index"));
}
}
public ActionResult LeaveEdit(LeaveDetail leaveDetail)
{
User user = getCurrentUser();
if (user == null)
{
ViewBag.UserList = (iuser.GetUsersList());
ViewBag.LeaveType = ileavetype.GetLeavetypes;
ViewBag.Message = "Session Expired !! Please Reload !!";
return(View());
}
else
{
var flag = "Update";
var result = ileavedetail.AddUpdateLeave(leaveDetail, flag, user.u_id);
if (result.Equals("Successfully added"))
{
return(RedirectToAction("LeaveDetail"));
}
else
{
ViewBag.UserList = (iuser.GetUsersList());
ViewBag.LeaveType = ileavetype.GetLeavetypes;
ViewBag.Message = result;
return(View());
}
}
}
public ActionResult ApplyLeave(LeaveDetail leaveDetail)
{
//if (!ModelState.IsValid)
//{
// var viewModel = new LeaveViewModel
// {
// LeaveDetail = leaveDetail,
// Leaves = db.Leaves.ToList()
// };
//}
db.LeaveDetails.Add(leaveDetail);
if (leaveDetail.Status == null)
{
leaveDetail.LeaveStatus = 1;
}
if (leaveDetail.TypeOfLeave == null)
{
leaveDetail.TypeOfLeave = 1;
}
db.SaveChanges();
if (leaveDetail.Employee_Id == 2)
{
return(RedirectToAction("Index", "ManagingDirector"));
}
else
{
return(RedirectToAction("Index", "Supervisor"));
}
}
public ActionResult EditLeave(LeaveDetail objasp)
{
objLeaveBLL.EditLeave(objasp);
string id = Session["id"].ToString();
return(RedirectToAction(id, "Emp/GetLeaveById/"));
}
public async Task <ActionResult <LeaveDetail> > PostLeaveDetail(LeaveDetail leaveDetail)
{
_context.LeaveDetails.Add(leaveDetail);
await _context.SaveChangesAsync();
return(CreatedAtAction("GetLeaveDetail", new { id = leaveDetail.id }, leaveDetail));
}
// POST api/LeaveApi
public IHttpActionResult empinsert(LeaveDetail empinsert)
{
lm.LeaveDetails.Add(empinsert);
lm.SaveChanges();
return(Ok(lm));
}
public async Task <IActionResult> PutLeaveDetail(int id, LeaveDetail leaveDetail)
{
if (id != leaveDetail.id)
{
return(BadRequest());
}
_context.Entry(leaveDetail).State = EntityState.Modified;
try
{
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!LeaveDetailExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(NoContent());
}
public ActionResult ApplyLeave(LeaveDetail leaveDetail)
{
try
{
if (ModelState.IsValid)
{
using (StudentEntities2 re = new StudentEntities2())
{
leaveDetail.PersonId = Convert.ToInt32(Session["PersonId"]);
leaveDetail.PersonName = Convert.ToString(Session["PersonName"]);
if (Convert.ToInt32(Session["Role"]) == 3)
{
leaveDetail.IsStudent = true;
}
else
{
leaveDetail.IsStudent = false;
}
leaveDetail.LeaveStatus = 1;
re.LeaveDetails.Add(leaveDetail);
re.SaveChanges();
ModelState.Clear();
ViewBag.Message = "Success";
leaveDetail = null;
}
}
}
catch (Exception ex)
{
return(View("Error", new HandleErrorInfo(ex, "Student", "Index")));
}
return(View(leaveDetail));
}
private void Prepareleavedetails(LeaveHeader leaveHeader, LeaveHeader _leaveHeader)
{
if (leaveHeader.LeaveDetail != null && leaveHeader.LeaveDetail.Any())
{
foreach (LeaveDetail item in leaveHeader.LeaveDetail)
{
LeaveDetail _leaveDetail = null;
if (item.Id > 0)
{
_leaveDetail = _leaveHeader.LeaveDetail.Where(i => i.Id == item.Id).FirstOrDefault();
_leaveDetail.ModifiedBy = USER_OBJECT.UserName;
_leaveDetail.ModifiedOn = DateTimeConverter.SingaporeDateTimeConversion(DateTime.Now);
}
else
{
_leaveDetail = new LeaveDetail();
_leaveDetail.CreatedBy = USER_OBJECT.UserName;
_leaveDetail.CreatedOn = DateTimeConverter.SingaporeDateTimeConversion(DateTime.Now);
}
_leaveDetail.LeaveType = item.LeaveType;
_leaveDetail.TotalLeaves = item.TotalLeaves;
if (_leaveHeader.LeaveDetail == null)
{
_leaveHeader.LeaveDetail = new List <LeaveDetail>();
}
bool isExists = _leaveHeader.LeaveDetail.Any(s => s.LeaveType == item.LeaveType);
if (!isExists)
{
_leaveHeader.LeaveDetail.Add(_leaveDetail);
}
}
}
}
public ActionResult CreateLeave(LeaveDetail objleave)
{
objleave.Id = Session["id"].ToString();
objLeaveBLL.Createleave(objleave);
//objleave.Id = Session["id"].ToString();
string id = objleave.Id;
return(RedirectToAction("GetLeaveById", "Emp", new { id }));
}
public ActionResult LeaveApproval()
{
LeaveDetail leave = new LeaveDetail();
leave = db.LeaveDetails.FirstOrDefault(x => x.LeaveStatus == 1);
leave.LeaveStatus = 2;
db.SaveChanges();
return(RedirectToAction("Index", "ManagingDirector"));
}
public void Add(LeaveDetail leaveDetail)
{
try
{
leaveDetailRepository.Add(leaveDetail);
}
catch (Exception ex)
{
throw ex;
}
}
public IEnumerable <LeaveDetail> GetLeaveDetail()
{
List <LeaveDetail> result = new List <LeaveDetail>();
var conn = db.Database.GetDbConnection();
try
{
conn.Open();
using (var command = conn.CreateCommand())
{
string query = @"exec spGetLeaveDetail";
command.CommandText = query;
DbDataReader reader = command.ExecuteReader();
if (reader.HasRows)
{
while (reader.Read())
{
LeaveDetail leave = new LeaveDetail();
leave.LeaveId = Convert.ToInt32(reader["LeaveId"]);
leave.EmpName = reader["EmpName"].ToString();
System.Diagnostics.Trace.WriteLine(reader["StartDate"].ToString());
if (!reader["StartDate"].ToString().Equals(""))
{
leave.StartDate = DateTime.Parse(reader["StartDate"].ToString());
}
if (!reader["EndDate"].ToString().Equals(""))
{
leave.EndDate = DateTime.Parse(reader["EndDate"].ToString());
}
if (!reader["LeaveDays"].ToString().Equals(""))
{
leave.LeaveDays = int.Parse(reader["LeaveDays"].ToString());
}
leave.MarkedBy = reader["MarkedBy"].ToString();
leave.MarkedDate = reader["MarkedDate"].ToString();
leave.LastModifiedBy = reader["LastModifiedBy"].ToString();
leave.LastModfiedDate = reader["LastModfiedDate"].ToString();
leave.LeaveType = reader["LeaveType"].ToString();
leave.CurrentStatus = reader["CurrentStatus"].ToString();
result.Add(leave);
}
}
reader.Dispose();
}
}
finally
{
conn.Close();
}
return(result);
}
public void Delete(LeaveDetail leaveDetail)
{
try
{
leaveDetailRepository.Delete(leaveDetail);
}
catch (Exception ex)
{
throw ex;
}
}
public ActionResult LeaveRejection()
{
LeaveDetail leave = new LeaveDetail();
leave = db.LeaveDetails.FirstOrDefault(x => x.LeaveStatus == 1);
leave.LeaveStatus = 3;
db.SaveChanges();
return(RedirectToAction("Index", "Supervisor"));
}
public ActionResult LeaveEdit(int id)
{
if (getCurrentUser() == null)
{
return(RedirectToAction("Index", "Login"));
}
else
{
ViewBag.UserList = (iuser.GetUsersList());
ViewBag.LeaveType = ileavetype.GetLeavetypes;
LeaveDetail leaveobj = ibio.GetLeaveDetail().Where(m => m.LeaveId == id).FirstOrDefault();
return(View(leaveobj));
}
}
public ActionResult Create(LeaveDetail insertemp)
{
HttpClient hc = new HttpClient();
hc.BaseAddress = new Uri("https://localhost:44351/api/LeaveApplicationApi");
var insertrecord = hc.PostAsJsonAsync <LeaveDetail>("LeaveApplicationApi", insertemp);
insertrecord.Wait();
var savedata = insertrecord.Result;
if (savedata.IsSuccessStatusCode)
{
return(RedirectToAction("Index"));
}
return(View("Create"));
}
//display the all the values uneditable mode
// GET: Leave/Details/5
public ActionResult Details(int id)
{
LeaveDetail empobj = null;
HttpClient hc = new HttpClient();
hc.BaseAddress = new Uri("https://localhost:44351/api/");
var consumeapi = hc.GetAsync("LeaveApplicationApi?id=" + id.ToString());
consumeapi.Wait();
var readdata = consumeapi.Result;
if (readdata.IsSuccessStatusCode)
{
var displaydata = readdata.Content.ReadAsAsync <LeaveDetail>();
displaydata.Wait();
empobj = displaydata.Result;
}
return(View(empobj));
}
public ActionResult LeaveApproval()
{
LeaveDetail leave = new LeaveDetail();
//if (leave.LeaveStatus == 3)
//{
// leave = db.LeaveDetails.FirstOrDefault(x => x.LeaveStatus == 3);
// leave.LeaveStatus = 1;
//}
//else
leave = db.LeaveDetails.FirstOrDefault(x => x.LeaveStatus == 1);
leave.LeaveStatus = 2;
db.SaveChanges();
return(RedirectToAction("Index", "Supervisor"));
}
private async void ApplyLeave()
{
try
{
ActivityIndicatorTitle = "Updating leave. Please wait.";
IsBusy = true;
LeaveDetail leaveDetail = PrismApplicationBase.Current.Container.Resolve(typeof(LeaveDetail)) as LeaveDetail;
leaveDetail.Name = _user.UserName;
leaveDetail.Id = _user.UserID;
leaveDetail.LeaveType = _leaveType;
//Todo-- Add popup to confirm if the data has been updated successfully.
await FirebaseService.UpdateLeaveAsync(_leaveDate.Day, CultureInfo.CurrentCulture.DateTimeFormat.GetMonthName(_leaveDate.Month), _leaveDate.Year.ToString(), leaveDetail);
}
finally
{
IsBusy = false;
}
}
// PUT api/LeaveApi/5
public IHttpActionResult put(LeaveDetail emp)
{
//another method for edit
//var updateemp = lm.Leavedetails.Where(x => x.empid == emp.empid).FirstOrDefault<leavedetail>();
//if (updateemp != null)
//{
// //updateemp.empid = emp.empid;
// //updateemp.EmployeeName = emp.EmployeeName;
// //updateemp.RoleID = emp.RoleID;
// //updateemp.UserName = emp.UserName;
// //updateemp.Password = emp.Password;
// updateemp.status = emp.status;
// lm.SaveChanges();
//}
//else
try
{
var up = lm.LeaveDetails.Where(x => x.Id == emp.Id).FirstOrDefault <LeaveDetail>();
lm.Entry(emp).State = System.Data.Entity.EntityState.Modified;
lm.SaveChanges();
}
catch (DbEntityValidationException e)
{
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;
}
return(Ok(lm));
}
/// <summary>
///
/// </summary>
/// <param name="loginid"></param>
/// <param name="type"></param>
/// <param name="ID"></param>
/// <param name="PersonID"></param>
/// <param name="CustomerID"></param>
/// <param name="OutCompanyID"></param>
/// <param name="page"></param>
/// <returns></returns>
public ActionResult DelPersonLeaveDetail(string loginid, string type, string ID, int PersonID, int CustomerID, int OutCompanyID, int page)
{
string msg = "删除失败";
#region 保存登录信息
if (!string.IsNullOrEmpty(loginid))
{
ViewBag.LoginID = loginid;
}
else
{
ViewBag.LoginID = "";
}
if (!string.IsNullOrEmpty(loginid))
{
ViewBag.Type = type;
}
else
{
ViewBag.Type = "";
}
#endregion
LeaveDetail model = leaveDetailDAL.GetModelByID(HttpUtility.HtmlDecode(ID));
//如果存在则删除当前对象
if (model != null)
{
leaveDetailDAL.Delete(model);
msg = "删除成功";
}
StringBuilder urlStr = new StringBuilder();
urlStr.AppendFormat("?loginid={0}&&type={1}&&PersonID={2}", loginid, type, PersonID);
urlStr.AppendFormat("&&CustomerID={0}&&OutCompanyID={1}&&page={2}", CustomerID, OutCompanyID, page);
return(Content(urlStr.ToString()));
}
// GET api/LeaveApi/5
public IHttpActionResult Getempid(int id)
{
LeaveDetail empdetails = null;
//empdetails = lm.Employees.Where(x=> ).Select(x => new Employee()
//{
// Id = x.Id,
// EmployeeName = x.EmployeeName,
// RoleID = x.RoleID,
// UserName = x.UserName,
// Password = x.Password,
// MailId = x.MailId,
// PhoneNumber = x.PhoneNumber
//}).FirstOrDefault<Employee>();
empdetails = lm.LeaveDetails.Find(id);
if (empdetails == null)
{
return(NotFound());
}
return(Ok(empdetails));
}
public async Task <bool> UpdateLeaveAsync(int day, string month, string year, LeaveDetail leaveDetail)
{
try
{
await firebase.Child(string.Join("/", year, month, day, leaveDetail.Id.Replace('.', '-'))).PutAsync(leaveDetail);
return(true);
}
catch (FirebaseException firebaseEx)
{
return(false);
}
}
public void Update(LeaveDetail leavetype)
{
throw new NotImplementedException();
}
public ActionResult AddPersonLeaveDetail(string loginid)
{
if (!string.IsNullOrEmpty(loginid))
{
ViewBag.LoginID = loginid;
}
else
{
ViewBag.LoginID = "";
}
CustomerOutsourc custOut = custOutDAL.GetModelByID(Convert.ToInt32(loginid));
if (custOut != null)
{
ViewBag.Type = custOut.Type;
}
ViewBag.PersonID = Request["PersonID"];
ViewBag.CustomerID = Request["CustomerID"];
ViewBag.OutCompanyID = Request["OutCompanyID"];
#region 初始化数据
LeaveDetail leaveDetail = new LeaveDetail();
leaveDetail.ID = Guid.NewGuid().ToString();
leaveDetail.PersonSettlementID = Request["ID"].ToString();
leaveDetail.LeaveStartDate = Convert.ToDateTime(Request["stime"]);
leaveDetail.LeaveEndDate = Convert.ToDateTime(Request["etime"]);
leaveDetail.LeaveHours = (decimal)(leaveDetail.LeaveEndDate - leaveDetail.LeaveStartDate).TotalHours;
leaveDetail.LeaveReason = Request["LeaveReason"].ToString();
DateTime now = DateTime.Now;
DateTime d1 = new DateTime(now.Year, now.Month, 1); //当月第一天
DateTime d2 = d1.AddMonths(1).AddDays(-1); //当月最后一天
long workDays = dateDiff(d1, d2); //获取当前月工作天数
decimal money = Convert.ToDecimal(Request["Moneys"]);
switch (Convert.ToInt32(Request["leaveType"]))
{
case 1: //请假
leaveDetail.LeaveType = 1;
//（工资÷工作日总数）÷工作8小时×请假时间
leaveDetail.LeaveMoney = ((money / workDays) / 8 * leaveDetail.LeaveHours) * -1;
break;
case 2: //加班补助
//加班补助直接录入
leaveDetail.LeaveMoney = money;
leaveDetail.LeaveType = 2;
break;
case 3: //事假调休
//事假调休不计入工资计算
leaveDetail.LeaveMoney = 0;
leaveDetail.LeaveType = 3;
break;
case 4: //加班
//加班不计算加班费算法
leaveDetail.LeaveMoney = 0;
leaveDetail.LeaveType = 4;
break;
}
leaveDetailDAL.Insert(leaveDetail);
#endregion
string url = string.Format("loginid={0}&&PersonID={1}&&CustomerID={2}&&OutCompanyID={3}&&page ={4}", loginid, ViewBag.PersonID, ViewBag.CustomerID, ViewBag.OutCompanyID, 1);
return(Content(url));
//return RedirectToAction("PersonSettl", new { loginid=loginid, PersonID= ViewBag.PersonID, CustomerID= ViewBag.CustomerID, OutCompanyID= ViewBag.OutCompanyID, page = 1 });
}
public ActionResult EditLeaveAdmin(LeaveDetail objasp)
{
objLeaveBLL.EditLeave(objasp);
return(RedirectToAction("/GetLeaves"));
}
public void Createleave(LeaveDetail objasp)
{
objLeaveDAL.CreateLeave(objasp);
}
public void EditLeave(LeaveDetail objasp)
{
objLeaveDAL.EditLeave(objasp);
}
