public bool Insert(string WardCode, string WardDescription, int BedsNumber, int WardCapacity, int RoomsNumber, string WardType, string WardPhone, string WardColor, int WardOrder) { WardDAC wardComponent = new WardDAC(); int WardId = 0; return(wardComponent.InsertNewWard(ref WardId, WardCode, WardDescription, BedsNumber, WardCapacity, RoomsNumber, WardType, WardPhone, WardColor, WardOrder)); }
public List <Ward> GetAll() { WardDAC _wardComponent = new WardDAC(); IDataReader reader = _wardComponent.GetAllWard().CreateDataReader(); List <Ward> _wardList = new List <Ward>(); while (reader.Read()) { if (_wardList == null) { _wardList = new List <Ward>(); } Ward _ward = new Ward(); if (reader["WardId"] != DBNull.Value) { _ward.WardId = Convert.ToInt32(reader["WardId"]); } if (reader["WardCode"] != DBNull.Value) { _ward.WardCode = Convert.ToString(reader["WardCode"]); } if (reader["WardDescription"] != DBNull.Value) { _ward.WardDescription = Convert.ToString(reader["WardDescription"]); } if (reader["BedsNumber"] != DBNull.Value) { _ward.BedsNumber = Convert.ToInt32(reader["BedsNumber"]); } if (reader["WardCapacity"] != DBNull.Value) { _ward.WardCapacity = Convert.ToInt32(reader["WardCapacity"]); } if (reader["RoomsNumber"] != DBNull.Value) { _ward.RoomsNumber = Convert.ToInt32(reader["RoomsNumber"]); } if (reader["WardType"] != DBNull.Value) { _ward.WardType = Convert.ToString(reader["WardType"]); } if (reader["WardPhone"] != DBNull.Value) { _ward.WardPhone = Convert.ToString(reader["WardPhone"]); } if (reader["WardColor"] != DBNull.Value) { _ward.WardColor = Convert.ToString(reader["WardColor"]); } if (reader["WardOrder"] != DBNull.Value) { _ward.WardOrder = Convert.ToInt32(reader["WardOrder"]); } _ward.NewRecord = false; _wardList.Add(_ward); } reader.Close(); return(_wardList); }
public Ward GetByID(int _wardId) { WardDAC _wardComponent = new WardDAC(); IDataReader reader = _wardComponent.GetByIDWard(_wardId); Ward _ward = null; while (reader.Read()) { _ward = new Ward(); if (reader["WardId"] != DBNull.Value) { _ward.WardId = Convert.ToInt32(reader["WardId"]); } if (reader["WardCode"] != DBNull.Value) { _ward.WardCode = Convert.ToString(reader["WardCode"]); } if (reader["WardDescription"] != DBNull.Value) { _ward.WardDescription = Convert.ToString(reader["WardDescription"]); } if (reader["BedsNumber"] != DBNull.Value) { _ward.BedsNumber = Convert.ToInt32(reader["BedsNumber"]); } if (reader["WardCapacity"] != DBNull.Value) { _ward.WardCapacity = Convert.ToInt32(reader["WardCapacity"]); } if (reader["RoomsNumber"] != DBNull.Value) { _ward.RoomsNumber = Convert.ToInt32(reader["RoomsNumber"]); } if (reader["WardType"] != DBNull.Value) { _ward.WardType = Convert.ToString(reader["WardType"]); } if (reader["WardPhone"] != DBNull.Value) { _ward.WardPhone = Convert.ToString(reader["WardPhone"]); } if (reader["WardColor"] != DBNull.Value) { _ward.WardColor = Convert.ToString(reader["WardColor"]); } if (reader["WardOrder"] != DBNull.Value) { _ward.WardOrder = Convert.ToInt32(reader["WardOrder"]); } _ward.NewRecord = false; } reader.Close(); return(_ward); }
public bool Insert(Ward ward) { int autonumber = 0; WardDAC wardComponent = new WardDAC(); bool endedSuccessfuly = wardComponent.InsertNewWard(ref autonumber, ward.WardCode, ward.WardDescription, ward.BedsNumber, ward.WardCapacity, ward.RoomsNumber, ward.WardType, ward.WardPhone, ward.WardColor, ward.WardOrder); if (endedSuccessfuly) { ward.WardId = autonumber; } return(endedSuccessfuly); }
public int UpdateDataset(System.Data.DataSet dataset) { WardDAC wardcomponent = new WardDAC(); return(wardcomponent.UpdateDataset(dataset)); }
public void Delete(int Original_WardId) { WardDAC wardComponent = new WardDAC(); wardComponent.DeleteWard(Original_WardId); }
public bool Update(string WardCode, string WardDescription, int BedsNumber, int WardCapacity, int RoomsNumber, string WardType, string WardPhone, string WardColor, int WardOrder, int Original_WardId) { WardDAC wardComponent = new WardDAC(); return(wardComponent.UpdateWard(WardCode, WardDescription, BedsNumber, WardCapacity, RoomsNumber, WardType, WardPhone, WardColor, WardOrder, Original_WardId)); }
public bool Update(Ward ward, int old_wardId) { WardDAC wardComponent = new WardDAC(); return(wardComponent.UpdateWard(ward.WardCode, ward.WardDescription, ward.BedsNumber, ward.WardCapacity, ward.RoomsNumber, ward.WardType, ward.WardPhone, ward.WardColor, ward.WardOrder, old_wardId)); }