public object ApplyLeave(LeaveParam obj)
{
LeaveBusiness ObjTerm = new LeaveBusiness();
var GetTermVar = ObjTerm.CreateLeave(obj);
return(GetTermVar);
}
public bool Insert(LeaveParam leaveParam)
{
if (leaveParam == null)
{
Console.WriteLine("Insert Name");
Console.Read();
}
else
{
_leaveRepository.Insert(leaveParam);
status = true;
Console.WriteLine("Success");
}
return(status);
}
public bool Update(int?Id, LeaveParam leaveParam)
{
var result = 0;
var getDataLeave = Get(Id);
getDataLeave.Name = leaveParam.Name;
getDataLeave.Status = leaveParam.Status;
getDataLeave.Days = leaveParam.Days;
getDataLeave.UpdateDate = DateTimeOffset.UtcNow.LocalDateTime;
result = myContext.SaveChanges();
if (result > 0)
{
status = true;
}
return(status);
}
public bool Insert(LeaveParam leaveParam)
{
var result = 0;
leave.Name = leaveParam.Name;
leave.Status = leaveParam.Status;
leave.Days = leaveParam.Days;
leave.CreateDate = DateTimeOffset.UtcNow.LocalDateTime;
myContext.Leaves.Add(leave);
result = myContext.SaveChanges();
if (result > 0)
{
status = true;
}
return(status);
}
public bool Update(int?Id, LeaveParam leaveParam)
{
if (Id == null)
{
Console.WriteLine("Insert Id");
Console.Read();
}
else if (Id == ' ')
{
Console.WriteLine("Dont Insert Blank Caracter");
Console.Read();
}
else
{
_leaveRepository.Update(Id, leaveParam);
status = true;
Console.WriteLine("update Success");
}
return(status);
}
public bool Update(int?id, LeaveParam leaveParam)
{
var result = 0;
Leave leave = Get(id);
leave.Name = leaveParam.Name;
leave.Status = leaveParam.Status;
leave.Days = leaveParam.Days;
leave.UpdateDate = DateTimeOffset.Now.LocalDateTime;
_context.Entry(leave).State = System.Data.Entity.EntityState.Modified;
_context.SaveChanges();
if (result > 0)
{
return(true);
}
else
{
return(false);
}
}
public bool Insert(LeaveParam leaveParam)
{
try {
var result = 0;
Leave leave = new Leave();
leave.Name = leaveParam.Name;
leave.Status = leaveParam.Status;
leave.Days = leaveParam.Days;
leave.CreateDate = DateTimeOffset.Now.LocalDateTime;
_context.Leaves1.Add(leave);
result = _context.SaveChanges();
if (result > 0)
{
return(true);
}
}
catch (DbEntityValidationException e)
{
Console.Write(e.EntityValidationErrors);
}
return(false);
}
public object CreateLeave(LeaveParam tobj)
{
SchoolMainContext db = new ConcreateContext().GetContext(tobj.UserName, tobj.Password);
if (db == null)
{
return(new Results()
{
IsSuccess = false, Message = "Invalid User"
});
}
var Info = db.TBLUSERLOGINs.Where(r => r.UserName == tobj.UserName && r.Password == tobj.Password).FirstOrDefault();
if (Info == null)
{
return(new Results()
{
IsSuccess = false, Message = "Invalid User"
});
}
double SactionDays = 0, AvailableDays = 0;
var academicyear = db.View_GETACADEMICYEAR.FirstOrDefault();
int EmployeeID = Convert.ToInt16(Info.EmpCode);
var GetInfo = db.TBLLEAVEMASTERs.Where(r => r.EMPLOYEEID == EmployeeID && r.DISPLAY == 1 && r.ACADEMICYEAR == academicyear.ACADEMICYEAR).ToList();
if (GetInfo.Count != 0)
{
var GetStatus = db.TBLLEAVEMASTERs.Where(r => r.EMPLOYEEID == EmployeeID && r.DISPLAY == 1 && r.LEAVETYPE == tobj.LEAVETYPE && r.ACADEMICYEAR == academicyear.ACADEMICYEAR).OrderByDescending(r => r.LEAVEID).FirstOrDefault();
if (GetStatus != null)
{
if (tobj.SUBSTITUTEID == "No Load")
{
//
}
else
{
string[] subID = tobj.SUBSTITUTEID.Split(',');
for (int i = 0; i < subID.Count(); i++)
{
var ID = int.Parse(subID[i]);
var substitute = db.TBLEMPLOYEEMASTERs.Where(r => r.EMPLOYEEID == ID && r.DEPARTMENTID == 24 && r.DISPLAY == 1 && r.EDUYEAR == academicyear.ACADEMICYEAR).ToList();
if (substitute.Count == 0)
{
return(new LeaveInfo()
{
Issucess = false, Status = "Not Found SUBSTITUTEID"
});
}
}
}
if (GetStatus.PRINCIPALSTATUS == "DisApproved" || GetStatus.PRINCIPALSTATUS == "Pending")
{
return(new LeaveInfo()
{
Issucess = false, Status = "Your Fisrt Leave are not Approved By PRINCIPAL "
});
}
else
{
for (int i = 0; i < GetInfo.Count(); i++)
{
SactionDays += Convert.ToDouble(GetInfo[i].NOOFDAYS);
}
var GetTotalLeave = db.TBLLEAVETYPEMASTERs.Where(r => r.EMPLOYEETYPEID == EmployeeID && r.LEAVETYPEID == tobj.LEAVETYPE && r.DISPLAY == 1 && r.ACADEMICYEAR == academicyear.ACADEMICYEAR).FirstOrDefault();
if (GetTotalLeave == null)
{
return(new Results()
{
IsSuccess = false, Message = "Does Not Created Department.Please Contact Admin"
});
}
AvailableDays = Convert.ToDouble(GetTotalLeave.DAYS - SactionDays);
//string[] subID = tobj.SUBSTITUTEID.Split(',');
//for (int i = 0; i < subID.Count(); i++)
//{
// var ID = int.Parse(subID[i]);
// var substitute = db.TBLEMPLOYEEMASTERs.Where(r => r.EMPLOYEEID == ID && r.DEPARTMENTID == 24 && r.DISPLAY==1 && r.EDUYEAR == academicyear.ACADEMICYEAR).ToList();
// if (substitute.Count == 0)
// {
// return new LeaveInfo() { Issucess = false, Status = "Not Found SUBSTITUTEID" };
// }
//}
if (AvailableDays >= SactionDays || AvailableDays == 0)
{
return(new LeaveList()
{
IsSuccess = false, ApplicableLeaves = GetTotalLeave.DAYS, RemainingLeaves = AvailableDays
});
}
if (tobj.DayType == "Half Day")
{
var DayType = 0.5;
tobj.NOOFDAYS = Convert.ToDecimal(DayType);
}
TBLLEAVEMASTER obj = new TBLLEAVEMASTER();
obj.LEAVETYPE = tobj.LEAVETYPE;
obj.EMPLOYEEID = EmployeeID;
obj.FROMDATE = tobj.FROMDATE;
obj.TODATE = tobj.TODATE;
obj.REASON = tobj.REASON;
obj.NOOFDAYS = tobj.NOOFDAYS;
obj.ACADEMICYEAR = academicyear.ACADEMICYEAR;
obj.CREATEDID = 1;
obj.CREATEDON = System.DateTime.Today.Date;
obj.CreationTime = System.DateTime.Today.TimeOfDay.ToString();
obj.DISPLAY = 1;
obj.SANCTIONEDNOOFDAYS = Convert.ToDecimal(SactionDays) + tobj.NOOFDAYS;
obj.SUBSTITUTESTATUS = "Pending";
obj.PRINCIPALSTATUS = "Pending";
obj.SUBSTITUTEID = tobj.SUBSTITUTEID;
db.TBLLEAVEMASTERs.Add(obj);
db.SaveChanges();
}
return(new LeaveInfo()
{
Issucess = true, Status = "Apply Leave Successfully"
});
}
// return new LeaveList() { IsSuccess = true, ApplicableLeaves = GetTotalLeave.DAYS,RemainingLeaves=AvailableDays };
}
else
{
var GetTotalLeave = db.TBLLEAVETYPEMASTERs.Where(r => r.EMPLOYEETYPEID == EmployeeID && r.LEAVETYPEID == tobj.LEAVETYPE && r.DISPLAY == 1 && r.ACADEMICYEAR == academicyear.ACADEMICYEAR).FirstOrDefault();
if (GetTotalLeave == null)
{
return(new Results()
{
IsSuccess = false, Message = "Does Not Created Department.Please Contact Admin"
});
}
if (tobj.SUBSTITUTEID == "No Load")
{
//
}
else
{
string[] subID = tobj.SUBSTITUTEID.Split(',');
for (int i = 0; i < subID.Count(); i++)
{
var ID = int.Parse(subID[i]);
var substitute = db.TBLEMPLOYEEMASTERs.Where(r => r.EMPLOYEEID == ID && r.DEPARTMENTID == 24 && r.DISPLAY == 1 && r.EDUYEAR == academicyear.ACADEMICYEAR).ToList();
if (substitute.Count == 0)
{
return(new LeaveInfo()
{
Issucess = false, Status = "Not Found SUBSTITUTEID"
});
}
}
}
for (int i = 0; i < GetInfo.Count(); i++)
{
SactionDays += Convert.ToDouble(GetInfo[i].NOOFDAYS);
}
// var GetTotalLeave = db.TBLLEAVETYPEMASTERs.Where(r => r.EMPLOYEETYPEID == EmployeeID && r.LEAVETYPEID == tobj.LEAVETYPE && r.DISPLAY == 1 && r.ACADEMICYEAR == academicyear.ACADEMICYEAR).FirstOrDefault();
AvailableDays = Convert.ToDouble(GetTotalLeave.DAYS - SactionDays);
if (AvailableDays >= SactionDays || AvailableDays == 0)
{
return(new LeaveList()
{
IsSuccess = false, ApplicableLeaves = GetTotalLeave.DAYS, RemainingLeaves = AvailableDays
});
}
if (tobj.DayType == "Half Day")
{
var DayType = 0.5;
tobj.NOOFDAYS = Convert.ToDecimal(DayType);
}
SactionDays = Convert.ToDouble(tobj.NOOFDAYS);
TBLLEAVEMASTER obj = new TBLLEAVEMASTER();
obj.LEAVETYPE = tobj.LEAVETYPE;
obj.EMPLOYEEID = EmployeeID;
obj.FROMDATE = tobj.FROMDATE;
obj.TODATE = tobj.TODATE;
obj.REASON = tobj.REASON;
obj.NOOFDAYS = tobj.NOOFDAYS;
obj.ACADEMICYEAR = academicyear.ACADEMICYEAR;
obj.CREATEDID = 1;
obj.CREATEDON = System.DateTime.Today.Date;
obj.CreationTime = System.DateTime.Today.TimeOfDay.ToString();
obj.DISPLAY = 1;
obj.SANCTIONEDNOOFDAYS = Convert.ToDecimal(SactionDays);
obj.SUBSTITUTESTATUS = "Pending";
obj.PRINCIPALSTATUS = "Pending";
obj.SUBSTITUTEID = tobj.SUBSTITUTEID;
db.TBLLEAVEMASTERs.Add(obj);
db.SaveChanges();
//AvailableDays = Convert.ToDouble(GetTotalLeave.DAYS - SactionDays);
//return new LeaveList() { IsSuccess = true, ApplicableLeaves = GetTotalLeave.DAYS, RemainingLeaves = GetTotalLeave.DAYS };
}
return(new LeaveInfo()
{
Issucess = true, Status = "Apply Leave Successfully"
});
}
// PUT: api/Leaves/5
public void Put(int Id, LeaveParam leaveParam)
{
_leaveRepository.Update(Id, leaveParam);
}
// POST: api/Leaves
public void Post(LeaveParam leaveParam)
{
_leaveRepository.Insert(leaveParam);
}
