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