public UnitType Edit(UnitType unitType) { using (CargoDBEntities db = new CargoDBEntities()) { db.Entry(unitType).State = EntityState.Modified; db.SaveChanges(); return(unitType); } }
public Notification Edit(Notification notification) { using (CargoDBEntities db = new CargoDBEntities()) { db.Entry(notification).State = EntityState.Modified; db.SaveChanges(); return(notification); } }
public Branch Edit(Branch branch) { using (CargoDBEntities db = new CargoDBEntities()) { db.Entry(branch).State = EntityState.Modified; db.SaveChanges(); return(branch); } }
public Country Edit(Country country) { using (CargoDBEntities db = new CargoDBEntities()) { db.Entry(country).State = EntityState.Modified; db.SaveChanges(); return(country); } }
public Origin Edit(Origin origin) { using (CargoDBEntities db = new CargoDBEntities()) { db.Entry(origin).State = EntityState.Modified; db.SaveChanges(); return(origin); } }
public string Save(Branch branch) { using (CargoDBEntities db = new CargoDBEntities()) { branch.BranchID = IDGenerator.NewId(); db.Branch.Add(branch); db.SaveChanges(); return(branch.BranchID); } }
public string Save(Notification notification) { using (CargoDBEntities db = new CargoDBEntities()) { notification.NotificationID = IDGenerator.NewId(); db.Notification.Add(notification); db.SaveChanges(); return(notification.NotificationID); } }
public Country Delete(Country country) { using (CargoDBEntities db = new CargoDBEntities()) { country.Deleted = !country.Deleted; db.Entry(country).State = EntityState.Modified; db.SaveChanges(); return(country); } }
public string Save(Country country) { using (CargoDBEntities db = new CargoDBEntities()) { country.CountryID = IDGenerator.NewId(); db.Country.Add(country); db.SaveChanges(); return(country.CountryID); } }
public string Save(Origin origin) { using (CargoDBEntities db = new CargoDBEntities()) { origin.OriginId = IDGenerator.NewId(); db.Origin.Add(origin); db.SaveChanges(); return(origin.OriginId); } }
public string Save(UnitType unitType) { using (CargoDBEntities db = new CargoDBEntities()) { unitType.UnitTypeId = IDGenerator.NewId(); db.UnitType.Add(unitType); db.SaveChanges(); return(unitType.UnitTypeId); } }
public string Create(Post post) { using (CargoDBEntities db = new CargoDBEntities()) { post.PostID = IDGenerator.NewId(); post.PubDate = DateTime.Now; db.Post.Add(post); db.SaveChanges(); return(post.PostID); } }
public JsonResult Create([Bind(Include = "WarehouseID,NumberCode,Fk_BranchID,CreationDate,Fk_ShipperID,Fk_Consignee,Fk_Agent,Fk_DeliveryCompany,Fk_Condition,Description,Fk_Origin,Fk_Destination")] Warehouse wareHouse, List <Courier> courier, string[] types) { GenerateId generator = new GenerateId(); wareHouse.WarehouseID = generator.generateID(); db.Warehouses.Add(wareHouse); db.SaveChanges(); ////Add Types List <WarehouseTypeRelation> typeList = new List <WarehouseTypeRelation>(); foreach (var item in types) { var idType = db.WarehouseTypes.Where(x => x.TypeName == item).Select(x => x.TypeId).SingleOrDefault(); WarehouseTypeRelation typeItem = new WarehouseTypeRelation(); typeItem.WarehouseTypeRelationId = generator.generateID(); typeItem.WarehouseId = wareHouse.WarehouseID; typeItem.TypeId = idType; typeList.Add(typeItem); } foreach (var item in courier) { Courier courierItem = new Courier(); item.CourierID = generator.generateID(); item.CreationDate = DateTime.Now; item.Deleted = false; item.Fk_WarehouseID = wareHouse.WarehouseID; db.Couriers.Add(item); } foreach (var item in typeList) { db.WarehouseTypeRelations.Add(item); } db.SaveChanges(); return(Json(new { }, JsonRequestBehavior.AllowGet)); }
//Method to post files for every post public JsonResult PostFile(HttpPostedFileBase file, string id, string idComment) { var postId = id; var ext = System.IO.Path.GetExtension(file.FileName); var name = System.IO.Path.GetFileNameWithoutExtension(file.FileName); if (Directory.Exists(Server.MapPath("~/Files/Post/" + postId + "/")) == false) { Directory.CreateDirectory(Server.MapPath("~/Files/Img/" + postId + "/")); } string filename = name; file.SaveAs(Server.MapPath("~/Files/Img/" + postId + "/") + filename + ext); Comment comment = db.Comments.Find(idComment); comment.FileUrl = name + ext; db.Entry(comment).State = EntityState.Modified; db.SaveChanges(); var userId = User.Identity.GetUserId(); var userName = us.Users.Where(x => x.Id == userId).Select(x => x.Nombre).SingleOrDefault(); var mail = us.Users.Where(x => x.Id == userId).Select(x => x.Email).SingleOrDefault(); var foto = us.Users.Where(x => x.Id == userId).Select(x => x.Foto).SingleOrDefault(); var obj = new { date = comment.Date, message = comment.CommentMessage, user = userName, mail = mail, foto = foto, url = comment.FileUrl }; return(Json(new { data = obj }, JsonRequestBehavior.AllowGet)); }
public JsonResult Create([Bind(Include = "TypeId,TypeName")] WarehouseType warehouseClassification) { GenerateId generator = new GenerateId(); warehouseClassification.TypeId = generator.generateID(); db.WarehouseTypes.Add(warehouseClassification); db.SaveChanges(); var tipo = new { TypeId = warehouseClassification.TypeId, TypeName = warehouseClassification.TypeName }; return(Json(new { data = tipo }, JsonRequestBehavior.AllowGet)); }
public JsonResult Create([Bind(Include = "DestinationId,DestinationName")] Destination destination) { GenerateId generator = new GenerateId(); destination.DestinationId = generator.generateID(); db.Destinations.Add(destination); db.SaveChanges(); var destino = new { DestinationId = destination.DestinationId, DestinationName = destination.DestinationName }; return(Json(new { data = destino }, JsonRequestBehavior.AllowGet)); }
public JsonResult Create([Bind(Include = "AccountClasificationID,ClasificationName")] AccountClasification classification) { GenerateId generator = new GenerateId(); classification.AccountClasificationID = generator.generateID(); db.AccountClasifications.Add(classification); db.SaveChanges(); var clasificacion = new { Id = classification.AccountClasificationID, Classification = classification.ClasificationName }; return(Json(new { data = clasificacion }, JsonRequestBehavior.AllowGet)); }
public JsonResult Create([Bind(Include = "CompanyID,CompanyName")] DeliveryCompany deliveryCompany) { GenerateId generator = new GenerateId(); deliveryCompany.CompanyID = generator.generateID(); db.DeliveryCompanies.Add(deliveryCompany); db.SaveChanges(); var delivery = new { Id = deliveryCompany.CompanyID, CompanyName = deliveryCompany.CompanyName }; return(Json(new { data = delivery }, JsonRequestBehavior.AllowGet)); }
public Country ToggleState(Country country) { using (CargoDBEntities db = new CargoDBEntities()) { if (country.Active == true) { country.Active = false; } else { country.Active = true; } db.Entry(country).State = EntityState.Modified; db.SaveChanges(); return(country); } }
public Origin ToggleState(Origin origin) { using (CargoDBEntities db = new CargoDBEntities()) { if (origin.Active == true) { origin.Active = false; } else { origin.Active = true; } db.Entry(origin).State = EntityState.Modified; db.SaveChanges(); return(origin); } }
public Branch ToggleState(Branch branch) { using (CargoDBEntities db = new CargoDBEntities()) { if (branch.Active == true) { branch.Active = false; } else { branch.Active = true; } db.Entry(branch).State = EntityState.Modified; db.SaveChanges(); return(branch); } }
public Notification ToggleState(Notification notification) { using (CargoDBEntities db = new CargoDBEntities()) { if (notification.Activate == true) { notification.Activate = false; } else { notification.Activate = true; } db.Entry(notification).State = EntityState.Modified; db.SaveChanges(); return(notification); } }
public JsonResult Create([Bind(Include = "CompanyAccountID,CompanyName,Adress,City,State,ZipCode,Fk_CountryID,Email,Phone,Fax,Mobile,ContactName,Fk_Agent")] CompanyAccount CompanyAccount, String[] Classification, String[] Notification) { GenerateId generator = new GenerateId(); CompanyAccount.CompanyAccountID = generator.generateID(); db.CompanyAccounts.Add(CompanyAccount); db.SaveChanges(); if (Classification != null) { ////Add classifications List <AccountClasificationRelation> classificationAccountList = new List <AccountClasificationRelation>(); foreach (var item in Classification) { var idClassification = db.AccountClasifications.Where(x => x.ClasificationName == item).Select(x => x.AccountClasificationID).SingleOrDefault(); AccountClasificationRelation classificacationItem = new AccountClasificationRelation(); classificacationItem.AccountClasificationID = generator.generateID(); classificacationItem.Fk_AccountID = CompanyAccount.CompanyAccountID; classificacationItem.Fk_ClasificationID = idClassification; classificationAccountList.Add(classificacationItem); } foreach (var item in classificationAccountList) { db.AccountClasificationRelations.Add(item); } } if (Notification != null) { ////Add notifications List <NotificationAccountRelation> notificationAccountList = new List <NotificationAccountRelation>(); foreach (var item in Notification) { var idNotification = db.Notifications.Where(x => x.NotificationName == item).Select(x => x.NotificationID).SingleOrDefault(); NotificationAccountRelation notificationItem = new NotificationAccountRelation(); notificationItem.NotificationAccountRelation1 = generator.generateID(); notificationItem.Fk_Account = CompanyAccount.CompanyAccountID; notificationItem.Fk_Notification = idNotification; notificationAccountList.Add(notificationItem); } foreach (var item in notificationAccountList) { db.NotificationAccountRelations.Add(item); } } var account = new { CompanyAccountID = CompanyAccount.CompanyAccountID, CompanyName = CompanyAccount.ContactName, Adress = CompanyAccount.Adress, City = CompanyAccount.City, State = CompanyAccount.State, }; db.SaveChanges(); return(Json(new { data = account }, JsonRequestBehavior.AllowGet)); }