public IHttpActionResult PostRule([FromBody] pcms_Rule _rule)
{
// string MS = "";
pcms_KeyRule objKeyRule = new pcms_KeyRule();
if (_rule != null)
{
pcms_BAL objBAL = new pcms_BAL();
objKeyRule = objBAL.RuleInformarion(_rule);
//var response = this.Request.CreateResponse(HttpStatusCode.OK);
//DataTableToJson json = new DataTableToJson();
//if (yourJson.Rows.Count > 0)
//{
// response.Content = new StringContent(json.DataTableToJsonObj(yourJson), Encoding.UTF8, "application/json");
// return response;
//}
//else
//{
// var response1 = this.Request.CreateResponse(HttpStatusCode.OK);
// string jsonData = "[{'RULE_ID':null,'RULE_APPLIED_URL':null,'CONTENT_HTML':null,'DESIGN_HTML':null,'POPUP_HTML':null}]";
// response1.Content = new StringContent(jsonData, Encoding.UTF8, "application/json");
// return response1;
//}
}
else
{
//var response2 = this.Request.CreateResponse(HttpStatusCode.OK);
//string json = "[{'RULE_ID':'','RULE_APPLIED_URL':'','CONTENT_HTML':'','DESIGN_HTML':'','POPUP_HTML':''}]";
//response2.Content = new StringContent(json, Encoding.UTF8, "application/json");
//return response2;
}
return(Ok(objKeyRule));
}
public pcms_KeyRule RuleInformarion(pcms_Rule _rule)
{
SqlCommand cmd = null;
using (SqlConnection con = new SqlConnection(_connectionString))
{
con.Open();
pcms_KeyRule objDAL = new pcms_KeyRule();
cmd = new SqlCommand(null, con);
cmd.CommandText = @"select RULE_ID,RULE_APPLIED_URL,CONTENT_HTML,DESIGN_HTML,
POPUP_HTML,RULE_PARAMETER_KEY_VALUE,CAMPAIGN_REDIRECT_URL,
CAMPAIGN_CONTAINER_ID FROM pcms_rules inner join pcms_campaign
on CAMPAIGN_RULE_ID=RULE_ID
left join pcms_popup on CAMPAIGN_POPUP_ID=POPUP_ID
left join pcms_design on CAMPAIGN_DESIGN_ID= DESIGN_ID
left join pcms_content on CAMPAIGN_CONTENT_ID=CONTENT_ID
where CAMPAIGN_STATUS='Active' AND RULE_APPLIED_URL=@RULE_APPLIED_URL
AND RULE_LOCATION=@RULE_LOCATION
AND RULE_USER_TYPE =@RULE_USER_TYPE
AND (CAMPAIGN_START_DATE <='" + DateTime.Now + "' AND CAMPAIGN_END_DATE >='" + DateTime.Now + "')";
SqlParameter RULE_APPLIED_URL = new SqlParameter("@RULE_APPLIED_URL", SqlDbType.NVarChar, -1);
SqlParameter RULE_LOCATION = new SqlParameter("@RULE_LOCATION", SqlDbType.NVarChar, -1);
SqlParameter RULE_USER_TYPE = new SqlParameter("@RULE_USER_TYPE", SqlDbType.NVarChar, -1);
RULE_APPLIED_URL.Value = Cryptographys.Encrypt(_rule.URL);
cmd.Parameters.Add(RULE_APPLIED_URL);
RULE_LOCATION.Value = _rule.COUNTRY;
cmd.Parameters.Add(RULE_LOCATION);
RULE_USER_TYPE.Value = _rule.USERTYPE;
cmd.Parameters.Add(RULE_USER_TYPE);
cmd.Prepare();
SqlDataReader dr = cmd.ExecuteReader();
//DataTable dt = new DataTable();
//dt.Columns.Add("CONTENT_HTML", typeof(string));
//dt.Columns.Add("DESIGN_HTML", typeof(string));
//dt.Columns.Add("POPUP_HTML", typeof(string));
//dt.Columns.Add("RULE_PARAMETER_KEY_VALUE", typeof(string));
//dt.Columns.Add("CAMPAIGN_REDIRECT_URL", typeof(string));
//dt.Columns.Add("CAMPAIGN_CONTAINER_ID", typeof(string));
// DataRow row;
while (dr.Read())
{
objDAL = new pcms_KeyRule();
// row["RULE_ID"] = dr["RULE_ID"].ToString();
objDAL.CAMPAIGN_CONTAINER_ID = dr["CAMPAIGN_CONTAINER_ID"].ToString();
objDAL.RULE_PARAMETER_KEY_VALUE = dr["RULE_PARAMETER_KEY_VALUE"].ToString();
// row["RULE_APPLIED_URL"] = Cryptographys.Decrypt(dr["RULE_APPLIED_URL"].ToString());
objDAL.CONTENT_HTML = Cryptographys.Decrypt(dr["CONTENT_HTML"].ToString());
objDAL.DESIGN_HTML = Cryptographys.Decrypt(dr["DESIGN_HTML"].ToString());
objDAL.POPUP_HTML = Cryptographys.Decrypt(dr["POPUP_HTML"].ToString());
objDAL.CAMPAIGN_REDIRECT_URL = Cryptographys.Decrypt(dr["CAMPAIGN_REDIRECT_URL"].ToString());
// dt.Rows.Add(row);
}
con.Close();
return(objDAL);
}
}
public pcms_KeyRule RuleInformarion(pcms_Rule _rule)
{
return(objDAL.RuleInformarion(_rule));
}
