protected void rptpack_ItemCommand(object source, RepeaterCommandEventArgs e) { try { var DC = new DataClassesDataContext(); if (e.CommandName == "Buy") { tblPackage Pack = DC.tblPackages.Single(ob => ob.PackagesID == Convert.ToInt32(e.CommandArgument)); tblSPPackage SPPackData = new tblSPPackage(); SPPackData.ServiceProviderID = Convert.ToInt32(Session["ServiceProviderID"]); SPPackData.PackagesId = Convert.ToInt32(e.CommandArgument); SPPackData.IsActive = false; SPPackData.Start_Date = DateTime.Now; SPPackData.End_Date = DateTime.Now.AddDays(Convert.ToInt32(Pack.Duration)); DC.tblSPPackages.InsertOnSubmit(SPPackData); DC.SubmitChanges(); Double Price = (from obj in DC.tblPackages where obj.PackagesID == Convert.ToInt32(e.CommandArgument) select obj.Price).Single(); var SPData = DC.tblServiceProviders.Single(ob => ob.ServiceProviderID == Convert.ToInt32(Session["ServiceProviderID"])); Session["Amount"] = Convert.ToInt32(Price); Session["FirstName"] = SPData.FirstName + " " + SPData.LastName; Session["Email"] = SPData.Email; Session["PhoneNo"] = SPData.ContactNo; Session["ProductInfo"] = "Lunch Box Package Payment"; Session["SuccessURL"] = "http://localhost:58118/Success.aspx"; Session["FailureURL"] = "http://localhost:58118/Success.aspx"; Response.Redirect("PayU/Default.aspx"); } } catch (Exception ex) { int session = Convert.ToInt32(Session["ServiceProviderID"].ToString()); string PageName = System.IO.Path.GetFileName(Request.Url.AbsolutePath); string MACAddress = GetMacAddress(); AddErrorLog(ref ex, PageName, "User", session, 0, MACAddress); ClientScript.RegisterStartupScript(GetType(), "abc", "alert('Something went wrong! Try again');", true); } }
protected void rptSP_ItemCommand(object source, RepeaterCommandEventArgs e) { try { var DC = new DataClassesDataContext(); int ID = Convert.ToInt32(e.CommandArgument); if (e.CommandName == "Active") { tblSPPackage result = (from u in DC.tblSPPackages where u.SPPackagesID == ID select u).Single(); if (result.IsActive == true) { result.IsActive = false; } else { result.IsActive = true; } DC.SubmitChanges(); } else if (e.CommandName == "View") { var str = from obj in DC.tblSPPackages // //where obj.IsActive == true where obj.SPPackagesID == Convert.ToInt32(e.CommandArgument) select new { img = (from ob in DC.tblPackages where ob.PackagesID == obj.PackagesId select new { Data = (from o1 in DC.tblImages where o1.ImagesID == ob.ImageID select new { str = o1.Name }).Take(1).SingleOrDefault().str, }).Take(1).SingleOrDefault().Data, CBy = (from ob in DC.tblAdmins where ob.AdminID == obj.CreatedBy select new { Data = ob.FirstName + " " + ob.LastName }).Take(1).SingleOrDefault().Data, PN = (from ob in DC.tblPackages where ob.PackagesID == obj.PackagesId select new { Data = ob.Name }).Take(1).SingleOrDefault().Data, price = (from ob in DC.tblPackages where ob.PackagesID == obj.PackagesId select new { Data = ob.Price }).Take(1).SingleOrDefault().Data, Du = (from ob in DC.tblPackages where ob.PackagesID == obj.PackagesId select new { Data = ob.Duration }).Take(1).SingleOrDefault().Data, Des = (from ob in DC.tblPackages where ob.PackagesID == obj.PackagesId select new { Data = ob.Description }).Take(1).SingleOrDefault().Data, //obj.Image, obj.SPPackagesID, obj.Start_Date, obj.End_Date, obj.CreatedBy, obj.IsActive }; rptViewDetail.DataSource = str; rptViewDetail.DataBind(); ScriptManager.RegisterStartupScript(Page, Page.GetType(), "myModal", "$('#myModal').modal({backdrop:'static', keyboard: false});", true); // upModal.Update(); } bindata(); } catch (Exception ex) { int session = Convert.ToInt32(Session["AdminID"].ToString()); string PageName = System.IO.Path.GetFileName(Request.Url.AbsolutePath); string MACAddress = GetMacAddress(); AddErrorLog(ref ex, PageName, "Admin", 0, session, MACAddress); ClientScript.RegisterStartupScript(GetType(), "abc", "alert('Something went wrong! Try again');", true); } }
protected void rptSP_ItemCommand(object source, RepeaterCommandEventArgs e) { try { var DC = new DataClassesDataContext(); int ID = Convert.ToInt32(e.CommandArgument); if (e.CommandName == "Active") { tblSPPackage result = (from u in DC.tblSPPackages where u.SPPackagesID == ID select u).Single(); if (result.IsActive == true) { result.IsActive = false; } else { result.IsActive = true; } DC.SubmitChanges(); } else if (e.CommandName == "View") { int ED = 0; int SD = 0; var str = from obj in DC.tblSPPackages //where obj.IsActive == true where obj.SPPackagesID == Convert.ToInt32(e.CommandArgument) select new { img = (from ob in DC.tblPackages where ob.PackagesID == obj.PackagesId select new { Data = (from o1 in DC.tblImages where o1.ImagesID == ob.ImageID select new { str = o1.Name }).Take(1).SingleOrDefault().str, }).Take(1).SingleOrDefault().Data, CBy = (from ob in DC.tblAdmins where ob.AdminID == obj.CreatedBy select new { Data = ob.FirstName + " " + ob.LastName }).Take(1).SingleOrDefault().Data, PN = (from ob in DC.tblPackages where ob.PackagesID == obj.PackagesId select new { Data = ob.Name }).Take(1).SingleOrDefault().Data, price = (from ob in DC.tblPackages where ob.PackagesID == obj.PackagesId select new { Data = ob.Price }).Take(1).SingleOrDefault().Data, Du = (from ob in DC.tblPackages where ob.PackagesID == obj.PackagesId select new { Data = ob.Duration }).Take(1).SingleOrDefault().Data, Des = (from ob in DC.tblPackages where ob.PackagesID == obj.PackagesId select new { Data = ob.Description }).Take(1).SingleOrDefault().Data, //Da = (from ob in DC.tblSPPackages // where ob.SPPackagesID == obj.SPPackagesID // select new // { // //SD = Convert.ToDateTime(ob.Start_Date).Day, // //ED = Convert.ToDateTime(ob.End_Date).Day, // //da = (Convert.ToDateTime(ob.End_Date) - Convert.ToDateTime(ob.Start_Date)), // //SD = DateTime.MinValue, // //ED = DateTime.MaxValue, // // da = SD - ED ; // }).Take(1).SingleOrDefault().da, //obj.Image, obj.SPPackagesID, obj.Start_Date, obj.End_Date, obj.CreatedBy, obj.IsActive }; rptViewDetail.DataSource = str; rptViewDetail.DataBind(); foreach (RepeaterItem item in rptViewDetail.Items) { HiddenField Start_Date = (HiddenField)item.FindControl("h1"); HiddenField End_Date = (HiddenField)item.FindControl("h2"); Label da = (Label)item.FindControl("lblday"); TimeSpan day = Convert.ToDateTime(End_Date.Value) - Convert.ToDateTime(Start_Date.Value); da.Text = day.TotalDays.ToString() + "Days"; } ScriptManager.RegisterStartupScript(Page, Page.GetType(), "myModal", "$('#myModal').modal({backdrop:'static', keyboard: false});", true); // upModal.Update(); } bindata(); } catch (Exception ex) { int session = Convert.ToInt32(Session["AdminID"].ToString()); string PageName = System.IO.Path.GetFileName(Request.Url.AbsolutePath); string MACAddress = GetMacAddress(); AddErrorLog(ref ex, PageName, "Admin", 0, session, MACAddress); ClientScript.RegisterStartupScript(GetType(), "abc", "alert('Something went wrong! Try again');", true); } }