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 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 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 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 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 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 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);
}
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 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 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 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);
}
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 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);
}