private void propertyGridControl1_ValidateRecord(object sender, DevExpress.XtraVerticalGrid.Events.ValidateRecordEventArgs e)
{
e.Valid = false;
}
private void cxDBVerticalGrid_Company_ValidateRecord(object sender, DevExpress.XtraVerticalGrid.Events.ValidateRecordEventArgs e)
{
if (drCompany == null)
{
return;
}
if (drCompany["COMPANY_CODE"] == DBNull.Value || string.IsNullOrWhiteSpace(drCompany["COMPANY_CODE"].ToString().Trim()))
{
XtraMessageBox.Show("Company Code is mandatory.", Application.ProductName, MessageBoxButtons.OK, MessageBoxIcon.Error);
e.Valid = false; sIsValided = "E";
return;
}
if (drCompany["NAME"] == DBNull.Value || string.IsNullOrWhiteSpace(drCompany["NAME"].ToString().Trim()))
{
XtraMessageBox.Show("Company Name is mandatory.", Application.ProductName, MessageBoxButtons.OK, MessageBoxIcon.Error);
e.Valid = false; sIsValided = "E";
return;
}
if (drCompany["SITE_CODE_PREFIX"] == DBNull.Value || string.IsNullOrWhiteSpace(drCompany["SITE_CODE_PREFIX"].ToString().Trim()) ||
Convert.ToString(drCompany["SITE_CODE_PREFIX"]).Trim().Length != 2)
{
XtraMessageBox.Show("Site Code Prefix should comprise of 2 characters.", Application.ProductName, MessageBoxButtons.OK, MessageBoxIcon.Error);
e.Valid = false; sIsValided = "E";
return;
}
if (drCompany["INITIAL_SEED_VALUE"] != DBNull.Value && !string.IsNullOrWhiteSpace(drCompany["INITIAL_SEED_VALUE"].ToString().Trim()) &&
Convert.ToString(drCompany["INITIAL_SEED_VALUE"]).Trim().Length > 4)
{
XtraMessageBox.Show("Initial Seed Value should comprise of 4 numbers.", Application.ProductName, MessageBoxButtons.OK, MessageBoxIcon.Error);
e.Valid = false; sIsValided = "E";
return;
}
if (drCompany.RowState == DataRowState.Added || (drCompany.RowState == DataRowState.Modified &&
Convert.ToString(drCompany["COMPANY_CODE", DataRowVersion.Original]) != Convert.ToString(drCompany["COMPANY_CODE", DataRowVersion.Current])))
{
object oResult = oCompMast.RetrieveDuplicateCompanyCount(Convert.ToString(drCompany["COMPANY_CODE"]));
if (oResult != null && Convert.ToDecimal(oResult) > 0)
{
XtraMessageBox.Show("Company code cannot be duplicate.", Application.ProductName, MessageBoxButtons.OK, MessageBoxIcon.Error);
e.Valid = false; sIsValided = "E";
return;
}
}
if (drCompany["JV_COMPANY"] != DBNull.Value && Convert.ToString(drCompany["JV_COMPANY"]) == "Y")
{
if (drCompany["OP_COMPANY_ID"] == DBNull.Value || string.IsNullOrWhiteSpace(drCompany["OP_COMPANY_ID"].ToString()) || Convert.ToDecimal(drCompany["OP_COMPANY_ID"]) == 0)
{
XtraMessageBox.Show("Please select Operating Company as the Company is a JV Company.", Application.ProductName, MessageBoxButtons.OK, MessageBoxIcon.Error);
e.Valid = false; sIsValided = "E";
return;
}
}
else if (drCompany.RowState == DataRowState.Modified && !drCompany["JV_COMPANY", DataRowVersion.Original].Equals(drCompany["JV_COMPANY", DataRowVersion.Current]) &&
(drCompany["JV_COMPANY"] == DBNull.Value || string.IsNullOrWhiteSpace(drCompany["JV_COMPANY"].ToString()) || drCompany["JV_COMPANY"].ToString() == "N"))
{
drCompany["OP_COMPANY_ID"] = DBNull.Value;
b_JV_Comp = true;
}
if (drCompany.RowState == DataRowState.Modified && !drCompany["OP_COMPANY_ID", DataRowVersion.Original].Equals(drCompany["OP_COMPANY_ID", DataRowVersion.Current]) &&
drCompany["OP_COMPANY_ID"] != DBNull.Value && !string.IsNullOrWhiteSpace(drCompany["OP_COMPANY_ID"].ToString()))
{
b_OP_Comp = true;
}
drCompany["CREATED_BY"] = ProfitCashflow.oPcfDM.UserName;
drCompany["LAST_UPDATED"] = DateTime.Now;
sIsValided = "Y";
}
private void cxDBVerGridUserCreation_ValidateRecord(object sender, DevExpress.XtraVerticalGrid.Events.ValidateRecordEventArgs e)
{
DevExpress.XtraVerticalGrid.VGridControl vGrid = sender as DevExpress.XtraVerticalGrid.VGridControl;
string sUsername = Convert.ToString(vGrid.GetCellValue(cxDBVerGridUserCreationUSERNAME, e.RecordIndex));
if (drUserSetup == null)
{
return;
}
//if (sUsername.IndexOf(' ') > 0)
if (drUserSetup["USERNAME"] != DBNull.Value && Convert.ToString(drUserSetup["USERNAME"]).IndexOf(' ') > 0)
{
oSecMainFrm.MessageDlg("Blank Spaces are not allowed in User Name.", "mtError", "mbOk", 0);
e.Valid = false; sIsValided = "E";
return;
}
//if (sUsername.Trim() == "")
if (drUserSetup["USERNAME"] == DBNull.Value || string.IsNullOrWhiteSpace(drUserSetup["USERNAME"].ToString().Trim()))
{
oSecMainFrm.MessageDlg("User Name cannot be blank.", "mtError", "mbOk", 0);
e.Valid = false; sIsValided = "E";
return;
}
else if (Convert.ToString(drUserSetup["USERNAME"]).Length > 27)
{
oSecMainFrm.MessageDlg("User Name exceeds maximum permissible length of 27.", "mtError", "mbOk", 0);
e.Valid = false; sIsValided = "E";
return;
}
else
{
drUserSetup["USERNAME"] = Convert.ToString(drUserSetup["USERNAME"]).Trim().ToUpper();
}
//if(Convert.ToString(vGrid.GetCellValue(cxDBVerGridUserCreationPASSWORD, e.RecordIndex)).Trim() == "")
if (drUserSetup["USER_PASSWORD"] == DBNull.Value || string.IsNullOrWhiteSpace(drUserSetup["USER_PASSWORD"].ToString().Trim()))
{
oSecMainFrm.MessageDlg("Password cannot be blank.", "mtError", "mbOk", 0);
e.Valid = false; sIsValided = "E";
return;
}
//if (Convert.ToString(vGrid.GetCellValue(cxDBVerGridUserCreationCONfPASSWORD, e.RecordIndex)).Trim() == "")
if (drUserSetup["CON_PASSWORD"] == DBNull.Value || string.IsNullOrWhiteSpace(drUserSetup["CON_PASSWORD"].ToString().Trim()))
{
oSecMainFrm.MessageDlg("Confirm Password cannot be blank.", "mtError", "mbOk", 0);
e.Valid = false; sIsValided = "E";
return;
}
/*if (Convert.ToString(vGrid.GetCellValue(cxDBVerGridUserCreationMaintainBlackoutPeriod, e.RecordIndex)) == "Y" &&
* Convert.ToString(vGrid.GetCellValue(cxDBVerGridUserCreationCorporateUser, e.RecordIndex)) == "N")*/
if (drUserSetup["PCF_MAINTAIN_BLACKOUT_PERIOD"] != DBNull.Value && Convert.ToString(drUserSetup["PCF_MAINTAIN_BLACKOUT_PERIOD"]) == "Y" &&
drUserSetup["PCF_CORPORATE_USER"] != DBNull.Value && Convert.ToString(drUserSetup["PCF_CORPORATE_USER"]) == "N")
{
oSecMainFrm.MessageDlg("Only a corporate user can maintain blackout period.", "mtError", "mbOk", 0);
e.Valid = false; sIsValided = "E";
return;
}
if (drUserSetup.RowState == DataRowState.Added)
{
object oResult = oUserSetup.CheckUserNameExist(drUserSetup["USERNAME"].ToString());
if (oResult != null && Convert.ToInt32(oResult) > 0)
{
oSecMainFrm.MessageDlg("User Name already exits.", "mtError", "mbOk", 0);
e.Valid = false; sIsValided = "E";
return;
}
if (Convert.ToString(drUserSetup["USER_PASSWORD"]) != Convert.ToString(drUserSetup["CON_PASSWORD"]))
{
oSecMainFrm.MessageDlg("Password confirmation is wrong.", "mtError", "mbOk", 0);
e.Valid = false; sIsValided = "E";
return;
}
try
{
drUserSetup["USER_PASSWORD"] = XpedeonCrypto.XpedeonServerEncrypt(drUserSetup["USER_PASSWORD"].ToString());
}
catch (Exception ex)
{
e.Valid = false; sIsValided = "E";
throw ex;
}
}
else //if (drUserSetup.RowState == DataRowState.Modified)
if (sPrevPassword != Convert.ToString(drUserSetup["USER_PASSWORD"]))
{
if (Convert.ToString(drUserSetup["USER_PASSWORD"]) != Convert.ToString(drUserSetup["CON_PASSWORD"]))
{
oSecMainFrm.MessageDlg("Password confirmation is wrong.", "mtError", "mbOk", 0);
e.Valid = false; sIsValided = "E";
return;
}
try
{
drUserSetup["USER_PASSWORD"] = XpedeonCrypto.XpedeonServerEncrypt(drUserSetup["USER_PASSWORD"].ToString());
}
catch (Exception ex)
{
e.Valid = false; sIsValided = "E";
throw ex;
}
drUserSetup["PASSWORD_UPDATED_ON"] = DateTime.Now;
}
sIsValided = "Y";
}
