public static string AddEditArea(Area areaDb)
{
string isSaved = "true";
EasyFreightEntities db = new EasyFreightEntities();
if (areaDb.AreaId == 0)
{
db.Areas.Add(areaDb);
}
else
{
db.Areas.Attach(areaDb);
db.Entry(areaDb).State = System.Data.Entity.EntityState.Modified;
}
try
{
db.SaveChanges();
}
catch (Exception ex)
{
isSaved = "false" + ex.Message;
}
return(isSaved);
}
public static string AddEditContainerType(int containerTypeId, string containerTypeName, string maxCBM, string maxWeight)
{
string isSaved = "true";
EasyFreightEntities db = new EasyFreightEntities();
ContainerType containerTypeDb = new ContainerType();
containerTypeDb.ContainerTypeId = containerTypeId;
containerTypeDb.ContainerTypeName = containerTypeName;
containerTypeDb.MaxCBM = decimal.Parse(maxCBM);
containerTypeDb.MaxWeight = decimal.Parse(maxWeight);
if (string.IsNullOrEmpty(containerTypeName))
{
return("false");
}
if (containerTypeId == 0)
{
db.ContainerTypes.Add(containerTypeDb);
}
else
{
db.ContainerTypes.Attach(containerTypeDb);
db.Entry(containerTypeDb).State = System.Data.Entity.EntityState.Modified;
}
try
{
db.SaveChanges();
}
catch (Exception ex)
{
isSaved = "false" + ex.Message;
}
return(isSaved);
}
public static string AddEditIncoterm(int incotermId, string incotermCode, string incotermName)
{
string isSaved = "true";
EasyFreightEntities db = new EasyFreightEntities();
IncotermLib incotermLibDb = new IncotermLib();
incotermLibDb.IncotermId = incotermId;
incotermLibDb.IncotermCode = incotermCode;
incotermLibDb.IncotermName = incotermName;
if (string.IsNullOrEmpty(incotermName))
{
return("false");
}
if (incotermId == 0)
{
db.IncotermLibs.Add(incotermLibDb);
}
else
{
db.IncotermLibs.Attach(incotermLibDb);
db.Entry(incotermLibDb).State = System.Data.Entity.EntityState.Modified;
}
try
{
db.SaveChanges();
}
catch (Exception ex)
{
isSaved = "false" + ex.Message;
}
return(isSaved);
}
public static string AddEditPackageType(int packageTypeId, string packageTypeNameEn, string packageTypeNameAr)
{
string isSaved = "true";
EasyFreightEntities db = new EasyFreightEntities();
PackageType packageTypeDb = new PackageType();
packageTypeDb.PackageTypeId = packageTypeId;
packageTypeDb.PackageTypeNameEn = packageTypeNameEn;
packageTypeDb.PackageTypeNameAr = packageTypeNameAr;
if (string.IsNullOrEmpty(packageTypeNameEn))
{
return("false");
}
if (packageTypeId == 0)
{
db.PackageTypes.Add(packageTypeDb);
}
else
{
db.PackageTypes.Attach(packageTypeDb);
db.Entry(packageTypeDb).State = System.Data.Entity.EntityState.Modified;
}
try
{
db.SaveChanges();
}
catch (Exception ex)
{
isSaved = "false" + ex.Message;
}
return(isSaved);
}
public static string AddEditCountry(int countryId, string countyNameEn, string countryNameAr)
{
string isSaved = "true";
EasyFreightEntities db = new EasyFreightEntities();
Country countryDb = new Country();
countryDb.CountryId = countryId;
countryDb.CountryNameAr = countryNameAr;
countryDb.CountryNameEn = countyNameEn;
if (string.IsNullOrEmpty(countyNameEn))
{
return("false");
}
if (countryId == 0)
{
db.Countries.Add(countryDb);
}
else
{
db.Countries.Attach(countryDb);
db.Entry(countryDb).State = System.Data.Entity.EntityState.Modified;
}
try
{
db.SaveChanges();
}
catch (Exception ex)
{
isSaved = "false" + ex.Message;
}
return(isSaved);
}