public string GetSystemConfigDepartmentValue(SystemConfigDepartmentQuery query)
{
var systemConfig = new SystemConfig();
systemConfig = _entities.SystemConfigs.FirstOrDefault(x => x.Title == query.Title && x.Deleted == false && x.Active == true);
if (systemConfig != null)
{
if (!systemConfig.AllowClientEdit)
{
return(systemConfig.Value);
}
else
{
var systemConfigDepartment = new SystemConfigDepartment();
systemConfigDepartment = _entities.SystemConfigDepartments.FirstOrDefault(x => x.DepartmentId == query.DepartmentId && x.ConfigId == systemConfig.Id);
if (systemConfigDepartment != null)
{
return(systemConfigDepartment.Value);
}
else
{
return(systemConfig.Value);
}
}
}
else
{
return(query.DefaultValue);
}
}
public string GenerateTaskCode(int departmentId)
{
#region Generate TaskCode
string taskCode = "";
string taskCodeText = "";
string taskCodeNumber = "";
try
{
var systemConfigDepartmentQuery = new SystemConfigDepartmentQuery();
systemConfigDepartmentQuery.DepartmentId = departmentId;
systemConfigDepartmentQuery.DefaultValue = "TASK";
systemConfigDepartmentQuery.Title = "TASKCODE";
taskCodeText = _systemConfigDepartmentRepository.GetSystemConfigDepartmentValue(systemConfigDepartmentQuery);
systemConfigDepartmentQuery.DefaultValue = "0";
systemConfigDepartmentQuery.Title = "TASKNUMBER";
string taskCodeNumberConfig = _systemConfigDepartmentRepository.GetSystemConfigDepartmentValue(systemConfigDepartmentQuery);
taskCodeNumber = (int.Parse(taskCodeNumberConfig) + 1).ToString("D4");
taskCode = taskCodeText + taskCodeNumber;
}
catch
{
}
return(taskCode);
#endregion Generate TaskCode
}
/// <summary>
/// Config email
/// </summary>
/// <param name="message"></param>
/// <returns></returns>
public async Task configSendGridasync(IdentityMessage message)
{
SystemConfigDepartmentQuery query = new SystemConfigDepartmentQuery();
SystemConfigDepartmentRepository _systemConfigDepartmentRepository = new SystemConfigDepartmentRepository();
query.Title = "NOTICEEMAIL";
string fromEmail = _systemConfigDepartmentRepository.GetSystemConfigDepartmentValue(query);
query.Title = "NOTICEEMAIL_PASSWORD";
string fromEmailPassword = _systemConfigDepartmentRepository.GetSystemConfigDepartmentValue(query);
dynamic MailMessage = new MailMessage();
MailMessage.From = new MailAddress(fromEmail);
MailMessage.To.Add(message.Destination);
MailMessage.Subject = message.Subject;
MailMessage.IsBodyHtml = true;
MailMessage.Body = message.Body;
SmtpClient SmtpClient = new SmtpClient();
SmtpClient.Host = "smtp.gmail.com";
SmtpClient.EnableSsl = true;
SmtpClient.Port = 587;
SmtpClient.Credentials = new System.Net.NetworkCredential(fromEmail, fromEmailPassword);
try
{
try
{
SmtpClient.Send(MailMessage);
}
catch (Exception ex)
{
}
}
catch (SmtpFailedRecipientsException ex)
{
for (int i = 0; i <= ex.InnerExceptions.Length; i++)
{
SmtpStatusCode status = ex.StatusCode;
if ((status == SmtpStatusCode.MailboxBusy) | (status == SmtpStatusCode.MailboxUnavailable))
{
System.Threading.Thread.Sleep(5000);
SmtpClient.Send(MailMessage);
}
}
}
}
public BaseResponse <SystemConfigDepartment> GetSystemConfigDepartmentValue(SystemConfigDepartmentQuery query)
{
var response = new BaseResponse <SystemConfigDepartment>();
try
{
SystemConfigDepartment systemConfigDepartment = new SystemConfigDepartment();
systemConfigDepartment.Value = _systemConfigDepartmentRepository.GetSystemConfigDepartmentValue(query);
response.Value = systemConfigDepartment;
}
catch (Exception ex)
{
response.Message = "Error: " + ex.Message + " StackTrace: " + ex.StackTrace;
response.IsSuccess = false;
}
return(response);
}
public List <SPGetSystemConfigDepartment_Result> Filter(SystemConfigDepartmentQuery query, out int count)
{
count = 0;
int pageNumber = query.PageNumber != 0 ? query.PageNumber : 1;
var keyword = string.IsNullOrEmpty(query.Keyword) != true ? query.Keyword : "";
var start = 0;
var limit = query.PageSize;
var depatmentId = query.DepartmentId;
start = (pageNumber - 1) * limit;
int totalRow = 0;
List <SPGetSystemConfigDepartment_Result> result = new List <SPGetSystemConfigDepartment_Result>();
ObjectParameter prTotalRow = new ObjectParameter("total", totalRow);
result = _entities.SPGetSystemConfigDepartment(Util.DetecVowel(keyword), depatmentId, start, limit, prTotalRow).ToList();
count = (prTotalRow.Value == null) ? 0 : Convert.ToInt32(prTotalRow.Value);
return(result);
}
public async static void SendEmail(int departmentId, string mailTo, string mailCC, string mailBCC, string subject, string content)
{
SystemConfigDepartmentQuery query = new SystemConfigDepartmentQuery();
query.DefaultValue = "*****@*****.**";
query.DepartmentId = departmentId;
query.Title = "NOTICEEMAIL";
string fromEmail = _systemConfigDepartmentRepository.GetSystemConfigDepartmentValue(query);
query.DefaultValue = "duyhung@6";
query.DepartmentId = departmentId;
query.Title = "NOTICEEMAIL_PASSWORD";
string fromEmailPassword = _systemConfigDepartmentRepository.GetSystemConfigDepartmentValue(query);
try
{
await EmailHelper.Send_Email(fromEmail, fromEmailPassword, mailTo, mailCC, mailBCC, subject, content);
}
catch
{
}
}
public async Task <IHttpActionResult> ForgotPassword(ForgotPasswordViewModel model)
{
if (ModelState.IsValid)
{
var user = await UserManager.FindByEmailAsync(model.Email);
if (user == null || !(await UserManager.IsEmailConfirmedAsync(user.Id)))
{
// Don't reveal that the user does not exist or is not confirmed
return(BadRequest("Either user does not exist or you have not confirmed your email."));
}
try
{
// Send an email with this link
SystemConfigDepartmentQuery query = new SystemConfigDepartmentQuery();
SystemConfigDepartmentRepository _systemConfigDepartmentRepository = new SystemConfigDepartmentRepository();
query.Title = "APP_DOMAIN";
string url = _systemConfigDepartmentRepository.GetSystemConfigDepartmentValue(query);
string code = await UserManager.GeneratePasswordResetTokenAsync(user.Id);
//string callbackUrl = Url.Link("Default", new { controller = "/#!/reset-password", userId = user.Id, code = code });
string callbackUrl = url + "/#!/reset-mat-khau?userId=" + user.Id + "&code=" + code;
await UserManager.SendEmailAsync(user.Id, "Khôi phục mật khẩu", "Chào bạn, để khôi phục mật khẩu truy cập hệ thống vOffice, xin vui lòng click vào <a href=\"" + callbackUrl + "\">đây</a>");
return(Ok());
}
catch
{
return(InternalServerError());
}
}
return(BadRequest());
}
public BaseResponse <int> AddStaff(ComplexStaff model)
{
Staff obj = new Staff();
obj.StaffCode = model.StaffCode;
obj.FirstName = model.FirstName;
obj.LastName = model.LastName;
obj.FullName = model.FullName;
obj.UserId = model.UserId;
obj.Email = model.Email;
obj.PhoneNumber = model.PhoneNumber;
obj.DateOfBirth = model.DateOfBirth;
obj.Gender = model.Gender;
obj.Address = model.Address;
obj.Avatar = model.Avatar;
obj.Order = model.Order;
obj.Leader = model.Leader;
obj.SeniorLeader = model.SeniorLeader;
obj.SuperLeader = model.SuperLeader;
obj.SignedBy = model.SignedBy;
obj.Active = model.Active;
obj.Deleted = model.Deleted;
obj.CreatedBy = model.CreatedBy;
obj.CreatedOn = model.CreatedOn;
obj.EditedBy = model.EditedBy;
obj.EditedOn = model.EditedOn;
var response = new BaseResponse <int>();
var responseTemp = new BaseResponse <Staff>();
#region Generate TaskCode
string taskCode = "";
string taskCodeText = "";
string taskCodeNumber = "";
try
{
var systemConfigDepartmentQuery = new SystemConfigDepartmentQuery();
systemConfigDepartmentQuery.DepartmentId = model.DepartmentId;
systemConfigDepartmentQuery.DefaultValue = "CB";
systemConfigDepartmentQuery.Title = "STAFFCODE";
taskCodeText = _systemConfigDepartmentRepository.GetSystemConfigDepartmentValue(systemConfigDepartmentQuery);
systemConfigDepartmentQuery.DefaultValue = "0";
systemConfigDepartmentQuery.Title = "STAFFNUMBER";
string taskCodeNumberConfig = _systemConfigDepartmentRepository.GetSystemConfigDepartmentValue(systemConfigDepartmentQuery);
taskCodeNumber = (int.Parse(taskCodeNumberConfig) + 1).ToString("D4");
taskCode = taskCodeText + taskCodeNumber;
}
catch
{
}
#endregion Generate TaskCode
try
{
obj.CreatedOn = DateTime.Now;
responseTemp.Value = _staffRepository.Add(obj);
response.Value = responseTemp.Value.Id;
_applicationLoggingRepository.Log("EVENT", "ADD", "Staff", "", "", "", obj, "", HttpContext.Current.Request.UserHostAddress, obj.CreatedBy);
//Update SystemConfigDepartment
SystemConfigDepartment taskCodeNumberSystemConfigDepartment = new SystemConfigDepartment();
taskCodeNumberSystemConfigDepartment = _systemConfigDepartmentRepository.GetByTitle("STAFFNUMBER", model.DepartmentId);
if (taskCodeNumberSystemConfigDepartment != null)
{
taskCodeNumberSystemConfigDepartment.Value = taskCodeNumber;
_systemConfigDepartmentRepository.Edit(taskCodeNumberSystemConfigDepartment);
}
}
catch (Exception ex)
{
response.IsSuccess = false;
response.Message = "Error: " + ex.Message + " StackTrace: " + ex.StackTrace;
}
return(response);
}
public BaseResponse <SystemConfigDepartment> GetValue([FromUri] SystemConfigDepartmentQuery query)
{
return(shareService.GetSystemConfigDepartmentValue(query));
}
public BaseListResponse <SPGetSystemConfigDepartment_Result> Search([FromUri] SystemConfigDepartmentQuery query)
{
return(shareService.FilterSystemConfigDepartment(query));
}
public BaseListResponse <SPGetSystemConfigDepartment_Result> FilterSystemConfigDepartment(SystemConfigDepartmentQuery query)
{
var response = new BaseListResponse <SPGetSystemConfigDepartment_Result>();
int count = 0;
try
{
response.Data = _systemConfigDepartmentRepository.Filter(query, out count);
response.TotalItems = count;
response.PageNumber = query.PageNumber != 0 ? query.PageNumber : 1;
response.PageSize = query.PageSize;
}
catch (Exception ex)
{
response.Message = "Error: " + ex.Message + " StackTrace: " + ex.StackTrace;
}
return(response);
}
