public NandanaResult UpdateFolderNameDetails(string Folder_ID, string Folder_Name)
{
NandanaResult result;
int iVal = -1;
ArrayList paramArray = new ArrayList();
paramArray.Add(new NandanaDBRequest.Parameter("@FolderId", Folder_ID));
paramArray.Add(new NandanaDBRequest.Parameter("@Foldername", Folder_Name));
try
{
NandanaAbstractFactory factory = NandanaDBInstance.GetDBFactory();
NandanaDBRequest request = new NandanaDBRequest("sp_UpdateFolderNameDetails", 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 UpdateFolderNameDetails sp.", m_oSession, e));
}
if (iVal < 0)
{
return(new NandanaResult(NandanaError.ErrorType.ERR_UPDATING_RECORD, "No record Updating from UpdateFolderNameDetails sp.", m_oSession));
}
else
{
result = new NandanaResult(null);
}
return(result);
}
public NandanaResult GetFormDetailsByMenuID(string MenuId)
{
NandanaResult result;
NandanaDataSet resultDS;
ArrayList paramArray = new ArrayList();
paramArray.Add(new NandanaDBRequest.Parameter("@MenuId", MenuId));
try
{
NandanaAbstractFactory factory = NandanaDBInstance.GetDBFactory();
NandanaDBRequest request = new NandanaDBRequest("GetFormDetailsByMenuID", 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 GetFormDetailsByMenuID 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 GetFormDetailsByMenuID sp.", m_oSession));
}
return(result);
}
public NandanaResult GetFolderNamesUsingParentFolderID(string FileCabinet_ID, string ParentFolderID)
{
NandanaResult result;
NandanaDataSet resultDS;
ArrayList paramArray = new ArrayList();
paramArray.Add(new NandanaDBRequest.Parameter("@FileCabinet_ID", FileCabinet_ID));
paramArray.Add(new NandanaDBRequest.Parameter("@ParentFolderID", ParentFolderID));
try
{
NandanaAbstractFactory factory = NandanaDBInstance.GetDBFactory();
NandanaDBRequest request = new NandanaDBRequest("sp_GetFolderNamesUsingParentFolderID", 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 GetFolderNamesUsingParentFolderID 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 GetFolderNamesUsingParentFolderID sp.", m_oSession));
}
return(result);
}
public NandanaResult BindMonth()
{
NandanaResult result;
NandanaDataSet resultDS;
ArrayList paramArray = new ArrayList();
try
{
NandanaAbstractFactory factory = NandanaDBInstance.GetDBFactory();
NandanaDBRequest request = new NandanaDBRequest("sp_BindMonth", 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 BindMonth 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 BindMonth 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 InsertUserValues(string Username, string password, string RoleId)
{
NandanaResult result;
int iVal = -1;
ArrayList paramArray = new ArrayList();
paramArray.Add(new NandanaDBRequest.Parameter("@Username", Username));
paramArray.Add(new NandanaDBRequest.Parameter("@password", password));
paramArray.Add(new NandanaDBRequest.Parameter("@RoleId", RoleId));
try
{
NandanaAbstractFactory factory = NandanaDBInstance.GetDBFactory();
NandanaDBRequest request = new NandanaDBRequest("sp_InsertUserValues", 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 InsertUserValues sp.", m_oSession, e));
}
if (iVal < 0)
{
return(new NandanaResult(NandanaError.ErrorType.ERR_INSERTING_RECORD, "Error While inserting data into InsertUserValues 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);
}
/// <summary>
/// If transaction is not yet started, then start transaction and return
/// </summary>
/// <returns>Opened Transaction</returns>
public MySqlTransaction BeginTransaction()
{
if (m_oTransaction == null)
{
if (m_oDBFactory == null)
{
m_oDBFactory = NandanaDBInstance.GetDBFactory();
}
m_oTransaction = m_oDBFactory.GetTransaction();
}
return(m_oTransaction);
}
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);
}
/// <summary>
/// Constuctor with NandanaSession and NandanaTransaction as argument.
/// </summary>
public NandanaBase(NandanaSession sess, MySqlTransaction Trans)
{
m_oSession = sess;
m_oDBFactory = NandanaDBInstance.GetDBFactory();
m_oTransaction = Trans;
}
/// <summary>
/// Constuctor with NandanaSession as argument.
/// </summary>
public NandanaBase(NandanaSession sess)
{
m_oSession = sess;
m_oTransaction = null;
m_oDBFactory = NandanaDBInstance.GetDBFactory();
}
