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));
}
