/// <summary>
/// Gets User list by filter criteria.
/// </summary>
/// <returns>Returns dataset contains custromer data.</returns>
public DataSet GetUserSearch(UserMasterBDto objUser)
{
Database db = null;
DbCommand dbCmd = null;
DataSet ds = null;
try
{
db = DatabaseFactory.CreateDatabase(DALHelper.CRM_CONNECTION_STRING);
dbCmd = db.GetStoredProcCommand(DALHelper.USP_ADMINISTRATION_USER_DYNAMIC_SELECT);
db.AddInParameter(dbCmd, "@USER_NAME", DbType.String, objUser.UserName);
ds = db.ExecuteDataSet(dbCmd);
}
catch (Exception ex)
{
bool rethrow = ExceptionPolicy.HandleException(ex, DALHelper.DAL_EXP_POLICYNAME);
if (rethrow)
{
throw ex;
}
}
finally
{
DALHelper.Destroy(ref dbCmd);
}
return ds;
}
/// <summary>
/// Update User detail.
/// </summary>
/// <param name="xmlData">Data that converted into xml format.</param>
/// <returns>Returns 1 and 0; (1 indicates successful operation).</returns>
public int UpdateUser(UserMasterBDto objUser)
{
Database db = null;
DbCommand dbCmd = null;
int Result = 0;
try
{
db = DatabaseFactory.CreateDatabase(DALHelper.CRM_CONNECTION_STRING);
dbCmd = db.GetStoredProcCommand(DALHelper.USP_ADMINISTRATION_USER_UPDATE);
db.AddInParameter(dbCmd, "@USER_ID", DbType.Int32, objUser.m_UserId);
db.AddInParameter(dbCmd, "@USER_NAME", DbType.String, objUser.UserName);
db.AddInParameter(dbCmd, "@PASSWORD", DbType.String, objUser.Password);
db.AddInParameter(dbCmd, "@EMP_ID", DbType.Int32, objUser.EmpID);
db.AddInParameter(dbCmd, "@SECURITY_QUESTION_ID", DbType.Int32, objUser.SecurityQusId);
db.AddInParameter(dbCmd, "@SECURITY_ANSWERS", DbType.String, objUser.SecurityQusAns);
db.AddInParameter(dbCmd, "@FROM_DATE", DbType.DateTime, objUser.FromDate);
if (objUser.ToDate == DateTime.MinValue)
db.AddInParameter(dbCmd, "@TO_DATE", DbType.DateTime, DBNull.Value);
else
db.AddInParameter(dbCmd, "@TO_DATE", DbType.DateTime, objUser.ToDate);
//db.AddInParameter(dbCmd, "@TO_DATE", DbType.DateTime, objUser.ToDate);
db.AddInParameter(dbCmd, "@MODIFIED_BY", DbType.Int32, objUser.UserId);
db.AddOutParameter(dbCmd, "@IS_INSERT", DbType.Int32, 1);
db.ExecuteNonQuery(dbCmd);
Result = Convert.ToInt32(db.GetParameterValue(dbCmd, "@IS_INSERT"));
}
catch (Exception ex)
{
bool rethrow = ExceptionPolicy.HandleException(ex, DALHelper.DAL_EXP_POLICYNAME);
if (rethrow)
{
throw ex;
}
}
finally
{
DALHelper.Destroy(ref dbCmd);
}
return Result;
}
/// <summary>
/// Action bar's Search button event which search records from database.
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void acbUser_SearchClick(object sender, EventArgs e)
{
#region OpenSearchInNewForm
//acbUser.Visible = false;
//pnlGrid.Visible = false;
//ucControlBox.SaveButton.CommandName = "Search";
//ucControlBox.SaveButton.Text = "Search";
//ValidationGroupSearch();
//txtPassword.Enabled = false;
//txtRetypePassword.Enabled = false;
//pnlAddMode.Visible = true;
//radMultiPage.SelectedIndex = 0;
//radTabStripe.FindTabByText("User Access").Enabled = false;
//radTabStripe.FindTabByText("User Info").Selected = true;
//Reset();
//BindEmployeeCombo(ddlEmployeeName);
//BindSecurityQuestionCombo(ddlSecurityQus);
#endregion
////
UserMasterBDto objUserMasterBDto = new UserMasterBDto();
UserMasterDal objUserMasterDal = new UserMasterDal();
objUserMasterBDto.UserName = acbUser.SearchTextBox.Text.Trim();
DataSet dsUser = objUserMasterDal.GetUserSearch(objUserMasterBDto);
if (dsUser != null && dsUser.Tables[0].Rows.Count > 0)
{
radgrdUser.DataSource = dsUser;
radgrdUser.DataBind();
ViewState[vsUser] = dsUser;
}
else
{
Master.DisplayMessage(ConfigurationSettings.AppSettings["NoRecord"].ToString());
Master.MessageCssClass = "errorMessage";
}
}
/// <summary>
/// Action bar's save button event which saves grid data by xml.
/// </summary>
/// <param name="sender">The object which raised the event</param>
/// <param name="e">The event listener object</param>
protected void acbUser_SaveClick(object sender, EventArgs e)
{
int result = 0;
objUserMasterDAL = new UserMasterDal();
switch (ucControlBox.SaveButton.CommandName)
{
case "Save":
objUserMasterBdto = new UserMasterBDto();
objUserMasterBdto.UserId = objAuthorizationBDto.UserProfile.UserId;
objUserMasterBdto.UserName = txtUserName.Text;
objUserMasterBdto.Password = txtPassword.Text;
objUserMasterBdto.EmpID = int.Parse(ddlEmployeeName.SelectedValue);
objUserMasterBdto.SecurityQusId = int.Parse(ddlSecurityQus.SelectedValue);
objUserMasterBdto.SecurityQusAns = txtSecurityQusAns.Text;
objUserMasterBdto.FromDate = Convert.ToDateTime(rdpFromDate.SelectedDate);
objUserMasterBdto.ToDate = Convert.ToDateTime(rdpToDate.SelectedDate);
result = objUserMasterDAL.InsertUser(objUserMasterBdto);
GlobalUserId = result;
GlobalEmpId = int.Parse(ddlEmployeeName.SelectedValue);
if (result == -2)
{
Master.DisplayMessage("Username already exists. Record is not saved.");
Master.MessageCssClass = "errorMessage";
}
else if (result >= 1)
{
Master.DisplayMessage(ConfigurationSettings.AppSettings[SuccessMessage.Save].ToString());
Master.MessageCssClass = "successMessage";
BindGrid();
radTabStripe.FindTabByText("User Access").Enabled = true;
FillCompanyLists(GlobalUserId, GlobalEmpId);
BindRoleList();
}
else
{
Master.DisplayMessage(ConfigurationSettings.AppSettings[FailureMessage.Save].ToString());
Master.MessageCssClass = "errorMessage";
}
break;
case "Update":
objUserMasterBdto = new UserMasterBDto();
objUserMasterDAL = new UserMasterDal();
//UpdateUser();
if (ViewState[PageConstants.vsItemIndexes] != null)
{
htItemIndex = (Hashtable)(ViewState[PageConstants.vsItemIndexes]);
}
if (htItemIndex != null)
{
GridDataItem item = radgrdUser.Items[int.Parse(htItemIndex[0].ToString())];
//Label lblGrdUserId = (Label)radgrdUser.Items[Convert.ToInt32(htItemIndex[0])].FindControl("lblGrdUserID");
objUserMasterBdto.m_UserId = int.Parse(item["USER_ID"].Text);
objUserMasterBdto.UserId = objAuthorizationBDto.UserProfile.UserId;
objUserMasterBdto.UserName = txtUserName.Text;
objUserMasterBdto.Password = txtPassword.Text;
objUserMasterBdto.EmpID = int.Parse(ddlEmployeeName.SelectedValue);
objUserMasterBdto.SecurityQusId = int.Parse(ddlSecurityQus.SelectedValue);
objUserMasterBdto.SecurityQusAns = txtSecurityQusAns.Text;
objUserMasterBdto.FromDate = Convert.ToDateTime(rdpFromDate.SelectedDate);
objUserMasterBdto.ToDate = Convert.ToDateTime(rdpToDate.SelectedDate);
GlobalEmpId = int.Parse(ddlEmployeeName.SelectedValue);
result = objUserMasterDAL.UpdateUser(objUserMasterBdto);
if (result == 1)
{
acbUser.DefaultMode = true;
Master.DisplayMessage(ConfigurationSettings.AppSettings[SuccessMessage.Update].ToString());
Master.MessageCssClass = "successMessage";
if (ViewState[PageConstants.vsItemIndexes] != null)
htItemIndex = (Hashtable)ViewState[PageConstants.vsItemIndexes];
for (int i = 0; i < htItemIndex.Count; i++)
radgrdUser.Items[Convert.ToInt32(htItemIndex[i])].Edit = false;
//bisEdit = true;
ViewState[PageConstants.vsItemIndexes] = null;
BindGrid();
radgrdUser.Rebind();
acbUser.Visible = true;
pnlAddMode.Visible = false;
pnlGrid.Visible = true;
}
else
{
Master.DisplayMessage(ConfigurationSettings.AppSettings[FailureMessage.Update].ToString());
Master.MessageCssClass = "errorMessage";
acbUser.Visible = true;
pnlAddMode.Visible = false;
}
}
break;
case "Search":
{
//UserMasterBDto objUserMasterBDto = new UserMasterBDto();
//objUserMasterBDto.UserName = txtUserName.Text;
//objUserMasterBDto.EmpID = int.Parse(ddlEmployeeName.SelectedValue);
//objUserMasterBDto.SecurityQusId = int.Parse(ddlSecurityQus.SelectedValue);
//objUserMasterBDto.SecurityQusAns = txtSecurityQusAns.Text;
//objUserMasterBDto.FromDate = Convert.ToDateTime(rdpFromDate.SelectedDate);
//objUserMasterBDto.ToDate = Convert.ToDateTime(rdpToDate.SelectedDate);
//DataSet dsUser = objUserMasterDAL.GetUser(objUserMasterBDto);
//if (dsUser != null && dsUser.Tables[0].Rows.Count > 0)
//{
// radgrdUser.DataSource = dsUser;
// radgrdUser.DataBind();
// ViewState[vsUser] = dsUser;
// acbUser.Visible = true;
// pnlAddMode.Visible = false;
// pnlGrid.Visible = true;
//}
//else
//{
// Master.DisplayMessage(ConfigurationSettings.AppSettings["NoRecord"].ToString());
// Master.MessageCssClass = "errorMessage";
//}
break;
}
}
}
private void UpdateUser()
{
objUserMasterBdto = new UserMasterBDto();
try
{
if (htItemIndex != null && htItemIndex.Count > 0)
{
for (int i = 0; i < htItemIndex.Count; i++)
{
Label lblGrdUserId = (Label)radgrdUser.Items[Convert.ToInt32(htItemIndex[i])].FindControl("lblGrdUserID");
objUserMasterBdto.UserId = objAuthorizationBDto.UserProfile.UserId;
objUserMasterBdto.UserName = txtUserName.Text;
objUserMasterBdto.Password = txtPassword.Text;
objUserMasterBdto.EmpID = int.Parse(ddlEmployeeName.SelectedValue);
objUserMasterBdto.SecurityQusId = int.Parse(ddlSecurityQus.SelectedValue);
objUserMasterBdto.SecurityQusAns = txtSecurityQusAns.Text;
objUserMasterBdto.FromDate = Convert.ToDateTime(rdpFromDate.SelectedDate);
objUserMasterBdto.ToDate = Convert.ToDateTime(rdpToDate.SelectedDate);
}
}
}
catch (Exception ex) { }
}