try
{
objErr = new ErrorLog(FilePath);
objErr.SaveException("Call to Queued Result Start...");
byte[] Thb_Templ = new byte[0];
int PK_ID = 0;
string Result = string.Empty;
dsTemp.Clear();
sqlcon.Open();
if (sqlcon.State == ConnectionState.Open)
{
sqlcon.Close();
}
else if (sqlcon.State == ConnectionState.Closed)
{
sqlcon.Open();
}
string qry = "CIS_USP_DedupeStoreSGTemplate";
sqlcmd = new SqlCommand(qry, sqlcon);
sqlcmd.CommandType = CommandType.StoredProcedure;
sqlcmd.Parameters.AddWithValue("@PK_ID", Convert.ToInt32(PK_ID));
sqlcmd.Parameters.AddWithValue("@Thb_Templ", Thb_Templ);
sqlcmd.Parameters.AddWithValue("@Result", Result);
sqlcmd.Parameters.AddWithValue("@Action", "VIEW");
adap = new SqlDataAdapter(sqlcmd);
adap.Fill(dsTemp, "SGTemplates");
sqlcon.Close();
if (dsTemp.Tables.Count > 0)
{
objErr.SaveException("Convert Queued Result To processing Start...");
ConvertDedupeStoreTmplFromSGToISO(dsTemp);
objErr.SaveException("Convert Queued Result To processing Ends...");
}
objErr.SaveException("Call to Queued Result Ends: ");
}
catch (Exception GenExp)
{
string FilePath = ConfigurationManager.AppSettings["XmlFilePath"].ToString();
ErrorLog objErr = new ErrorLog(FilePath);
objErr.SaveException(GenExp.Message);
}