public NandanaResult UpdateAdminPassword(string UserName, string Password)
{
NandanaResult result;
int iVal = -1;
ArrayList paramArray = new ArrayList();
paramArray.Add(new NandanaDBRequest.Parameter("@UserName", UserName));
paramArray.Add(new NandanaDBRequest.Parameter("@Pwd", Password));
try
{
NandanaAbstractFactory factory = NandanaDBInstance.GetDBFactory();
NandanaDBRequest request = new NandanaDBRequest("sp_UpdateAdminPassword", CommandType.StoredProcedure, m_oTransaction, paramArray);
iVal = factory.ExecuteNonQuery(request);
}
catch (Exception e)
{
return(new NandanaResult(NandanaError.ErrorType.ERR_UPDATING_RECORD, "Error While Updating data from UpdateAdminPassword sp.", m_oSession, e));
}
if (iVal < 0)
{
return(new NandanaResult(NandanaError.ErrorType.ERR_UPDATING_RECORD, "No record Updating from UpdateAdminPassword sp.", m_oSession));
}
else
{
result = new NandanaResult(null);
}
return(result);
}
public NandanaResult AdminChangePassword(string UserName, string Password)
{
NandanaResult result;
NandanaDataSet resultDS;
ArrayList paramArray = new ArrayList();
paramArray.Add(new NandanaDBRequest.Parameter("@UserName", UserName));
paramArray.Add(new NandanaDBRequest.Parameter("@Pwd", Password));
try
{
NandanaAbstractFactory factory = NandanaDBInstance.GetDBFactory();
NandanaDBRequest request = new NandanaDBRequest("sp_AdminChangePassword", CommandType.StoredProcedure, m_oTransaction, paramArray);
resultDS = factory.ExecuteDataSet(request);
}
catch (Exception e)
{
return(new NandanaResult(NandanaError.ErrorType.ERR_RETRIEVING_DATA, "Error while Getting data from AdminChangePassword sp.", m_oSession, e));
}
result = new NandanaResult();
result.resultDS = resultDS.ReturnedDataSet;
if (!(result.resultDS != null && result.resultDS.Tables.Count > 0 && result.resultDS.Tables[0].Rows.Count > 0))
{
return(new NandanaResult(NandanaError.ErrorType.ERR_RETRIEVING_DATA, "No record found from AdminChangePassword sp.", m_oSession));
}
return(result);
}
public NandanaResult UpdateLockDocCount(string Config_ID, string Config_Value)
{
NandanaResult result;
int iVal = -1;
ArrayList paramArray = new ArrayList();
paramArray.Add(new NandanaDBRequest.Parameter("@Config_ID", Config_ID));
paramArray.Add(new NandanaDBRequest.Parameter("@Config_Value", Config_Value));
try
{
NandanaAbstractFactory factory = NandanaDBInstance.GetDBFactory();
NandanaDBRequest request = new NandanaDBRequest("sp_UpdateLockDocCount", CommandType.StoredProcedure, m_oTransaction, paramArray);
iVal = factory.ExecuteNonQuery(request);
}
catch (Exception e)
{
return(new NandanaResult(NandanaError.ErrorType.ERR_UPDATING_RECORD, "Error While Updating data into UpdateLockDocCount sp.", m_oSession, e));
}
if (iVal < 0)
{
return(new NandanaResult(NandanaError.ErrorType.ERR_UPDATING_RECORD, "No record Updating from UpdateLockDocCount sp.", m_oSession));
}
else
{
result = new NandanaResult(null);
}
return(result);
}
public NandanaResult InsertScannedDocumentResults(string Date, string Keyword_ID, string Document_ID, string Document_Path, string Match)
{
NandanaResult result;
int iVal = -1;
ArrayList paramArray = new ArrayList();
paramArray.Add(new NandanaDBRequest.Parameter("@date", Date));
paramArray.Add(new NandanaDBRequest.Parameter("@KeywordId", Keyword_ID));
paramArray.Add(new NandanaDBRequest.Parameter("@DocumentId", Document_ID));
paramArray.Add(new NandanaDBRequest.Parameter("@DocumentPath", Document_Path));
paramArray.Add(new NandanaDBRequest.Parameter("@matchstatus", Match));
try
{
NandanaAbstractFactory factory = NandanaDBInstance.GetDBFactory();
NandanaDBRequest request = new NandanaDBRequest("sp_InsertScannedDocumentResults", CommandType.StoredProcedure, m_oTransaction, paramArray);
iVal = factory.ExecuteNonQuery(request);
}
catch (Exception e)
{
return(new NandanaResult(NandanaError.ErrorType.ERR_INSERTING_RECORD, "Error While inserting data into InsertScannedDocumentResults sp.", m_oSession, e));
}
if (iVal < 0)
{
return(new NandanaResult(NandanaError.ErrorType.ERR_INSERTING_RECORD, "Error While inserting data into InsertScannedDocumentResults sp.", m_oSession));
}
else
{
result = new NandanaResult(null);
}
return(result);
}
public NandanaResult UpdateFolderCabinet(string CabinetName, string FolderName)
{
NandanaResult result;
NandanaDataSet resultDS;
ArrayList paramArray = new ArrayList();
paramArray.Add(new NandanaDBRequest.Parameter("@CabinetName", CabinetName));
paramArray.Add(new NandanaDBRequest.Parameter("@Foldername", FolderName));
try
{
NandanaAbstractFactory factory = NandanaDBInstance.GetDBFactory();
NandanaDBRequest request = new NandanaDBRequest("sp_UpdateFolderCabinet", CommandType.StoredProcedure, m_oTransaction, paramArray);
resultDS = factory.ExecuteDataSet(request);
}
catch (Exception e)
{
return(new NandanaResult(NandanaError.ErrorType.ERR_UPDATING_RECORD, "Error While updating data UpdateFolderCabinet", m_oSession, e));
}
result = new NandanaResult();
result.resultDS = resultDS.ReturnedDataSet;
if (!(result.resultDS != null && result.resultDS.Tables.Count > 0 && result.resultDS.Tables[0].Rows.Count > 0))
{
return(new NandanaResult(NandanaError.ErrorType.ERR_RETRIEVING_DATA, "No record found from UpdateFolderCabinet sp.", m_oSession));
}
return(result);
}
public NandanaResult UpdateFileDetails(int Folder_ID, int FileCabinet_ID, string Cabinet_Name, string File_Name, string File_Path, string IsDelete)
{
NandanaResult result;
NandanaDataSet resultDS;
ArrayList paramArray = new ArrayList();
paramArray.Add(new NandanaDBRequest.Parameter("@FolderId", Folder_ID));
paramArray.Add(new NandanaDBRequest.Parameter("@FilecabinetId", FileCabinet_ID));
paramArray.Add(new NandanaDBRequest.Parameter("@CabinetName", Cabinet_Name));
paramArray.Add(new NandanaDBRequest.Parameter("@Filename", File_Name));
paramArray.Add(new NandanaDBRequest.Parameter("@Filepath", File_Path));
paramArray.Add(new NandanaDBRequest.Parameter("@Isdelete", IsDelete));
try
{
NandanaAbstractFactory factory = NandanaDBInstance.GetDBFactory();
NandanaDBRequest request = new NandanaDBRequest("sp_UpdateFileDetails", CommandType.StoredProcedure, m_oTransaction, paramArray);
resultDS = factory.ExecuteDataSet(request);
}
catch (Exception e)
{
return(new NandanaResult(NandanaError.ErrorType.ERR_RETRIEVING_DATA, "Error While retriving data from UpdateFileDetails sp.", m_oSession, e));
}
result = new NandanaResult();
result.resultDS = resultDS.ReturnedDataSet;
if (!(result.resultDS != null && result.resultDS.Tables.Count > 0 && result.resultDS.Tables[0].Rows.Count > 0))
{
return(new NandanaResult(NandanaError.ErrorType.ERR_RETRIEVING_DATA, "No record found from UpdateFileDetails sp.", m_oSession));
}
return(result);
}
public NandanaResult InsertLogHistoryDetails(string LogDateTime, string LoggedInUser, string Description, string Type, string LogDate)
{
NandanaResult result;
int iVal = -1;
ArrayList paramArray = new ArrayList();
paramArray.Add(new NandanaDBRequest.Parameter("@logdatetme", LogDateTime));
paramArray.Add(new NandanaDBRequest.Parameter("@loggeduser", LoggedInUser));
paramArray.Add(new NandanaDBRequest.Parameter("@description", Description));
paramArray.Add(new NandanaDBRequest.Parameter("@logintype", Type));
paramArray.Add(new NandanaDBRequest.Parameter("@LogDate", LogDate));
try
{
NandanaAbstractFactory factory = NandanaDBInstance.GetDBFactory();
NandanaDBRequest request = new NandanaDBRequest("sp_InsertLogHistoryDetails", CommandType.StoredProcedure, m_oTransaction, paramArray);
iVal = factory.ExecuteNonQuery(request);
}
catch (Exception e)
{
return(new NandanaResult(NandanaError.ErrorType.ERR_INSERTING_RECORD, "Error While inserting data into InsertLogHistoryDetails sp.", m_oSession, e));
}
if (iVal < 0)
{
return(new NandanaResult(NandanaError.ErrorType.ERR_INSERTING_RECORD, "Error While inserting data into InsertLogHistoryDetails sp.", m_oSession));
}
else
{
result = new NandanaResult(null);
}
return(result);
}
public NandanaResult GetMainFileNamesUsingFileCabinetID(string FileCabinet_ID)
{
NandanaResult result;
NandanaDataSet resultDS;
ArrayList paramArray = new ArrayList();
paramArray.Add(new NandanaDBRequest.Parameter("@FileCabinet_ID", FileCabinet_ID));
try
{
NandanaAbstractFactory factory = NandanaDBInstance.GetDBFactory();
NandanaDBRequest request = new NandanaDBRequest("sp_GetMainFileNamesUsingFileCabinetID", CommandType.StoredProcedure, m_oTransaction, paramArray);
resultDS = factory.ExecuteDataSet(request);
}
catch (Exception e)
{
return(new NandanaResult(NandanaError.ErrorType.ERR_RETRIEVING_DATA, "Error while Getting data from GetMainFileNamesUsingFileCabinetID sp.", m_oSession, e));
}
result = new NandanaResult();
result.resultDS = resultDS.ReturnedDataSet;
if (!(result.resultDS != null && result.resultDS.Tables.Count > 0 && result.resultDS.Tables[0].Rows.Count > 0))
{
return(new NandanaResult(NandanaError.ErrorType.ERR_RETRIEVING_DATA, "No record found from GetMainFileNamesUsingFileCabinetID sp.", m_oSession));
}
return(result);
}
public NandanaResult GetFormLevelControlPermissions(string RoleId, string UserId, string FormName)
{
NandanaResult result;
NandanaDataSet resultDS;
ArrayList paramArray = new ArrayList();
paramArray.Add(new NandanaDBRequest.Parameter("@RoleId", RoleId));
paramArray.Add(new NandanaDBRequest.Parameter("@UserId", UserId));
paramArray.Add(new NandanaDBRequest.Parameter("@FormName", FormName));
try
{
NandanaAbstractFactory factory = NandanaDBInstance.GetDBFactory();
NandanaDBRequest request = new NandanaDBRequest("GetUserAccessControls", CommandType.StoredProcedure, m_oTransaction, paramArray);
resultDS = factory.ExecuteDataSet(request);
}
catch (Exception e)
{
return(new NandanaResult(NandanaError.ErrorType.ERR_RETRIEVING_DATA, "Error While retriving data from GetUserAccessControls sp.", m_oSession, e));
}
result = new NandanaResult();
result.resultDS = resultDS.ReturnedDataSet;
if (!(result.resultDS != null && result.resultDS.Tables.Count > 0 && result.resultDS.Tables[0].Rows.Count > 0))
{
return(new NandanaResult(NandanaError.ErrorType.ERR_RETRIEVING_DATA, "No record found from GetUserAccessControls sp.", m_oSession));
}
return(result);
}
public void GetPermissiondetails(int FormID)
{
UserManager objUserManager = new UserManager();
NandanaResult dsuserPermission = new NandanaResult();
dsuserPermission = objUserManager.GetUserPermissions(UserAccessPermissionvalues.RoleID);
if (dsuserPermission.resultDS != null && dsuserPermission.resultDS.Tables[0].Rows.Count > 0)
{
Boolean View = false;
DataRow[] drpermissions = dsuserPermission.resultDS.Tables[0].Select("Form_ID ='" + FormID + "'");
if (drpermissions.Length > 0)
{
View = Convert.ToBoolean(drpermissions[0]["IsView"]);
}
if (View == false)
{
ChangeControlStatus(false);
}
else
{
ChangeControlStatus(true);
}
}
}
public NandanaResult InsertUpdateUserAccessPermissions(string RoleID, string ID, Boolean View)
{
NandanaResult result;
int iVal = -1;
ArrayList paramArray = new ArrayList();
paramArray.Add(new NandanaDBRequest.Parameter("@RoleId", RoleID));
paramArray.Add(new NandanaDBRequest.Parameter("@FormId", ID));
paramArray.Add(new NandanaDBRequest.Parameter("@Isview", View));
try
{
NandanaAbstractFactory factory = NandanaDBInstance.GetDBFactory();
NandanaDBRequest request = new NandanaDBRequest("sp_InsertUpdateUserAccessPermissions", CommandType.StoredProcedure, m_oTransaction, paramArray);
iVal = factory.ExecuteNonQuery(request);
}
catch (Exception e)
{
return(new NandanaResult(NandanaError.ErrorType.ERR_INSERTING_RECORD, "Error While inserting data into InsertUpdateUserAccessPermissions sp.", m_oSession, e));
}
if (iVal < 0)
{
return(new NandanaResult(NandanaError.ErrorType.ERR_INSERTING_RECORD, "Error While inserting data into InsertUpdateUserAccessPermissions sp.", m_oSession));
}
else
{
result = new NandanaResult(null);
}
return(result);
}
public NandanaResult InsertUpdateConfigParamUserAccessPermissions(string RoleID, string UserID, string ID, Boolean HasAccess)
{
NandanaResult result;
NandanaDataSet resultDS;
ArrayList paramArray = new ArrayList();
paramArray.Add(new NandanaDBRequest.Parameter("@RoleID", RoleID));
paramArray.Add(new NandanaDBRequest.Parameter("@UserID", UserID));
paramArray.Add(new NandanaDBRequest.Parameter("@ID", ID));
paramArray.Add(new NandanaDBRequest.Parameter("@HasAccess", HasAccess));
try
{
NandanaAbstractFactory factory = NandanaDBInstance.GetDBFactory();
NandanaDBRequest request = new NandanaDBRequest("InsertUpdateConfigParamUserAccessPermissions", CommandType.StoredProcedure, m_oTransaction, paramArray);
resultDS = factory.ExecuteDataSet(request);
}
catch (Exception e)
{
return(new NandanaResult(NandanaError.ErrorType.ERR_RETRIEVING_DATA, "Error While retriving data from InsertUpdateConfigParamUserAccessPermissions sp.", m_oSession, e));
}
result = new NandanaResult();
result.resultDS = resultDS.ReturnedDataSet;
if (!(result.resultDS != null && result.resultDS.Tables.Count > 0 && result.resultDS.Tables[0].Rows.Count > 0))
{
return(new NandanaResult(NandanaError.ErrorType.ERR_RETRIEVING_DATA, "No record found from InsertUpdateConfigParamUserAccessPermissions sp.", m_oSession));
}
return(result);
}
public NandanaResult GetMenuDetails(int RoleId, int UserId)
{
NandanaResult result;
NandanaDataSet resultDS;
ArrayList paramArray = new ArrayList();
paramArray.Add(new NandanaDBRequest.Parameter("@RoleID", RoleId));
paramArray.Add(new NandanaDBRequest.Parameter("@UserId", UserId));
try
{
NandanaAbstractFactory factory = NandanaDBInstance.GetDBFactory();
NandanaDBRequest request = new NandanaDBRequest("GetMenuItemsBasedonRoleanduser", CommandType.StoredProcedure, m_oTransaction, paramArray);
resultDS = factory.ExecuteDataSet(request);
}
catch (Exception e)
{
return(new NandanaResult(NandanaError.ErrorType.ERR_RETRIEVING_DATA, "Error While retriving data from GetMenuItemsBasedonRoleanduser sp.", m_oSession, e));
}
result = new NandanaResult();
result.resultDS = resultDS.ReturnedDataSet;
if (!(result.resultDS != null && result.resultDS.Tables.Count > 0 && result.resultDS.Tables[0].Rows.Count > 0))
{
return(new NandanaResult(NandanaError.ErrorType.ERR_RETRIEVING_DATA, "No record found from GetMenuItemsBasedonRoleanduser sp.", m_oSession));
}
return(result);
}
public NandanaResult InserRoleValues(string Rolename, string Roledesc, Boolean Isactive)
{
NandanaResult result;
int iVal = -1;
ArrayList paramArray = new ArrayList();
paramArray.Add(new NandanaDBRequest.Parameter("@Rolename", Rolename));
paramArray.Add(new NandanaDBRequest.Parameter("@Roledesc", Roledesc));
paramArray.Add(new NandanaDBRequest.Parameter("@Isactive", Isactive));
try
{
NandanaAbstractFactory factory = NandanaDBInstance.GetDBFactory();
NandanaDBRequest request = new NandanaDBRequest("sp_InsertRoleValues", CommandType.StoredProcedure, m_oTransaction, paramArray);
iVal = factory.ExecuteNonQuery(request);
}
catch (Exception e)
{
return(new NandanaResult(NandanaError.ErrorType.ERR_INSERTING_RECORD, "Error While inserting data into InsertRoleValues sp.", m_oSession, e));
}
if (iVal < 0)
{
return(new NandanaResult(NandanaError.ErrorType.ERR_INSERTING_RECORD, "Error While inserting data into InsertRoleValues sp.", m_oSession));
}
else
{
result = new NandanaResult(null);
}
return(result);
}
public NandanaResult DeleteFileCabinetDetails(string FilecabinetId, string Isdelete)
{
NandanaResult result;
int iVal = -1;
ArrayList paramArray = new ArrayList();
paramArray.Add(new NandanaDBRequest.Parameter("@FilecabinetId", FilecabinetId));
paramArray.Add(new NandanaDBRequest.Parameter("@Isdelete", Isdelete));
try
{
NandanaAbstractFactory factory = NandanaDBInstance.GetDBFactory();
NandanaDBRequest request = new NandanaDBRequest("sp_DeleteFileCabinetDetails", CommandType.StoredProcedure, m_oTransaction, paramArray);
iVal = factory.ExecuteNonQuery(request);
}
catch (Exception e)
{
return(new NandanaResult(NandanaError.ErrorType.ERR_UPDATING_RECORD, "Error While Updating data into DeleteFileCabinetDetails sp.", m_oSession, e));
}
if (iVal < 0)
{
return(new NandanaResult(NandanaError.ErrorType.ERR_UPDATING_RECORD, "No record Updating from DeleteFileCabinetDetails sp.", m_oSession));
}
else
{
result = new NandanaResult(null);
}
return(result);
}
public NandanaResult GetKeywordDetails()
{
NandanaResult result;
NandanaDataSet resultDS;
ArrayList paramArray = new ArrayList();
try
{
NandanaAbstractFactory factory = NandanaDBInstance.GetDBFactory();
NandanaDBRequest request = new NandanaDBRequest("sp_GetKeywordDetails", CommandType.StoredProcedure, m_oTransaction, paramArray);
resultDS = factory.ExecuteDataSet(request);
}
catch (Exception e)
{
return(new NandanaResult(NandanaError.ErrorType.ERR_RETRIEVING_DATA, "Error While retriving data from GetKeywordDetails sp.", m_oSession, e));
}
result = new NandanaResult();
result.resultDS = resultDS.ReturnedDataSet;
if (!(result.resultDS != null && result.resultDS.Tables.Count > 0 && result.resultDS.Tables[0].Rows.Count > 0))
{
return(new NandanaResult(NandanaError.ErrorType.ERR_RETRIEVING_DATA, "No record found from GetKeywordDetails sp.", m_oSession));
}
return(result);
}
private void btnOK_Click(object sender, EventArgs e)
{
bool status = true;
if (txtRoleName.Text == String.Empty)
{
lblErrorMsg.Visible = true;
lblErrorMsg.Text = "Role name is required";
status = false;
txtRoleName.Focus();
return;
}
if (!status)
{
MessageBox.Show("Please Enter required data");
}
else
{
try
{
// Checking duplicate Role names
UserManager objUserManager = new UserManager();
NandanaResult result = new NandanaResult();
result = objUserManager.GetRoles();
if (!result.HasError && result.resultDS.Tables[0].Rows.Count > 0)
{
foreach (DataRow dr in result.resultDS.Tables[0].Rows)
{
string RoleName = dr["Role_Name"].ToString();
if (RoleName.ToUpper() == txtRoleName.Text.ToUpper())
{
lblErrorMsg.Visible = true;
lblErrorMsg.Text = "Role already exists, type a new name";
status = false;
txtRoleName.Focus();
return;
}
}
}
//end
//* inserting Role details in Roles table *//
NandanaResult insertFileCabinet = objUserManager.InserRoleValues(txtRoleName.Text.Trim(), txtRoleName.Text + " Desc", Convert.ToBoolean(1));
//* End *//
this.Hide();
}
catch (Exception x)
{
MessageBox.Show(x.Message, "Error while Inserting Data from InsertFileCabinet SP");
}
}
}
public NandanaResult InsertKeywordDetails(string Keyword, string SubSection, string StartWith, string EndWith)
{
NandanaResult result;
NandanaDataSet resultDS;
ArrayList paramArray = new ArrayList();
paramArray.Add(new NandanaDBRequest.Parameter("@keyword", Keyword));
paramArray.Add(new NandanaDBRequest.Parameter("@subsection", SubSection));
paramArray.Add(new NandanaDBRequest.Parameter("@startwith", StartWith));
paramArray.Add(new NandanaDBRequest.Parameter("@endwith", EndWith));
try
{
NandanaAbstractFactory factory = NandanaDBInstance.GetDBFactory();
NandanaDBRequest request = new NandanaDBRequest("sp_InsertKeywordDetails", CommandType.StoredProcedure, m_oTransaction, paramArray);
resultDS = factory.ExecuteDataSet(request);
}
catch (Exception e)
{
return(new NandanaResult(NandanaError.ErrorType.ERR_RETRIEVING_DATA, "Error While retriving data from InsertKeywordDetails sp.", m_oSession, e));
}
result = new NandanaResult();
result.resultDS = resultDS.ReturnedDataSet;
if (!(result.resultDS != null && result.resultDS.Tables.Count > 0 && result.resultDS.Tables[0].Rows.Count > 0))
{
return(new NandanaResult(NandanaError.ErrorType.ERR_RETRIEVING_DATA, "No record found from InsertKeywordDetails sp.", m_oSession));
}
return(result);
}
public NandanaResult InsertDocumentlistDetails(string Date, string File_Name, string ProcessType)
{
NandanaResult result;
NandanaDataSet resultDS;
ArrayList paramArray = new ArrayList();
paramArray.Add(new NandanaDBRequest.Parameter("@date", Date));
paramArray.Add(new NandanaDBRequest.Parameter("@Filename", File_Name));
paramArray.Add(new NandanaDBRequest.Parameter("@Processtype", ProcessType));
try
{
NandanaAbstractFactory factory = NandanaDBInstance.GetDBFactory();
NandanaDBRequest request = new NandanaDBRequest("sp_InsertDocumentlistDetails", CommandType.StoredProcedure, m_oTransaction, paramArray);
resultDS = factory.ExecuteDataSet(request);
}
catch (Exception e)
{
return(new NandanaResult(NandanaError.ErrorType.ERR_RETRIEVING_DATA, "Error While retriving data from InsertDocumentlistDetails sp.", m_oSession, e));
}
result = new NandanaResult();
result.resultDS = resultDS.ReturnedDataSet;
if (!(result.resultDS != null && result.resultDS.Tables.Count > 0 && result.resultDS.Tables[0].Rows.Count > 0))
{
return(new NandanaResult(NandanaError.ErrorType.ERR_RETRIEVING_DATA, "No record found from InsertDocumentlistDetails sp.", m_oSession));
}
return(result);
}
public void BindFileCabinets()
{
try
{
string RoleID = UserAccessPermissionvalues.RoleID;
string UserID = UserAccessPermissionvalues.UserID;
if (RoleID != null && UserID != null)
{
FileCabinetManager objFileCabinetManager = new FileCabinetManager();
NandanaResult result = new NandanaResult();
result = objFileCabinetManager.GetFileCabinets();
if (!result.HasError && result.resultDS.Tables[0].Rows.Count > 0)
{
cmbFileCabinet.Items.Clear();
cmbFileCabinet.DisplayMember = "FileCabinet_Name";
cmbFileCabinet.ValueMember = "FileCabinet_ID";
cmbFileCabinet.DataSource = GetComboBoxedDataTable(result.resultDS.Tables[0], "FileCabinet_ID", "FileCabinet_Name", "0", "Choose a Cabinet");
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Error While retriving data from Filecabinet table");
}
}
private void BindRoles()
{
try
{
UserManager objUserManager = new UserManager();
NandanaResult dsUserData = objUserManager.GetRoles();
if (!dsUserData.HasError && dsUserData.resultDS.Tables[0].Rows.Count > 0)
{
cmbRole.Items.Clear();
cmbRole.DisplayMember = "Role_Name";
cmbRole.ValueMember = "Role_ID";
cmbRole.DataSource = GetComboBoxedDataTable(dsUserData.resultDS.Tables[0], "Role_ID", "Role_Name", "0", "Choose Role");
}
else
{
cmbRole.Items.Clear();
DataTable dtRoles = new DataTable();
cmbRole.DisplayMember = "Role_Name";
cmbRole.ValueMember = "Role_ID";
cmbRole.DataSource = GetComboBoxedDataTable(dtRoles, "Role_ID", "Role_Name", "0", "Choose Role");
}
}
catch (Exception e)
{
MessageBox.Show(e.Message, "Error While retriving data from GetRoles");
}
}
public NandanaResult DeleteUserDetails(string UserId)
{
NandanaResult result;
int iVal = -1;
ArrayList paramArray = new ArrayList();
paramArray.Add(new NandanaDBRequest.Parameter("@UserId", UserId));
try
{
NandanaAbstractFactory factory = NandanaDBInstance.GetDBFactory();
NandanaDBRequest request = new NandanaDBRequest("sp_DeleteUserDetails", CommandType.StoredProcedure, m_oTransaction, paramArray);
iVal = factory.ExecuteNonQuery(request);
}
catch (Exception e)
{
return(new NandanaResult(NandanaError.ErrorType.ERR_INSERTING_RECORD, "Error While inserting data into DeleteUserDetails sp.", m_oSession, e));
}
if (iVal < 0)
{
return(new NandanaResult(NandanaError.ErrorType.ERR_INSERTING_RECORD, "Error While inserting data into DeleteUserDetails sp.", m_oSession));
}
else
{
result = new NandanaResult(null);
}
return(result);
}
public NandanaResult GetDocumentCountReportUsingDate(string StartDate, string EndDate)
{
NandanaResult result;
NandanaDataSet resultDS;
ArrayList paramArray = new ArrayList();
paramArray.Add(new NandanaDBRequest.Parameter("@StartDate", StartDate));
paramArray.Add(new NandanaDBRequest.Parameter("@EndDate", EndDate));
try
{
NandanaAbstractFactory factory = NandanaDBInstance.GetDBFactory();
NandanaDBRequest request = new NandanaDBRequest("sp_GetDocumentCountReportUsingDate", CommandType.StoredProcedure, m_oTransaction, paramArray);
resultDS = factory.ExecuteDataSet(request);
}
catch (Exception e)
{
return(new NandanaResult(NandanaError.ErrorType.ERR_RETRIEVING_DATA, "Error While retriving data from GetDocumentCountReportUsingDate sp.", m_oSession, e));
}
result = new NandanaResult();
result.resultDS = resultDS.ReturnedDataSet;
if (!(result.resultDS != null && result.resultDS.Tables.Count > 0 && result.resultDS.Tables[0].Rows.Count > 0))
{
return(new NandanaResult(NandanaError.ErrorType.ERR_RETRIEVING_DATA, "No record found from GetDocumentCountReportUsingDate sp.", m_oSession));
}
return(result);
}
private string FormMenuwithMainMenu(string MenuId)
{
string strMenuName = string.Empty;
NandanaResult dsResult = new NandanaResult();
UserManager objUserManager = new UserManager();
dsResult = objUserManager.GetMenuDetilsByMainMenuId(MenuId);
return(strMenuName);
}
private string GetMenuName(string ID)
{
String MenuName = string.Empty;
UserManager objUserManager = new UserManager();
NandanaResult dsResult = new NandanaResult();
dsResult = objUserManager.GetMenuNamesByFormID(ID);
if (!dsResult.HasError && dsResult.resultDS.Tables[0].Rows.Count > 0)
{
MenuName = Convert.ToString(dsResult.resultDS.Tables[0].Rows[0][0]);
}
return(MenuName);
}
public string GetRootFileCabinetName()
{
// Retrieving FileCabinetName using FileCabinetID
m_sConfigFile = null;
if (m_sConfigFile == null)
{
m_sConfigFile = ConfigurationManager.AppSettings["TreeviewFilepath"].ToString();
if (!System.IO.Directory.Exists(m_sConfigFile))
{
System.IO.Directory.CreateDirectory(m_sConfigFile);
}
}
//SearchString objSearchString = new SearchString();
if (SelectedFileCabinetID == "")
{
SelectedFileCabinetID = "1";
}
NandanaResult getfilecabinets = objFileCabinetManager.GetFileCabinets();
if (!getfilecabinets.HasError && getfilecabinets.resultDS.Tables[0].Rows.Count > 0)
{
foreach (DataRow dr in getfilecabinets.resultDS.Tables[0].Rows)
{
if (dr["FileCabinet_ID"].ToString() == SelectedFileCabinetID)
{
FileCabinetName = dr["FileCabinet_Name"].ToString().ToUpper();
m_sRootFile = null;
if (m_sRootFile == null)
{
m_sRootFile = m_sConfigFile + "\\" + FileCabinetName.ToUpper();
if (!System.IO.Directory.Exists(m_sRootFile))
{
System.IO.Directory.CreateDirectory(m_sRootFile);
}
}
}
}
}
if (FileCabinetName == string.Empty)
{
FileCabinetName = "";
}
return(FileCabinetName);
//
}
public void GetFolders()
{
// Taking all all records of Folders into DtFolders table
NandanaResult objgetFolderdetails = objFolderManager.GetFolderDetails();
if (objgetFolderdetails.resultDS != null && objgetFolderdetails.resultDS.Tables[0].Rows.Count > 0)
{
DtFolders = objgetFolderdetails.resultDS.Tables[0];
}
else
{
DtFolders = null;
}
// End
}
private void btnSave_Click(object sender, EventArgs e)
{
bool status = true;
if (cmbRoles.Text == "Choose Role" || cmbRoles.Text.Length == 0)
{
pnlError.Visible = true;
pnlError.Location = new Point((this.Width - pnlError.ClientSize.Width) / 2, 26);
pnlError.BackColor = System.Drawing.ColorTranslator.FromHtml("#f5b7b7");
lblError.Text = "Select a Role";
lblError.Location = new Point((pnlError.Width - lblError.ClientSize.Width) / 2, (pnlError.Height - lblError.ClientSize.Height) / 2);
status = false;
cmbRoles.Focus();
return;
}
if (!status)
{
MessageBox.Show("Please Enter required data");
}
else
{
if (dgvUserAccessPermissions.Rows.Count > 0)
{
foreach (DataGridViewRow gvrow in dgvUserAccessPermissions.Rows)
{
bool View = Convert.ToBoolean(gvrow.Cells[2].Value);
NandanaResult dsResult = new NandanaResult();
try
{
UserManager objUserManager = new UserManager();
dsResult = objUserManager.InsertUpdateUserAccessPermissions(cmbRoles.SelectedValue.ToString(), Convert.ToString(gvrow.Cells[0].Value), Convert.ToBoolean(gvrow.Cells[2].Value));
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Error while Inserting Data from UserAccessPermissions table");
}
}
SaveSuccess objSaveSuccess = new SaveSuccess();
objSaveSuccess.ShowDialog();
}
}
}
public NandanaResult UpdateUserDetails(string UserId, string Firstname, string Lastname, string Middlename, string address, string city, string state, string country, string zip, string mobileno, string alternativemobileno, string Username, string password, string RoleId, Boolean status)
{
NandanaResult result;
int iVal = -1;
ArrayList paramArray = new ArrayList();
paramArray.Add(new NandanaDBRequest.Parameter("@UserId", UserId));
paramArray.Add(new NandanaDBRequest.Parameter("@Firstname", Firstname));
paramArray.Add(new NandanaDBRequest.Parameter("@Lastname", Lastname));
paramArray.Add(new NandanaDBRequest.Parameter("@Middlename", Middlename));
paramArray.Add(new NandanaDBRequest.Parameter("@address", address));
paramArray.Add(new NandanaDBRequest.Parameter("@city", city));
paramArray.Add(new NandanaDBRequest.Parameter("@state", state));
paramArray.Add(new NandanaDBRequest.Parameter("@country", country));
paramArray.Add(new NandanaDBRequest.Parameter("@zip", zip));
paramArray.Add(new NandanaDBRequest.Parameter("@mobileno", mobileno));
paramArray.Add(new NandanaDBRequest.Parameter("@alternativemobileno", alternativemobileno));
paramArray.Add(new NandanaDBRequest.Parameter("@Username", Username));
paramArray.Add(new NandanaDBRequest.Parameter("@password", password));
paramArray.Add(new NandanaDBRequest.Parameter("@RoleId", RoleId));
paramArray.Add(new NandanaDBRequest.Parameter("@Isstatus", status));
try
{
NandanaAbstractFactory factory = NandanaDBInstance.GetDBFactory();
NandanaDBRequest request = new NandanaDBRequest("sp_UpdateUserDetails", CommandType.StoredProcedure, m_oTransaction, paramArray);
iVal = factory.ExecuteNonQuery(request);
}
catch (Exception e)
{
return(new NandanaResult(NandanaError.ErrorType.ERR_INSERTING_RECORD, "Error While inserting data into UpdateUserDetails sp.", m_oSession, e));
}
if (iVal < 0)
{
return(new NandanaResult(NandanaError.ErrorType.ERR_INSERTING_RECORD, "Error While inserting data into UpdateUserDetails sp.", m_oSession));
}
else
{
result = new NandanaResult(null);
}
return(result);
}
public void GetLogHistoryDetails()
{
try
{
Log_History_Manager objLogHistory = new Log_History_Manager();
NandanaResult dsgethistorydetails = objLogHistory.GetLogHistoryDetails();
if (!dsgethistorydetails.HasError && dsgethistorydetails.resultDS.Tables[0].Rows.Count > 0)
{
dgvLogHistory.DataSource = dsgethistorydetails.resultDS.Tables[0];
}
else
{
dgvLogHistory.DataSource = null;
}
}
catch (Exception x)
{
MessageBox.Show(x.Message, "Error While retriving data from GetLogHistoryDetails SP");
}
}
