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);
}
}
