public async Task <ReturnMsgViewModel> NotiSettingAsync(NotiSettingViewModel setting)
{
ReturnMsgViewModel data = new ReturnMsgViewModel();
data.message = new messageModel();
try
{
using (var context = new StandardcanContext())
{
var userId = JwtHelper.GetUserIdFromToken(HttpContext);
if (String.IsNullOrEmpty(userId))
{
throw new Exception("Unauthorized Access");
}
try
{
var jsonData = JsonConvert.SerializeObject(new
{
emp_id = userId,
noti_status = setting.notification
});
SystemLog systemLog = new SystemLog()
{
module = "api/Setting/NotiSetting",
data_log = jsonData
};
await _systemLogService.InsertSystemLogAsync(systemLog);
SqlParameter emp_id = new SqlParameter("emp_id", userId ?? "");
SqlParameter noti_status = new SqlParameter("noti_status", setting.notification ?? "");
SqlParameter lang = new SqlParameter("lang", setting.language ?? "");
await context.Database.ExecuteSqlCommandAsync("sp_mb_update_setting @emp_id, @noti_status", emp_id, noti_status);
}
catch (Exception ex)
{
throw new Exception("Noticiation is Error");
}
data.message.status = "1";
data.message.msg = "Success";
}
}
catch (Exception ex)
{
data.message.status = "2";
data.message.msg = ex.Message;
}
return(data);
}
public async Task <ReturnMsgViewModel> CheckInTimeAsync(CheckInTimeViewModel dataCheckin)
{
ReturnMsgViewModel data = new ReturnMsgViewModel();
data.message = new messageModel();
try
{
var dt = DateTime.Now;
var userId = JwtHelper.GetUserIdFromToken(HttpContext);
if (String.IsNullOrEmpty(userId))
{
throw new Exception("Unauthorized Access");
}
using (var context = new StandardcanContext())
{
var jsonData = JsonConvert.SerializeObject(new
{
emp_id = userId,
qrcode = dataCheckin.qrcode,
lang = dataCheckin.language
});
SystemLog systemLog = new SystemLog()
{
module = "api/TimeInOut/CheckInTime",
data_log = jsonData
};
await _systemLogService.InsertSystemLogAsync(systemLog);
SqlParameter emp_id = new SqlParameter("emp_id", userId ?? "");
SqlParameter qrcode = new SqlParameter("qrcode", dataCheckin.qrcode ?? "");
SqlParameter lang = new SqlParameter("lang", dataCheckin.language ?? "");
//SqlParameter newPass = new SqlParameter("new_pass", newPassEncrypt ?? "");
var spData = context.SpMbMeetingCheckin.FromSqlRaw("sp_mb_meeting_checkin @emp_id, @qrcode, @lang", emp_id, qrcode, lang).ToList();
foreach (var item in spData)
{
data.message.status = item.status;
data.message.msg = item.msg;
}
}
}
catch (Exception ex)
{
data.message.status = "2";
data.message.msg = ex.Message;
}
return(data);
}
public async Task <ReturnMsgViewModel> UpdateUserAsync(EmpProfileDataViewModel user)
{
ReturnMsgViewModel data = new ReturnMsgViewModel();
data.message = new messageModel();
try
{
var userId = JwtHelper.GetUserIdFromToken(HttpContext);
if (String.IsNullOrEmpty(userId))
{
throw new Exception("Unauthorized Access");
}
using (var context = new StandardcanContext())
{
var jsonData = JsonConvert.SerializeObject(new
{
emp_id = userId,
tel = user.tel,
email = user.email,
line = user.line,
lang = user.language
});
SystemLog systemLog = new SystemLog()
{
module = "api/User/UpdateUser",
data_log = jsonData
};
await _systemLogService.InsertSystemLogAsync(systemLog);
SqlParameter emp_id = new SqlParameter("emp_id", userId ?? "");
SqlParameter tel = new SqlParameter("tel", user.tel ?? "");
SqlParameter email = new SqlParameter("email", user.email ?? "");
SqlParameter line = new SqlParameter("line", user.line ?? "");
SqlParameter lang = new SqlParameter("lang", user.language ?? "");
await context.Database.ExecuteSqlCommandAsync("sp_mb_update_profile @emp_id, @tel, @email, @line, @lang", emp_id, tel, email, line, lang);
data.message.status = "1";
data.message.msg = "Success";
}
}
catch (Exception ex)
{
data.message.status = "2";
data.message.msg = ex.Message;
}
return(data);
}
public async Task <ReturnMsgViewModel> UserChangePasswordAsync(ChangePasswordViewModel user)
{
ReturnMsgViewModel data = new ReturnMsgViewModel();
data.message = new messageModel();
try
{
var dt = DateTime.Now;
var userId = JwtHelper.GetUserIdFromToken(HttpContext);
if (String.IsNullOrEmpty(userId))
{
throw new Exception("Unauthorized Access");
}
using (var context = new StandardcanContext())
{
var userDetail = context.EmpProfile.SingleOrDefault(a => a.EmpId.ToString() == userId);
if (userDetail == null)
{
throw new Exception("Data not found");
}
var oldPassEncrypt = Cipher.Encrypt(user.old_password, secrectKey);
if (oldPassEncrypt != userDetail.EmpPassword)
{
throw new Exception("Old Password is incorrect");
}
var newPassEncrypt = Cipher.Encrypt(user.new_password, secrectKey);
SqlParameter emp_id = new SqlParameter("emp_id", userId ?? "");
SqlParameter newPass = new SqlParameter("new_pass", newPassEncrypt ?? "");
await context.Database.ExecuteSqlCommandAsync("sp_mb_update_password @emp_id, @new_pass", emp_id, newPass);
data.message.status = "1";
data.message.msg = "Success";
}
}
catch (Exception ex)
{
data.message.status = "2";
data.message.msg = ex.Message;
}
return(data);
}
public async Task <ReturnMsgViewModel> UserResetPasswordAsync(ResetPasswordViewModel user)
{
ReturnMsgViewModel data = new ReturnMsgViewModel();
data.message = new messageModel();
try
{
using (var context = new StandardcanContext())
{
var jsonData = JsonConvert.SerializeObject(new
{
emp_id = user.emp_code,
lang = user.language
});
SystemLog systemLog = new SystemLog()
{
module = "api/Authentication/UserResetPassword",
data_log = jsonData
};
await _systemLogService.InsertSystemLogAsync(systemLog);
var newPassEncrypt = Cipher.Encrypt(user.new_pass, secrectKey);
SqlParameter emp_code = new SqlParameter("emp_code", user.emp_code ?? "");
SqlParameter new_pass = new SqlParameter("new_pass", newPassEncrypt ?? "");
await context.Database.ExecuteSqlCommandAsync("sp_mb_set_password @emp_code, @new_pass", emp_code, new_pass);
data.message.status = "1";
data.message.msg = "Success";
}
}
catch (Exception ex)
{
data.message.status = "2";
data.message.msg = ex.Message;
}
return(data);
}
//public async Task<ReturnMsgViewModel> CheckinOutdoorAsync(CheckinOutdoorViewModel dataCheckin)
//{
// ReturnMsgViewModel data = new ReturnMsgViewModel();
// data.message = new messageModel();
// try
// {
// var dt = DateTime.Now;
// var userId = JwtHelper.GetUserIdFromToken(HttpContext);
// if (String.IsNullOrEmpty(userId))
// {
// throw new Exception("Unauthorized Access");
// }
// using (var context = new StandardcanContext())
// {
// var jsonData = JsonConvert.SerializeObject(new
// {
// TarDate = dt.ToString("dd/MM/yyyy"),
// TarTime = dt.ToString("dd/MM/yyyy HH:mm:ss"),
// TarType = 2,
// EmpId = userId,
// MLat = dataCheckin.lat,
// MLong = dataCheckin.lng,
// Remark = dataCheckin.remark,
// Img = dataCheckin.img
// });
// SystemLog systemLog = new SystemLog()
// {
// module = "api/TimeInOut/CheckinOutdoor",
// data_log = jsonData
// };
// await _systemLogService.InsertSystemLogAsync(systemLog);
// TimeAttRealtime timeAttRealtime = new TimeAttRealtime();
// timeAttRealtime.TarDate = dt;
// timeAttRealtime.TarTime = dt;
// timeAttRealtime.TarType = 2;
// timeAttRealtime.EmpId = Convert.ToInt32(userId);
// timeAttRealtime.MLat = dataCheckin.lat;
// timeAttRealtime.MLong = dataCheckin.lng;
// timeAttRealtime.Remark = dataCheckin.remark;
// context.TimeAttRealtime.Add(timeAttRealtime);
// await context.SaveChangesAsync();
// if (timeAttRealtime.TarId != 0)
// {
// if (dataCheckin.img != null)
// {
// foreach (var item in dataCheckin.img)
// {
// var intIdt = context.TimeAttImage.DefaultIfEmpty().Max(r => r == null ? 1 : r.TariId);
// TimeAttImage timeImg = new TimeAttImage();
// timeImg.TarId = timeAttRealtime.TarId;
// string[] img = item.base64.Split(',');
// var imgBase64 = img.Count() > 1 ? img[1] : img[0];
// byte[] imgbyte = Convert.FromBase64String(imgBase64);
// var uniqueFileName = "TimeAtt_" + timeAttRealtime.TarId + "_" + intIdt + ".JPG";
// string filePath = Path.Combine(_environment.ContentRootPath + "\\images\\TimeAttReal\\", uniqueFileName);
// var uploads = Path.Combine(_environment.ContentRootPath + "\\images\\TimeAttReal");
// if (!Directory.Exists(uploads))
// {
// Directory.CreateDirectory(uploads);
// }
// using (FileStream fs = new FileStream(filePath, FileMode.Create))
// {
// using (BinaryWriter bw = new BinaryWriter(fs))
// {
// bw.Write(imgbyte);
// fs.Flush(true);
// }
// }
// timeImg.TariImage = uniqueFileName;
// timeImg.TariUpdateDate = dt;
// context.TimeAttImage.Add(timeImg);
// await context.SaveChangesAsync();
// }
// }
// }
// data.message.status = "1";
// data.message.msg = "Success";
// }
// }
// catch (Exception ex)
// {
// data.message.status = "2";
// data.message.msg = ex.Message;
// }
// return data;
//}
public async Task <ReturnMsgViewModel> CheckinOutdoorAsync(CheckinOutdoorViewModel dataCheckin)
{
ReturnMsgViewModel data = new ReturnMsgViewModel();
data.message = new messageModel();
try
{
var dt = DateTime.Now;
var userId = JwtHelper.GetUserIdFromToken(HttpContext);
if (String.IsNullOrEmpty(userId))
{
throw new Exception("Unauthorized Access");
}
string stime = dt.ToString("dd/MM/yyyy HH:mm:ss");
using (var context = new StandardcanContext())
{
var jsonData = JsonConvert.SerializeObject(new
{
TarDate = dt.ToString("dd/MM/yyyy"),
TarTime = dt.ToString("dd/MM/yyyy HH:mm:ss"),
TarType = 2,
EmpId = userId,
MLat = dataCheckin.lat,
MLong = dataCheckin.lng,
Remark = dataCheckin.remark,
Img = dataCheckin.img
});
SystemLog systemLog = new SystemLog()
{
module = "api/TimeInOut/CheckinOutdoor",
data_log = jsonData
};
await _systemLogService.InsertSystemLogAsync(systemLog);
TimeAttRealtime timeAttRealtime = new TimeAttRealtime();
timeAttRealtime.TarDate = dt;
timeAttRealtime.TarTime = dt;
timeAttRealtime.TarType = 2;
timeAttRealtime.EmpId = Convert.ToInt32(userId);
timeAttRealtime.MLat = dataCheckin.lat;
timeAttRealtime.MLong = dataCheckin.lng;
timeAttRealtime.Remark = dataCheckin.remark;
context.TimeAttRealtime.Add(timeAttRealtime);
await context.SaveChangesAsync();
if (timeAttRealtime.TarId != 0)
{
if (dataCheckin.img != null)
{
foreach (var item in dataCheckin.img)
{
var intIdt = context.TimeAttImage.DefaultIfEmpty().Max(r => r == null ? 1 : r.TariId);
TimeAttImage timeImg = new TimeAttImage();
timeImg.TarId = timeAttRealtime.TarId;
string[] img = item.base64.Split(',');
var imgBase64 = img.Count() > 1 ? img[1] : img[0];
byte[] imgbyte = Convert.FromBase64String(imgBase64);
var uniqueFileName = "TimeAtt_" + timeAttRealtime.TarId + "_" + intIdt + ".JPG";
// string filePath = Path.Combine(_environment.ContentRootPath + "\\images\\TimeAttReal\\", uniqueFileName);
//var uploads = Path.Combine(_environment.ContentRootPath + "\\images\\TimeAttReal");
string root = @"D:\SmartCard\API";
string filePath = Path.Combine(root + "\\images\\TimeAttReal\\", uniqueFileName);
var uploads = Path.Combine(root + "\\images\\TimeAttReal");
if (!Directory.Exists(uploads))
{
Directory.CreateDirectory(uploads);
}
using (FileStream fs = new FileStream(filePath, FileMode.Create))
{
using (BinaryWriter bw = new BinaryWriter(fs))
{
bw.Write(imgbyte);
fs.Flush(true);
}
}
timeImg.TariImage = uniqueFileName;
timeImg.TariUpdateDate = dt;
context.TimeAttImage.Add(timeImg);
await context.SaveChangesAsync();
}
}
}
data.message.status = "1";
data.message.msg = "ลงเวลาสำเร็จ : " + stime;
}
}
catch (Exception ex)
{
data.message.status = "2";
data.message.msg = ex.Message;
}
return(data);
}
