protected void Login_Click(object sender, EventArgs e)
{
if (IsValid)
{
var cUser = new CUser();
var user = cUser.Get(tbUsername.Text.Trim());
if (user != null)
{
if (CCryptography.DecryptCipherTextToPlainText(user.Password.Trim()) == tbPassword.Text.Trim())
{
if (user.IsActive)
{
btLogin.Enabled = false;
Session["UserId"] = user.UserId;
Session["SiteLocationId"] = user.SiteLocationId;
var siteLocation = (new CSiteLocation()).Get(user.SiteLocationId);
if (siteLocation != null)
{
Session["SiteId"] = siteLocation.SiteId;
Session["SiteName"] = new CSite().Get(siteLocation.SiteId)?.Abbreviation;
Session["SiteLocationName"] = siteLocation.Name;
}
Session["UserName"] = cUser.GetUserName(user);
Session["UserPositionId"] = user.UserPositionId;
var userPosition = (new CUserPosition()).Get(user.UserPositionId);
if (userPosition != null)
{
Session["UserGroupId"] = userPosition.UserGroupId;
}
var userPermissionModelList = (new CUserPermission()).GetUserPermissionModelList(user.UserId);
Session["UserPermissionModelList"] = userPermissionModelList;
RadAjaxPanel1.Redirect("~/Dashboard");
}
else
{
ShowMessage("Your account is disabled<br /><br />Please contact administrator.");
}
// set cookie
WriteCookie("IsKeepSign", RadButtonKeepSign.Checked ? "1" : "0");
if (RadButtonKeepSign.Checked)
{
WriteCookie("Username", tbUsername.Text.Trim());
}
}
else
{
ShowMessage("Wrong Password<br /><br />Please try again!");
}
}
else
{
ShowMessage("Invalid Login Id<br /><br />Please try again!");
}
}
}
public static string AutenticacionUsuario(string usuario, string contrasena)
{
try
{
CCryptography objCCryptography = new CCryptography();
usuario = usuario.Trim();
contrasena = objCCryptography.Encrypt(contrasena,"{MD5/MGGROUP@Security}");
using (ESM.Model.ESMBDDataContext db = new ESM.Model.ESMBDDataContext())
{
string idusuario = null;
Table<Usuario> tUsuarios = db.GetTable<Usuario>();
var rUsuarios = from u in tUsuarios
where u.Contrasena == contrasena && u.Usuario1 == usuario
select new { u.IdUsuario };
foreach (var r in rUsuarios)
{
idusuario = r.IdUsuario.ToString();
}
if (rUsuarios.Count() != 0)
{
var tkc = new FormsAuthenticationTicket(usuario, true, 15000);
string encriptar = FormsAuthentication.Encrypt(tkc);
HttpContext.Current.Response.Cookies.Add(
new HttpCookie(FormsAuthentication.FormsCookieName, encriptar));
}
return idusuario;
}
}
catch (Exception)
{
return null;
}
}
protected void StaffButtonClicked(object sender, RadToolBarEventArgs e)
{
if (e.Item.Text == @"New")
{
ResetForm();
}
else if (e.Item.Text == @"Update" && RadGridUser.SelectedValue != null)
{
if (IsValid)
{
var cUser = new CUser();
var user = cUser.Get(Convert.ToInt32(RadGridUser.SelectedValue));
if (string.IsNullOrEmpty(tbPassWord.Text) == false)
{
user.Password = CCryptography.EncryptPlainTextToCipherText(tbPassWord.Text.Trim());
}
user.FirstName = tbFName.Text;
user.MidName = tbMName.Text;
user.LastName = tbLName.Text;
user.DOB = tbDOB.SelectedDate;
user.MaritalStatus = ddlMarital.SelectedValue;
user.Gender = ddlGender.SelectedValue;
user.Email = tbWEmail.Text.Trim();
user.Phone = tbWPhone.Text.Trim();
user.EContactName = tbEName.Text;
user.ERelation = tbERelation.Text;
user.EPhone = tbEPhone.Text;
user.EAddress = tbEAddress.Text;
// only HR or IT can modify those things.
if (CurrentGroupId == (int)CConstValue.UserGroupForUserInformation.HR ||
CurrentGroupId == (int)CConstValue.UserGroupForUserInformation.IT)
{
user.UserPositionId = Convert.ToInt32(RadComboBoxUserPosition.SelectedValue);
user.SINNo = Convert.ToInt32(tbSIN.Text);
user.SiteLocationId = Convert.ToInt32(RadComboBoxSiteLocation.SelectedValue);
user.EmployeeNumber = tbEmpNo.Text;
user.IsActive = cbActive.Checked;
int?supervisor = string.IsNullOrEmpty(RadComboBoxSuper.SelectedValue) ? (int?)null : Convert.ToInt32(RadComboBoxSuper.SelectedValue);
if (user.Supervisor != supervisor)
{
user.Supervisor = supervisor;
var cApp = new CApproval();
var appList = cApp.GetList(Convert.ToInt32(RadGridUser.SelectedValue));
foreach (var app in appList)
{
app.Supervisor = user.Supervisor;
app.IsActive = user.IsActive;
app.UpdatedId = CurrentUserId;
app.UpdatedDate = DateTime.Now;
cApp.Update(app);
}
}
}
user.Address1 = tbPAddess1.Text;
user.Address2 = tbPAddess2.Text;
user.City = tbPCity.Text;
user.Province = tbPProvince.Text;
user.PostalCode = tbPPostal.Text;
user.HomePhone = tbPHomePhone.Text;
user.CellPhone = tbPCell.Text;
user.PersonalEmail = tbPEmail.Text;
user.UpdatedId = CurrentUserId;
user.UpdatedDate = DateTime.Now;
if (AsyncUploadPicture.UploadedFiles.Count > 0)
{
UploadedFile file = AsyncUploadPicture.UploadedFiles[0];
byte[] fileData = new byte[file.InputStream.Length];
file.InputStream.Read(fileData, 0, (int)file.InputStream.Length);
user.Picture = fileData;
}
if (cUser.Update(user))
{
RadGridUser.Rebind();
ShowMessage("Updated Staff Info Successfully");
}
else
{
ShowMessage("Failed To Update Staff Info");
}
}
}
else if (e.Item.Text == @"Save")
{
if (IsValid)
{
var cUser = new CUser();
var user = new Erp2016.Lib.User();
if (CurrentSiteId != 1)
{
user.SiteLocationId = Convert.ToInt32(CurrentSiteLocationId);
}
else
{
user.SiteLocationId = Convert.ToInt32(RadComboBoxSiteLocation.SelectedValue);
}
user.LoginId = tbUserID.Text;
user.Password = CCryptography.EncryptPlainTextToCipherText(tbPassWord.Text.Trim());
user.FirstName = tbFName.Text;
user.MidName = tbMName.Text;
user.LastName = tbLName.Text;
user.SINNo = Convert.ToInt32(tbSIN.Text);
user.DOB = tbDOB.SelectedDate;
user.MaritalStatus = ddlMarital.SelectedValue;
user.Gender = ddlGender.SelectedValue;
user.Email = tbWEmail.Text.Trim();
user.Phone = tbWPhone.Text.Trim();
user.UserPositionId = Convert.ToInt32(RadComboBoxUserPosition.SelectedValue);
if (!string.IsNullOrEmpty(RadComboBoxSuper.SelectedValue))
{
user.Supervisor = Convert.ToInt32(RadComboBoxSuper.SelectedValue);
}
user.EmployeeNumber = tbEmpNo.Text;
user.EContactName = tbEName.Text;
user.ERelation = tbERelation.Text;
user.EPhone = tbEPhone.Text;
user.EAddress = tbEAddress.Text;
user.Address1 = tbPAddess1.Text;
user.Address2 = tbPAddess2.Text;
user.City = tbPCity.Text;
user.Province = tbPProvince.Text;
user.PostalCode = tbPPostal.Text;
user.HomePhone = tbPHomePhone.Text;
user.CellPhone = tbPCell.Text;
user.PersonalEmail = tbPEmail.Text;
user.IsActive = true;
user.CreatedId = CurrentUserId;
user.CreatedDate = DateTime.Now;
if (AsyncUploadPicture.UploadedFiles.Count > 0)
{
UploadedFile file = AsyncUploadPicture.UploadedFiles[0];
byte[] fileData = new byte[file.InputStream.Length];
file.InputStream.Read(fileData, 0, (int)file.InputStream.Length);
user.Picture = fileData;
}
int newUserId = cUser.Add(user);
if (newUserId > 0)
{
var tempSupervisor = user.Supervisor ?? CConstValue.UserSystemId;
var cApproval = new CApproval();
var approval = cApproval.GetAppType(tempSupervisor);
foreach (var a in approval)
{
var type = new Approval();
type.ApproveType = a.ApproveType;
type.UserId = newUserId;
type.Supervisor = a.UserId;
type.IsActive = true;
type.CreatedId = CurrentUserId;
type.CreatedDate = DateTime.Now;
cApproval.Add(type);
}
// vacation Schema
var cVacationSchema = new CVacationSchema();
var isKgic = new CSite().Get(new CSiteLocation().Get(user.SiteLocationId).SiteId).Abbreviation.ToLower() == "kgic";
for (var i = 1; i <= 6; i++)
{
var vacationType = 0;
var date = i % 2 == 0 ? DateTime.Today.AddYears(1) : DateTime.Today;
switch (i)
{
case 1:
case 2:
vacationType = (int)CConstValue.VacationType.PaidVacationDay;
break;
case 3:
case 4:
vacationType = (int)CConstValue.VacationType.SickDay;
break;
case 5:
case 6:
if (isKgic == false)
{
continue;
}
vacationType = (int)CConstValue.VacationType.EntitlementDay;
break;
}
cVacationSchema.Add(new VacationSchema
{
Date = date,
UserId = newUserId,
VacationType = vacationType,
TotalDays = 0,
CreatedId = CurrentUserId,
CreatedDate = DateTime.Now
});
}
// user permission
new CUserPermission().SetBasicPermission(user, CurrentUserId);
RadGridUser.Rebind();
ShowMessage(new CUser().GetUserName(user) + " has been successfully created");
}
else
{
ShowMessage("Failed To Add Staff Info");
}
}
}
else if (e.Item.Text == "Permission")
{
if (RadGridUser.SelectedValue != null)
{
RunClientScript("ShowPermission(" + RadGridUser.SelectedValue + ");");
}
}
else if (e.Item.Text == "User Information")
{
if (RadGridUser.SelectedValue != null)
{
RunClientScript("ShowUserInformation(" + RadGridUser.SelectedValue + ");");
}
}
}
