protected void btnChangePW_Click(object sender, EventArgs e)
{
if (captcha.IsValid && ASPxEdit.ValidateEditorsInContainer(this))
{
//PopupChangePW.HeaderText = "Confirm";
//PopupChangePW.ShowOnPageLoad = true;
string qry = "", _sPassword = "";
SqlCommand cmd = null;
_sPassword = EncryptionClass.Encrypt(newPasswordCH.Text.ToString().Trim());
SqlConnection con = new SqlConnection(GlobalClass.SQLConnString());
con.Open();
qry = "UPDATE tbl_Users " +
" SET Password = '******' " +
" WHERE (PK = " + Session["CreatorKey"] + ")";
cmd = new SqlCommand(qry);
cmd.Connection = con;
cmd.ExecuteNonQuery();
con.Close();
ModalPopupExtenderLoading.Hide();
Response.Redirect("home.aspx");
}
}
public bool CustomFieldEditing_PreTransitionCRUD(string transition)
{
switch (transition.ToUpper())
{
case "SAVE":
if (ASPxEdit.ValidateEditorsInContainer(formlayoutGeneralInfo))
{
using (UnitOfWork uow = XpoHelper.GetNewUnitOfWork())
{
Guid selectedCustomFieldTypeId =
Guid.Parse(cbbCustomFieldType.SelectedItem.Value.ToString());
CustomFieldType customFieldType =
uow.GetObjectByKey <CustomFieldType>(selectedCustomFieldTypeId);
//Get eidting CustomField
NAS.DAL.CMS.ObjectDocument.CustomField customField =
uow.GetObjectByKey <NAS.DAL.CMS.ObjectDocument.CustomField>(CustomFieldId);
customField.Name = txtCustomFieldName.Text;
customField.CustomFieldTypeId = customFieldType;
//Set new Id to session variable
CustomFieldId = customField.CustomFieldId;
uow.CommitChanges();
}
}
else
{
return(false);
}
break;
default:
break;
}
return(true);
}
protected void CallbackPanel_Callback(object sender, DevExpress.Web.CallbackEventArgsBase e)
{
if (ASPxEdit.ValidateEditorsInContainer(sender as ASPxCallbackPanel))
{
ASPxWebControl.RedirectOnCallback(VirtualPathUtility.ToAbsolute(loginUrl));
}
}
protected void btnRestore_Click(object sender, EventArgs e)
{
if (!IsPostBack && !IsCallback)
{
ASPxEdit.ValidateEditorsInContainer(this);
}
string lang = System.Globalization.CultureInfo.CurrentUICulture.ToString();
if (_sysDbManager.RestoreDataBase(tree0.GetVirtualNodeObject(tree0.FocusedNode).ToString()))
{
if (lang == "vi-VN")
{
lblStatus.Text = "Phục hồi thành công!";
}
else
{
lblStatus.Text = "Restore Successfully!";
}
//btnOk.Visible = true;
}
else
{
if (lang == "vi-VN")
{
lblStatus.Text = "Lỗi!";
}
else
{
lblStatus.Text = "Error !";
}
//btnOk.Visible = true;
}
//WriteLog("Restore DataBase " + tree0.GetVirtualNodeObject(tree0.FocusedNode).ToString(), Action.Update);
}
protected void signUp_Click(object sender, EventArgs e)
{
if (eMailTextBox.IsValid && Captcha.IsValid)
{
using (OleDbConnection connection = GetConnection()) {
OleDbCommand command = new OleDbCommand(string.Empty, connection);
command.CommandText = "INSERT INTO [Users] (FirstName, LastName, Gender, BirthDate, Country, City, Email, UserPassword) VALUES (@firstName, @lastName, @gender, @birthDate, @country, @city, @email, @password)";
command.Parameters.AddWithValue("firstName", firstNameTextBox.Text);
command.Parameters.AddWithValue("lastName", lastNameTextBox.Text);
command.Parameters.AddWithValue("gender", genderRadioButtonList.Value);
command.Parameters.AddWithValue("birthDate", birthDateEdit.Date.ToShortDateString());
command.Parameters.AddWithValue("country", countryComboBox.Text);
command.Parameters.AddWithValue("city", cityComboBox.Text);
command.Parameters.AddWithValue("email", eMailTextBox.Text);
command.Parameters.AddWithValue("password", passwordTextBox.Text);
connection.Open();
command.ExecuteNonQuery();
}
if (ASPxEdit.ValidateEditorsInContainer(registrationFormLayout))
{
Response.Redirect("RegisteredPage.aspx");
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
try
{
string link = HttpContext.Current.Request.Url.AbsoluteUri; //lay url
string[] list = link.Split('?'); // tach chuoi de lay ma md5
string prameterInfo = Utility.Security.DecryptString(list[1], "123");
list = prameterInfo.Split('&');
userId = list[0].Split('=')[1];
DateTime timeCreateLink = Convert.ToDateTime(list[1].Split('=')[1]);
timeCreateLink = timeCreateLink.AddDays(1);
if (timeCreateLink.Ticks < DateTime.Now.Ticks)
{
Response.Redirect("~/");//direct page link expire
}
if (IsPostBack && captcha.IsValid && ASPxEdit.ValidateEditorsInContainer(this))
{
//UserBLO userBLO = new UserBLO();
//if (userBLO.ResetPassword(Guid.Parse(userId),
// FormsAuthentication.HashPasswordForStoringInConfigFile(passwordtb.Text, "MD5")))
//{
// //Direct page reset successful
//}
//else
//{
// //Direct page reset not successful
//}
}
}
catch
{
}
}
protected void SignInButton_Click(object sender, EventArgs e)
{
FormLayout.FindItemOrGroupByName("GeneralError").Visible = false;
if (ASPxEdit.ValidateEditorsInContainer(this))
{
// Your Authentication logic
string user = UserNameTextBox.Value.ToString().Trim();
string pass = PasswordButtonEdit.Value.ToString().Trim();
string val1 = ConfigurationManager.AppSettings["Debug:User.Login"].ToString();
string val2 = ConfigurationManager.AppSettings["Debug:User.Login"].ToString();
if (user.Equals(val1) && pass.Equals(val2))
{
//TODO: rol system
Global.Sessions.SetDeveloperUserSessionVariables();
Response.Redirect("~/Views/Main.aspx");
}
else
{
GeneralErrorDiv.InnerText = "Invalid login attempt.";
FormLayout.FindItemOrGroupByName("GeneralError").Visible = true;
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (IsPostBack && ASPxEdit.ValidateEditorsInContainer(ASPxFormLayout1))
{
Page.ClientScript.RegisterStartupScript(this.GetType(), "alert",
@"<script type=""text/javascript"">setTimeout(function() { alert('You have successfully registered'); }, 0);</script>");
}
}
public bool CustomFieldCreatingHasNoInitData_PreTransitionCRUD(string transition)
{
switch (transition.ToUpper())
{
case "ACCEPT":
if (ASPxEdit.ValidateEditorsInContainer(formlayoutGeneralInfo))
{
using (UnitOfWork uow = XpoHelper.GetNewUnitOfWork())
{
Guid selectedCustomFieldTypeId =
Guid.Parse(cbbCustomFieldType.SelectedItem.Value.ToString());
CustomFieldType customFieldType =
uow.GetObjectByKey <CustomFieldType>(selectedCustomFieldTypeId);
//Create new CustomField
NAS.DAL.CMS.ObjectDocument.CustomField customField =
new NAS.DAL.CMS.ObjectDocument.CustomField(uow)
{
CustomFieldId = Guid.NewGuid(),
Name = txtCustomFieldName.Text,
CustomFieldTypeId = customFieldType
};
//Attach CustomField to ObjectTypeId
if (ObjectTypeId != null && !ObjectTypeId.Equals(Guid.Empty))
{
/*2013-12-12 Khoa.Truong DEL START
* Decoupling with the client using this form
* //Guid objectTypeId = ((ObjectTypeCustomFieldListing)Parent).ObjectTypeId;
* 2013-12-12 Khoa.Truong DEL END*/
ObjectType objectType = uow.GetObjectByKey <ObjectType>(ObjectTypeId);
ObjectTypeCustomField objectTypeCustomField = new ObjectTypeCustomField(uow)
{
ObjectTypeCustomFieldId = Guid.NewGuid(),
CustomFieldId = customField,
ObjectTypeId = objectType
};
}
//Attach new custom fields for all object of the object type
/*These code is replace with lazy updating for custom fields of each object
* //ObjectBO objectBO = new ObjectBO();
* //objectBO.UpdateCMSObjects(uow, objectTypeId);
*/
uow.CommitChanges();
}
}
else
{
return(false);
}
break;
default:
break;
}
return(true);
}
protected void Page_Load(object sender, EventArgs e)
{
//ApplyValidationSummarySettings();
//ApplyEditorsSettings();
bool isCallback = IsCallback;
bool isPostback = IsPostBack;
if (Request.QueryString["subjid"] != null)
{
SQL_utils sql = new SQL_utils("backend");
string theID = sql.StringScalar_from_SQLstring("select id from tblsubject where subjID=" + Request.QueryString["subjid"]);
Session["ID"] = theID;
//cboID.Value = theID;
ID = theID;
lblID.Text = theID;
int newstudyID = sql.IntScalar_from_SQLstring("select studyID from vwMasterStatus_S where subjID=" + Request.QueryString["subjid"]);
if (newstudyID != Master.Master_studyID)
{
sql.NonQuery_from_SQLstring("exec spSEC_Update_Default_StudyID_for_User " + newstudyID);
}
Master.Master_studyID = newstudyID;
sql.Close();
}
else if (Request.QueryString["ID"] != null)
{
ID = Request.QueryString["ID"];
Session["ID"] = ID;
lblID.Text = ID;
//cboID.Value = ID;
}
else
{
Session["ID"] = "";
}
if (!IsCallback && !IsPostBack)
{
//sliderValue.Value = color.GetColorLevel().ToString();
if (!String.IsNullOrEmpty(Session["ID"].ToString()))
{
GetSubjectInfo(Session["ID"].ToString());
//GetMeasureInfo(ID);
ASPxEdit.ValidateEditorsInContainer(this);
}
}
}
protected void StandardButton_Click(object sender, EventArgs e)
{
ASPxEdit.ValidateEditorsInContainer(Page); // Required only for a standard button
if (ASPxEdit.AreEditorsValid(Page))
{
UpdateStatusLabel.Text = string.Format("Submitted value: {0}", spinEdit.Value);
}
else
{
UpdateStatusLabel.Text = "Editors are not valid!";
}
}
protected void ASPxGridView1_CustomCallback(object sender, ASPxGridViewCustomCallbackEventArgs e)
{
if (e.Parameters == "Cancel")
{
ASPxEdit.ClearEditorsInContainer(ASPxGridView1, "DateGroup");
ASPxGridView1.DataBind();
}
else
{
if (ASPxEdit.ValidateEditorsInContainer(ASPxGridView1))
{
//Your update operations here
}
}
}
protected void SignInButton_Click(object sender, EventArgs e)
{
FormLayout.FindItemOrGroupByName("GeneralError").Visible = false;
if (ASPxEdit.ValidateEditorsInContainer(this, "login"))
{
// DXCOMMENT: You Authentication logic
if (AuthHelper.SignIn(UserNameTextBox.Text, PasswordButtonEdit.Text) == null)
{
GeneralErrorDiv.InnerText = "Đăng nhập không thành công: Sai tên đăng nhập hoặc mật khẩu.";
FormLayout.FindItemOrGroupByName("GeneralError").Visible = true;
}
else
{
Response.Redirect("~/Map.aspx");
}
}
}
protected void SignInButton_Click(object sender, EventArgs e)
{
FormLayout.FindItemOrGroupByName("GeneralError").Visible = false;
if (ASPxEdit.ValidateEditorsInContainer(this))
{
// DXCOMMENT: You Authentication logic
if (!AuthHelper.SignIn(UserNameTextBox.Text, PasswordButtonEdit.Text, RememberMeCheckBox.Checked))
{
GeneralErrorDiv.InnerText = "Tên đăng nhập hoặc mật khẩu không đúng.";
FormLayout.FindItemOrGroupByName("GeneralError").Visible = true;
}
else
{
loadLicense();
}
}
}
protected void SignInButton_Click(object sender, EventArgs e)
{
FormLayout.FindItemOrGroupByName("GeneralError").Visible = false;
if (ASPxEdit.ValidateEditorsInContainer(this))
{
// DXCOMMENT: You Authentication logic
if (!AuthHelper.SignIn(UserNameTextBox.Text, PasswordButtonEdit.Text))
{
GeneralErrorDiv.InnerText = "Invalid login attempt.";
FormLayout.FindItemOrGroupByName("GeneralError").Visible = true;
}
else
{
Response.Redirect("~/");
}
}
}
public bool ReceiptVoucherCreating_PreTransitionCRUD(string transition)
{
//Save data before transit by 'Save' transition
if (transition.ToUpper().Equals(VoucherStateTransition.SaveTransition.TransitionName.ToUpper()))
{
gridviewReceiptVoucherAllocation.GridView.UpdateEdit();
//Validate input data
if (!ASPxEdit.ValidateEditorsInContainer(cpnReceiptVoucherEditingForm, "ReceiptVoucherEditingForm", false))
{
return(false);
}
//Collects input data
string code = txtCode.Text;
DateTime issueDate = txtIssueDate.Date;
string description = txtDescription.Text;
string address = txtAddress.Text;
string payer = txtPayer.Text;
Guid sourceOrgId = cboSourceOrganization.Value != null ? (Guid)cboSourceOrganization.Value : Guid.Empty;
Guid targetOrgId = Utility.CurrentSession.Instance.AccessingOrganizationId;
double debit = (double)spinAmount.Number;
//Guid currencyId = (Guid)cboCurrency.Value;
Guid currencyId = (Guid)gridlookupCurrency.GetSelectedCurrencyKey();
double exchangeRate = (double)spinExchangeRate.Number;
//Insert data to database
ReceiptVouchesBO receiptVoucherBO = new ReceiptVouchesBO();
receiptVoucherBO.Insert(VoucherId,
code,
issueDate,
description,
address,
payer,
sourceOrgId,
targetOrgId,
debit,
currencyId,
exchangeRate);
}
else if (transition.ToUpper().Equals(VoucherStateTransition.CancelTransition.TransitionName.ToUpper()))
{
voucherBO.DeleteTempObject(VoucherId);
}
return(true);
}
protected void SignInButton_Click(object sender, EventArgs e)
{
FormLayout.FindItemOrGroupByName("GeneralError").Visible = false;
if (ASPxEdit.ValidateEditorsInContainer(this))
{
// DXCOMMENT: You Authentication logic
if (AuthHelper.SignIn(UserNameTextBox.Text, PasswordButtonEdit.Text) == 0)
{
ApplicationUser user = HttpContext.Current.Session["User"] as ApplicationUser;
Session["GlobalConnectionString"] = cmbSite.Value;
int site_id = 0;
if (!string.IsNullOrEmpty(user.SiteID))
{
site_id = Convert.ToInt32(user.SiteID);
}
// "1" = site_id.ToString();
//"1" = user.Exercice;
GestionConnexion(user.Rolename, 1, site_id);
Response.Redirect("~/");
}
else if (AuthHelper.SignIn(UserNameTextBox.Text, PasswordButtonEdit.Text) == 2)
{
GeneralErrorDiv.InnerText = "Merci de vous rapprocher vous de votre administrateur pour acceder à la plateforme.";
FormLayout.FindItemOrGroupByName("GeneralError").Visible = true;
GestionConnexion("", 0, 0);
}
else
{
GeneralErrorDiv.InnerText = "Erreur d'authentification";
FormLayout.FindItemOrGroupByName("GeneralError").Visible = true;
GestionConnexion("", 0, 0);
}
}
}
protected void btnBackup_Click(object sender, EventArgs e)
{
if (!IsPostBack && !IsCallback)
{
ASPxEdit.ValidateEditorsInContainer(this);
}
string lang = System.Globalization.CultureInfo.CurrentUICulture.ToString();
string fileName = String.Format("{0}\\{1}.bak", tree.GetVirtualNodeObject(tree.FocusedNode), txtFileName.Text);
if (_sysDbManager.BackupDataBase(fileName))
{
if (lang == "vi-VN")
{
lblStatus.Text = "Sao lưu thành công. ?";
}
else
{
lblStatus.Text = "Backup Successfuly. ?";
}
//btnOk.Visible = true;
btnCancel.Visible = true;
}
else
{
if (lang == "vi-VN")
{
lblStatus.Text = "Lỗi!Bạn hãy kiểm tra lai tên. Ko chưa các kí tự đặc biệt";
}
else
{
lblStatus.Text = "Error !";
}
//btnOk.Visible = true;
}
//WriteLog("Backup DataBase " + fileName, Action.Create);
}
public bool AllocationEditing_PreTransitionCRUD(string transition)
{
switch (transition.ToUpper())
{
case "SAVE":
if (ASPxEdit.ValidateEditorsInContainer(formlayoutAllocationEditingForm))
{
using (UnitOfWork uow = XpoHelper.GetNewUnitOfWork())
{
Guid selectedAllocationTypeId;
Guid selectedAccountActorTypeId;
AllocationType selectedAllocationType = null;
AccountActorType selectedAccountActorType = null;
Allocation allocation = null;
bool isParseSuccess;
//Get selected allocation type
isParseSuccess = Guid.TryParse(cboAllocationType.Value.ToString(), out selectedAllocationTypeId);
if (!isParseSuccess)
{
throw new Exception("The string is invalid for parsing to GUID");
}
selectedAllocationType = uow.GetObjectByKey <AllocationType>(selectedAllocationTypeId);
//Update allocation
allocation = uow.GetObjectByKey <Allocation>(AllocationId);
allocation.Code = txtCode.Text;
allocation.Name = txtName.Text;
allocation.Description = txtDescription.Text;
allocation.AllocationTypeId = selectedAllocationType;
//Get selected IsMaster AccountActorType
isParseSuccess =
Guid.TryParse(cbIsMasterAccountActorType.Value.ToString()
, out selectedAccountActorTypeId);
if (!isParseSuccess)
{
throw new Exception("The string is invalid for parsing to GUID");
}
selectedAccountActorType = uow.GetObjectByKey <AccountActorType>(selectedAccountActorTypeId);
//Update isMaster AllocationAccountActorType
AllocationAccountActorType isMasterAllocationAccountActorType =
allocation.AllocationAccountActorTypes.FirstOrDefault(r => r.IsMaster);
if (isMasterAllocationAccountActorType != null)
{
isMasterAllocationAccountActorType.AccountActorTypeId = selectedAccountActorType;
}
else
{
//Create new IsMaster AllocationAccountActorType
AllocationAccountActorType allocationAccountActorType
= new AllocationAccountActorType(uow)
{
AccountActorTypeId = selectedAccountActorType,
AllocationId = allocation,
IsMaster = true
};
}
//Get selected ids in gridlookupAccountActorType
var relatedAccountActorTypeIds = gridlookupAccountActorType.GridView
.GetSelectedFieldValues("AccountActorTypeId")
.Select(r => Guid.Parse(r.ToString()));
List <AllocationAccountActorType> relatedAccountActorTypes =
allocation.AllocationAccountActorTypes.Where(r => !r.IsMaster).ToList();
uow.Delete(relatedAccountActorTypes);
//Create new related AllocationAccountActorTypes
foreach (var relatedAccountActorTypeId in relatedAccountActorTypeIds)
{
AllocationAccountActorType relatedAllocationAccountActorType
= new AllocationAccountActorType(uow)
{
AccountActorTypeId = uow.GetObjectByKey <AccountActorType>(relatedAccountActorTypeId),
AllocationId = allocation,
IsMaster = false
};
relatedAllocationAccountActorType.Save();
}
//Set new Id to session variable
AllocationId = allocation.AllocationId;
uow.CommitChanges();
}
}
else
{
return(false);
}
break;
default:
break;
}
return(true);
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
if (IsPostBack && ASPxEdit.ValidateEditorsInContainer(this))
{
}
}
protected void ASPxCallbackPanelDemo_Callback(object sender, DevExpress.Web.ASPxClasses.CallbackEventArgsBase e)
{
ASPxCallbackPanel callbackPanel = (ASPxCallbackPanel)sender;
bool isValid = ASPxEdit.ValidateEditorsInContainer(callbackPanel);
}
public bool AllocationCreating_PreTransitionCRUD(string transition)
{
switch (transition.ToUpper())
{
case "SAVE":
if (ASPxEdit.ValidateEditorsInContainer(formlayoutAllocationEditingForm))
{
using (UnitOfWork uow = XpoHelper.GetNewUnitOfWork())
{
Guid selectedAllocationTypeId;
Guid selectedAccountActorTypeId;
AllocationType selectedAllocationType = null;
AccountActorType selectedAccountActorType = null;
Allocation allocation = null;
bool isParseSuccess;
//Get selected allocation type
isParseSuccess = Guid.TryParse(cboAllocationType.Value.ToString(), out selectedAllocationTypeId);
if (!isParseSuccess)
{
throw new Exception("The string is invalid for parsing to GUID");
}
selectedAllocationType = uow.GetObjectByKey <AllocationType>(selectedAllocationTypeId);
//Create new allocation
allocation = new Allocation(uow)
{
AllocationId = Guid.NewGuid(),
AllocationTypeId = selectedAllocationType,
Code = txtCode.Text,
Description = txtDescription.Text,
Name = txtName.Text,
RowStatus = Utility.Constant.ROWSTATUS_ACTIVE
//OwnerOrgId
};
//Get selected IsMaster AccountActorType
isParseSuccess =
Guid.TryParse(cbIsMasterAccountActorType.Value.ToString()
, out selectedAccountActorTypeId);
if (!isParseSuccess)
{
throw new Exception("The string is invalid for parsing to GUID");
}
selectedAccountActorType = uow.GetObjectByKey <AccountActorType>(selectedAccountActorTypeId);
//Create new IsMaster AllocationAccountActorType
AllocationAccountActorType allocationAccountActorType
= new AllocationAccountActorType(uow)
{
AccountActorTypeId = selectedAccountActorType,
AllocationId = allocation,
IsMaster = true
};
//Get selected ids in gridlookupAccountActorType
var relatedAccountActorTypeIds = gridlookupAccountActorType.GridView
.GetSelectedFieldValues("AccountActorTypeId")
.Select(r => Guid.Parse(r.ToString()));
//Create new related AllocationAccountActorTypes
foreach (var relatedAccountActorTypeId in relatedAccountActorTypeIds)
{
AllocationAccountActorType relatedAllocationAccountActorType
= new AllocationAccountActorType(uow)
{
AccountActorTypeId = uow.GetObjectByKey <AccountActorType>(relatedAccountActorTypeId),
AllocationId = allocation,
IsMaster = false
};
relatedAllocationAccountActorType.Save();
}
//Set new Id to session variable
AllocationId = allocation.AllocationId;
uow.CommitChanges();
}
}
else
{
return(false);
}
break;
default:
break;
}
return(true);
}
protected void ASPxButton1_Click(object sender, EventArgs e)
{
ASPxEdit.ValidateEditorsInContainer(Form, "submit");
}
protected void signUp_Click(object sender, EventArgs e)
{
int iEmployeeKey = 0;
//MRPClass.PrintString("pass clicked signup");
if (captcha.IsValid && ASPxEdit.ValidateEditorsInContainer(this))
{
ModalPopupExtenderLoading.Show();
//MRPClass.PrintString("pass inside validation");
DataTable dt = new DataTable();
SqlCommand cmd = null;
SqlDataAdapter adp;
string qry = "";
using (SqlConnection conHRIS = new SqlConnection(GlobalClass.SQLConnStringHRIS()))
{
//MRPClass.PrintString("pass inside hris");
qry = "SELECT PK, IDNumber FROM dbo.tbl_EmployeeIDNumber WHERE(IDNumber = '" + IDNumTextBox.Text.ToString() + "')";
cmd = new SqlCommand(qry);
cmd.Connection = conHRIS;
adp = new SqlDataAdapter(cmd);
adp.Fill(dt);
if (dt.Rows.Count > 0)
{
//MRPClass.PrintString("pass inside hris with id");
foreach (DataRow row in dt.Rows)
{
iEmployeeKey = Convert.ToInt32(row["PK"]);
}
}
else
{
//Page.ClientScript.RegisterStartupScript(this.GetType(), "alert",
// @"<script type=""text/javascript"">setTimeout(()=>{alert('ID Number not found in Employee MasterList!')},0);</script>");
ModalPopupExtenderLoading.Hide();
CreateAccntNotify.HeaderText = "Error...";
CreateAccntNotifyLbl.Text = "ID Number not found in Employee MasterList!";
CreateAccntNotifyLbl.ForeColor = System.Drawing.Color.Red;
CreateAccntNotify.ShowOnPageLoad = true;
return;
}
dt.Clear();
conHRIS.Close();
}
DataTable dtUser = AccountClass.UserList();
//dtUser.CaseSensitive = true;
string expressionID = "EmployeeKey = '" + iEmployeeKey.ToString().Trim() + "'";
string sortOrderID = "PK ASC";
DataRow[] foundRowsID;
foundRowsID = dtUser.Select(expressionID, sortOrderID);
if (foundRowsID.Length > 0)
{
//Page.ClientScript.RegisterStartupScript(this.GetType(), "alert",
// @"<script type=""text/javascript"">setTimeout(()=>{alert('Found Duplicate ID Number!')},0);</script>");
ModalPopupExtenderLoading.Hide();
CreateAccntNotify.HeaderText = "Error...";
CreateAccntNotifyLbl.Text = "Found Duplicate ID Number!";
CreateAccntNotifyLbl.ForeColor = System.Drawing.Color.Red;
CreateAccntNotify.ShowOnPageLoad = true;
return;
}
dtUser.CaseSensitive = true;
string expressionName = "Lastname = '" + lastNameTextBox.Text.ToString().Trim() + "' AND Firstname = '" + firstNameTextBox.Text.ToString().Trim() + "'";
string sortOrderName = "PK ASC";
DataRow[] foundRowsName;
foundRowsName = dtUser.Select(expressionName, sortOrderName);
if (foundRowsName.Length > 0)
{
//Page.ClientScript.RegisterStartupScript(this.GetType(), "alert",
// @"<script type=""text/javascript"">setTimeout(()=>{alert('Found Duplicate Lastname and Firstname!')},0);</script>");
ModalPopupExtenderLoading.Hide();
CreateAccntNotify.HeaderText = "Error...";
CreateAccntNotifyLbl.Text = "Found Duplicate Lastname and Firstname!";
CreateAccntNotifyLbl.ForeColor = System.Drawing.Color.Red;
CreateAccntNotify.ShowOnPageLoad = true;
return;
}
string expressionEmail = "Email = '" + eMailTextBox.Text.ToString().Trim() + "'";
string sortOrderEmail = "PK ASC";
DataRow[] foundRowsEmail;
foundRowsEmail = dtUser.Select(expressionEmail, sortOrderEmail);
if (foundRowsEmail.Length > 0)
{
//Page.ClientScript.RegisterStartupScript(this.GetType(), "alert",
// @"<script type=""text/javascript"">setTimeout(()=>{alert('Found Duplicate Email!')},0);</script>");
ModalPopupExtenderLoading.Hide();
CreateAccntNotify.HeaderText = "Error...";
CreateAccntNotifyLbl.Text = "Found Duplicate Email!";
CreateAccntNotifyLbl.ForeColor = System.Drawing.Color.Red;
CreateAccntNotify.ShowOnPageLoad = true;
return;
}
string expressionUName = "Username = '******'";
string sortOrderUName = "PK ASC";
DataRow[] foundRowsUName;
foundRowsUName = dtUser.Select(expressionUName, sortOrderUName);
if (foundRowsUName.Length > 0)
{
//Page.ClientScript.RegisterStartupScript(this.GetType(), "alert",
// @"<script type=""text/javascript"">setTimeout(()=>{alert('Found Duplicate Username!')},0);</script>");
ModalPopupExtenderLoading.Hide();
CreateAccntNotify.HeaderText = "Error...";
CreateAccntNotifyLbl.Text = "Found Duplicate Username!";
CreateAccntNotifyLbl.ForeColor = System.Drawing.Color.Red;
CreateAccntNotify.ShowOnPageLoad = true;
return;
}
using (SqlConnection con = new SqlConnection(GlobalClass.SQLConnString()))
{
string _sLastName, _sFirstName, _sEmail, _sUserName, _sPassword, _sIDNum;
int _Gender = 0;
_sLastName = EncryptionClass.Encrypt(GlobalClass.UpperCaseFirstLetter(lastNameTextBox.Text.ToString().Trim()));
_sFirstName = EncryptionClass.Encrypt(GlobalClass.UpperCaseFirstLetter(firstNameTextBox.Text.ToString().Trim()));
_Gender = gender_int;
_sEmail = EncryptionClass.Encrypt(eMailTextBox.Text.ToString().Trim());
_sUserName = EncryptionClass.Encrypt(userNameTextBox.Text.ToString().Trim());
_sPassword = EncryptionClass.Encrypt(passwordTextBox.Text.ToString().Trim());
_sIDNum = EncryptionClass.Encrypt(IDNumTextBox.Text.ToString().Trim());
con.Open();
qry = "INSERT INTO tbl_Users " +
" (Lastname, Firstname, Username, Password, Email, EmployeeKey, Gender) " +
" VALUES ('" + _sLastName + "', '" + _sFirstName + "', '" + _sUserName + "', " +
" '" + _sPassword + "', '" + _sEmail + "', " + iEmployeeKey + ", " + _Gender + ")";;
try
{
cmd = new SqlCommand(qry);
cmd.Connection = con;
cmd.ExecuteNonQuery();
con.Close();
//Page.ClientScript.RegisterStartupScript(this.GetType(), "alert",
// @"<script type=""text/javascript"">setTimeout(()=>{alert('You have successfully registered')},0);</script>");
//MRPClass.PrintString("pass saved");
ModalPopupExtenderLoading.Hide();
CreateAccntNotify.HeaderText = "Info";
CreateAccntNotifyLbl.Text = "You is successfully registered.";
CreateAccntNotifyLbl.ForeColor = System.Drawing.Color.Black;
CreateAccntNotify.ShowOnPageLoad = true;
Response.Redirect("default.aspx");
}
catch (SqlException ex)
{
//MRPClass.PrintString(ex.ToString());
con.Close();
//Page.ClientScript.RegisterStartupScript(this.GetType(), "alert",
// @"<script type=""text/javascript"">setTimeout(()=>{alert('" + ex.ToString() + "')},0);</script>");
CreateAccntNotify.HeaderText = "Error...";
CreateAccntNotifyLbl.Text = ex.ToString();
CreateAccntNotifyLbl.ForeColor = System.Drawing.Color.Red;
CreateAccntNotify.ShowOnPageLoad = true;
}
}
}
}
