public async Task <ProjectResult> AddPackageInfo(tblPackage model)
{
try
{
if (ModelState.IsValid)
{
tblPackage _objPkg = new tblPackage();
_objPkg.PackageName = model.PackageName;
_objPkg.Rate = model.Rate;
_db.tblPackages.Add(_objPkg);
_db.SaveChanges();
return(new ProjectResult {
Message = "Sucsess", Status = 1, Response = "Success"
});
}
else
{
return(new ProjectResult {
Message = "Something is Wrong", Status = 0, Response = null
});
}
}
catch (Exception exp)
{
return(new ProjectResult {
Message = exp.ToString(), Status = 0, Response = null
});
}
}
public async Task <ProjectResult> PackageData(tblPackage model)
{
try
{
var result = _db.tblPackages.Where(a => a.IMEINo == model.IMEINo && a.OperatorCode == model.OperatorCode).ToList();
if (result != null)
{
return(new ProjectResult {
Message = "Success", Status = 1, Response = result
});
}
else
{
return(new ProjectResult {
Message = "Not Success", Status = 0, Response = null
});
}
}
catch (Exception exp)
{
return(new ProjectResult {
Message = exp.ToString(), Status = 0, Response = null
});
}
}
public ActionResult Delete(int id)
{
tblPackage packagedetalis = Obj.tblPackages.Find(id);
Obj.tblPackages.Remove(packagedetalis);
Obj.SaveChanges();
return(RedirectToAction("Destination"));
}
public ActionResult Index(tblPackage pac, HttpPostedFileBase file)
{
if (file != null)
{
string ImageName = System.IO.Path.GetFileName(file.FileName);
string physicalPath = Server.MapPath("~/Content/Images/" + ImageName);
file.SaveAs(physicalPath);
pac.Package_Image = ImageName;
}
tour.tblPackages.Add(pac);
tour.SaveChanges();
return(RedirectToAction("packagelist"));
}
public ActionResult Update(tblPackage pac, HttpPostedFileBase file)
{
if (file != null)
{
string ImageName = System.IO.Path.GetFileName(file.FileName);
string physicalPath = Server.MapPath("~/Content/Images/" + ImageName);
file.SaveAs(physicalPath);
pac.PackageImage = ImageName;
}
Obj.Entry(pac).State = System.Data.Entity.EntityState.Modified;
Obj.SaveChanges();
return(RedirectToAction("Destination"));
}
public ActionResult Update(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
tblPackage packagedetalis = Obj.tblPackages.Find(id);
if (packagedetalis == null)
{
return(HttpNotFound());
}
return(View(packagedetalis));
}
public ActionResult AddDestination(tblPackage pacg, HttpPostedFileBase file)
{
TourPlannerEntities1 TP = new TourPlannerEntities1();
if (file != null)
{
string ImageName = System.IO.Path.GetFileName(file.FileName);
string physicalPath = Server.MapPath("~/Content/Images/" + ImageName);
file.SaveAs(physicalPath);
pacg.PackageImage = ImageName;
}
TP.tblPackages.Add(pacg);
TP.SaveChanges();
return(RedirectToAction("Destination"));
}
public void AddDefaultPackage(int courseID)
{
//var defaultPckgID =
// Entites.tblPackages.Where(p => p.PACKAGE_NAME == "Full Package").SingleOrDefault().PACKAGE_ID;
var fullPackageName = "Full Package";
var dnewPackage = new tblPackage();
dnewPackage.PACKAGE_NAME = fullPackageName;
Entites.tblPackages.Add(dnewPackage);
Entites.SaveChanges();
Entites.tblCoursePackages.Add(new tblCoursePackage()
{
PACKAGE_ID = dnewPackage.PACKAGE_ID,
COURSE_ID = courseID
});
Entites.SaveChanges();
}
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);
}
}
public async Task <ProjectResult> PackageInsert(tblPackage model)
{
tblPackage _objPackage = new tblPackage();
try
{
if (ModelState.IsValid)
{
_objPackage.Pid = model.Pid;
_objPackage.PackageName = model.PackageName;
_objPackage.Rate = model.Rate;
_objPackage.IMEINo = model.IMEINo;
_objPackage.OperatorCode = model.OperatorCode;
_db.tblPackages.Add(_objPackage);
_db.SaveChanges();
return(new ProjectResult {
Message = "Success", Status = 1, Response = "Success"
});
}
else
{
return(new ProjectResult {
Message = "Failed", Status = 0, Response = null
});
}
}
catch (Exception exp)
{
return(new ProjectResult {
Message = exp.ToString(), Status = 0, Response = null
});
}
}
protected void Page_Load(object sender, EventArgs e)
{
var DC = new DataClassesDataContext();
//if (Session["ServiceProviderID"] == null)
//{
// Response.Redirect("ServiceLogin.aspx");
//}
try
{
string[] merc_hash_vars_seq;
string merc_hash_string = string.Empty;
string merc_hash = string.Empty;
string order_id = string.Empty;
string hash_seq = "key|txnid|amount|productinfo|firstname|email|udf1|udf2|udf3|udf4|udf5|udf6|udf7|udf8|udf9|udf10";
if (Request.Form["status"] == "success")
{
merc_hash_vars_seq = hash_seq.Split('|');
Array.Reverse(merc_hash_vars_seq);
merc_hash_string = ConfigurationManager.AppSettings["SALT"] + "|" + Request.Form["status"];
foreach (string merc_hash_var in merc_hash_vars_seq)
{
merc_hash_string += "|";
merc_hash_string = merc_hash_string + (Request.Form[merc_hash_var] != null ? Request.Form[merc_hash_var] : "");
}
merc_hash = Generatehash512(merc_hash_string).ToLower();
if (merc_hash != Request.Form["hash"])
{
//Value didn't match that means some paramter value change between transaction
lblFail2.Text = "Hash value did not matched.";
lblSuccess.Visible = false;
lblSuccess2.Visible = false;
lblFail2.Visible = true;
lblFail.Visible = true;
}
else
{
//if hash value match for before transaction data and after transaction data
//that means success full transaction , see more in response
order_id = Request.Form["txnid"];
string prod_info = Request.Form["productinfo"];
lblSuccess2.Text = "value matched" + order_id + "<br/>" + "Product :" + prod_info;
lblSuccess.Visible = true;
lblSuccess2.Visible = true;
lblFail2.Visible = false;
lblFail.Visible = false;
if (Session["ClientID"] != null)
{
var ClientData = (from obj in DC.tblClients
where obj.ClientID == Convert.ToInt32(Session["ClientID"])
select obj).Single();
lblClientName.Text = ClientData.FirstName + " " + ClientData.LastName;
lblClientEmail.Text = ClientData.Email;
lblClientContectNo.Text = ClientData.ContactNo;
tblOrder OrderData = (from obj in DC.tblOrders
where obj.ClientID == Convert.ToInt32(Session["ClientID"]) && (obj.IsActive == false || obj.IsActive == null)
select obj).First();
lblBillAddress.Text = OrderData.BillingAddress;
lblShippingAddress.Text = OrderData.ShippingAddress;
var str = from obj in DC.tblOrders
where obj.MACAddress == GetMACAddress() && obj.ClientID == Convert.ToInt32(Session["ClientID"]) && (obj.IsActive == false || obj.IsActive == null) && obj.ItemID != null
select new
{
CN = (from ob in DC.tblitems
where ob.ItemID == obj.ItemID
select new
{
Data = ob.ItemName,
}).Take(1).SingleOrDefault().Data,
CNN = (from ob in DC.tblitems
where ob.ItemID == obj.ItemID
select new
{
Data = Convert.ToInt32(ob.ItemPrice).ToString(),
}).Take(1).SingleOrDefault().Data,
obj.Date,
obj.OrderID,
obj.Qty,
Total = (Convert.ToInt32((from ob in DC.tblitems
where ob.ItemID == obj.ItemID
select new
{
Data = Convert.ToInt32(ob.ItemPrice).ToString(),
}).Take(1).SingleOrDefault().Data) * obj.Qty),
};
Repeater1.DataSource = str;
Repeater1.DataBind();
var str1 = from obj in DC.tblOrders
where obj.MACAddress == GetMACAddress() && obj.ClientID == Convert.ToInt32(Session["ClientID"]) && (obj.IsActive == false || obj.IsActive == null) && obj.MealID != null
select new
{
CN = (from ob in DC.tblMealPlans
where ob.MealID == obj.MealID
select new
{
Data = ob.MealName,
}).Take(1).SingleOrDefault().Data,
CNN = (from ob in DC.tblMealPlans
where ob.MealID == obj.MealID
select new
{
Data = Convert.ToInt32(ob.MealPrice).ToString(),
}).Take(1).SingleOrDefault().Data,
obj.Date,
obj.OrderID,
obj.Qty,
Total = (Convert.ToInt32((from ob in DC.tblMealPlans
where ob.MealID == obj.MealID
select new
{
Data = Convert.ToInt32(ob.MealPrice).ToString(),
}).Take(1).SingleOrDefault().Data) * obj.Qty),
};
Repeater2.DataSource = str1;
Repeater2.DataBind();
foreach (RepeaterItem item in Repeater1.Items)
{
HiddenField hdnOrder = (HiddenField)item.FindControl("hdnOrder");
tblOrder Data = DC.tblOrders.Single(ob => ob.OrderID == Convert.ToInt32(hdnOrder.Value));
Data.IsActive = true;
DC.SubmitChanges();
}
foreach (RepeaterItem item in Repeater2.Items)
{
HiddenField hdnOrder = (HiddenField)item.FindControl("hdnOrder");
tblOrder Data = DC.tblOrders.Single(ob => ob.OrderID == Convert.ToInt32(hdnOrder.Value));
Data.IsActive = true;
DC.SubmitChanges();
}
//lnkPDF.Visible = true;
PanelClient.Visible = true;
}
if (Session["ServiceProviderID"] != null)
{
tblServiceProvider SP = (from obj in DC.tblServiceProviders
where obj.ServiceProviderID == Convert.ToInt32(Session["ServiceProviderID"])
select obj).Single();
lblSPName.Text = SP.FirstName + " " + SP.LastName;
lblSPEmail.Text = SP.Email;
lblSPContectNumber.Text = SP.ContactNo;
tblPackage Package = (from obj in DC.tblPackages
join obj2 in DC.tblSPPackages
on obj.PackagesID equals obj2.PackagesId
where obj2.ServiceProviderID == Convert.ToInt32(Session["ServiceProviderID"]) && obj2.IsActive == false
orderby obj.PackagesID descending
select obj).First();
lblPackageName.Text = Package.Name;
lblPackagePrice.Text = Package.Price.ToString();
//lnkSPPDF.Visible = true;
PanelSP.Visible = true;
}
}
}
else
{
lblFail2.Text = "Hash value did not matched.";
lblSuccess.Visible = false;
lblSuccess2.Visible = false;
lblFail2.Visible = true;
lblFail.Visible = true;
// osc_redirect(osc_href_link(FILENAME_CHECKOUT, 'payment' , 'SSL', null, null,true));
}
}
catch (Exception ex)
{
Response.Write("<span style='color:red'>" + ex.Message + "</span>");
}
}
protected void rptadmin_ItemCommand1(object source, RepeaterCommandEventArgs e)
{
try {
var DC = new DataClassesDataContext();
int ID = Convert.ToInt32(e.CommandArgument);
if (e.CommandName == "Active")
{
tblPackage result = (from u in DC.tblPackages
where u.PackagesID == ID
select u).Single();
if (result.IsActive == true)
{
result.IsActive = false;
}
else
{
result.IsActive = true;
}
DC.SubmitChanges();
BindData();
}
else if (e.CommandName == "View")
{
var str = from obj in DC.tblPackages
where obj.PackagesID == Convert.ToInt32(e.CommandArgument)
select new
{
CBy = (from ob in DC.tblAdmins
where ob.AdminID == obj.CreatedBy
select new
{
Data = ob.FirstName + " " + ob.LastName
}).Take(1).SingleOrDefault().Data,
img = (from obj1 in DC.tblImages
where obj1.ImagesID == obj.ImageID
select new
{
str1 = obj1.Name
}).Take(1).SingleOrDefault().str1,
obj.PackagesID,
obj.Name,
obj.Duration,
obj.Description,
cv = Convert.ToDouble(obj.Price),
obj.CreatedOn,
obj.IsActive
};
rptViewDetail.DataSource = str;
rptViewDetail.DataBind();
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "myModal", "$('#myModal').modal({backdrop:'static', keyboard: false});", true);
// upModal.Update();
BindData();
}
else if (e.CommandName == "Package")
{
LinkButton lnkRowSelection = (LinkButton)e.Item.FindControl("lnkRowSelection");
string[] arguments = lnkRowSelection.CommandArgument.Split(';');
string PackageID = arguments[0];
Response.Redirect(string.Format("Addpackages.aspx?id={0}", PackageID), false);
}
}
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 btninsert_Click(object sender, EventArgs e)
{
try
{
var dc = new DataClassesDataContext();
if (Request.QueryString["id"] != null)
{
if (FileUpload1.HasFile)
{
var path = Server.MapPath("~/Admin/Packimg");
FileUpload1.SaveAs(path + "/" + FileUpload1.FileName);
tblImage objimg = new tblImage();
objimg.Name = FileUpload1.FileName;
objimg.AlbumID = 1;
objimg.IsActive = true;
objimg.IsDefault = false;
objimg.CreatedOn = DateTime.Now;
dc.tblImages.InsertOnSubmit(objimg);
dc.SubmitChanges();
}
tblPackage p1 = dc.tblPackages.Single(ob => ob.PackagesID == Convert.ToInt32(Request.QueryString["id"]));
var str1 = (from p2 in dc.tblPackages
where p2.Name == txtfnm.Text
select p2).Count();
if (str1 <= 0)
{
p1.Name = txtfnm.Text;
if (FileUpload1.HasFile)
{
var img = (from im in dc.tblImages
orderby im.ImagesID descending
select im).FirstOrDefault();
p1.ImageID = Convert.ToInt32(img.ImagesID);
}
if (CheckBox4.Checked == true)
{
p1.IsActive = true;
}
else
{
p1.IsActive = false;
}
p1.Duration = Convert.ToInt32(txtduration.Text);
p1.Description = txtdesc.Text;
p1.Price = Convert.ToInt32(txtpri.Text);
p1.CreatedOn = DateTime.Now;
p1.CreatedBy = Convert.ToInt32(Session["AdminID"]);
dc.SubmitChanges();
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alertMessage", "alert('Record Updated Successfully')", true);
clear1();
bindata();
}
else
{
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alertMessage", "alert('Record already Exit')", true);
}
}
else
{
if (FileUpload1.HasFile)
{
var path = Server.MapPath("~/Admin/Packimg");
FileUpload1.SaveAs(path + "/" + FileUpload1.FileName);
tblImage objimg = new tblImage();
objimg.Name = FileUpload1.FileName;
objimg.AlbumID = 1;
objimg.IsActive = true;
objimg.IsDefault = false;
objimg.CreatedOn = DateTime.Now;
dc.tblImages.InsertOnSubmit(objimg);
dc.SubmitChanges();
}
var img = (from im in dc.tblImages
orderby im.ImagesID descending
select im).FirstOrDefault();
tblPackage p1 = new tblPackage();
var str1 = (from p2 in dc.tblPackages
where p2.Name == txtfnm.Text
select p2).Count();
if (str1 <= 0)
{
p1.Name = txtfnm.Text;
p1.ImageID = Convert.ToInt32(img.ImagesID);
p1.Duration = Convert.ToInt32(txtduration.Text);
p1.Description = txtdesc.Text;
p1.Price = Convert.ToInt32(txtpri.Text);
p1.IsActive = false;
p1.CreatedOn = DateTime.Now;
p1.CreatedBy = Convert.ToInt32(Session["AdminID"]);
dc.tblPackages.InsertOnSubmit(p1);
dc.SubmitChanges();
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alertMessage", "alert('Record Inserted Successfully')", true);
clear1();
bindata();
}
else
{
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alertMessage", "alert('Record already Exit')", true);
}
}
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);
}
}
