public bool UpdatePreviewHTML(string HTML, string CDID, string PDID)
{
try
{
DatabaseHandler oDBH = new DatabaseHandler();
oDBH.ExecuteNonQuery("UpdatePreviewHTML", CDID, HTML, PDID);
return true;
}
catch (Exception ex)
{
throw ex;
}
}
//DONE
public AppConfiguration GetAvailableConfig(string CDID)
{
try
{
DatabaseHandler oDBH = new DatabaseHandler();
DataSet dsFinalHTML = new DataSet();
AppConfiguration _oAppConfig = new AppConfiguration();
dsFinalHTML = oDBH.FillData_SP("GetAvailableConfig");
if (dsFinalHTML.Tables.Count > 0)
{
if (dsFinalHTML.Tables[0].Rows.Count > 0)
{
_oAppConfig.AppCustomerDID = CDID;
_oAppConfig.AppID = dsFinalHTML.Tables[0].Rows[0]["AppID"].ToString();
objCommon.SendErrorMail(Convert.ToString(_oAppConfig.AppID), "DALC", "", "", "");
_oAppConfig.AppKey = dsFinalHTML.Tables[0].Rows[0]["AppKey"].ToString();
_oAppConfig.AppSecretKey = dsFinalHTML.Tables[0].Rows[0]["AppSecretKey"].ToString();
_oAppConfig.AppPath = dsFinalHTML.Tables[0].Rows[0]["AppName"].ToString();
_oAppConfig.AppName = dsFinalHTML.Tables[0].Rows[0]["AppType"].ToString();
//_oAppConfig.DID = new AppConfiguration().GetNewDIDWithPrefix();
}
//Now Update this row status to IA
string sqlQueryUpdate = "update [AppConfigRefrence] set AppConfigStatus='IA' where RowID=" + dsFinalHTML.Tables[0].Rows[0]["RowID"].ToString();
if (oDBH.ExecuteNonQuery(sqlQueryUpdate) > 0) return _oAppConfig; else return _oAppConfig;
}
else
{
return null;
}
}
catch (Exception ex)
{
CommonUtility commUtil = new CommonUtility();
commUtil.SendErrorMail(ex.Message, ex.StackTrace, System.Reflection.MethodBase.GetCurrentMethod().Name.ToString(), System.Reflection.MethodBase.GetCurrentMethod().DeclaringType.ToString(), SessionData.Customer.CustomerID);
}
return null;
}
public bool InsertFinalHTML(AppProduct oAppProduct)
{
try
{
DatabaseHandler oDBH = new DatabaseHandler();
if (oDBH.ExecuteNonQuery_SP("InsertFinalHTML", oAppProduct.AppConfigDID, oAppProduct.ProductHTML, oAppProduct.DID) > 0)
{
DatabaseHandler oDBHProd = new DatabaseHandler();
StringBuilder oSBQueryPRod = new StringBuilder();
oSBQueryPRod.Append("Update [AppProduct] set PRoductHTML='" + oAppProduct.ProductHTML + "'");
oSBQueryPRod.Append("where DID='" + oAppProduct.DID + "'");
if (oDBHProd.ExecuteNonQuery(oSBQueryPRod.ToString()) > 0) return true; else return false;
}
//Now insert this FetchFinalHTML to AppProduct too!
return true;
}
catch (Exception ex)
{
throw ex;
}
}