public async Task <FacilityEntity> UpdateFacilityByIdAsync(FacilityEntity facilityEntity, CancellationToken token)
{
_dbContext.Facilities.Update(facilityEntity);
await _dbContext.SaveChangesAsync(token);
return(facilityEntity);
}
public void saveFacility(FacilityEntity obj)
{
try
{
using (ACHSystem.EDMX.ACHDBContainer db = new ACHSystem.EDMX.ACHDBContainer())
{
EDMX.tblFacility fac = new EDMX.tblFacility
{
Id = obj.FacilityId,
Name = obj.Name,
Address = obj.Address,
Active = obj.Active,
DateCreated = obj.DateCreated,
DateUpdated = obj.DateUpdated
};
db.tblFacilities.Add(fac);
db.SaveChanges();
}
}
catch (Exception ex)
{
ErrorLogging.Log(ex, this.Name, "Method Save Facility");
MessageBox.Show("Error Detected, Let the Developer know", "Information", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public FacilityEntity DataRowToModel(DataRow row)
{
FacilityEntity model = new FacilityEntity();
if (row != null)
{
if (row["Facility_ID"] != null && row["Facility_ID"].ToString() != "")
{
model.Facility_ID = int.Parse(row["Facility_ID"].ToString());
}
if (row["GroupID"] != null && row["GroupID"].ToString() != "")
{
model.GroupID = int.Parse(row["GroupID"].ToString());
}
if (row["Facility_Type"] != null && row["Facility_Type"].ToString() != "")
{
model.Facility_Type = int.Parse(row["Facility_Type"].ToString());
}
if (row["Facility_Name"] != null)
{
model.Facility_Name = row["Facility_Name"].ToString();
}
if (row["Facility_longitude"] != null && row["Facility_longitude"].ToString() != "")
{
model.Facility_longitude = decimal.Parse(row["Facility_longitude"].ToString());
}
if (row["Facility_dimensionality"] != null && row["Facility_dimensionality"].ToString() != "")
{
model.Facility_dimensionality = decimal.Parse(row["Facility_dimensionality"].ToString());
}
if (row["power"] != null && row["power"].ToString() != "")
{
model.power = decimal.Parse(row["power"].ToString());
}
if (row["IsOnGIS"] != null && row["IsOnGIS"].ToString() != "")
{
if ((row["IsOnGIS"].ToString() == "1") || (row["IsOnGIS"].ToString().ToLower() == "true"))
{
model.IsOnGIS = true;
}
else
{
model.IsOnGIS = false;
}
}
if (row["Well_head_height"] != null && row["Well_head_height"].ToString() != "")
{
model.Well_head_height = int.Parse(row["Well_head_height"].ToString());
}
if (row["Well_bottom_height"] != null && row["Well_bottom_height"].ToString() != "")
{
model.Well_bottom_height = int.Parse(row["Well_bottom_height"].ToString());
}
if (row["rateOfFlow"] != null && row["rateOfFlow"].ToString() != "")
{
model.rateOfFlow = decimal.Parse(row["rateOfFlow"].ToString());
}
}
return(model);
}
private void btnUpdate_Click_1(object sender, EventArgs e)
{
try
{
if (hasInvalidInput(txtName.Text, txtAddress.Text) == false)
{
FacilityEntity fac = new FacilityEntity();
fac.FacilityId = Convert.ToInt32(lblFacilityId.Text);
fac.Name = txtName.Text;
fac.Address = txtAddress.Text;
if (chkActive.Checked)
{
fac.Active = "Y";
}
else
{
fac.Active = "N";
}
fac.DateCreated = lblCreated.Text;
fac.DateUpdated = DateTime.Now.ToString();
updateFacility(fac);
getAllFacility();
resetSettings();
lblStatus.Text = "Status : Successfully Updated!";
}
}
catch (Exception ex)
{
ErrorLogging.Log(ex, this.Name, "Button Update");
MessageBox.Show("Error Detected, Let the Developer know", "Information", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
public async Task <FacilityEntity> CreateFacilityAsync(FacilityEntity facilityEntity, CancellationToken token)
{
await _dbContext.Facilities.AddAsync(facilityEntity, token);
await _dbContext.SaveChangesAsync(token);
return(await _dbContext.Facilities
.SingleAsync(facility => facility.Id == facilityEntity.Id, token));
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(FacilityEntity model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update Facility set ");
strSql.Append("GroupID=@GroupID,");
strSql.Append("Facility_Type=@Facility_Type,");
strSql.Append("Facility_Name=@Facility_Name,");
strSql.Append("Facility_longitude=@Facility_longitude,");
strSql.Append("Facility_dimensionality=@Facility_dimensionality,");
strSql.Append("power=@power,");
strSql.Append("IsOnGIS=@IsOnGIS,");
strSql.Append("Well_head_height=@Well_head_height,");
strSql.Append("Well_bottom_height=@Well_bottom_height,");
strSql.Append("rateOfFlow=@rateOfFlow");
strSql.Append(" where Facility_ID=@Facility_ID");
SqlParameter[] parameters =
{
new SqlParameter("@GroupID", SqlDbType.Int, 4),
new SqlParameter("@Facility_Type", SqlDbType.Int, 4),
new SqlParameter("@Facility_Name", SqlDbType.NVarChar, 50),
new SqlParameter("@Facility_longitude", SqlDbType.Float, 8),
new SqlParameter("@Facility_dimensionality", SqlDbType.Float, 8),
new SqlParameter("@power", SqlDbType.Float, 8),
new SqlParameter("@IsOnGIS", SqlDbType.Bit, 1),
new SqlParameter("@Well_head_height", SqlDbType.Int, 4),
new SqlParameter("@Well_bottom_height", SqlDbType.Int, 4),
new SqlParameter("@rateOfFlow", SqlDbType.Float, 8),
new SqlParameter("@Facility_ID", SqlDbType.Int, 4)
};
parameters[0].Value = model.GroupID;
parameters[1].Value = model.Facility_Type;
parameters[2].Value = model.Facility_Name;
parameters[3].Value = model.Facility_longitude;
parameters[4].Value = model.Facility_dimensionality;
parameters[5].Value = model.power;
parameters[6].Value = model.IsOnGIS;
parameters[7].Value = model.Well_head_height;
parameters[8].Value = model.Well_bottom_height;
parameters[9].Value = model.rateOfFlow;
parameters[10].Value = model.Facility_ID;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(FacilityEntity model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into Facility(");
strSql.Append("GroupID,Facility_Type,Facility_Name,Facility_longitude,Facility_dimensionality,power,IsOnGIS,Well_head_height,Well_bottom_height,rateOfFlow)");
strSql.Append(" values (");
strSql.Append("@GroupID,@Facility_Type,@Facility_Name,@Facility_longitude,@Facility_dimensionality,@power,@IsOnGIS,@Well_head_height,@Well_bottom_height,@rateOfFlow)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@GroupID", SqlDbType.Int, 4),
new SqlParameter("@Facility_Type", SqlDbType.Int, 4),
new SqlParameter("@Facility_Name", SqlDbType.NVarChar, 50),
new SqlParameter("@Facility_longitude", SqlDbType.Float, 8),
new SqlParameter("@Facility_dimensionality", SqlDbType.Float, 8),
new SqlParameter("@power", SqlDbType.Float, 8),
new SqlParameter("@IsOnGIS", SqlDbType.Bit, 1),
new SqlParameter("@Well_head_height", SqlDbType.Int, 4),
new SqlParameter("@Well_bottom_height", SqlDbType.Int, 4),
new SqlParameter("@rateOfFlow", SqlDbType.Float, 8)
};
parameters[0].Value = model.GroupID;
parameters[1].Value = model.Facility_Type;
parameters[2].Value = model.Facility_Name;
parameters[3].Value = model.Facility_longitude;
parameters[4].Value = model.Facility_dimensionality;
parameters[5].Value = model.power;
parameters[6].Value = model.IsOnGIS;
parameters[7].Value = model.Well_head_height;
parameters[8].Value = model.Well_bottom_height;
parameters[9].Value = model.rateOfFlow;
object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt32(obj));
}
}
public void updateFacility(FacilityEntity obj)
{
try
{
using (ACHSystem.EDMX.ACHDBContainer db = new ACHSystem.EDMX.ACHDBContainer())
{
EDMX.tblFacility emp = db.tblFacilities.Where(x => x.Id == obj.FacilityId).FirstOrDefault();
emp.Name = obj.Name;
emp.Address = obj.Address;
emp.Active = obj.Active;
emp.DateCreated = obj.DateCreated;
emp.DateUpdated = obj.DateUpdated;
db.SaveChanges();
}
}
catch (Exception ex)
{
ErrorLogging.Log(ex, this.Name, "Method Update Facility");
MessageBox.Show("Error Detected, Let the Developer know", "Information", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <summary>
/// Load list of facility of hospital
/// </summary>
/// <param name="hospitalID"></param>
/// <returns></returns>
public static async Task <List <FacilityEntity> > LoadFacilityOfHospitalAsync(int hospitalID)
{
List <FacilityEntity> facilityList = new List <FacilityEntity>();
List <SP_LOAD_FACILITY_IN_HOSPITAL_FACILITYResult> result;
FacilityEntity facility = null;
using (LinqDBDataContext data = new LinqDBDataContext())
{
result = await Task.Run(() => data.SP_LOAD_FACILITY_IN_HOSPITAL_FACILITY(hospitalID).ToList());
foreach (SP_LOAD_FACILITY_IN_HOSPITAL_FACILITYResult r in result)
{
facility = new FacilityEntity();
facility.Facility_ID = r.Facility_ID;
facility.Facility_Name = r.Facility_Name;
facility.Type_ID = r.Facility_Type;
facility.Type_Name = r.Type_Name;
facilityList.Add(facility);
}
}
return(facilityList);
}
/// <summary>
///
/// </summary>
/// <param name="request"></param>
public async Task <FacilityEntity> SaveFacility(FacilityRequest request)
{
var facilityEntity = new FacilityEntity()
{
CreatedDate = DateTime.Now,
CreatedBy = Admin.CreatedBy,
Active = request.Active,
LastModifiedBy = Admin.LastUpdatedBy,
LastModifiedDate = DateTime.Now,
ADUIgnoreCritLow = request.ADUIgnoreCritLow,
ADUIgnoreStockOut = request.ADUIgnoreStockOut,
ADUQtyRounding = request.ADUQtyRounding,
FormularyId = request.FormularyId,
Approved = request.Approved,
FacilityId = request.FacilityId
};
await _facilityRepository.Add(facilityEntity);
await _unitOfWork.CommitChanges();
return(facilityEntity);
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public FacilityEntity GetModel(int Facility_ID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 Facility_ID,GroupID,Facility_Type,Facility_Name,Facility_longitude,Facility_dimensionality,power,IsOnGIS,Well_head_height,Well_bottom_height,rateOfFlow from Facility ");
strSql.Append(" where Facility_ID=@Facility_ID");
SqlParameter[] parameters =
{
new SqlParameter("@Facility_ID", SqlDbType.Int, 4)
};
parameters[0].Value = Facility_ID;
FacilityEntity model = new FacilityEntity();
DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
private FacilityEntity[] ParseFacilitySection(StreamReader reader)
{
var facilities = new List <FacilityEntity>();
bool started = false;
bool completed = false;
string line;
do
{
line = reader.ReadLine();
if (line == null)
{
break;
}
if (line == "********************************************************************************" && started == false)
{
started = true;
// Skip the next to lines since they aren't useful
if (reader.ReadLine() == null)
{
break;
}
if (reader.ReadLine() == null)
{
break;
}
}
else if (line == "********************************************************************************")
{
// We've reached the end of the section
completed = true;
}
else if (started && line != string.Empty)
{
// This is where the parsing of a single well happens
var facility = new FacilityEntity();
var header = line.Split(';');
facility.LicenceNumber = header[0].Trim();
facility.LicenceStatus = header[1].Trim();
facility.LocationIdentifier = header[2].Trim();
facility.LiabilityManagementProgram = header[3].Trim();
facility.AssetCalulationMethod = header[4].Trim();
facility.AssetValue = double.Parse(header[5], NumberStyles.Currency);
facility.LiabilityAmount = double.Parse(header[6], NumberStyles.Currency);
facility.PVSValueType = header[7].Trim();
facility.ActiveIndicator = header[8].Trim();
do
{
line = reader.ReadLine();
if (line == null || line == string.Empty)
{
break;
}
var details = line.Split(';');
if (details[2].Trim() == "Abandonment" && details[3].Trim() == "Fac Abandonment")
{
facility.AbandonmentFacilityAmountIncluded = (details[4].Trim() == "Y");
facility.AbandonmentFacilityAmount = double.Parse(details[5], NumberStyles.Currency);
}
else if (details[2].Trim() == "Abandonment" && details[3].Trim() == "Site Specific")
{
facility.AbandonmentSiteSpecificAmountIncluded = (details[4].Trim() == "Y");
facility.AbandonmentSiteSpecificAmount = double.Parse(details[5], NumberStyles.Currency);
}
else if (details[2].Trim() == "Reclamation" && details[3].Trim() == "Site Reclamation")
{
facility.ReclamationSiteReclamationAmountIncluded = (details[4].Trim() == "Y");
facility.ReclamationSiteReclamationAmount = double.Parse(details[5], NumberStyles.Currency);
}
else if (details[2].Trim() == "Reclamation" && details[3].Trim() == "Site Specific")
{
facility.ReclamationSiteSpecificAmountIncluded = (details[4].Trim() == "Y");
facility.ReclamationSiteSpecificAmount = double.Parse(details[5], NumberStyles.Currency);
}
} while (true);
facilities.Add(facility);
}
} while (!completed);
return(facilities.ToArray());
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(FacilityEntity model)
{
return(dal.Update(model));
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(FacilityEntity model)
{
return(dal.Add(model));
}
/// <summary>
/// Gets the dummy facility request.
/// </summary>
/// <param name="facility">The facility.</param>
/// <returns>Facility.</returns>
private Model.Facility GetMockFacilityRequest(FacilityEntity facility)
{
return(_mapper.Map <FacilityEntity, Model.Facility>(facility));
}
