public datTabJSON getRattlesICreated(int PageNum)
{
//System.Windows.Forms.MessageBox.Show("in service");
datTabJSON rtnJSON = new datTabJSON();
try
{
bizInformation myBizInfo = new bizInformation();
rtnJSON.sColumns = myBizInfo.getMyRattlesHtml(PageNum);
if (rtnJSON.sColumns != null)
{
rtnJSON.iTotalDisplayRecords = PageNum + 1;
rtnJSON.sError = 0;
}
else
{
rtnJSON.iTotalDisplayRecords = 0;
rtnJSON.sError = 100;
}
}
catch (Exception err)
{
rtnJSON.sError = 550;
return(null);
}
return(rtnJSON);
}
public datTabJSON getShopsRattle(string shopID)
{
datTabJSON rtnJSON = new datTabJSON();
try
{
bizInformation myBizInfo = new bizInformation(shopID);
rtnJSON.sColumns = myBizInfo.getMyRattlesHtml(1);
if (rtnJSON.sColumns != null)
{
rtnJSON.iTotalDisplayRecords = 1 + 1;
rtnJSON.iTotalRecords = myBizInfo.CurrCycleRattleCnt;
rtnJSON.sError = 0;
}
else
{
rtnJSON.iTotalDisplayRecords = 0;
rtnJSON.sError = 100;
}
}
catch (Exception err)
{
rtnJSON.sError = 911;
}
return(rtnJSON);
}
public datTabJSON getMyRattles(int pageNum)
{
datTabJSON dtTab = new datTabJSON();
try
{
if (!User.Identity.IsAuthenticated)
{
dtTab.sError = 904;
return(dtTab);
}
SNetwrking myNetWork = new SNetwrking();
dtTab.iDataGrp = myNetWork.generateMyRattles(pageNum);
if (dtTab.iDataGrp != null)
{
dtTab.iTotalRecords = dtTab.iDataGrp.Count;
dtTab.sError = 0;
}
else
{
dtTab.sError = 100;
}
return(dtTab);
}
catch (Exception err)
{
//System.Windows.Forms.MessageBox.Show(err.Message );
dtTab.sError = 911;
return(dtTab);
}
}
public datTabJSON DeleteRattle(int rattleID)
{
datTabJSON myJSON = new datTabJSON();
if (!User.Identity.IsAuthenticated)
{
myJSON.sError = 904;
return(myJSON);
}
string connStr = WebConfigurationManager.ConnectionStrings["rattleDB"].ConnectionString;
string myID = Membership.GetUser().ProviderUserKey.ToString();
string storedProc = "rattleDelete";
using (SqlConnection con = new SqlConnection(connStr))
{
SqlCommand cmd = new SqlCommand(storedProc, con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@ID", SqlDbType.VarChar, 50));
cmd.Parameters.Add(new SqlParameter("@RattleID", SqlDbType.Int, 120));
cmd.Parameters["@ID"].Value = myID;
cmd.Parameters["@RattleID"].Value = rattleID;
//System.Windows.Forms.MessageBox.Show("4" + typ);
try
{
con.Open();
int rtnCode = cmd.ExecuteNonQuery();
con.Close();
string cacheFans = myID + "rattlesIcreatedXml";;
CommonFunctions.cacheRemove(cacheFans);
myJSON.sError = 0;
return(myJSON);
}
catch (SqlException sqlErr)
{
//System.Windows.Forms.MessageBox.Show(sqlErr.Message);
myJSON.sError = 557;
return(myJSON);
}
}
}
public datTabJSON getmyCoupons(int PageNum)
{
datTabJSON rtnJSON = new datTabJSON();
if (!User.Identity.IsAuthenticated)
{
rtnJSON.sError = 904;
return(rtnJSON);
}
if (!patRatesFunctions.CommonFunctions.isNumeric(PageNum.ToString()))
{
rtnJSON.sEcho = "Invalid Pagenumber";
rtnJSON.sError = 908;
return(rtnJSON);
}
try
{
SNetwrking disMy = new SNetwrking();
string myHtml = disMy.getMydiscounts(PageNum);
if (myHtml == null)
{
rtnJSON.sEcho = "<div>No More records to fetch.</div>";
rtnJSON.sError = 100;
return(rtnJSON);
}
rtnJSON.sEcho = myHtml;
rtnJSON.sError = 0;
}
catch (Exception ex)
{
rtnJSON.sError = 656;
rtnJSON.sEcho = ex.Message;
return(rtnJSON);
}
return(rtnJSON);
}
public datTabJSON getMyFans(string sEcho)
{
//Get all Fans And FanGrps in Array and pass it as JSON - cloned from getMyShops
datTabJSON JSON = new datTabJSON();
try
{
if (User.Identity.IsAuthenticated)
{
SNetwrking myFans = new SNetwrking();
JSON.aaData = myFans.getMyFans();
JSON.iDataGrp = myFans.getFanGroups();
JSON.iTotalRecords = myFans.TotalFans;
JSON.sColumns = "4";
JSON.sEcho = sEcho;
JSON.iTotalDisplayRecords = 10;
if (JSON.iTotalRecords == 0)
{
JSON.sError = 100;
}
else
{
JSON.sError = 0;
}
}
else
{
JSON.sError = 904;
}
}
catch (Exception err)
{
//System.Windows.Forms.MessageBox.Show (err.Message );
JSON.sError = 999;
}
return(JSON);
}
public datTabJSON createNewRattle(string rattle)
{
datTabJSON myJSON = new datTabJSON();
try
{
if (!User.Identity.IsAuthenticated)
{
myJSON.sEcho = "User not logged in";
myJSON.sError = 904;
return(myJSON);
}
rattle.Trim();
if (rattle.Length > 120)
{
myJSON.sEcho = "Rattle length is greater than 120 characters";
myJSON.sError = 555;
return(myJSON);
}
if (rattle.Length == 0)
{
myJSON.sEcho = "Your rattles cannot be empty";
myJSON.sError = 556;
return(myJSON);
}
string connStr = WebConfigurationManager.ConnectionStrings["rattleDB"].ConnectionString;
string myID = Membership.GetUser().ProviderUserKey.ToString();
string storedProc = "rattleInsert";
using (SqlConnection con = new SqlConnection(connStr))
{
SqlCommand cmd = new SqlCommand(storedProc, con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@ID", SqlDbType.VarChar, 50));
cmd.Parameters.Add(new SqlParameter("@rattleMsg", SqlDbType.VarChar, 120));
cmd.Parameters.Add(new SqlParameter("@RattleID", SqlDbType.Int, 120));
cmd.Parameters["@ID"].Value = myID;
cmd.Parameters["@rattleMsg"].Value = rattle;
cmd.Parameters["@RattleID"].Direction = ParameterDirection.Output;
//System.Windows.Forms.MessageBox.Show("4" + typ);
try
{
con.Open();
cmd.ExecuteNonQuery();
string rattleID = cmd.Parameters["@RattleID"].Value.ToString();
con.Close();
string cacheFans = myID + "rattlesIcreatedXml";
myJSON.sEcho = patRatesFunctions.CommonFunctions.createRattleHTML(rattleID, DateTime.Now.ToShortTimeString(), rattle);
myJSON.sColumns = "#R" + rattleID;
patRatesFunctions.CommonFunctions.cacheRemove(cacheFans);
myJSON.sError = 000;
return(myJSON);
}
catch (SqlException sqlErr)
{
myJSON.sEcho = sqlErr.Message;
myJSON.sError = 557;
return(myJSON);
}
}
}
catch (Exception err)
{
myJSON.sEcho = err.Message;
myJSON.sError = 558;
return(myJSON);
}
}
public datTabJSON updateEmail(string id, char flag)
{
datTabJSON rtnCls = new datTabJSON();
try
{
if (!User.Identity.IsAuthenticated)
{
rtnCls.sError = 904;
return(rtnCls);
}
string myID = Membership.GetUser().ProviderUserKey.ToString();
if (string.IsNullOrEmpty(id))
{
rtnCls.sError = 913;
return(rtnCls);
}
if (char.IsWhiteSpace(flag))
{
rtnCls.sError = 914;
return(rtnCls);
}
if (flag.ToString() == "Y" || flag.ToString() == "N")
{
}
else
{
rtnCls.sError = 915;
return(rtnCls);
}
string connStr = WebConfigurationManager.ConnectionStrings["eastManDB"].ConnectionString;
string storedProc = "SNEmailNotificationChg";
using (SqlConnection con = new SqlConnection(connStr))
{
SqlCommand cmd = new SqlCommand(storedProc, con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@myID", SqlDbType.VarChar, 50));
cmd.Parameters.Add(new SqlParameter("@shopID", SqlDbType.VarChar, 50));
cmd.Parameters.Add(new SqlParameter("@email", SqlDbType.Char, 1));
cmd.Parameters["@myID"].Value = myID;
cmd.Parameters["@shopID"].Value = id;
cmd.Parameters["@email"].Value = flag;
//System.Windows.Forms.MessageBox.Show("4" + typ);
try
{
con.Open();
int rtncode = cmd.ExecuteNonQuery();
//System.Windows.Forms.MessageBox.Show("5" + typ);
con.Close();
//System.Windows.Forms.MessageBox.Show("6" + typ);
string cacheFans = myID + "SNetwrkMyFansDataTab";
CommonFunctions.cacheRemove(cacheFans);
string HTMLstr;
if (flag.ToString() == "Y")
{ // This means that the Flag is now set to Yes. So we need to set it to "N" on the page
HTMLstr = "<a href='#' onclick='updateMsgFlag(" + '"' + myID + '"' + "," + '"' + "N" + '"' + "," + '"' + "Email" + '"' + ",this)'; Title='Stop Email Notification'> <img style='outline-style:none;border-style:none;' alt='Stop Email Notification' src='../Images/mail-delete.png' /> </a>";
}
else
{
HTMLstr = "<a href='#' onclick='updateMsgFlag(" + '"' + myID + '"' + "," + '"' + "Y" + '"' + "," + '"' + "Email" + '"' + ",this)';Title='Get Email Notification'> <img style='outline-style:none;border-style:none;' alt='Get Email Notification' src='../Images/mail-add.png' /></a>";
}
rtnCls.sError = 0;
rtnCls.sEcho = HTMLstr;
}
catch (SqlException sqlErr)
{
//System.Windows.Forms.MessageBox.Show(sqlErr.Message);
rtnCls.sError = 911;
}
return(rtnCls);
}
}
catch (Exception err)
{
rtnCls.sError = 912;
return(rtnCls);
}
}
