public void allFavorites()
{
DataTable dtresults = new DataTable();
dtresults.Columns.Add("ID");
dtresults.Columns.Add("ResourceName");
dtresults.Columns.Add("Description");
dtresults.Columns.Add("QuickLink");
dtresults.Columns.Add("ShowInNewWindow");
dtresults.Columns.Add("ShowLogin");
dtresults.Columns.Add("SharedPassword");
dtresults.Columns.Add("SharedUsername");
dtresults.Columns.Add("contentType");
dtresults.Columns.Add("collection");
commonfunctions cf = new commonfunctions();
DataTableReader dtr = commonfunctions.AllMyFavsDTP().CreateDataReader();
while (dtr.Read())
{
string ResourceContentType = dtr["ResourceContentType"].ToString().Trim();
string FavoriteURL = dtr["FavoriteURL"].ToString().Trim();
string collection = dtr["collection"].ToString().Trim();
string Data = dtr["Data"].ToString().Trim();
switch (ResourceContentType)
{
case "1": //this is a resource
dtresults.Rows.Add(getResourceitem(FavoriteURL, ResourceContentType));
break;
case "2": //this is a ektron content
dtresults.Rows.Add(getEktronContenItem(FavoriteURL, ResourceContentType));
// Response.Write(resourceID + "<br/>");
break;
case "3": //SSA Report - ContentDM
dtresults.Rows.Add(getContentDMItem(FavoriteURL, ResourceContentType, collection));
break;
case "4": //Summon Search
dtresults.Rows.Add(getSummonItem(FavoriteURL, ResourceContentType, Data));
break;
case "6": //Tools For
dtresults.Rows.Add(getToolsForContent(FavoriteURL, ResourceContentType));
break;
}
}
// Response.Write(dtresults.Rows.Count);
DL_Resourceslist.DataSource = commonfunctions.sortDataTable(dtresults, "ResourceName", "ASC");
DL_Resourceslist.DataBind();
}
/// <summary>
/// Page load event
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
if (!string.IsNullOrEmpty(Request.QueryString["id"]))
{
long contentId = long.Parse(Request.QueryString["id"]);
}
commonfunctions cf = new commonfunctions();
if (!string.IsNullOrEmpty(Request.QueryString["resourceid"]))
{
string resourceid = Request.QueryString["resourceid"].ToString();
DataTable dtResource = DataBase.dbDataTable("Select * from Resources where ID ='" + resourceid + "'");
DL_Resourceslist.DataSource = dtResource;
DL_Resourceslist.DataBind();
subjectArea = "";
string sql = "SELECT * FROM [ViewAllSubjectArea_SSADL] order by Name ASC";
DataTable dtSA = DataBase.dbDataTable(sql, "Ektron.DbConnection");
DataTableReader dtr = dtResource.CreateDataReader();
if (dtr.HasRows)
{
while (dtr.Read())
{
string ID = dtr["ID"].ToString().Trim();
Title = dtr["ResourceName"].ToString().Trim();
string Link = "/dynamicdb.aspx?resourceid=" + dtr["ID"].ToString().Trim();
string Description = dtr["Description"].ToString().Trim();
string SubjectAreasIDs = dtr["SubjectAreasTaxonomy"].ToString().Trim();
if (SubjectAreasIDs != "")
{
string[] SubjectAreaIDss = SubjectAreasIDs.Split(new string[] { "," }, StringSplitOptions.RemoveEmptyEntries);
foreach (string SubjectAreaID in SubjectAreaIDss)
{
DataRow[] result = dtSA.Select("TaxID='" + SubjectAreaID + "'");
foreach (DataRow row in result)
{
subjectArea += "<li><a href='" + row["URL"].ToString() + "'>" + row["Name"].ToString() + "</a></li>";
}
}
}
}
}
}
}
uxPageTitle.pgTitle = Title; // mainContent.EkItem.Title.ToString();
uxPageTitle.pageId = mainContent.EkItem.Id.ToString();
mainContent.Text = "<!-- -->";
uxPageTitle.ResourceTypeId = "2";
uxBreadcrumb.contentID = mainContent.EkItem.Id.ToString();
}
private void CountDeliveryAmount()
{
foreach (DataListItem item in DataList1.Items)
{
Label lblcartid = (Label)item.FindControl("lblCartid");
string ChefID = con.singlecell("select Chef_ID from CartMaster where Cart_ID='" + lblcartid.Text + "'");
string ChefZipCode = con.singlecell("Select PinCode from ChefPersonalDetail Where Chef_ID='" + ChefID + "'");
string Destination = lblpincode.Text;
//string consumeraddresss = objcheck.get_User_Address(Session["Consumer_ID"].ToString(),false,true,addressid);
//string chefaddress = objcheck.get_User_Address(ChefID,true,true,null);
if (con.check_data("Select * from DeliveryCount where Cart_ID='" + lblcartid.Text + "'"))
{
}
else
{
commonfunctions cf = new commonfunctions();
Dictionary<string, string> fromvalues = new Dictionary<string, string>();
//fromvalues = cf.CalculateResult(chefaddress, consumeraddresss);
fromvalues = cf.CalculateResult(ChefZipCode, Destination);
lblshippingcharge.Text = fromvalues["charges"];
string shippingcarge = fromvalues["charges"];
int shippingcharge = int.Parse(fromvalues["charges"]);
SqlParameter[] p1 = new SqlParameter[3];
p1[0] = new SqlParameter("@CartID", lblcartid.Text);
p1[1] = new SqlParameter("@Mode", 3);
p1[2] = new SqlParameter("@DeliveryAmt", shippingcharge);
con1.Ins_Upd_Del("SP_ConsumerCart_Edit", p1);
// con.insert_data("insert into DeliveryCount values('" + ChefID + "','" + fromvalues["distancecount"] + "','" + lblcartid.Text + "','" + shippingcharge.ToString() + "')");
con.insert_data("insert into DeliveryCount values('" + Session["Consumer_ID"] + "','" + fromvalues["distancecount"] + "','" + lblcartid.Text + "','" + shippingcharge.ToString() + "')");
}
}
string totdelAmt = con.singlecell("Select Sum(Amount) from DeliveryCount where Chef_ID='" + Session["Consumer_ID"] + "' and Amount!='-1'");
con.delete_data("delete from DeliveryCount where Chef_ID='" + Session["Consumer_ID"] + "'");
lblshippingcharge.Text = totdelAmt;
}
