public List <AirLine> GetAll()
{
AirLineDAC _airLineComponent = new AirLineDAC();
IDataReader reader = _airLineComponent.GetAllAirLine().CreateDataReader();
List <AirLine> _airLineList = new List <AirLine>();
while (reader.Read())
{
if (_airLineList == null)
{
_airLineList = new List <AirLine>();
}
AirLine _airLine = new AirLine();
if (reader["ID"] != DBNull.Value)
{
_airLine.ID = Convert.ToInt32(reader["ID"]);
}
if (reader["Name"] != DBNull.Value)
{
_airLine.Name = Convert.ToString(reader["Name"]);
}
_airLine.NewRecord = false;
_airLineList.Add(_airLine);
}
reader.Close();
return(_airLineList);
}
public ActionResult Create([Bind(Include = "Name,Country,LinkToPage")] AirLineFormModel airLine)
{
try
{
if (ModelState.IsValid)
{
AirLine newAirline = new AirLine()
{
Name = airLine.Name,
Country = airLine.Country,
LinkToPage = airLine.LinkToPage,
PublicId = Guid.NewGuid(),
IsActive = true
};
db.AirLines.Add(newAirline);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(airLine));
}
catch
{
return(View(airLine));
}
}
public ActionResult Edit(Guid id, [Bind(Include = "Name,Country,LinkToPage")] AirLineFormModel request)
{
try
{
if (id == Guid.Empty)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
if (ModelState.IsValid)
{
AirLine airLine = db.AirLines.FirstOrDefault(p => p.PublicId == id);
if (airLine != null)
{
airLine.Name = request.Name;
airLine.Country = request.Country;
airLine.LinkToPage = request.LinkToPage;
db.Entry(airLine).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
}
return(View(request));
}
catch
{
return(View(request));
}
}
/// <summary>
/// 修改航空公司信息
/// </summary>
/// <param name="vm"></param>
public string ModiflyAriLine(AirLine vm)
{
string path = System.AppDomain.CurrentDomain.BaseDirectory + "config\\AirLineManage.xml";
List <AirLine> list = BPiaoBao.Common.XmlHelper.XmlDeserializeFromFile <List <AirLine> >(path, Encoding.Default);
AirLine airLine = list.Where(x => x.CarrayCode.Equals(vm.CarrayCode) & x.CarrayName.Equals(vm.CarrayName) & x.CarrayAbbreviation.Equals(vm.CarrayAbbreviation)).FirstOrDefault();
if (airLine != null)
{
if (airLine.Id != vm.Id)
{
return("此航空公司已存在!");
}
}
list.ForEach(x =>
{
if (x.Id == vm.Id)
{
x.CarrayName = vm.CarrayName;
x.CarrayCode = vm.CarrayCode;
x.CarrayAbbreviation = vm.CarrayAbbreviation;
x.B2BStatus = vm.B2BStatus;
x.BSPStatus = vm.BSPStatus;
x.AriLineStatus = vm.AriLineStatus;
x.AriLineType = vm.AriLineType;
}
});
BPiaoBao.Common.XmlHelper.XmlSerializeToFile(list, path, Encoding.Default);
InitSystemSwitch.InitAirSystem();
return("成功");
}
/// <summary>
/// 航空公司新增
/// </summary>
/// <param name="vm"></param>
public string AriLineSave(AirLine vm)
{
if (vm == null)
{
return("设置信息失败");
}
List <AirLine> list = null;
string path = System.AppDomain.CurrentDomain.BaseDirectory + "config\\AirLineManage.xml";
if (!File.Exists(path))
{
vm.Id = 1;
list = new List <AirLine>();
list.Add(vm);
BPiaoBao.Common.XmlHelper.XmlSerializeToFile(list, path, Encoding.Default);
}
else
{
list = BPiaoBao.Common.XmlHelper.XmlDeserializeFromFile <List <AirLine> >(path, Encoding.Default);
if (list.Where(x => x.CarrayCode.Equals(vm.CarrayCode) & x.CarrayName.Equals(vm.CarrayName)).FirstOrDefault() != null)
{
return("此航空公司已存在!");
}
vm.Id = list.Max(x => x.Id).HasValue ? list.Max(x => x.Id) + 1 : 1;
list.Add(vm);
BPiaoBao.Common.XmlHelper.XmlSerializeToFile(list, path, Encoding.Default);
}
InitSystemSwitch.InitAirSystem();
return("成功");
}
public ActionResult DeleteConfirmed(Guid id)
{
AirLine airLine = db.AirLines.Find(id);
airLine.IsDelete = true;
airLine.DeleteDate = DateTime.Now;
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult DeleteConfirmed(Guid id)
{
AirLine airLine = db.AirLines.FirstOrDefault(p => p.PublicId == id);
airLine.IsActive = false;
db.Entry(airLine).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Edit(AirLine airLine)
{
if (ModelState.IsValid)
{
airLine.IsDelete = false;
db.Entry(airLine).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(airLine));
}
public bool Insert(AirLine airline)
{
int autonumber = 0;
AirLineDAC airlineComponent = new AirLineDAC();
bool endedSuccessfuly = airlineComponent.InsertNewAirLine(ref autonumber, airline.Name);
if (endedSuccessfuly)
{
airline.ID = autonumber;
}
return(endedSuccessfuly);
}
/// <summary>
/// 航空公司查询
/// </summary>
/// <returns></returns>
public PagedList <AirLine> GetAriLineList(AirLine model, int page, int rows)
{
string path = System.AppDomain.CurrentDomain.BaseDirectory + "config\\AirLineManage.xml";
if (!File.Exists(path))
{
return(new PagedList <AirLine>
{
Total = 0,
Rows = new List <AirLine>()
});
}
else
{
List <AirLine> list = BPiaoBao.Common.XmlHelper.XmlDeserializeFromFile <List <AirLine> >(path, Encoding.Default);
if (!string.IsNullOrEmpty(model.CarrayName))
{
list = list.Where(x => x.CarrayName == model.CarrayName).ToList();
}
if (!string.IsNullOrEmpty(model.CarrayCode))
{
list = list.Where(x => x.CarrayCode.Equals(model.CarrayCode)).ToList();
}
if (!string.IsNullOrEmpty(model.CarrayAbbreviation))
{
list = list.Where(x => x.CarrayAbbreviation.Equals(model.CarrayAbbreviation)).ToList();
}
if (model.B2BStatus.HasValue)
{
list = list.Where(x => x.B2BStatus == model.B2BStatus).ToList();
}
if (model.BSPStatus.HasValue)
{
list = list.Where(x => x.BSPStatus == model.BSPStatus).ToList();
}
if (model.AriLineStatus.HasValue)
{
list = list.Where(x => x.AriLineStatus == model.AriLineStatus).ToList();
}
if (!string.IsNullOrEmpty(model.AriLineType))
{
list = list.Where(x => x.AriLineType.Equals(model.AriLineType)).ToList();
}
return(new PagedList <AirLine>
{
Total = list.Count,
Rows = list.OrderByDescending(x => x.Id).Skip((page - 1) * rows).Take(rows).ToList()
});
}
}
// GET: AirLines/Delete/5
public ActionResult Delete(Guid?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
AirLine airLine = db.AirLines.Find(id);
if (airLine == null)
{
return(HttpNotFound());
}
return(View(airLine));
}
public ActionResult Create(AirLine airLine)
{
if (ModelState.IsValid)
{
airLine.IsDelete = false;
airLine.SubmitDate = DateTime.Now;
airLine.Id = Guid.NewGuid();
db.AirLines.Add(airLine);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(airLine));
}
public AirLine GetByID(int _iD)
{
AirLineDAC _airLineComponent = new AirLineDAC();
IDataReader reader = _airLineComponent.GetByIDAirLine(_iD);
AirLine _airLine = null;
while (reader.Read())
{
_airLine = new AirLine();
if (reader["ID"] != DBNull.Value)
{
_airLine.ID = Convert.ToInt32(reader["ID"]);
}
if (reader["Name"] != DBNull.Value)
{
_airLine.Name = Convert.ToString(reader["Name"]);
}
_airLine.NewRecord = false;
}
reader.Close();
return(_airLine);
}
// GET: AirLines/Delete/5
public ActionResult Delete(Guid id)
{
if (id == Guid.Empty)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
AirLine airLine = db.AirLines.FirstOrDefault(p => p.PublicId == id);
if (airLine == null)
{
return(HttpNotFound());
}
AirLineFormModel toDelete = new AirLineFormModel()
{
Name = airLine.Name,
Country = airLine.Country,
LinkToPage = airLine.LinkToPage
};
return(View(toDelete));
}
// GET: AirLines/Details/5
public ActionResult Details(Guid id)
{
if (id == Guid.Empty)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
AirLine airLine = db.AirLines.FirstOrDefault(p => p.PublicId == id);
if (airLine == null)
{
return(HttpNotFound());
}
AirlineViewModel model = new AirlineViewModel()
{
Name = airLine.Name,
Country = airLine.Country,
LinkToPage = airLine.LinkToPage,
PublicId = airLine.PublicId,
Routes = airLine.Routes
};
return(View(model));
}
public bool Update(AirLine airline, int old_iD)
{
AirLineDAC airlineComponent = new AirLineDAC();
return(airlineComponent.UpdateAirLine(airline.Name, old_iD));
}
