public JsonResult DeleteBike(int id)
{
if (ContextManager.Current.UserKey == null)
return Json(new { Success = true, LoggedIn = false });
else
{
var context = new DAL.DataClassesDataContext();
var item = context.items.Where(i => i.id == id && i.user_key == ContextManager.Current.UserKey).SingleOrDefault();
context.items.DeleteOnSubmit(item);
context.SubmitChanges();
HttpContext.Application["totalNumberOfBikesRegistered"] = Convert.ToInt32(HttpContext.Application["totalNumberOfBikesRegistered"]) - 1;
return Json(new { Success = true, LoggedIn = true });
}
}
public JsonResult StoreBike(item item)
{
if (ContextManager.Current.UserKey == null)
return Json(new { Success = true, LoggedIn = false });
else
{
var context = new DAL.DataClassesDataContext();
//var item = new DAL.DataClassesDataContext().items.Where(i => i.serial_no == serialNo).SingleOrDefault();
item.user_key = ContextManager.Current.UserKey;
context.items.InsertOnSubmit(item);
context.SubmitChanges();
HttpContext.Application["totalNumberOfBikesRegistered"] = Convert.ToInt32(HttpContext.Application["totalNumberOfBikesRegistered"]) + 1;
return Json(new { Success = true, LoggedIn = true });
}
}
public List <ServiceForUpdateBO> getServiceReportBW(string from, string to)
{
string constr = @"Data Source=(LocalDB)\MSSQLLocalDB;AttachDbFilename=D:\BCS DATA\Samester 6\C Sharp\Assingment 1\DAL\styloDatabase.mdf;Integrated Security=True";
using (DataClassesDataContext data = new DataClassesDataContext(constr))
{
var check = from p in data.Items
join c in data.Services
on p.PID equals c.PID
select new
{
p.PID,
p.Price,
p.Category,
p.Size,
p.Color,
p.Brand,
p.Date,
c.Customer_Name,
c.Address,
c.Phone,
c.Charges,
c.Service_Date,
c.Return_Date
};
if (check.Any())
{
List <ServiceForUpdateBO> ls = new List <ServiceForUpdateBO>();
foreach (var i in check)
{
if (DateTime.Parse(i.Service_Date) >= DateTime.Parse(from) && DateTime.Parse(i.Service_Date) <= DateTime.Parse(to))
{
ServiceForUpdateBO itBO = new ServiceForUpdateBO();
itBO.Pid = i.PID;
itBO.Price = (int)i.Price;
itBO.Category = i.Category;
itBO.Size = (int)i.Size;
itBO.Color = i.Color;
itBO.Brand = i.Brand;
itBO.CustomerName = i.Customer_Name;
itBO.Address = i.Address;
itBO.Phone = i.Phone;
itBO.Charges = (int)i.Charges;
itBO.ServiceDate = i.Service_Date;
itBO.ReturnDate = i.Return_Date;
itBO.ReturnDate = i.Return_Date;
itBO.Date = i.Date;
//itBO.Quantity = (int)i.Quantity;
ls.Add(itBO);
}
}
return(ls);
}
else
{
return(null);
}
}
}
public JsonResult SearchBike(String serialNo)
{
var item = new DAL.DataClassesDataContext().items.Where(i => i.serial_no == serialNo).SingleOrDefault();
return Json(new { Found = item != null });
}
public ServiceForUpdateBO searchToUpdateIteam(ServiceForUpdateBO item)
{
string constr = @"Data Source=(LocalDB)\MSSQLLocalDB;AttachDbFilename=D:\BCS DATA\Samester 6\C Sharp\Assingment 1\DAL\styloDatabase.mdf;Integrated Security=True";
using (DataClassesDataContext data = new DataClassesDataContext(constr))
{
var check = from p in data.Items
join c in data.Services
on p.PID equals c.PID
select new {
c.PID,
p.Price,
p.Category,
p.Size,
p.Color,
p.Brand,
p.Date,
c.Customer_Name,
c.Address,
c.Phone,
c.Charges,
c.Service_Date,
c.Return_Date
};
int flag = 0;
if (check.Any())
{
ServiceForUpdateBO itBO = new ServiceForUpdateBO();
foreach (var i in check)
{
if (i.PID == item.Pid)
{
itBO.Pid = i.PID;
itBO.Price = (int)i.Price;
itBO.Category = i.Category;
itBO.Size = (int)i.Size;
itBO.Color = i.Color;
itBO.Brand = i.Brand;
itBO.Date = i.Date;
itBO.CustomerName = i.Customer_Name;
itBO.Address = i.Address;
itBO.Phone = i.Phone;
itBO.Charges = (int)i.Charges;
itBO.ServiceDate = i.Service_Date;
itBO.ReturnDate = i.Return_Date;
flag = 1;
break;
}
if (flag == 1)
{
break;
}
}
if (itBO.Quantity == 0 && flag == 1)
{
return(itBO);
}
else
{
return(null);
}
}
else
{
return(null);
}
}
}