public Event Add(Event M) { cont.EventSet.Add(M); cont.SaveChanges(); return(M); }
public Account Add(Account M) { cont.AccountSet.Add(M); cont.SaveChanges(); return(M); }
public PaymentToPeers Add(PaymentToPeers M) { cont.PaymentToPeersSet.Add(M); cont.SaveChanges(); return(M); }
public Employee Add(Employee M) { cont.EmployeeSet.Add(M); cont.SaveChanges(); return(M); }
public Client Add(Client M) { if (cont.ClientSet.Where(x => x.FIO == M.FIO).Count() == 0) { cont.ClientSet.Add(M); } cont.SaveChanges(); return(M); }
public IHttpActionResult PutOrder(int id, OrderViewModel order_view_model) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } if (id != order_view_model.Id) { return(BadRequest()); } //把資料庫中的那筆資料讀出來 var order = db.Orders.Find(order_view_model.Id); if (order == null) { return(ResponseMessage(Request.CreateErrorResponse(HttpStatusCode.NotFound, "這筆資料已被刪除!"))); } else { try { order.OrderDate = order_view_model.OrderDate; order.Customer_Id = order_view_model.Customer_Id; order.OrderDetails.Clear(); Product product; foreach (var detail in order_view_model.OrderDetails) { product = db.Products.Find(detail.Product_Id); order.OrderDetails.Add(new OrderDetail { Product = product, Quantity = detail.Quantity }); } db.Entry(order).OriginalValues["Timestamp"] = Convert.FromBase64String(order_view_model.TimestampString); db.SaveChanges(); } catch (DbUpdateConcurrencyException) { if (!OrderExists(id)) { throw new HttpResponseException(Request.CreateResponse(HttpStatusCode.NotFound, "這筆資料已被刪除!")); } else { throw new HttpResponseException(Request.CreateErrorResponse(HttpStatusCode.Conflict, "這筆資料已被其他人修改!"));// "" } } } return(Ok(toOrderViewModel(order))); }
public IHttpActionResult PutProduct(int id, ProductViewModel product_view_model) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } if (id != product_view_model.Id) { return(BadRequest()); } Category category = db.Categories.Find(product_view_model.Category_Id); if (category == null) { return(BadRequest("找不到對應的產品分類: " + product_view_model.Category_Id)); } //把資料庫中的那筆資料讀出來 Product product_db = db.Products.Find(id); if (product_db == null) { return(ResponseMessage(Request.CreateErrorResponse(HttpStatusCode.NotFound, "這筆資料已被刪除!"))); } else { try { product_db.Name = product_view_model.Name; product_db.Price = product_view_model.Price; product_db.Category = category; db.Entry(product_db).OriginalValues["Timestamp"] = Convert.FromBase64String(product_view_model.TimestampString); db.SaveChanges(); } catch (DbUpdateConcurrencyException) { if (!ProductExists(id)) { throw new HttpResponseException(Request.CreateResponse(HttpStatusCode.NotFound, "這筆資料已被刪除!")); } else { throw new HttpResponseException(Request.CreateErrorResponse(HttpStatusCode.Conflict, "這筆資料已被其他人修改!")); } } } return(Ok(ToViewModel(product_db))); }
public IEnumerable <Payments> GetCollection(bool flagofstatus) { foreach (Payments pm in cont.PaymentsSet) { try { pm.StatusForSalary = cont.Pay_minSet.Where(x => x.Date == pm.Date && pm.Account.Id == x.Account.Id).Select(y => y.Finished).FirstOrDefault(); } catch { pm.StatusForSalary = false; } } cont.SaveChanges(); return(cont.PaymentsSet.OrderBy(cw => cw.Id)); }
public IEnumerable <Pay_min> GetEmplPays(int id) { foreach (Pay_min pm in cont.Pay_minSet) { try { var a = cont.Pay_minSet.Where( x => x.Account.Id == pm.Account.Id && x.Date == pm.Date && x.Employee.Id == pm.Employee.Id).Select(y => y.Sum).Sum(); var b = cont.PaymentsSet.Where(x => x.Account.Id == pm.Account.Id && x.Date == pm.Date && x.Employee.Id == pm.Employee.Id).Select(y => y.Receipt).Sum(); pm.Finished = a == b; } catch { pm.Finished = false; } } cont.SaveChanges(); return(cont.Pay_minSet.Where(x => x.Employee.Id == id).OrderBy(cw => cw.Id)); }
public IHttpActionResult PutcatCustomer(int id, CatCustomerViewModel Cat_CustomerView_Model) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } if (id != Cat_CustomerView_Model.Id) { return(BadRequest()); } //把資料庫中的那筆資料讀出來 var catCustomer_db = db.catCustomers.Find(id); if (catCustomer_db == null) { return(ResponseMessage(Request.CreateErrorResponse(HttpStatusCode.NotFound, "這筆資料已被刪除!"))); } else { try { catCustomer_db.Id = Cat_CustomerView_Model.Id; catCustomer_db.No = Cat_CustomerView_Model.No; catCustomer_db.Name = Cat_CustomerView_Model.Name; db.Entry(catCustomer_db).OriginalValues["Timestamp"] = Convert.FromBase64String(Cat_CustomerView_Model.TimestampString); db.SaveChanges(); } catch (DbUpdateConcurrencyException) { if (!catCustomerExists(id)) { throw new HttpResponseException(Request.CreateResponse(HttpStatusCode.NotFound, "這筆資料已被刪除!")); } else { throw new HttpResponseException(Request.CreateErrorResponse(HttpStatusCode.Conflict, "這筆資料已被其他人修改!"));// "" } } } return(Ok(ToViewModel(catCustomer_db))); }
public IHttpActionResult PuttypeFactory(int id, TypeFactoryViewModel Type_FactoryView_Model) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } if (id != Type_FactoryView_Model.Id) { return(BadRequest()); } //把資料庫中的那筆資料讀出來 var typeFactory_db = db.typeFactories.Find(id); if (typeFactory_db == null) { return(ResponseMessage(Request.CreateErrorResponse(HttpStatusCode.NotFound, "這筆資料已被刪除!"))); } else { try { typeFactory_db.Id = Type_FactoryView_Model.Id; typeFactory_db.No = Type_FactoryView_Model.No; typeFactory_db.Name = Type_FactoryView_Model.Name; db.Entry(typeFactory_db).OriginalValues["Timestamp"] = Convert.FromBase64String(Type_FactoryView_Model.TimestampString); db.SaveChanges(); } catch (DbUpdateConcurrencyException) { if (!typeFactoryExists(id)) { throw new HttpResponseException(Request.CreateResponse(HttpStatusCode.NotFound, "這筆資料已被刪除!")); } else { throw new HttpResponseException(Request.CreateErrorResponse(HttpStatusCode.Conflict, "這筆資料已被其他人修改!"));// "" } } } return(Ok(ToViewModel(typeFactory_db))); }
public Contract Add(int sumonly, int eventid, string client, DateTime sign, DateTime _event, DateTime pay1, DateTime pay2, DateTime pay3, int paysum1, int paysum2, int paysum3, string comment, int emplid) { Contract add = new Contract(); add.Sum_only_contract = sumonly; add.EventSet = cont.EventSet.Find(eventid); Client cladd = new Client(); cladd.FIO = client; if (cont.ClientSet.Where(x => x.FIO == cladd.FIO).Count() == 0) { cont.ClientSet.Add(cladd); cont.SaveChanges(); } add.ClientSet = cont.ClientSet.Where(x => x.FIO == cladd.FIO).FirstOrDefault(); add.Date_of_sign = sign; add.Date_of_event = _event; if (pay1 != default(DateTime)) { add.Payment1Date = pay1; } if (pay2 != default(DateTime)) { add.Payment2Date = pay2; } if (pay3 != default(DateTime)) { add.Payment3Date = pay3; } if (paysum1 != 0) { add.Payment1Sum = paysum1; } if (paysum2 != 0) { add.Payment2Sum = paysum2; } if (paysum3 != 0) { add.Payment3Sum = paysum3; } add.Comment = comment; add.Received = 0; add.Sum_plus = 0; add.Status = Status.Активный.ToString(); add.EmployeeSet = cont.EmployeeSet.Find(emplid); // Убрать потом при регистрации!!!!!!! add.Name = add.Date_of_event.ToString().Split(' ')[0] + " — " + " (" + add.EmployeeSet.Name.First() + add.EmployeeSet.Surname.First() + ") " + add.ClientSet.FIO; cont.ContractSet.Add(add); cont.SaveChanges(); return(add); }
public IHttpActionResult PutCustomer(int id, CustomerViewModel customer_View_Model) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } if (id != customer_View_Model.Id) { return(BadRequest()); } //把資料庫中的那筆資料讀出來 var customer_db = db.Customers.Find(id); if (customer_db == null) { return(ResponseMessage(Request.CreateErrorResponse(HttpStatusCode.NotFound, "這筆資料已被刪除!"))); } else { try { //customer_db.catCustomer.Name = customer_View_Model.CatName; customer_db.Cat = customer_View_Model.Cat; customer_db.NO = customer_View_Model.NO; customer_db.Name = customer_View_Model.Name; customer_db.Sname = customer_View_Model.Sname; customer_db.Unid = customer_View_Model.Unid; customer_db.Contact1 = customer_View_Model.Contact1; customer_db.Contact2 = customer_View_Model.Contact2; customer_db.Email1 = customer_View_Model.Email1; customer_db.Email2 = customer_View_Model.Email2; customer_db.Email3 = customer_View_Model.Email3; customer_db.Telephone1 = customer_View_Model.Telephone1; customer_db.Telephone2 = customer_View_Model.Telephone2; customer_db.Telephone3 = customer_View_Model.Telephone3; customer_db.Website = customer_View_Model.Website; customer_db.Fax = customer_View_Model.Fax; customer_db.Address = customer_View_Model.Address; customer_db.Shipaddr = customer_View_Model.Shipaddr; customer_db.Invoiceaddr = customer_View_Model.Invoiceaddr; customer_db.Pay = customer_View_Model.Pay; //customer_db.catPay.Name = customer_View_Model.PayName; customer_db.Currency = customer_View_Model.Currency; //customer_db.catCurrency.Name = customer_View_Model.CurrencyName; customer_db.Lasttrade = customer_View_Model.Lasttrade; customer_db.Note = customer_View_Model.Note; db.Entry(customer_db).OriginalValues["Timestamp"] = Convert.FromBase64String(customer_View_Model.TimestampString); db.SaveChanges(); } catch (DbUpdateConcurrencyException) { if (!CustomerExists(id)) { throw new HttpResponseException(Request.CreateResponse(HttpStatusCode.NotFound, "這筆資料已被刪除!")); } else { throw new HttpResponseException(Request.CreateErrorResponse(HttpStatusCode.Conflict, "這筆資料已被其他人修改!"));// "" } } } return(Ok(ToViewModel(customer_db))); }
public void Add(Salary s) { cont.SalarySet.Add(s); cont.SaveChanges(); }
public IHttpActionResult PutFactory(int id, FactoryViewModel factory_view_model) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } if (id != factory_view_model.Id) { return(BadRequest()); } //把資料庫中的那筆資料讀出來 var factory_db = db.Factories.Find(id); if (factory_db == null) { return(ResponseMessage(Request.CreateErrorResponse(HttpStatusCode.NotFound, "這筆資料已被刪除!"))); } else { try { //factory_db.catFactory.Name = factory_view_model.CatName; factory_db.Cat = factory_view_model.Cat; //factory_db.typeFactory.Name = factory_view_model.TypeName; factory_db.Type = factory_view_model.Type; factory_db.NO = factory_view_model.NO; factory_db.Name = factory_view_model.Name; factory_db.Sname = factory_view_model.Sname; factory_db.Unid = factory_view_model.Unid; factory_db.Contact1 = factory_view_model.Contact1; factory_db.Contact2 = factory_view_model.Contact2; factory_db.Email1 = factory_view_model.Email1; factory_db.Email2 = factory_view_model.Email2; factory_db.Email3 = factory_view_model.Email3; factory_db.Telephone1 = factory_view_model.Telephone1; factory_db.Telephone2 = factory_view_model.Telephone2; factory_db.Telephone3 = factory_view_model.Telephone3; factory_db.Website = factory_view_model.Website; factory_db.Fax = factory_view_model.Fax; factory_db.Address = factory_view_model.Address; factory_db.Shipaddr = factory_view_model.Shipaddr; factory_db.Invoiceaddr = factory_view_model.Invoiceaddr; factory_db.Pay = factory_view_model.Pay; //factory_db.catPay.Name = factory_view_model.PayName; factory_db.Currency = factory_view_model.Currency; //factory_db.catCurrency.Name = factory_view_model.CurrencyName; factory_db.Lasttrade = factory_view_model.Lasttrade; factory_db.Note = factory_view_model.Note; db.Entry(factory_db).OriginalValues["Timestamp"] = Convert.FromBase64String(factory_view_model.TimestampString); db.SaveChanges(); } catch (DbUpdateConcurrencyException) { if (!FactoryExists(id)) { throw new HttpResponseException(Request.CreateResponse(HttpStatusCode.NotFound, "這筆資料已被刪除!")); } else { throw new HttpResponseException(Request.CreateErrorResponse(HttpStatusCode.Conflict, "這筆資料已被其他人修改!"));// "" } } } return(Ok(ToViewModel(factory_db))); }