public void PushFCMNotificationToStoreClerk(string title, string message, List <String> myData)
{
List <Employee> Allemp = db.Employees.Where(p => p.RoleId == 1).ToList();
foreach (Employee e in Allemp)
{
if (e.Token == null)
{
Notification n = new Notification();
n.EmployeeId = e.EmployeeId;
n.Title = title;
n.Body = message;
n.Intent = myData[0];
n.PageHeader = myData[1];
n.PageId = myData[2];
n.ExtraDetail = myData[3];
db.Notifications.Add(n);
db.SaveChanges();
}
else
{
PushFCMNotification(title, message, e.Token, myData);
}
}
}
public IHttpActionResult PutEmployeeClass(int id, EmployeeClass employeeClass)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != employeeClass.Id)
{
return(BadRequest());
}
db.Entry(employeeClass).State = EntityState.Modified;
try
{
db.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
if (!EmployeeClassExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(StatusCode(HttpStatusCode.NoContent));
}
//הרשמה
public static WebResult <UserDTO> Register(UserDTO user)//האובייקט מגיע עם שדות חובה שכבר נבדקו
{
User goodUser = UserCast.GetUser(user);
if (db.Users.FirstOrDefault(w => w.passwordUser == goodUser.passwordUser) != null ||
db.Users.FirstOrDefault(w => w.mailUser == user.mailUser) != null) // אם יש כבר כזו סיסמה או כזה מייל
{
return new WebResult <UserDTO>
{
Message = "אחד מהנתונים שהוקשו קיימים במערכת",
Status = false,
Value = null
}
}
;
db.Users.Add(goodUser);
db.SaveChanges();
HttpContext.Current.Session["User"] = user;
return(new WebResult <UserDTO>
{
Message = "הנתונים נשמרו בהצלחה",
Value = user,
Status = true
});
}
public IHttpActionResult PutLastMonth(int id, LastMonth lastMonth)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != lastMonth.Id)
{
return(BadRequest());
}
db.Entry(lastMonth).State = EntityState.Modified;
try
{
db.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
if (!LastMonthExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(StatusCode(HttpStatusCode.NoContent));
}
public IHttpActionResult PutP2_Record(int id, P1_Record p1_Record)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != p1_Record.r_id)
{
return(BadRequest());
}
db.Entry(p1_Record).State = EntityState.Modified;
try
{
db.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
if (!P1_RecordExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(StatusCode(HttpStatusCode.NoContent));
}
public ActionResult Create([Bind(Include = "DepartmentID,DepartmentName")] Department department)
{
if (ModelState.IsValid)
{
db.Departments.Add(department);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(RedirectToAction("Index"));
}
public ActionResult Create([Bind(Include = "CargoID,CType,HazPer,WRate,DRate")] Cargo cargo)
{
if (ModelState.IsValid)
{
db.Cargoes.Add(cargo);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(cargo));
}
public ActionResult Create([Bind(Include = "CustomerID,CName,ConNum,Adrs,PostAdrs,Email")] Customer customer)
{
if (ModelState.IsValid)
{
db.Customers.Add(customer);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(customer));
}
public ActionResult Create([Bind(Include = "StatusID,StatusName")] Status status)
{
if (ModelState.IsValid)
{
db.Status.Add(status);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(status));
}
public ActionResult Create([Bind(Include = "BusinessId,Name,Description,Preview")] AspNetProject aspNetProject)
{
if (ModelState.IsValid)
{
db.AspNetProjects.Add(aspNetProject);
db.SaveChanges();
return(RedirectToAction("MyProjects"));
}
return(View(aspNetProject));
}
public ActionResult Create([Bind(Include = "Id,RoleName,Code")] Role role)
{
if (ModelState.IsValid)
{
db.Role.Add(role);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(role));
}
public ActionResult Create([Bind(Include = "UrgencyName,UrgencyDescription")] Urgency urgency)
{
urgency.UrgencyID = CreateCode(db.Urgencies.Count());
if (ModelState.IsValid)
{
db.Urgencies.Add(urgency);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(urgency));
}
public ActionResult Create([Bind(Include = "proj_id,title,price,duration,descr,attachment,req_languages,posted_by")] project project)
{
if (ModelState.IsValid)
{
db.projects.Add(project);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(project));
}
//Update shop with categories
public static WebResult <ShopDTO> Update(ShopDTO shopDTO)
{
using (ProjectEntities db = new ProjectEntities())
{
Shop shop = db.Shops.FirstOrDefault(f => f.mailShop == shopDTO.mailShop);
//למייל אסור להשתנות
if (shop == null)
{
return new WebResult <ShopDTO>
{
Message = "החנות לא נמצאה",
Status = false,
Value = null
}
}
;
shop.nameShop = shopDTO.nameShop;
shop.phoneShop = shopDTO.phoneShop;
shop.latitude = shopDTO.latitude;
shop.longitude = shopDTO.longitude;
shop.fromHour = shopDTO.fromHour;
shop.toHour = shopDTO.toHour;
shop.addressString = shopDTO.addressString;
List <CategoryDTO> sourceCats = shopDTO.Categories;
//למחוק קודם את כל הקטגוריות של החנות
List <Category_to_shop> category_To_Shops = db.Category_to_shop.ToList();
category_To_Shops.ForEach(item =>
{
if (item.codeShop == shop.codeShop)
{
db.Category_to_shop.Remove(item);
}
});
db.SaveChanges();
// להוסיף את כל הקטגוריות החדשות לחנות
foreach (var item in sourceCats)
{
db.Category_to_shop.Add(new Category_to_shop()
{
codeCategory = item.codeCategory, codeShop = shop.codeShop
});
}
db.SaveChanges();
return(new WebResult <ShopDTO>
{
Message = "הנתונים התעדכנו בהצלחה",
Value = shopDTO,
Status = true
});
}
}
public ActionResult Create([Bind(Include = "Id,Name,Description")] Category category)
{
if (ModelState.IsValid)
{
db.Category.Add(category);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(category));
}
public ActionResult Create([Bind(Include = "TruckID,Vin,LP,Tstat,Make,Model,Chassis,Cabin,Engine,Steering,Powert,Torque,GearBox,TankCap,Milage,Weightt,MaxLoad,PDate,LSD,GarageID")] Truck truck)
{
if (ModelState.IsValid)
{
db.Trucks.Add(truck);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.GarageID = new SelectList(db.Garages, "GarageID", "Adrs", truck.GarageID);
return(View(truck));
}
public ActionResult Create([Bind(Include = "ServiceID,SDate,Engine,PF,Trans,Chassis,cabin,WT,Brakes,Cost,TruckID")] ServiceHistory serviceHistory)
{
if (ModelState.IsValid)
{
db.ServiceHistories.Add(serviceHistory);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.TruckID = new SelectList(db.Trucks, "TruckID", "Vin", serviceHistory.TruckID);
return(View(serviceHistory));
}
public ActionResult Create([Bind(Include = "Id,UserName,Password,RoleId,Name,Created_at,Updated_at,Address")] User user)
{
if (ModelState.IsValid)
{
db.User.Add(user);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.RoleId = new SelectList(db.Role, "Id", "RoleName", user.RoleId);
return(View(user));
}
public ActionResult Index(int albumid, int qty)
{
Cart obj = new Cart();
obj.Cartid = GetCartId();
obj.Albumid = albumid;
obj.DateCreated = DateTime.Now;
obj.Quantity = qty;
db.Carts.Add(obj);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Create([Bind(Include = "Id,Name,CateId,Price,Description")] Product product)
{
if (ModelState.IsValid)
{
db.Product.Add(product);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.CateId = new SelectList(db.Category, "Id", "Name", product.CateId);
return(View(product));
}
public ActionResult Create([Bind(Include = "Id,UserId,OrderCode,Created_at,Updated_at,Status")] Order order)
{
if (ModelState.IsValid)
{
db.Order.Add(order);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.UserId = new SelectList(db.User, "Id", "UserName", order.UserId);
return(View(order));
}
public ActionResult Create([Bind(Include = "ProfileID,ProfileName,DepartmentID")] Profile profile)
{
if (ModelState.IsValid)
{
db.Profiles.Add(profile);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.DepartmentID = new SelectList(db.Departments, "DepartmentID", "DepartmentName", profile.DepartmentID);
return(View(profile));
}
public ActionResult Create([Bind(Include = "Id,ProductId,Quantity,OrderId,Price")] OrderDetail orderDetail)
{
if (ModelState.IsValid)
{
db.OrderDetail.Add(orderDetail);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.OrderId = new SelectList(db.Order, "Id", "OrderCode", orderDetail.OrderId);
ViewBag.ProductId = new SelectList(db.Product, "Id", "Name", orderDetail.ProductId);
return(View(orderDetail));
}
public ActionResult Create(Album album)
{
if (ModelState.IsValid)
{
db.Albums.Add(album);
db.SaveChanges();
return(RedirectToAction("Index"));
}
else
{
return(View());
}
}
//הרשמה
public async static Task <WebResult <LoginData <ShopDTO> > > Register(ShopDTO shopDto, Uri request)
{
if (db.Shops.FirstOrDefault(w => w.passwordShop == shopDto.passwordShop) != null ||
db.Shops.FirstOrDefault(w => w.mailShop == shopDto.mailShop) != null)//אם יש כבר כזה מייל או כזו סיסמה
{
return new WebResult <LoginData <ShopDTO> >
{
Message = "אחד מהפרטים שהוקשו כבר קיים במערכת",
Status = false,
Value = null
}
}
;
List <CategoryDTO> sourceCats = shopDto.Categories;
List <Category_to_shop> category_To_Shops = new List <Category_to_shop>();
foreach (var item in sourceCats)
{
db.Category_to_shop.Add(new Category_to_shop()
{
codeCategory = item.codeCategory, codeShop = shopDto.codeShop
});
}
db.Shops.Add(ShopCast.GetShop(shopDto));
if (db.SaveChanges() > 0)//בדיקה שהמידע נשמר
{
var accessToken = await GetTokenDataAsync(shopDto.mailShop, shopDto.passwordShop, request);
if (!string.IsNullOrEmpty(accessToken))
{
return(new WebResult <LoginData <ShopDTO> >
{
Status = true,
Message = "התחברת בהצלחה",
Value = new LoginData <ShopDTO>
{
TokenJson = accessToken,
objectDTO = shopDto
}
});
}
}
return(new WebResult <LoginData <ShopDTO> >
{
Status = false,
Message = "אין משתמש רשום בשם וסיסמא זו",
Value = null
});
}
public ActionResult Create([Bind(Include = "commentid,user_id,game_id,download_id,content,comment_time")] comment comment)
{
if (ModelState.IsValid)
{
db.comment.Add(comment);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.download_id = new SelectList(db.download, "downloadid", "downloadid", comment.download_id);
ViewBag.game_id = new SelectList(db.game, "gameid", "game_name", comment.game_id);
ViewBag.user_id = new SelectList(db.userinfo, "userid", "username", comment.user_id);
return(View(comment));
}
public object addorupdatefood(Register fm)
{
try
{
if (fm.Id == 0)
{
EmployeeLogin c = new EmployeeLogin();
c.EmployeeName = fm.EmployeeName;
c.Email = fm.Email;
c.City = fm.City;
c.Department = fm.Department;
c.Password = fm.Password;
db.EmployeeLogins.Add(c);
db.SaveChanges();
return(new Response
{
Status = "Success",
Message = "Data Add"
});
}
else
{
var obj = db.EmployeeLogins.Where(x => x.Id == fm.Id).ToList().FirstOrDefault();
if (obj.Id > 0)
{
obj.EmployeeName = fm.EmployeeName;
obj.City = fm.City;
obj.Email = fm.Email;
obj.Department = fm.Department;
obj.Password = fm.Password;
db.SaveChanges();
}
return(new Response
{
Status = "Success",
Message = "Data Add"
});
}
}
catch
{
return(new Response
{
Status = "Error",
Message = "Error"
});
}
}
public ActionResult DeleteProject(int id)
{
Project project = model.Projects.SingleOrDefault(p => p.ID == id);
if (project == null)
{
return(View("NotFound"));
}
ViewData["DeletedProject"] = project.Title;
model.DeleteObject(project);
model.SaveChanges();
return(View("Deleted"));
}
public object InsertCustomer(Register rg)
{
try
{
UserLogin ul = new UserLogin();
if (ul.Id == 0)
{
ul.Name = rg.Name;
ul.City = rg.City;
ul.Email = rg.Email;
ul.Password = rg.Password;
db.UserLogins.Add(ul);
db.SaveChanges();
return(new Response
{
Status = "Success",
Message = "Record Successlly saved"
});
}
else
{
var obj = db.UserLogins.Where(x => x.Id == ul.Id).ToList().FirstOrDefault();
if (obj.Id > 0)
{
obj.Name = ul.Name;
obj.Email = ul.Email;
obj.City = ul.City;
db.SaveChanges();
return(new Response
{
Status = "Success",
Message = "Record Successlly saved"
});
}
}
}
catch (Exception)
{
return(new Response
{
Status = "AlreadyExists",
Message = "Invalid Data."
});
}
return(new Response {
Status = "Error", Message = "Invalid Data."
});
}
// POST api/addfriend
public HttpResponseMessage Post(long userId, long FriendUserId, String groupkey)
{
HttpResponseMessage response;
try
{
using (TransactionScope scope = new TransactionScope())
{
int groupId = 0;
using (var ctx = new ProjectEntities())
{
var user = ctx.Group_table.Where(x => x.user_id == userId).Select(grp => new
{
groupId = grp.group_id
}).ToList(); //add default name condition also
groupId = Convert.ToInt32(user[0].groupId);
Friend objfrnd = new Friend();
objfrnd.FriendUserId = FriendUserId;
objfrnd.userId = userId;
objfrnd.GroupId = groupId;
ctx.Friends.Add(objfrnd);
ctx.SaveChanges();
Group_key gk = new Group_key();
gk.group_id = groupId;
gk.group_key1 = groupkey;
gk.status = true;
gk.user_id = FriendUserId;
gk.version = 1;
ctx.Group_key.Add(gk);
ctx.SaveChanges();
scope.Complete();
response = Request.CreateResponse <IQueryable>(System.Net.HttpStatusCode.OK, user.AsQueryable());
}
}
}
catch (Exception e)
{
response = Request.CreateResponse <Exception>(System.Net.HttpStatusCode.BadRequest, e);
}
return(response);
}
