public byte[] GetCustomerImagePhoto(string Id, string boid)
{
byte[] image = null;
DataTable dt = new DataTable();
CustomerInfoBAL bal = new CustomerInfoBAL();
string Cust_Code = Id != string.Empty ? Convert.ToString(bal.GetCustomerCode(boid).Rows[0][0]) : Id;
string query = "";
string queryImage = "";
if (Id != "")
{
query = @" select [Photo] FROM [SBP_Cust_Image] where [Cust_Code]='" + Id + "'";
queryImage = @" select [Photo] FROM [SBP_Cust_Image_ImgExt] where [Cust_Code]='" + Id + "'";
}
else
{
query = @"select [Photo] FROM [SBP_Cust_Image] where [Cust_Code]=(select [Cust_Code] from [SBP_Customers] where [BO_ID]='" + boid + "')";
queryImage = @"select [Photo] FROM [SBP_Cust_Image_ImgExt] where [Cust_Code]='" + Cust_Code + @"'";
}
try
{
_dbconneciton.ConnectDatabase_ImageExt();
dt = _dbconneciton.ExecuteQuery_ImageExt(queryImage);
}
catch (Exception ex)
{
try
{
_dbconneciton.ConnectDatabase();
dt = _dbconneciton.ExecuteQuery(query);
}
catch (Exception ext)
{
throw new Exception(ex.Message);
}
finally
{
_dbconneciton.CloseDatabase();
}
}
finally
{
_dbconneciton.CloseDatabase_ImageExt();
}
if (dt.Rows.Count > 0)
{
if (dt.Rows[0][0] != DBNull.Value)
{
image = (byte[])dt.Rows[0][0];
}
}
return(image);
}
public byte[] jointholderSignature(string id)
{
byte[] image = null;
DataTable dt = new DataTable();
CustomerInfoBAL bal = new CustomerInfoBAL();
string Cust_Code = id.Length > 7 ? Convert.ToString(bal.GetCustomerCode(id).Rows[0][0]) : id;
string queryImage = "";
string query = "";
if (id.Length > 7)
{
query = @"select [Signature] from [SBP_Joint_holder_Image] where cust_code=(select [Cust_Code] from [SBP_Customers] where [BO_ID]='" + id + "')";
queryImage = @" select [Signature] FROM [SBP_Joint_holder_Image_ImgExt] where [Cust_Code]='" + Cust_Code + "'";
}
else
{
query = @"select [Signature] from [SBP_Joint_holder_Image] where cust_code='" + Cust_Code + "'";
queryImage = @" select [Signature] FROM [SBP_Joint_holder_Image_ImgExt] where [Cust_Code]='" + Cust_Code + "'";
}
try
{
_dbconneciton.ConnectDatabase_ImageExt();
dt = _dbconneciton.ExecuteQuery_ImageExt(queryImage);
}
catch (Exception ex)
{
try
{
_dbconneciton.ConnectDatabase();
dt = _dbconneciton.ExecuteQuery(query);
}
catch (Exception ext)
{
throw new Exception(ex.Message);
}
finally
{
_dbconneciton.CloseDatabase();
}
}
finally
{
_dbconneciton.CloseDatabase_ImageExt();
}
if (dt.Rows.Count > 0)
{
if (dt.Rows[0][0] != DBNull.Value)
{
image = (byte[])dt.Rows[0][0];
}
}
return(image);
}