public static string SaveImage(string Path, string FolderName, out string err)
{
string id = "";
err = "";
try
{
string filePath = UploadImage(Path, FolderName);
string saveName = Path.Substring(Path.LastIndexOf(@"\") + 1);
List <Tools.SqlContainer> SQLCommands = new List <Tools.SqlContainer>();
{
Tools.SqlContainer SQLContainer = new Tools.SqlContainer();
SQLContainer.Query = "INSERT INTO Files ([FilePathInServer],[OriginalFileName]) VALUES (@FilePathInServer, @OriginalFileName)";
List <SqlParameter> SqlParameters = new List <SqlParameter>();
SqlParameters.Add(new SqlParameter("FilePathInServer", filePath));
SqlParameters.Add(new SqlParameter("OriginalFileName", saveName));
SQLContainer.SqlParameters = SqlParameters;
SQLCommands.Add(SQLContainer);
}
if (Tools.ExecuteSQL(SQLCommands, out err))
{
DataSet ds = new DataSet("ds");
SQLCommands = new List <Tools.SqlContainer>();
{
Tools.SqlContainer SQLContainer = new Tools.SqlContainer();
SQLContainer.Query = "SELECT MAX(FileID) AS ID FROM Files";
SQLCommands.Add(SQLContainer);
}
if (Tools.GetData(SQLCommands, out ds, out err))
{
err = "";
id = ds.Tables[0].Rows[0][0].ToString().Trim();
}
}
}
catch { }
return(id);
}
public static string UploadImagewithLocalCopy(string Path, string FolderName)
{
string filepath = "";
try
{
string saveName = Path.Substring(Path.LastIndexOf(@"\") + 1);
using (client = new AmazonS3Client(Tools.GetConfigValue(Tools.KeyVariables.S3Key), Tools.GetConfigValue(Tools.KeyVariables.S3Secret), RegionEndpoint.APSoutheast1))
{
// Creates the bucket.
CreateBucket(client, FolderName);
PutObjectRequest request = new PutObjectRequest()
{
BucketName = FolderName,
Key = saveName,
FilePath = Path
};
request.CannedACL = Amazon.S3.S3CannedACL.PublicRead;
PutObjectResponse response2 = client.PutObject(request);
}
filepath = GetConfigValue(KeyVariables.S3Url).Replace("[FOLDERNAME]", FolderName) + saveName;
}
catch (Exception ex)
{
string err = "";
List <Tools.SqlContainer> SQLCommands = new List <Tools.SqlContainer>();
{
Tools.SqlContainer SQLContainer = new Tools.SqlContainer();
SQLContainer.Query = "UPDATE Config SET ConfigValue = @ConfigValue WHERE ConfigKey = 'Error'";
List <SqlParameter> SqlParameters = new List <SqlParameter>();
SqlParameters.Add(new SqlParameter("ConfigValue", ex.ToString().Trim()));
SQLContainer.SqlParameters = SqlParameters;
SQLCommands.Add(SQLContainer);
}
ExecuteSQL(SQLCommands, out err);
}
return(filepath);
}
public static string GetConfigValue(string key)
{
string value = "";
string err = "";
List <Tools.SqlContainer> SQLCommands = new List <Tools.SqlContainer>();
{
Tools.SqlContainer SQLContainer = new Tools.SqlContainer();
SQLContainer.Query = "Select ConfigValue From Config Where ConfigKey=@ConfigKey";
List <SqlParameter> SqlParameters = new List <SqlParameter>();
SqlParameters.Add(new SqlParameter("ConfigKey", key));
SQLContainer.SqlParameters = SqlParameters;
SQLCommands.Add(SQLContainer);
}
DataSet ds = new DataSet("ds");
if (GetData(SQLCommands, out ds, out err))
{
if (ds.Tables[0].Rows.Count > 0)
{
value = ds.Tables[0].Rows[0]["ConfigValue"].ToString().Trim();
}
}
return(value);
}
