public static EmployeeSchedule GetEmployeeScheduleByID(int id)
{
EmployeeSchedule employeeSchedule = new EmployeeSchedule();
SqlEmployeeScheduleProvider sqlEmployeeScheduleProvider = new SqlEmployeeScheduleProvider();
employeeSchedule = sqlEmployeeScheduleProvider.GetEmployeeScheduleByID(id);
return employeeSchedule;
}
protected void btnAdd_Click(object sender, EventArgs e)
{
EmployeeSchedule employeeSchedule = new EmployeeSchedule();
employeeSchedule.EmployeeID = Int32.Parse(ddlEmployee.SelectedValue);
employeeSchedule.ClassDayID = Int32.Parse(ddlClassDay.SelectedValue);
employeeSchedule.StartTime = txtStartTime.Text;
employeeSchedule.EndTime = txtEndTime.Text;
employeeSchedule.RowStatusID = Int32.Parse(ddlRowStatus.SelectedValue);
employeeSchedule.AddedBy = txtAddedBy.Text;
employeeSchedule.AddedDate = DateTime.Now;
employeeSchedule.UpdatedBy = txtUpdatedBy.Text;
employeeSchedule.UpdateDate = txtUpdateDate.Text;
int resutl = EmployeeScheduleManager.InsertEmployeeSchedule(employeeSchedule);
Response.Redirect("AdminEmployeeScheduleDisplay.aspx");
}
protected void btnUpdate_Click(object sender, EventArgs e)
{
EmployeeSchedule employeeSchedule = new EmployeeSchedule();
employeeSchedule = EmployeeScheduleManager.GetEmployeeScheduleByID(Int32.Parse(Request.QueryString["employeeScheduleID"]));
EmployeeSchedule tempEmployeeSchedule = new EmployeeSchedule();
tempEmployeeSchedule.EmployeeScheduleID = employeeSchedule.EmployeeScheduleID;
tempEmployeeSchedule.EmployeeID = Int32.Parse(ddlEmployee.SelectedValue);
tempEmployeeSchedule.ClassDayID = Int32.Parse(ddlClassDay.SelectedValue);
tempEmployeeSchedule.StartTime = txtStartTime.Text;
tempEmployeeSchedule.EndTime = txtEndTime.Text;
tempEmployeeSchedule.RowStatusID = Int32.Parse(ddlRowStatus.SelectedValue);
tempEmployeeSchedule.AddedBy = txtAddedBy.Text;
tempEmployeeSchedule.AddedDate = DateTime.Now;
tempEmployeeSchedule.UpdatedBy = txtUpdatedBy.Text;
tempEmployeeSchedule.UpdateDate = txtUpdateDate.Text;
bool result = EmployeeScheduleManager.UpdateEmployeeSchedule(tempEmployeeSchedule);
Response.Redirect("AdminEmployeeScheduleDisplay.aspx");
}
public bool UpdateEmployeeSchedule(EmployeeSchedule employeeSchedule)
{
using (SqlConnection connection = new SqlConnection(this.ConnectionString))
{
SqlCommand cmd = new SqlCommand("UpdateHR_EmployeeSchedule", connection);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@EmployeeScheduleID", SqlDbType.Int).Value = employeeSchedule.EmployeeScheduleID;
cmd.Parameters.Add("@EmployeeID", SqlDbType.NVarChar).Value = employeeSchedule.EmployeeID;
cmd.Parameters.Add("@ClassDayID", SqlDbType.Int).Value = employeeSchedule.ClassDayID;
cmd.Parameters.Add("@StartTime", SqlDbType.NVarChar).Value = employeeSchedule.StartTime;
cmd.Parameters.Add("@EndTime", SqlDbType.NVarChar).Value = employeeSchedule.EndTime;
cmd.Parameters.Add("@RowStatusID", SqlDbType.Int).Value = employeeSchedule.RowStatusID;
cmd.Parameters.Add("@AddedBy", SqlDbType.NVarChar).Value = employeeSchedule.AddedBy;
cmd.Parameters.Add("@AddedDate", SqlDbType.DateTime).Value = employeeSchedule.AddedDate;
cmd.Parameters.Add("@UpdatedBy", SqlDbType.NVarChar).Value = employeeSchedule.UpdatedBy;
cmd.Parameters.Add("@UpdateDate", SqlDbType.DateTime).Value = employeeSchedule.UpdateDate;
connection.Open();
int result = cmd.ExecuteNonQuery();
return result == 1;
}
}
public int InsertEmployeeSchedule(EmployeeSchedule employeeSchedule)
{
using (SqlConnection connection = new SqlConnection(this.ConnectionString))
{
SqlCommand cmd = new SqlCommand("InsertHR_EmployeeSchedule", connection);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@EmployeeScheduleID", SqlDbType.Int).Direction = ParameterDirection.Output;
cmd.Parameters.Add("@EmployeeID", SqlDbType.UniqueIdentifier).Value = employeeSchedule.EmployeeID;
cmd.Parameters.Add("@ClassDayID", SqlDbType.Int).Value = employeeSchedule.ClassDayID;
cmd.Parameters.Add("@StartTime", SqlDbType.NVarChar).Value = employeeSchedule.StartTime;
cmd.Parameters.Add("@EndTime", SqlDbType.NVarChar).Value = employeeSchedule.EndTime;
cmd.Parameters.Add("@RowStatusID", SqlDbType.Int).Value = employeeSchedule.RowStatusID;
cmd.Parameters.Add("@AddedBy", SqlDbType.UniqueIdentifier).Value = employeeSchedule.AddedBy;
cmd.Parameters.Add("@AddedDate", SqlDbType.DateTime).Value = employeeSchedule.AddedDate;
cmd.Parameters.Add("@UpdatedBy", SqlDbType.UniqueIdentifier).Value = employeeSchedule.UpdatedBy;
cmd.Parameters.Add("@UpdateDate", SqlDbType.DateTime).Value = employeeSchedule.UpdateDate;
connection.Open();
int result = cmd.ExecuteNonQuery();
return (int)cmd.Parameters["@EmployeeScheduleID"].Value;
}
}
public EmployeeSchedule GetEmployeeScheduleFromReader(IDataReader reader)
{
try
{
EmployeeSchedule employeeSchedule = new EmployeeSchedule
(
(int)reader["EmployeeScheduleID"],
reader["EmployeeID"].ToString(),
(int)reader["ClassDayID"],
reader["StartTime"].ToString(),
reader["EndTime"].ToString(),
(int)reader["RowStatusID"],
reader["AddedBy"].ToString(),
(DateTime)reader["AddedDate"],
reader["UpdatedBy"].ToString(),
(DateTime)reader["UpdateDate"]
);
try
{
employeeSchedule.ClassDay = reader["ClassDay"].ToString();
}
catch(Exception ex)
{
}
return employeeSchedule;
}
catch(Exception ex)
{
return null;
}
}
protected void btnAddEmployeeSchedule_Click(object sender, EventArgs e)
{
EmployeeSchedule employeeSchedule = new EmployeeSchedule();
employeeSchedule.EmployeeID = Request.QueryString["ID"];
employeeSchedule.ClassDayID = ddlClassDay.SelectedIndex +1;
employeeSchedule.StartTime = ddlStartHour.SelectedValue+":"+ddlStartMin.SelectedValue+" "+ddlStartTT.SelectedValue;
employeeSchedule.EndTime = ddlEndHour.SelectedValue + ":" + ddlEndMin.SelectedValue + " " + ddlEndTT.SelectedValue;
employeeSchedule.RowStatusID = 1;
employeeSchedule.AddedBy = Profile.card_id;
employeeSchedule.AddedDate = DateTime.Now;
employeeSchedule.UpdatedBy = Profile.card_id;
employeeSchedule.UpdateDate = DateTime.Now;
int resutl = EmployeeScheduleManager.InsertEmployeeSchedule(employeeSchedule);
showEmployeeScheduleGrid();
}
protected void lbSelectEmployeeSchedule_Click(object sender, EventArgs e)
{
ImageButton linkButton = new ImageButton();
linkButton = (ImageButton)sender;
int id;
id = Convert.ToInt32(linkButton.CommandArgument);
hfEmployeeScheduleID.Value = id.ToString();
btnUpdateEmployeeSchedule.Visible = true;
EmployeeSchedule employeeSchedule = new EmployeeSchedule();
employeeSchedule = EmployeeScheduleManager.GetEmployeeScheduleByID(id);
ddlClassDay.SelectedIndex = employeeSchedule.ClassDayID - 1;
ddlStartHour.SelectedValue = employeeSchedule.StartTime.Split(':')[0].Trim();
ddlStartMin.SelectedValue = employeeSchedule.StartTime.Split(':')[1].Split(' ')[0].Trim();
ddlStartTT.SelectedValue = employeeSchedule.StartTime.Split(':')[1].Split(' ')[1].Trim();
ddlEndHour.SelectedValue = employeeSchedule.EndTime.Split(':')[0].Trim();
ddlEndMin.SelectedValue = employeeSchedule.EndTime.Split(':')[1].Split(' ')[0].Trim();
ddlEndTT.SelectedValue = employeeSchedule.EndTime.Split(':')[1].Split(' ')[1].Trim();
}
public string GenerateToken(Users Login)
{
var query = (from t in _Context.Users
join login in _Context.Roles on t.RoleID equals login.RoleID
where Login.UserName == t.UserName && Login.Password == t.Password select new { login.RoleName, t.UserName, t.Password, t.UserID, t.isLoggedIn }).FirstOrDefault();
var getEmployee = (from users in _Context.Users
join emp in _Context.Employees on users.UserID equals emp.UserID
where Login.UserName == users.UserName
select new { emp.EmployeeId }).FirstOrDefault();
if (query != null)
{
if (query.isLoggedIn == false)
{
var key = new SymmetricSecurityKey(Encoding.UTF8.GetBytes(_auth.Value.SecretKey));
var code = new SigningCredentials(key, SecurityAlgorithms.HmacSha256);
var tokenDescriptions = new SecurityTokenDescriptor
{
Subject = new ClaimsIdentity(new Claim[]
{
new Claim("UserID", query.UserID.ToString()),
new Claim(ClaimTypes.Role, query.RoleName)
}),
Issuer = _auth.Value.Issuer,
Audience = _auth.Value.Audience,
Expires = DateTime.UtcNow.AddDays(1),
SigningCredentials = code
};
var tokenHandler = new JwtSecurityTokenHandler();
var securityToken = tokenHandler.CreateToken(tokenDescriptions);
var tokenString = tokenHandler.WriteToken(securityToken);
var checkLogged = (from t in _Context.Users
where query.UserName == t.UserName
select t).FirstOrDefault();
checkLogged.isLoggedIn = true;
_Context.Users.Update(checkLogged);
try
{
var empSchedule = _Context.EmployeeSchedule.Where(x => x.EmployeeID == getEmployee.EmployeeId).OrderByDescending(x => x.CreatedTimeStamp).FirstOrDefault();
if (empSchedule == null)
{
var insertIntoEmpSchedule = new EmployeeSchedule
{
EmployeeID = getEmployee.EmployeeId,
InTime = DateTime.Now
};
_Context.EmployeeSchedule.Add(insertIntoEmpSchedule);
_Context.SaveChanges();
}
else if (empSchedule != null)
{
var insertAnother = new EmployeeSchedule
{
EmployeeID = getEmployee.EmployeeId,
InTime = DateTime.Now
};
_Context.EmployeeSchedule.Add(insertAnother);
if (empSchedule.OutTime != null)
{
_Context.SaveChanges();
}
return(tokenString);
}
}
catch (Exception ex)
{
throw ex;
}
return(tokenString);
}
else
{
return("Already logged in");
}
}
else
{
return("Username or password is incorrect");
}
}
public void SetEmployeeSchedule(EmployeeSchedule schedule)
{
EmployeeSchedule = schedule;
EmployeeSchedule.AssignmentsChanged += LoadAssignments;
}
private void showEmployeeScheduleData()
{
EmployeeSchedule employeeSchedule = new EmployeeSchedule();
employeeSchedule = EmployeeScheduleManager.GetEmployeeScheduleByID(Int32.Parse(Request.QueryString["employeeScheduleID"]));
ddlEmployee.SelectedValue = employeeSchedule.EmployeeID.ToString();
ddlClassDay.SelectedValue = employeeSchedule.ClassDayID.ToString();
txtStartTime.Text = employeeSchedule.StartTime;
txtEndTime.Text = employeeSchedule.EndTime;
ddlRowStatus.SelectedValue = employeeSchedule.RowStatusID.ToString();
txtAddedBy.Text = employeeSchedule.AddedBy;
txtUpdatedBy.Text = employeeSchedule.UpdatedBy;
txtUpdateDate.Text = employeeSchedule.UpdateDate;
}
public Task <bool> UpdateScheduleDaysync(Guid id, EmployeeSchedule schedule)
{
throw new NotImplementedException();
}
public static bool UpdateEmployeeSchedule(EmployeeSchedule employeeSchedule)
{
SqlEmployeeScheduleProvider sqlEmployeeScheduleProvider = new SqlEmployeeScheduleProvider();
return sqlEmployeeScheduleProvider.UpdateEmployeeSchedule(employeeSchedule);
}
public static int InsertEmployeeSchedule(EmployeeSchedule employeeSchedule)
{
SqlEmployeeScheduleProvider sqlEmployeeScheduleProvider = new SqlEmployeeScheduleProvider();
return sqlEmployeeScheduleProvider.InsertEmployeeSchedule(employeeSchedule);
}
public async Task <IHttpActionResult> GetEmplWithPosition([FromUri] TimesPar par)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (!par.DontCare && !par.EmplId.HasValue) //ако го интересува служителя, но няма и служител
{
return(BadRequest(ModelState));
}
ResponseServiceTimes ret = new ResponseServiceTimes();
int dayOfW = ((int)par.DateTimeRes.DayOfWeek == 0) ? 7 : (int)par.DateTimeRes.DayOfWeek;
if (par.DontCare)
{
SalonSchedule startEndTime = new SalonSchedule();
startEndTime = await db.SalonSchedules.Where(
x => x.SalonID == par.SalonId && x.DayOfWeek == dayOfW).FirstOrDefaultAsync();
if (startEndTime != null)
{
if (!startEndTime.Holiday && startEndTime.StartTime.HasValue && startEndTime.EndTime.HasValue)
{
TimeSpan startTime = startEndTime.StartTime.Value;
TimeSpan endTime = startEndTime.StartTime.Value.Add(par.ServiceDur);
TimeSpan timeToAdd = TimeSpan.FromMinutes(15);
TimeSpan currentStartTime = startTime;
TimeSpan currentEndTime = endTime;
List <ServiceTime> times = new List <ServiceTime>();
do
{
ServiceTime tempTime = new ServiceTime();
tempTime.StartTime = currentStartTime;
tempTime.EndTime = currentEndTime;
times.Add(tempTime);
currentStartTime = currentStartTime.Add(timeToAdd);
currentEndTime = currentEndTime.Add(timeToAdd);
}while (currentEndTime <= startEndTime.EndTime.Value);
ret.Result = "OK";
ret.times = times;
return(Ok(ret));
}
else
{
ret.Result = "Holiday";
return(Ok(ret));
}
}
else
{
ret.Result = "No schedule";
return(Ok(ret));
}
}
else
{
EmployeeSchedule startEndTime = new EmployeeSchedule();
startEndTime = await db.EmployeeSchedules.Where(
x => x.EmployeeID == par.EmplId && x.DayOfWeek == dayOfW).FirstOrDefaultAsync();
if (startEndTime != null)
{
if (!startEndTime.Holiday && startEndTime.StartTime.HasValue && startEndTime.EndTime.HasValue)
{
TimeSpan startTime = startEndTime.StartTime.Value;
TimeSpan endTime = startEndTime.StartTime.Value.Add(par.ServiceDur);
TimeSpan timeToAdd = TimeSpan.FromMinutes(15);
TimeSpan currentStartTime = startTime;
TimeSpan currentEndTime = endTime;
List <ServiceTime> times = new List <ServiceTime>();
do
{
ServiceTime tempTime = new ServiceTime();
tempTime.StartTime = currentStartTime;
tempTime.EndTime = currentEndTime;
times.Add(tempTime);
currentStartTime = currentStartTime.Add(timeToAdd);
currentEndTime = currentEndTime.Add(timeToAdd);
}while (currentEndTime <= startEndTime.EndTime.Value);
ret.Result = "OK";
ret.times = times;
return(Ok(ret));
}
else
{
ret.Result = "Holiday";
return(Ok(ret));
}
}
else
{
ret.Result = "No schedule";
return(Ok(ret));
}
}
}
