public string CompanyLogoImageFileName(string CompanyID, CompanyImageTypes CompanyImageType, string ConnectionString)
{
ServiceCallDataElements.SQLServer sqlServer = new ServiceCallDataElements.SQLServer();
string sImageFile = ""; string sName = ""; string sTypeColumn = ""; string sExtention = ""; string sTempPath = "";
try
{
sTempPath = Environment.CurrentDirectory + "\\Temp\\";
switch (CompanyImageType)
{
case CompanyImageTypes.InvoiceLogoImage:
sTypeColumn = "InvoiceLogoImageType";
sName = "InvoiceLogo";
break;
case CompanyImageTypes.SmallLogoImage:
sTypeColumn = "SmallLogoImageType";
sName = "SmallLogo";
break;
}
sqlServer.ConnectionString = ConnectionString;
sExtention = sqlServer.GetStringValue("SELECT " + sTypeColumn + " FROM Core.Companies WHERE CompanyID='" + CompanyID + "'", "");
if (sExtention == "")
{
sExtention = "jpg";
}
sImageFile = sTempPath + sName + "_" + CompanyID + "." + sExtention;
}
catch (Exception ex)
{
sImageFile = "";
}
return(sImageFile);
}
public bool ExtractCompanyImage(string CompanyID, ref string LogoImageFile, CompanyImageTypes CompanyImageType, string ConnectionString)
{
System.IO.FileStream DocumentStream;
System.Data.DataTable DataTable = null; System.Data.DataRow DataRow = null;
string sCommandText = ""; string sImageColumn = ""; string sImageSizeColumn = "";
int iFileSize = 0; bool bResult = true;
ServiceCallDataElements.SQLServer SQLServer = new ServiceCallDataElements.SQLServer();
try
{
switch (CompanyImageType)
{
case CompanyImageTypes.InvoiceLogoImage:
sImageColumn = "InvoiceLogoImage";
sImageSizeColumn = "InvoiceLogoImageSize";
break;
case CompanyImageTypes.SmallLogoImage:
sImageColumn = "SmallLogoImage";
sImageSizeColumn = "SmallLogoImageSize";
break;
}
RemoveFile(LogoImageFile);
sCommandText = "SELECT " + sImageColumn + "," + sImageSizeColumn + " FROM Core.Companies WHERE CompanyID='" + CompanyID + "'";
SQLServer.ConnectionString = ConnectionString;
DataTable = SQLServer.GetDataTable(sCommandText);
DataTable.TableName = "Logo";
DataRow = DataTable.Rows[0];
iFileSize = Convert.ToInt32(DataRow[sImageSizeColumn]);
Byte[] BLOBData = new Byte[iFileSize - 1];
BLOBData = (Byte[])DataRow[sImageColumn];
DocumentStream = new System.IO.FileStream(LogoImageFile, System.IO.FileMode.CreateNew);
DocumentStream.Write(BLOBData, 0, iFileSize);
DocumentStream.Flush();
DocumentStream.Close();
DocumentStream = null;
}
catch (Exception ex)
{
bResult = false;
Console.WriteLine(ex.Message);
}
finally
{
DocumentStream = null;
DataTable = null;
}
return(bResult);
}
