public bool isSubscribe(string MSISDN)
{
string subStatus= String.Empty;
DataSet dsExt = null;
//dsExt = oCDA.GetDataSet("EXEC WapPortal_CMS.dbo.spGetExtensionByCategoryCodeandSpecification '" + sCategoryCode + "','" + Specification + "'", "WAPDB");
//string Extenstion = dsExt.Tables[0].Rows[0].ItemArray[0].ToString();
// dsExt = CA.GetDataSet("EXEC [Partner_Basket].[dbo].[spChkSubStatus] '" + MSISDN + "'", "WAPDB");
dsExt = CA.GetDataSet("EXEC [FitnessPortal].[dbo].[spChkSubStatus] '" + MSISDN + "'", "WAPDB");
if (dsExt != null)
{
subStatus = dsExt.Tables[0].Rows[0].ItemArray[0].ToString();
}
if (subStatus == "Active")
{
return true;
}
else
{
return false;
}
}
private void BnNatok()
{
ds = CA.GetDataSet("Exec Sp_FullvideoContents_videobox1 'CEBF2EA8-1FB3-4E64-AAD2-C5320EB6A23F'", "WAPDB");
dalaListBanglaNatok.DataSource = ds;
dalaListBanglaNatok.DataBind();
ImageButton2.Visible = true;
}
private void loadEasyWorkOut()
{
DataSet dsVdo = null;
dsVdo = CA.GetDataSet("Exec [FitnessPortal].dbo.Sp_getContentsBySubcategoryID_fitness 'E0AEF450-099B-495F-B056-8AED4B95F00A', 4", "WAPDB");
repeaterEasyWorkOut.DataSource = dsVdo;
repeaterEasyWorkOut.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
#region "MSISDN"
if (Session["MSISDN"] == null)
{
try
{
if (string.IsNullOrEmpty(oUAProfile.GetMSISDN()) || oUAProfile.GetMSISDN().StartsWith("Error"))
{
throw new Exception();
}
else
{
sMsisdn = oUAProfile.GetMSISDN();
}
}
catch //(Exception ex)
{
sMsisdn = string.Empty;
}
}
else
{
sMsisdn = Session["MSISDN"].ToString();
}
if (sMsisdn.StartsWith("88018"))
{
Response.Redirect("Restricted.aspx");
}
#endregion "MSISDN"
string scriptForBl = @" $(document).ready(function() {
$('.vdtitle').css('background-color','#58C1E6');
});";
cssTemplate.Attributes.Add("href", "~/Css/StyleSheetBL.css");
ScriptManager.RegisterStartupScript(this, this.GetType(), "myScriptName", scriptForBl, true);
if (!IsPostBack)
{
userInfo();
dsPage = CA.GetDataSet("Exec [sp_PerPageAccessLog] '" + "fitness.mobi" + "','" + "FitnessSecrets" + "','" + sMsisdn + "','" + UAPROF_URL + "','" + HS_MANUFAC + "','" + HS_MOD + "','" + HS_DIM + "','" + HS_OS + "','" + oUAProfile.GetUserIP() + "'", "WAPDB");
loadFitnessSecrets();
}
}
public void Slider()
{
DataSet datasetslider = null;
string slider = String.Empty;
datasetslider = CA.GetDataSet("Sp_slider_videobox", "WAPDB");
if (slider != null)
{
int i = 0;
foreach (DataRow dr in datasetslider.Tables[0].Rows)
{
if (i == 0)
{
slider = "<div class='item active'>" +
"<a href='" + dr["path"] + "'><img src='" + dr["imageUrl"] + "' /></a>" +
"</div>";
i++;
}
else
{
slider += "<div class='item'>" +
"<a href='" + dr["path"] + "'><img src='" + dr["imageUrl"] + "' /></a>" +
"</div>";
i++;
}
}
ltslider.Text = slider.ToString();
}
}
private void loadSheraList()
{
string title = "newyear_video";
ds = CA.GetDataSet("Exec [sp_MustWatch_bdtube1] '" + title + "'", "WAPDB");
if (ds != null)
{
total = ds.Tables[0].Rows.Count;
Session["total"] = total;
btnmoviereview.Visible = total > 4;
datasetShera = CA.GetDataSet("Exec[sp_MustWatch_bdtube1] '" + title + "','" + 4 + "'", "WAPDB");
dataListShera.DataSource = datasetShera;
dataListShera.DataBind();
}
}
public void BanglaMovies()
{
ds = CA.GetDataSet("Exec Sp_FullvideoContents_videoboxmovie 'E564F048-1AD7-450A-BA81-47409FC58BFE'", "WAPDB");
datalistbanglamovie.DataSource = ds;
datalistbanglamovie.DataBind();
btnbanglamovie.Visible = true;
}
private void loadFavList()
{
ds = CA.GetDataSet("Exec [FitnessPortal].dbo.[Sp_Fav_Fitness] '" + sMsisdn + "'", "WAPDB");
if (ds != null)
{
total = ds.Tables[0].Rows.Count;
Session["total"] = total;
btnmoviereview.Visible = total > 10;
datasetFav = CA.GetDataSet("Exec [FitnessPortal].dbo.[Sp_Fav_Fitness] '" + sMsisdn + "','" + 10 + "'", "WAPDB");
if (sMsisdn == "")
{
dataListFav.DataSource = null;
btnmoviereview.Visible = false;
dataListFav.DataBind();
}
else
{
dataListFav.DataSource = datasetFav;
dataListFav.DataBind();
}
}
}
//===================================ADDED==============================================
private void loadAudioInfo()
{
DataSet audioInfo = null;
if ((Request.QueryString["CategoryCode"].ToString() == "01A332B2-A207-44B9-9D3C-F85A1563571A") || (Request.QueryString["CategoryCode"].ToString() == "873E3EA9-3A28-484B-B74B-68C107DDD800"))
{
audioInfo = CA.GetDataSet("Exec sp_getAudionInfoBdtube '" + contentCode + "'", "WAPDB2");
}
else
{
audioInfo = CA.GetDataSet("Exec sp_getAudionInfoBdtube '" + contentCode + "'", "WAPDB");
}
if (audioInfo.Tables[0].Rows.Count > 0)
{
lblInfo.Text = audioInfo.Tables[0].Rows[0][0].ToString();
}
}
public bool isSubscribe(string MSISDN)
{
DataSet dsExt = null;
dsExt = CA.GetDataSet("EXEC [FitnessPortal].[dbo].[spChkSubStatus] '" + MSISDN + "'", "WAPDB");
var subStatus = String.Empty;
if (dsExt != null)
{
subStatus = dsExt.Tables[0].Rows[0].ItemArray[0].ToString();
}
if (subStatus == "Active")
{
return(true);
}
else
{
return(false);
}
}
public void display()
{
try
{
contentname = Request.QueryString["name"].ToString();
}
catch
{
}
//ds = CA.GetDataSet("Exec [FitnessPortal].dbo.Sp_Search_fitness_All N'" + contentname + "'", "WAPDB");
ds = CA.GetDataSet("Exec [FitnessPortal].dbo.Sp_Search_fitness N'" + contentname + "'", "WAPDB");
if (ds != null)
{
dataListnewvideo.DataSource = ds;
dataListnewvideo.DataBind();
}
else
{
lblresult.Text = "No info Found";
}
// btnbanglamovie.Visible = true;
}
protected void Page_Load(object sender, EventArgs e)
{
#region "MSISDN"
try
{
if (string.IsNullOrEmpty(oUAProfile.GetMSISDN()) || oUAProfile.GetMSISDN().StartsWith("Error"))
{
throw new Exception();
}
else
{
sMsisdn = oUAProfile.GetMSISDN();
}
}
catch //(Exception ex)
{
sMsisdn = string.Empty;
}
#endregion "MSISDN"
if (sMsisdn.StartsWith("88018") || sMsisdn.StartsWith("88016"))
{
DataSet ds = new DataSet();
ds = oCDA.GetDataSet("Exec [FitnessPortal].dbo.spChkTypeStatus '" + sMsisdn + "'", "WAPDB");
if (ds != null)
{
if (ds.Tables[0].Rows[0]["Type"].ToString() == "DA")
{
oCDA.ExecuteNonQuery("EXEC Robi_SDP.dbo.spInsertSubscriptionQ_To_SDP_channelID_1 '" + sMsisdn + "','0303900076','0300407908','Deletion'",
"ROBI");
}
else if (ds.Tables[0].Rows[0]["Type"].ToString() == "WA")
{
oCDA.ExecuteNonQuery("EXEC Robi_SDP.dbo.spInsertSubscriptionQ_To_SDP_channelID_1 '" + sMsisdn + "','0303900076','0300407910','Deletion'",
"ROBI");
}
else if (ds.Tables[0].Rows[0]["Type"].ToString() == "DNA")
{
oCDA.ExecuteNonQuery("EXEC Robi_SDP.dbo.spInsertSubscriptionQ_To_SDP_channelID_1 '" + sMsisdn + "','0303900077','0300407912','Deletion'",
"ROBI");
}
else if (ds.Tables[0].Rows[0]["Type"].ToString() == "WNA")
{
oCDA.ExecuteNonQuery("EXEC Robi_SDP.dbo.spInsertSubscriptionQ_To_SDP_channelID_1 '" + sMsisdn + "','0303900077','0300407914','Deletion'",
"ROBI");
}
else if (ds.Tables[0].Rows[0]["Type"].ToString() == "Not")
{
Response.Redirect("Default.aspx");
}
}
//oCDA.ExecuteNonQuery("EXEC [Robi_SDP].[dbo].[spDeactivate_CZ_SB] '" + sMsisdn + "','BdTube'", "ROBI");
////EXEC Robi_SDP.dbo.spDeactivate_CZ_SB '8801814652546','BdTube'
//oCDA.ExecuteNonQuery("EXEC [Partner_Basket].[dbo].[sp_setActiveDeactiveBdtube] '" + sMsisdn + "','0'", "BUDDY");
// oCDA.ExecuteNonQuery("EXEC [FitnessPortal].[dbo].[sp_setActiveDeactiveFitnessPortal] '" + sMsisdn + "','0'", "BUDDY");
}
else
{
oCDA.ExecuteNonQuery("EXEC [FitnessPortal].[dbo].[sp_setActiveDeactiveFitnessPortal] '" + sMsisdn + "','0'", "BUDDY");
if (sMsisdn.StartsWith("88016"))
{
/*try
* {
* ATASE.Service objATASAE = new ATASE.Service();
* objATASAE.ASESubscribe(sMsisdn, "vubdtube", "Deletion");
* }
* catch
* {
* }
*/
string offMSG = "Your Fitness service has been Stopped. To START send START Fitness to 6624 or visit http://wap.shabox.mobi/fitnessclub Help : 01674985965";
oCDA.ExecuteNonQuery("EXEC Partner_API.dbo.spSendSMS '" + sMsisdn + "','" + offMSG + "'", "WAPDB");
}
else
{
string offMSG = "Fitness service is off now. To restart START Fitness and send to 6624.";
//string offMSG = "Your BdTube service has been Stopped. To START send START BDTUBE to 6624 or visit http://bdtube.mobi/ Help : 01674985965";
oCDA.ExecuteNonQuery("EXEC Partner_API.dbo.spSendSMS '" + sMsisdn + "','" + offMSG + "'", "WAPDB");
}
}
}
public void MusicVideo()
{
DataSet dsFullvideo = null;
string fulvideocontents = "<div class='swiper-container'><div class='swiper-wrapper' style='width:47%;height:50%'>";
dsFullvideo = CA.GetDataSet("Exec [WapPortal].dbo.Sp_getContentsBySubcategoryID_BdtubeRobi_Newup '60579B0C-259E-435A-A227-BF2E546DDCFE', " + 6 + "", "WapPortal");
//dsFullvideo = CA.GetDataSet("Exec [FitnessPortal].dbo.Sp_getContentsBySubcategoryID_fitness '873E3EA9-3A28-484B-B74B-68C107DDD800', " + 8 + "", "WAPDB2");
if (dsFullvideo != null)
{
foreach (DataRow dr in dsFullvideo.Tables[0].Rows)
{
fulvideocontents +=
"<div class='swiper-slide' style='width:100%'><div class='videowrap' style='width:100%'><div class='videocontent' style='position:relative;'>" +
"<a href='" + dr["path"] + "'><img src='" + dr["imageUrl"] + "' /></a>" +
"<div class='Icone_image'>" +
"<a href='" + dr["path"] + "'><img src='images/play-button.png' style='width:24px;height:27px'/></a></div></div>" +
"<div class='videoTitle'>" +
"<div class='Title1'>" +
"<span class='fonte'>" + dr["ContentTile"] + "</span>" + "</br>" +
"<img class='like-count' style='width: 15%;margin-left: 75%;' src='images/vi.png'>" +
"<label style='font-weight: 100;'>" + dr["totalView"] + "</label>" +
//"<img class='' style=' width: 18px;height:18px;margin-left: 45%; ' src='images/lik.png'>" +
//"<label style='font-weight: 100;'>" + dr["totalLike"] + "</label>" +
"</div>" +
"</div></div></div>";
}
ltrlmusicVideos.Text = fulvideocontents.ToString() + "</div></div>";;
}
}
protected void Page_Load(object sender, EventArgs e)
{
userInfo();
try
{
number = ms.GetMSISDN();
}
catch { }
option = Request.QueryString["op"];
if (option == "setLike")
{
string flag = Request.QueryString["flag"];
string catid = Request.QueryString["categorycode"];
if (flag == "y")
{
DataSet ds = null;
string likecount = String.Empty;
if ((catid == "01A332B2-A207-44B9-9D3C-F85A1563571A") || (catid == "873E3EA9-3A28-484B-B74B-68C107DDD800"))
{
ds = db.GetDataSet("Exec [FitnessPortal].[dbo].sp_UpdateLikeCountByContentFitnessPortal '" + Request.QueryString["contentId"] + "','" + 2 + "'", "WAPDB2");
}
else
{
ds = db.GetDataSet("Exec [FitnessPortal].[dbo].sp_UpdateLikeCountByContentFitnessPortal '" + Request.QueryString["contentId"] + "','" + 2 + "'", "WAPDB");
}
// DataSet ds = db.GetDataSet("Exec [FitnessPortal].[dbo].sp_UpdateLikeCountByContentFitnessPortal '" + Request.QueryString["contentId"] + "','" + 2 + "'", "WAPDB");
if (ds != null && ds.Tables[0].Rows.Count > 0)
{
likecount = ds.Tables[0].Rows[0][0].ToString();
}
Response.Write(likecount);
}
}
else if (option == "setView")
{
string flag = Request.QueryString["flag"];
string msisdn = Request.QueryString["msisdn"];
string categorycode = Request.QueryString["categorycode"];
string contentcode = Request.QueryString["contentId"];
string sMaster = Request.QueryString["sMasterCat"];//from here
string contetntTitle = Request.QueryString["ContentTitle"];
string contentType = Request.QueryString["ContentType"];
string zid = Request.QueryString["ZedID"];
DataSet ds1 = db.GetDataSet("Exec [Sp_insert_View] '" + contentcode + "','Buddy'", "WapPortal");
//if (categorycode.Equals("413623EB-E3BF-4494-8BB8-0302473A91A1"))
//{
// type = "Zumba";
//}
//else if (categorycode.Equals("44EAE2BC-F85F-483E-9C8E-B76D84114C00"))
//{
// type = "Yoga";
//}
//else if (categorycode.Equals("E0AEF450-099B-495F-B056-8AED4B95F00A"))
//{
// type = "Easy Workout";
//}
//else if (categorycode.Equals("A2106AB1-A41B-41C4-96FC-42971B8F84C5"))
//{
// type = "Fitness Secrets";
//}
//else
//{
// type = "New";
//}
//if (categorycode.Equals("E564F048-1AD7-450A-BA81-47409FC58BFE") || categorycode.Equals("7E8B1C80-EB99-402C-BE1E-00E7F7C99A3F") && isSubscribe(msisdn))
//{
// string PortalCode_Port_VU = "EE9D65C0-A155-464C-A41F-D6FAF01D4B88";
// string ContentCode = contentcode;
// //string PortalCategoryCode = sMasterCat;
// if (isSubscribe(msisdn))
// {
// string response = CGW(number, "", PortalCode_Port_VU, contentcode, "");
// if (response.StartsWith("su"))
// {
// Response.Write("success");
// if (msisdn.StartsWith("88017"))
// {
// db.ExecuteNonQuery("Exec [FitnessPortal].[dbo].[sp_SetPortalSuccess] '" + sMsisdn + "','" + contentcode + "',N'" + contetntTitle + "','" + sMaster + "','" + contentType + "','" + zid + "','" + UAPROF_URL + "','" + HS_MANUFAC + "','" + HS_MOD + "','" + HS_DIM + "','" + HS_OS + "','" + OPERATOR + "','" + categorycode + "','','1','194','12.18','0'", "WAPDB");
// }
// else
// {
// db.ExecuteNonQuery("Exec [FitnessPortal].[dbo].[sp_SetPortalSuccess] '" + sMsisdn + "','" + contentcode + "',N'" + contetntTitle + "','" + sMaster + "','" + contentType + "','" + zid + "','" + UAPROF_URL + "','" + HS_MANUFAC + "','" + HS_MOD + "','" + HS_DIM + "','" + HS_OS + "','" + OPERATOR + "','" + categorycode + "','','1','194','24.35','0'", "WAPDB");
// }
// }
// else
// {
// Response.Write("notSubscribe");
// }
// }
// else
// {
// Response.Write("notSubscribe");
// }
//}
//else
//{
// string obj = String.Empty;
// string catid = Request.QueryString["categorycode"];
// if (flag == "y" && isSubscribe(msisdn))
// {
// string chargepervideo = "";
// DataSet ds = null;
// DataSet ds1 = null;
// if ((catid == "01A332B2-A207-44B9-9D3C-F85A1563571A") || (catid == "873E3EA9-3A28-484B-B74B-68C107DDD800"))
// {//pavel
// //ds =
// // db.GetDataSet(
// // "Exec [FitnessPortal].[dbo].sp_UpdateLikeCountByContentFitnessPortal '" + Request.QueryString["contentId"] + "','" + 1 +
// // "'", "WAPDB2");
// //ds1 = db.GetDataSet("Exec [FitnessPortal].[dbo].sp_ViewCountByMsisdn '" + msisdn + "'", "WAPDB2");
// }
// else
// {
// //pavel
// //ds =
// // db.GetDataSet(
// // "Exec [FitnessPortal].[dbo].sp_UpdateLikeCountByContentFitnessPortal '" + Request.QueryString["contentId"] + "','" + 1 +
// // "'", "WAPDB");
// //ds1 = db.GetDataSet("Exec [FitnessPortal].[dbo].sp_ViewCountByMsisdn '" + msisdn + "'", "WAPDB");
// }
// // obj = ds1.Tables[0].Rows[0][0].ToString();
// obj= "1";
// if (obj == "1" || obj == "5")
// {
// //pavel db.ExecuteNonQuery("Exec [FitnessPortal].[dbo].[sp_SetPortalSuccess] '" + msisdn + "','" + contentcode + "',N'" + contetntTitle + "','" + type + "','" + contentType + "','" + zid + "','" + UAPROF_URL + "','" + HS_MANUFAC + "','" + HS_MOD + "','" + HS_DIM + "','" + HS_OS + "','" + OPERATOR + "','" + categorycode + "','','','194','" + chargepervideo + "','1'", "WAPDB");
// }
// //#region 5 video seen msg
// //if (obj == "5")
// //{
// // string MSG = null;
// // if (number.StartsWith("88019"))
// // {
// // MSG =
// // "Dear subscriber you assumed your daily free limits. You will be charge Taka 2(+VAT,SD and SC) for next five views except full movie. Help:01992303765";
// // }
// // else if (number.StartsWith("88015"))
// // {
// // MSG =
// // "Dear subscriber you assumed your daily free limits. You will be charge Taka 2(+VAT,SD and SC) for next five views except full movie. Help:01534524714";
// // }
// // else if (number.StartsWith("88016"))
// // {
// // MSG =
// // "Dear subscriber you assumed your daily free limits. You will be charge Taka 2(+VAT,SD and SC) for next five views except full movie. Help:01674985965";
// // }
// // else if (number.StartsWith("88018"))
// // {
// // MSG =
// // "Dear subscriber you assumed your daily free limits. You will be charge Taka 2(+VAT,SD and SC) for next five views . Help:8801814426426";
// // }
// // db.ExecuteNonQuery("EXEC Partner_API.dbo.spSendSMS '" + number + "','" + MSG + "'", "WAPDB");
// //}
// //#endregion 5 video seen msg
// Response.Write("1");
// }
// else
// {
// Response.Write("1");
// }
//}
}
else if (option == "setFav")
{
string flag = Request.QueryString["flag"];
string msisdn = Request.QueryString["msisdn"];
if (flag == "y")
{
DataSet ds = db.GetDataSet("Exec [FitnessPortal].[dbo].sp_UpdateLikeCountByContentFitnessPortal '" + Request.QueryString["contentId"] + "','" + 3 + "','" + msisdn + "'", "WAPDB");
Response.Write("s");
}
}
else if (option == "agrohi")
{
string flag = Request.QueryString["flag"];
string number = Request.QueryString["msisdn"];
string HS_MANUFAC = Request.QueryString["manu"];
string HS_MOD = Request.QueryString["mod"];
string HS_DIM = Request.QueryString["dim"];
string HS_OS = Request.QueryString["os"];
if (flag == "y")
{
DataSet dsWord = db.GetDataSet("EXEC [FitnessPortal].[dbo].[sp_getHistory_AgrohiCheck] '" + number + "'", "WAPDB");
string check = dsWord.Tables[0].Rows[0]["Content_Title"].ToString();
if (check == "Renew")
{
ag = true;
}
else
{
ag = false;
}
if (!ag)
{
string ChargingReply = CGW(number);
if (ChargingReply == "success")
{
string MSG = String.Empty;
if (number.StartsWith("88019"))
{
MSG =
"You have successfully charged Tk.2.44 for next 5 videos. To cancel SMS STOP FC to 6624. Help: 01992303765";
}
else if (number.StartsWith("88015"))
{
MSG =
"You have successfully charged Tk.2.44 for next 5 videos. To cancel SMS STOP FC to 6624. Help: 01534524714";
}
else if (number.StartsWith("88016"))
{
MSG =
"You have successfully charged Tk.2.44 for next 5 videos. To cancel SMS STOP FC to 6624. Help: 01674985965";
}
else if (number.StartsWith("88018"))
{
MSG =
"You have successfully charged Tk.2(+VAT+SD+SC) for next 5 videos . Help: 8801814426426";
}
//ag = true;
db.ExecuteNonQuery("EXEC Partner_API.dbo.spSendSMS '" + number + "','" + MSG + "'", "WAPDB");
db.ExecuteNonQuery("Exec [FitnessPortal].[dbo].[sp_SetPortalSuccess] '" + number + "','Renew','Renew','Renew','Renew','Renew','Renew','" + HS_MANUFAC + "','" + HS_MOD + "','" + HS_DIM + "','" + HS_OS + "','','Renew','','1','194','2.44','1'", "WAPDB");
//string MSG = "Welcome to BDTube service. Visit http://bdtube.mobi to watch latest and exclusive videos. Cost:TK.2 daily. SMS STOP BDTUBE to 6624 to cancel.";
DataSet ds = db.GetDataSet("Exec FitnessPortal.dbo.[sp_ViewCountByMsisdn] '" + number + "','" + 1 + "'", "WAPDB");
Response.Write(ds);
}
else
{
Response.Write("error");
}
}
else
{
Response.Write("error");
}
}
}
}
protected void btnAdd_OnClick(object sender, ImageClickEventArgs e)
{
string number = ms.GetMSISDN();
string flag = "y";
if (flag == "y")
{
DataSet dsWord = db.GetDataSet("EXEC [FitnessPortal].[dbo].[sp_getHistory_AgrohiCheck] '" + number + "'",
"WAPDB");
string check = dsWord.Tables[0].Rows[0]["Content_Title"].ToString();
if (check == "Renew")
{
ag = true;
}
else
{
ag = false;
}
if (!ag)
{
string ChargingReply = CGW(number);
if (ChargingReply == "success")
{
string MSG = String.Empty;
if (number.StartsWith("88019"))
{
MSG =
"You have successfully charged Tk.2.44 for next 5 videos. To cancel SMS STOP FC to 6624. Help: 01992303765";
}
else if (number.StartsWith("88015"))
{
MSG =
"You have successfully charged Tk.2.44 for next 5 videos. To cancel SMS STOP FC to 6624. Help: 01534524714";
}
else if (number.StartsWith("88016"))
{
MSG =
"You have successfully charged Tk.2.44 for next 5 videos. To cancel SMS STOP FC to 6624. Help: 01674985965";
}
else if (number.StartsWith("88018"))
{
MSG =
"You have successfully charged Tk.2(+VAT+SD+SC) for next 5 videos . Help: 8801814426426";
}
//ag = true;
db.ExecuteNonQuery("EXEC Partner_API.dbo.spSendSMS '" + number + "','" + MSG + "'", "WAPDB");
db.ExecuteNonQuery(
"Exec [FitnessPortal].[dbo].[sp_SetPortalSuccess] '" + number +
"','Renew','Renew','Renew','Renew','Renew','Renew','" + HS_MANUFAC + "','" + HS_MOD + "','" +
HS_DIM + "','" + HS_OS + "','','Renew','','1','194','2.44','1'", "WAPDB");
//string MSG = "Welcome to BDTube service. Visit http://bdtube.mobi to watch latest and exclusive videos. Cost:TK.2 daily. SMS STOP BDTUBE to 6624 to cancel.";
DataSet ds =
db.GetDataSet("Exec FitnessPortal.dbo.[sp_ViewCountByMsisdn] '" + number + "','" + 1 + "'",
"WAPDB");
Response.Redirect("Default.aspx");
}
else
{
Response.Write("error");
}
}
else
{
Response.Redirect("Default.aspx");
}
}
}
private void subscribeuser(string types, string autos)
{
string msisdnN = ms.GetMSISDN();
DataSet DNDMno = CA.GetDataSet("EXEC [WapPortal_CMS].dbo.spCheckDNDMno '" + msisdnN + "','Fitnss','6624'",
"WAPDB");
string DNDMobileNo = string.Empty;
try
{
DNDMobileNo = DNDMno.Tables[0].Rows[0].ItemArray[0].ToString();
}
catch
{
}
try
{
string UAPROF_URL = oUAProfile.GetUserAgent();
SOURCE_URL = System.Web.HttpContext.Current.Request.Url.AbsoluteUri;
HSProfiling.Service Profile = new HSProfiling.Service();
var HSProfiling = Profile.HansetDetection(UAPROF_URL, oUAProfile.GetUAProfileXWap());
HS_MANUFAC = HSProfiling.Manufacturer;
HS_MOD = HSProfiling.Model;
HS_DIM = HSProfiling.Dimension;
HS_OS = HSProfiling.OS;
UAPROF_URL = HSProfiling.UAXML;
if (HS_OS == "Desktop")
{
Response.Redirect("http://wap.shabox.mobi/Error/Default.aspx?id=OS");
}
else if (HS_MANUFAC == "Generic" || HS_MOD == "Generic")
{
Response.Redirect("http://wap.shabox.mobi/Error/Default.aspx?id=Mobile");
}
}
catch
{
Response.Redirect("http://wap.shabox.mobi/Error/Default.aspx?id=OS");
}
if (DNDMobileNo == "Y")
{
Response.Redirect("~/ErrorMessage.aspx?type=dnd");
}
if (types == "d" && autos == "t")
{
string msisdn = ms.GetMSISDN();
//string Package = "FC";
//CA.ExecuteNonQuery("EXEC [Partner_API].[dbo].[spProcessRequestOnlineAdvertisement] '" + msisdn + "','" + Package + "'", "WAPDB");
RobiDoubleConfirm rs = new RobiDoubleConfirm();
Response.Redirect(rs.GetLink(msisdn, "http://amarfitness.com/", "0300407908"), true);
}
else if (types == "w" && autos == "t")
{
string msisdn = ms.GetMSISDN();
//string Package = "FCW";
//CA.ExecuteNonQuery("EXEC [Partner_API].[dbo].[spProcessRequestOnlineAdvertisement] '" + msisdn + "','" + Package + "'", "WAPDB");
RobiDoubleConfirm rs = new RobiDoubleConfirm();
Response.Redirect(rs.GetLink(msisdn, "http://amarfitness.com/", "0300407910"), true);
}
else if (types == "d" && autos == "f")
{
string msisdn = ms.GetMSISDN();
//string Package = "FCDN";
//CA.ExecuteNonQuery("EXEC [Partner_API].[dbo].[spProcessRequestOnlineAdvertisement] '" + msisdn + "','" + Package + "'", "WAPDB");
RobiDoubleConfirm rs = new RobiDoubleConfirm();
Response.Redirect(rs.GetLink(msisdn, "http://amarfitness.com/", "0300407912"), true);
}
else if (types == "w" && autos == "f")
{
string msisdn = ms.GetMSISDN();
//string Package = "FCWN";
//CA.ExecuteNonQuery("EXEC [Partner_API].[dbo].[spProcessRequestOnlineAdvertisement] '" + msisdn + "','" + Package + "'", "WAPDB");
RobiDoubleConfirm rs = new RobiDoubleConfirm();
Response.Redirect(rs.GetLink(msisdn, "http://amarfitness.com/", "0300407914"), true);
}
}
protected void Page_Load(object sender, EventArgs e)
{
// Year.Text = DateTime.Now.Year.ToString();
if (!IsPostBack)
{
#region UAProfile_AND_Banner
#region "MSISDN"
try
{
if (string.IsNullOrEmpty(oUAProfile.GetMSISDN()) || oUAProfile.GetMSISDN().StartsWith("Error"))
{
throw new Exception();
}
else
{
sMsisdn = oUAProfile.GetMSISDN();
}
}
catch //(Exception ex)
{
sMsisdn = string.Empty;
}
#endregion "MSISDN"
string UAPROF_URL = oUAProfile.GetUserAgent();
try
{
HSProfiling.Service Profile = new HSProfiling.Service();
//HSProfiling. Profile = new HS_Profiling.ServiceSoapClient();
var HSProfiling = Profile.HansetDetection(UAPROF_URL, oUAProfile.GetUAProfileXWap());
HS_MANUFAC = HSProfiling.Manufacturer;
HS_MOD = HSProfiling.Model;
HS_DIM = HSProfiling.Dimension;
HS_OS = HSProfiling.OS;
UAPROF_URL = HSProfiling.UAXML;
}
catch { }
lblHandset.Text = " " + HS_MANUFAC + " " + HS_MOD;
//hlHome.NavigateUrl = "~/Default.aspx";
//hlSupport.NavigateUrl = "~/Support.aspx";
string scriptForBl = @" $(document).ready(function() {
$('.robititle').css('background-color','#58C1E6');
});";
cssTemplate.Attributes.Add("href", "~/Css/StyleSheetBL.css");
ScriptManager.RegisterStartupScript(this, this.GetType(), "myScriptName", scriptForBl, true);
#region "TopHeader"
try
{
if (string.IsNullOrEmpty(HS_DIM))
{
throw new Exception();
}
else
{
FOLDER = "D" + HS_DIM;
}
}
catch //(Exception ex)
{
FOLDER = "D320x240";
}
#endregion "TopHeader"
object dim = oCDA.getSingleValue("EXEC spGetDimensionByCategoryCode'" + "3F0996CC-94DB-4C87-8EEE-790D79C42593" + "','" + FOLDER + "'", "WAPDB");
if (dim != null)
{
if (dim.ToString() == "Y")
{
sPath = "http://wap.shabox.mobi/CMS/UIHeader/" + FOLDER + "/";
}
else if (dim.ToString() == "N")
{
string bestfitCat = oUAProfile.ClosestMinimumFinder(HS_DIM, "Wallpaper");
sPath = "http://wap.shabox.mobi/CMS/UIHeader/" + bestfitCat + "/";
}
}
else
{
sPath = "~http://wap.shabox.mobi/CMS/UIHeader/D320x240/";
}
if (sMsisdn.StartsWith("88015"))
{
lnkHeader.ImageUrl = sPath + "BD_Tub_Header_TT.jpg";
cssTemplate.Attributes.Add("href", "~/StyleSheet/StyleSheetTT.css");
}
else if (sMsisdn.StartsWith("88018"))
{
lnkHeader.ImageUrl = sPath + "Robi_bdtube_header.jpg";
cssTemplate.Attributes.Add("href", "~/StyleSheet/StyleSheetRobi.css");
}
else if (sMsisdn.StartsWith("88016"))
{
lnkHeader.ImageUrl = sPath + "Robi_bdtube_header.jpg";
cssTemplate.Attributes.Add("href", "~/StyleSheet/StyleSheetRobi.css");
}
else if (sMsisdn.StartsWith("88017"))
{
lnkHeader.ImageUrl = sPath + "BD_Tub_Header_GP.jpg";
//scrollBanner.ImageUrl = sPath + "BD_Tub_Header_Header.jpg";
cssTemplate.Attributes.Add("href", "~/StyleSheet/StyleSheetGP.css");
}
else if (sMsisdn.StartsWith("88019"))
{
lnkHeader.ImageUrl = sPath + "BDtube.jpg";
}
else
{
lnkHeader.ImageUrl = sPath + "BDtube.jpg";
}
//lnkHeader.ImageUrl = sPath + "BDtube.jpg";
//lnkHeader.NavigateUrl = "~/Default.aspx";
//lnkFooter.ImageUrl = sPath + "Shabox_Buddy_Footer.jpg";
//lnkFooter.NavigateUrl = "~/Default.aspx";
#endregion UAProfile_AND_Banner
DataSet dsWord = oCDA.GetDataSet("SELECT TOP (20) MSISDN, CONTENT_TITLE, CONTENT_TYPE_SHORT, CAST (TIME_STAMP AS datetime) AS Date, ChargingReply FROM tbl_Success_BDTUBE WHERE (MSISDN = '" + sMsisdn + "') ORDER BY TIME_STAMP DESC", "BDTUBE");
if (dsWord != null)
{
RptTopScore.DataSource = dsWord.Tables[0].Rows;
RptTopScore.DataBind();
}
//DataSet subStatusData = oCDA.GetDataSet("SELECT MSISDN, RegDate, ReActivationDate, DeactivationDate FROM tbl_Subscriber_BDTUBE WHERE (MSISDN = '" + sMsisdn + "') ORDER BY TimeStamp DESC", "BDTUBE");
DataSet subStatusData = oCDA.GetDataSet("EXEC[Partner_Basket].[dbo].[spSubStatus] '" + sMsisdn + "'", "BDTUBE");
if (subStatusData != null)
{
subStatus.DataSource = subStatusData.Tables[0].Rows;
subStatus.DataBind();
}
}
if ((sMsisdn.StartsWith("88019") || sMsisdn.StartsWith("88018")) && isSubscribe(sMsisdn))
{
//cancelSubscription.Visible = true;
}
}
public void Banglamusic()
{
ds = CA.GetDataSet("Exec Sp_FullvideoContents_videobox6 '5DCA7C64-F342-434A-A934-750F37D74AEC'", "WAPDB");
datalistBanglaMusic.DataSource = ds;
datalistBanglaMusic.DataBind();
btnbanglamusic.Visible = true;
}
protected void Page_Load(object sender, EventArgs e)
{
#region "MSISDN"
if (Session["MSISDN"] == null)
{
try
{
if (string.IsNullOrEmpty(oUAProfile.GetMSISDN()) || oUAProfile.GetMSISDN().StartsWith("Error"))
{
throw new Exception();
}
else
{
sMsisdn = oUAProfile.GetMSISDN();
}
}
catch //(Exception ex)
{
sMsisdn = string.Empty;
}
}
else
{
sMsisdn = Session["MSISDN"].ToString();
}
if (isSubscribe(sMsisdn))
{
cancelSubscriptionBlink.Visible = true;
}
if (sMsisdn.StartsWith("88018"))
{
// Response.Redirect("Restricted.aspx");
}
#endregion "MSISDN"
string scriptForBl = @" $(document).ready(function() {
$('.ribonMusic').css('background-color','#58c1e6');
});";
string scriptForTT = @" $(document).ready(function() {
$('.ribonMusic').css('background-color','#58c1e6');
});";
cssTemplate.Attributes.Add("href", "~/Css/StyleSheetBL.css");
ScriptManager.RegisterStartupScript(this, this.GetType(), "myScriptName", scriptForBl, true);
if (!IsPostBack)
{
#region UAProfile_AND_Banner
#region "MSISDN"
try
{
if (string.IsNullOrEmpty(oUAProfile.GetMSISDN()) || oUAProfile.GetMSISDN().StartsWith("Error"))
{
throw new Exception();
}
else
{
sMsisdn = oUAProfile.GetMSISDN();
}
}
catch //(Exception ex)
{
sMsisdn = string.Empty;
}
#endregion "MSISDN"
if (sMsisdn.StartsWith("88018"))
{
// Response.Redirect("Restricted.aspx");
}
string UAPROF_URL = oUAProfile.GetUserAgent();
try
{
HSProfiling.Service Profile = new HSProfiling.Service();
var HSProfiling = Profile.HansetDetection(UAPROF_URL, oUAProfile.GetUAProfileXWap());
HS_MANUFAC = HSProfiling.Manufacturer;
HS_MOD = HSProfiling.Model;
HS_DIM = HSProfiling.Dimension;
HS_OS = HSProfiling.OS;
UAPROF_URL = HSProfiling.UAXML;
}
catch { }
//lblHandset.Text = " " + HS_MANUFAC + " " + HS_MOD;
#endregion UAProfile_AND_Banner
lblM.Text = sMsisdn;
lblM1.Text = sMsisdn;
DataSet dsWord = oCDA.GetDataSet("EXEC [FitnessPortal].[dbo].[sp_getHistory] '" + sMsisdn + "'", "BDTUBE");
DataSet subStatusData = oCDA.GetDataSet("EXEC [FitnessPortal].[dbo].[spSubStatus1] '" + sMsisdn + "'", "BDTUBE");
if (subStatusData != null)
{
grdMyAccount.DataSource = subStatusData;
grdMyAccount.DataBind();
}
if (dsWord != null)
{
if (sMsisdn == "")
{
GridView1.DataSource = null;
GridView1.DataBind();
}
else
{
GridView1.DataSource = dsWord;
GridView1.DataBind();
}
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
userInfo();
try
{
number = ms.GetMSISDN();
}
catch
{
number = "wifi";
}
if (number.Contains("Error"))
{
number = "wifi";
}
option = Request.QueryString["op"].ToString();
if (option == "buddy")
{
DataSet dsUserinfo = db.GetDataSet("Exec sp_otherLinkInfo '" + number + "','" + OPERATOR + "','" + HS_MANUFAC + "','" + HS_MOD + "','" + HS_DIM + "','" + HS_OS + "','" + option + "'", "WAPDB");
DataSet hit = db.GetDataSet("Exec sp_otherLinkTotalHitCount '" + option + "'", "WAPDB");
}
if (option == "clubz")
{
DataSet dsUserinfo = db.GetDataSet("Exec sp_otherLinkInfo '" + number + "','" + OPERATOR + "','" + HS_MANUFAC + "','" + HS_MOD + "','" + HS_DIM + "','" + HS_OS + "','" + option + "'", "WAPDB");
DataSet hit = db.GetDataSet("Exec sp_otherLinkTotalHitCount '" + option + "'", "WAPDB");
}
if (option == "quiz")
{
DataSet dsUserinfo = db.GetDataSet("Exec sp_otherLinkInfo '" + number + "','" + OPERATOR + "','" + HS_MANUFAC + "','" + HS_MOD + "','" + HS_DIM + "','" + HS_OS + "','" + option + "'", "WAPDB");
DataSet hit = db.GetDataSet("Exec sp_otherLinkTotalHitCount '" + option + "'", "WAPDB");
}
if (option == "sticker")
{
DataSet dsUserinfo = db.GetDataSet("Exec sp_otherLinkInfo '" + number + "','" + OPERATOR + "','" + HS_MANUFAC + "','" + HS_MOD + "','" + HS_DIM + "','" + HS_OS + "','" + option + "'", "WAPDB");
DataSet hit = db.GetDataSet("Exec sp_otherLinkTotalHitCount '" + option + "'", "WAPDB");
}
if (option == "gameClub")
{
DataSet dsUserinfo = db.GetDataSet("Exec sp_otherLinkInfo '" + number + "','" + OPERATOR + "','" + HS_MANUFAC + "','" + HS_MOD + "','" + HS_DIM + "','" + HS_OS + "','" + option + "'", "WAPDB");
DataSet hit = db.GetDataSet("Exec sp_otherLinkTotalHitCount '" + option + "'", "WAPDB");
}
if (option == "liveGame")
{
DataSet dsUserinfo = db.GetDataSet("Exec sp_otherLinkInfo '" + number + "','" + OPERATOR + "','" + HS_MANUFAC + "','" + HS_MOD + "','" + HS_DIM + "','" + HS_OS + "','" + option + "'", "WAPDB");
DataSet hit = db.GetDataSet("Exec sp_otherLinkTotalHitCount '" + option + "'", "WAPDB");
}
}
public string ClosestMinimumFinder(string Dimension, string ContentType)
{
CDA cmd = new CDA();
DataSet ds = cmd.GetDataSet("Select Specification from tbl_ContentFormat Where title='" + ContentType + "'", "WAPDB");
int Input_W = 0;
int Input_H = 0;
string strDimentionFromDB = string.Empty;
int Database_W = 0;
int Database_H = 0;
string[] arrSplitedString = Dimension.Split('x');
Input_W = Convert.ToInt32(arrSplitedString[0]);
Input_H = Convert.ToInt32(arrSplitedString[1]);
int TempDifference = -1;
int MinimumDifference = -1;
int MinimumClosestWidth = 0;
string MinimumDimention = "Default";
foreach (DataRow dr in ds.Tables[0].Rows)
{
strDimentionFromDB = dr.ItemArray[0].ToString();
arrSplitedString = strDimentionFromDB.Split('x');
Database_W = Convert.ToInt32(arrSplitedString[0].Split('D')[1]);
TempDifference = Input_W - Database_W;
if (TempDifference == 0)
{
MinimumDifference = TempDifference;
MinimumClosestWidth = Database_W;
break;
}
else if (TempDifference > 0)
{
if (MinimumDifference != -1)
{
if (TempDifference < MinimumDifference)
{
MinimumDifference = TempDifference;
MinimumClosestWidth = Database_W;
}
}
else
{
MinimumDifference = TempDifference;
MinimumClosestWidth = Database_W;
}
}
}
if (MinimumDifference >= 0)
{
DataSet objDataSet = cmd.GetDataSet("SELECT Specification FROM tbl_ContentFormat WHERE title='" + ContentType + "' AND Specification LIKE 'D" + MinimumClosestWidth + "x%'", "WAPDB");
TempDifference = -1;
MinimumDifference = -1;
if (objDataSet.Tables[0].Rows.Count > 0)
{
foreach (DataRow dataRaw in objDataSet.Tables[0].Rows)
{
strDimentionFromDB = dataRaw.ItemArray[0].ToString();
arrSplitedString = strDimentionFromDB.Split('x');
Database_H = Convert.ToInt32(arrSplitedString[1]);
TempDifference = Input_H - Database_H;
if (TempDifference == 0)
{
MinimumDifference = TempDifference;
MinimumDimention = strDimentionFromDB;
break;
}
else if (TempDifference > 0)
{
if (MinimumDifference != -1)
{
if (TempDifference < MinimumDifference)
{
MinimumDifference = TempDifference;
MinimumDimention = strDimentionFromDB;
}
}
else
{
MinimumDifference = TempDifference;
MinimumDimention = strDimentionFromDB;
}
}
}
}
}
return(MinimumDimention);
}
protected void Page_Load(object sender, EventArgs e)
{
#region "MSISDN"
if (Session["MSISDN"] == null)
{
try
{
if (string.IsNullOrEmpty(oUAProfile.GetMSISDN()) || oUAProfile.GetMSISDN().StartsWith("Error"))
{
throw new Exception();
}
else
{
sMsisdn = oUAProfile.GetMSISDN();
}
}
catch //(Exception ex)
{
sMsisdn = string.Empty;
}
}
else
{
sMsisdn = Session["MSISDN"].ToString();
}
if (sMsisdn.StartsWith("88018"))
{
// Response.Redirect("Restricted.aspx");
}
#endregion "MSISDN"
if (!isSubscribe(sMsisdn))
{
if (sMsisdn.StartsWith("88018"))
{
Response.Redirect("Confirmation.aspx");
}
else
{
Response.Redirect("Default.aspx");
}
}
string scriptForBl = @" $(document).ready(function() {
$('.vdtitle').css('background-color','#58C1E6');
});";
cssTemplate.Attributes.Add("href", "~/Css/StyleSheetBL.css");
ScriptManager.RegisterStartupScript(this, this.GetType(), "myScriptName", scriptForBl, true);
if (!IsPostBack)
{
string type = String.Empty;
try
{
type = Request.QueryString["type"];
userInfo();
UAPROF_URL = Request.UserAgent;
if (type == null)
{
Response.Redirect("Default.aspx");
}
}
catch
{
Response.Redirect("Default.aspx");
}
if (type == "zumba")
{
dsPage = CA.GetDataSet("Exec [sp_PerPageAccessLog] '" + "fitness.mobi" + "','" + "Zumba" + "','" + sMsisdn + "','" + UAPROF_URL + "','" + HS_MANUFAC + "','" + HS_MOD + "','" + HS_DIM + "','" + HS_OS + "','" + oUAProfile.GetUserIP() + "'", "WAPDB");
loadZumbaDetails();
}
else if (type == "yoga")
{
dsPage = CA.GetDataSet("Exec [sp_PerPageAccessLog] '" + "fitness.mobi" + "','" + "Yoga" + "','" + sMsisdn + "','" + UAPROF_URL + "','" + HS_MANUFAC + "','" + HS_MOD + "','" + HS_DIM + "','" + HS_OS + "','" + oUAProfile.GetUserIP() + "'", "WAPDB");
loadYogaDetails();
}
else if (type == "easy")
{
dsPage = CA.GetDataSet("Exec [sp_PerPageAccessLog] '" + "fitness.mobi" + "','" + "EasyWorkOut" + "','" + sMsisdn + "','" + UAPROF_URL + "','" + HS_MANUFAC + "','" + HS_MOD + "','" + HS_DIM + "','" + HS_OS + "','" + oUAProfile.GetUserIP() + "'", "WAPDB");
loadEasyDetails();
}
else if (type == "fitnessSecrets")
{
dsPage = CA.GetDataSet("Exec [sp_PerPageAccessLog] '" + "fitness.mobi" + "','" + "FitnessSecrets" + "','" + sMsisdn + "','" + UAPROF_URL + "','" + HS_MANUFAC + "','" + HS_MOD + "','" + HS_DIM + "','" + HS_OS + "','" + oUAProfile.GetUserIP() + "'", "WAPDB");
loadFitnessSecrets();
}
}
}
public void Loadcontent()
{
string CategoryName = String.Empty;
string contentid = String.Empty;
string texttype = String.Empty;
try
{
contentid = Request.QueryString["contentid"];
}
catch
{
contentid = "";
}
if (contentid == null)
{
contentid = "";
}
DataSet ds = CA.GetDataSet("Exec [Sp_getTextContent] '" + type + "','" + contentid + "'", "WapPortal");
if (ds != null)
{
string imgLoad = String.Empty;
main.Visible = true;
string img = ds.Tables[0].Rows[0]["ContentImage"].ToString();
if (img == "")
{
imgLoad = "none";
}
else
{
imageurl =
"http://182.160.119.238/CMS/Assets/images/200/" + img;
imgLoad = "block";
}
try
{
ContentID = Request.QueryString["cid"].ToString();
}
catch
{
ContentID = ds.Tables[0].Rows[0]["cid"].ToString();
}
textFull.Text = ds.Tables[0].Rows[0]["Content"].ToString();
txtType.Text = ds.Tables[0].Rows[0]["Title"].ToString();
lblLastTime.Text = ds.Tables[0].Rows[0]["ContentDate"].ToString();
texttype = ds.Tables[0].Rows[0]["Title"].ToString();
ltvideo.Text = "<div class='videocontent' style='position:relative;width:100%'>" +
"<img src='" + imageurl + "'style='display:" + imgLoad + "' />" +
"<div class='Icone_image'>" +
"<img src='images/Watch_R.png' style='width:0%' align='left'/></div></div>";
}
else
{
DataSet ds1 = CA.GetDataSet("Exec [Sp_getTextContentNextpage] '" + contentid + "'", "WapPortal");
try
{
CategoryName = Request.QueryString["CategoryName"].ToString();
}
catch
{
CategoryName = ds1.Tables[0].Rows[0]["CategoryName"].ToString();
}
lblcat.Text = CategoryName;
string imgLoad = String.Empty;
main.Visible = true;
if (ds1 != null)
{
string img = ds1.Tables[0].Rows[0]["ContentImage"].ToString();
if (img == "")
{
imgLoad = "none";
}
else
{
imageurl =
"http://182.160.119.238/CMS/Assets/images/200/" + img;
imgLoad = "block";
}
ContentID = ds1.Tables[0].Rows[0]["ContentId"].ToString();
textFull.Text = ds1.Tables[0].Rows[0]["Content"].ToString();
lblLastTime.Text = ds1.Tables[0].Rows[0]["ContentDate"].ToString();
txtType.Text = ds1.Tables[0].Rows[0]["Title"].ToString();
texttype = ds1.Tables[0].Rows[0]["Title"].ToString();
ltvideo.Text = "<div class='videocontent' style='position:relative;width:100%'>" +
"<img src='" + imageurl + "'style='display:" + imgLoad + "' />" +
"<div class='Icone_image'>" +
"<img src='images/Watch_R.png' style='width:0%' align='left'/></div></div>";
}
}
//CA.ExecuteNonQuery("Exec [FitnessPortal].[dbo].[sp_SetPortalSuccess] '" + sMsisdn + "','" + "Text" + "',N'" + texttype + "','" + "" + "','" + "Text" + "','" + "" + "','" + UAPROF_URL + "','" + HS_MANUFAC + "','" + HS_MOD + "','" + HS_DIM + "','" + HS_OS + "','" + OPERATOR + "','" + "" + "','','','194','" + "" + "','1'", "WAPDB");
}