public OperationResult AddFolder(Folder folder)
{
OperationResult operationResult = new Models.OperationResult();
using (IDbConnection db = new SqlConnection(ConfigurationValues.PostOfficeDatabaseConnection))
{
try
{
const string query = "INSERT INTO [HoldFolders]"
+ " ("
+ " [ActiveDirectoyUser]"
+ " ,[DocumentType]"
+ " ,[FolderName]"
+ " )"
+ "VALUES"
+ " ("
+ " @ActiveDirectoyUser,@DocumentType,@FolderName"
+ " )";
int rowsAffectd = db.Execute(query, new
{
@ActiveDirectoyUser = Utility.GetUserName(),
@DocumentType = folder.DocumentType,
@FolderName = folder.FolderName
});
operationResult.Success = true;
return operationResult;
}
catch (Exception er)
{
operationResult.Success = false;
operationResult.AddMessage(er.ToString());
return operationResult;
}
}
}
//public List<Folder> GetFolders(string folderType)
//{
// List<Folder> folderList = new List<Folder>();
// List<Folder> folderList2 = new List<Folder>();
// Folder folder = new Folder();
// folder.Id = 0;
// folder.FolderName = "Select Folder";
// folderList2.Add(folder);
// try
// {
// string query = "SELECT [ID],[FolderName]"
// + " FROM [HoldFolders]"
// + " where [ActiveDirectoyUser] = @ActiveDirectoyUser"
// + " and documentType = @documentType";
// using (SqlConnection db = new SqlConnection(ConfigurationValues.PostOfficeDatabaseConnection))
// {
// folderList = db.Query<Folder>(query, new
// {
// @ActiveDirectoyUser = Utility.GetUserName(),
// @documentType = folderType
// }).ToList();
// for (int i = 0; i < folderList.Count; i++)
// {
// folderList2.Add(folderList[i]);
// }
// return folderList2;
// }
// }
// catch (Exception er)
// {
// Logging.LogErrors(ConfigurationValues.ErrorLogPath, er.ToString());
// return folderList2;
// }
//}
public List<FaxFolders> GetSendToNames(string friendlyName)
{
List<FaxFolders> faxFoldersList = new List<FaxFolders>();
List<FaxFolders> faxFoldersList2 = new List<FaxFolders>();
FaxFolders faxFolders = new Models.FaxFolders();
faxFolders.ID = 0;
faxFolders.FriendlyName = "Send To";
faxFoldersList2.Add(faxFolders);
Folder folder = new Folder();
// folder.Id = 0;
// folder.FolderName = "Select Folder";
// folderList2.Add(folder);
try
{
using (IDbConnection db = new SqlConnection(ConfigurationValues.PostOfficeDatabaseConnection))
{
string query = "SELECT [ID],[FriendlyName],[NewPath]"
+ " FROM [PostOfficeFolders]"
+ " where [FriendlyName] Like '%" + friendlyName + "%'"
+ " order by [FriendlyName]";
faxFoldersList = db.Query<FaxFolders>(query).ToList();
for (int i = 0; i < faxFoldersList.Count; i++)
{
faxFoldersList2.Add(faxFoldersList[i]);
}
return faxFoldersList2;
}
}
catch (Exception er)
{
Logging.LogErrors(ConfigurationValues.ErrorLogPath, er.ToString());
return faxFoldersList2;
}
}
public List<Folder> GetFolders(string folderType)
{
List<Folder> folderList = new List<Folder>();
List<Folder> folderList2 = new List<Folder>();
Folder folder = new Folder();
folder.Id = 0;
folder.FolderName = "Select Folder";
folderList2.Add(folder);
try
{
string query = "SELECT [ID],[FolderName]"
+ " FROM [HoldFolders]"
+ " where [ActiveDirectoyUser] = @ActiveDirectoyUser"
+ " and documentType = @documentType";
using (SqlConnection db = new SqlConnection(ConfigurationValues.PostOfficeDatabaseConnection))
{
folderList = db.Query<Folder>(query, new
{
@ActiveDirectoyUser = Utility.GetUserName(),
@documentType = folderType
}).ToList();
for (int i = 0; i < folderList.Count; i++)
{
folderList2.Add(folderList[i]);
}
return folderList2;
}
}
catch (Exception er)
{
Logging.LogErrors(ConfigurationValues.ErrorLogPath, er.ToString());
return folderList2;
}
}
