private FacilityInfo GetFacilitiesValues(DataRow dr)
{
FacilityInfo Facility = new FacilityInfo();
Facility.FacilityId = Convert.ToInt32(dr["FacilityId"]);
if (!dr.IsNull("FacilityTypeId"))
{
Facility.FacilityTypeId = Convert.ToInt32(dr["FacilityTypeId"]);
}
if (!dr.IsNull("FacilityTypeName"))
{
Facility.FacilityTypeName = Convert.ToString(dr["FacilityTypeName"]);
}
if (!dr.IsNull("FacilityName"))
{
Facility.FacilityName = Convert.ToString(dr["FacilityName"]);
}
if (!dr.IsNull("IsActive"))
{
Facility.IsActive = Convert.ToBoolean(dr["IsActive"]);
}
return(Facility);
}
public List <SqlParameter> SetValuesInFacility(FacilityInfo facility)
{
List <SqlParameter> sqlParam = new List <SqlParameter>();
if (facility.FacilityId != 0)
{
sqlParam.Add(new SqlParameter("FacilityId", facility.FacilityId));
}
else
{
sqlParam.Add(new SqlParameter("CreatedDate", facility.CreatedDate));
sqlParam.Add(new SqlParameter("CreatedBy", facility.CreatedBy));
}
sqlParam.Add(new SqlParameter("FacilityTypeId", facility.FacilityTypeId));
Logger.Debug("Facility Controller FacilityTypeId:" + facility.FacilityTypeId);
sqlParam.Add(new SqlParameter("FacilityName", facility.FacilityName));
Logger.Debug("Facility Controller FacilityName:" + facility.FacilityName);
sqlParam.Add(new SqlParameter("IsActive", facility.IsActive));
Logger.Debug("Facility Controller IsActive:" + facility.IsActive);
sqlParam.Add(new SqlParameter("UpdatedBy", facility.UpdatedBy));
sqlParam.Add(new SqlParameter("UpdatedDate", facility.UpdatedDate));
return(sqlParam);
}
public FacilityInfo AddFacilityInfo(GameObject Object)
{
FacilityInfo newFacility = new FacilityInfo();
newFacility.Object = Object;
newFacility.ObjectActCall = Object.GetComponent <InstallableObjectAct>();
newFacility.isActive = true;
newFacility.SuppliedElectricity = 0f;
newFacility.SuppliedLabor = 0;
newFacility.InstallDate = TimeManagerCall.TimeValue;
FacilityList.Add(newFacility);
InstalledFacilityAmount++;
CompanyValueCall.GetEconomyValue().GetComponent <EconomyValue>().AddHistory(TimeManagerCall.TimeValue, "Install",
newFacility.ObjectActCall.Info.Name, "Install " + Object.name, -newFacility.ObjectActCall.Info.Price);
CompanyValueCall.GetEconomyValue().GetComponent <EconomyValue>().AddPersistHistory(TimeManagerCall.GetNextMonth(0, newFacility.ObjectActCall.Info.UpkeepMonthTerm) + (TimeManagerCall.TimeValue % TimeManagerCall.Month),
newFacility.ObjectActCall.Info.UpkeepMonthTerm * TimeManagerCall.Month, "Upkeep", newFacility.ObjectActCall.Info.Name,
Object.name + "'s Upkeep Price", -newFacility.ObjectActCall.Info.UpkeepPrice);
CompanyValueCall.GetElectricityValue().GetComponent <ElectricityValue>().AddObject(newFacility);
CompanyValueCall.GetEmployeeValue().GetComponent <EmployeeValue>().AddLaborInfo(newFacility);
return(newFacility);
}
private void Update()
{
if (canvas.enabled)
{
if (selectedToggle != toggleGroup.ActiveToggles().FirstOrDefault <Toggle>())
{
selectedToggle = toggleGroup.ActiveToggles().FirstOrDefault <Toggle>();
selectedFacilityInfo = facilityList.GetFacilityByName(selectedToggle.transform.Find("Name").GetComponent <Text>().text);
}
if (selectedToggle != null)
{
if (playerStats.GetCompanyFunds() >= selectedFacilityInfo.costToBuy && selectedFacility.CheckFacilitySize(selectedFacilityInfo))
{
confirmButton.interactable = true;
}
else
{
confirmButton.interactable = false;
}
}
else
{
confirmButton.interactable = false;
}
}
}
public ActionResult DeleteConfirmed(int id)
{
FacilityInfo facilityInfo = db.FacilityInfo.Find(id);
db.FacilityInfo.Remove(facilityInfo);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Edit([Bind(Include = "Id,FacilityId,LocationKind,LocationName,Address,City,State,ZipCode,PhoneNumber,Directions,OperationalHours")] FacilityInfo facilityInfo)
{
if (ModelState.IsValid)
{
db.Entry(facilityInfo).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(facilityInfo));
}
private FacilityInfo CreateFacilityInfo()
{
var fi = new FacilityInfo();
fi.FacilityId = "JPN999999999999";
fi.FacilityName = "医療法人 オルカ医院";
fi.PostNumber = "113-0021";
fi.AddressText = "東京都文京区本駒込２－２８－１６";
return(fi);
}
public FacilityViewModel()
{
FriendlyMessage = new List <FriendlyMessage>();
Pager = new PaginationInfo();
Facility = new FacilityInfo();
Facilities = new List <FacilityInfo>();
FacilityTypes = new List <FacilityTypeInfo>();
Filter = new FacilityFilter();
}
// GET: FacilityInfoes/Delete/5
public ActionResult Delete(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
FacilityInfo facilityInfo = db.FacilityInfo.Find(id);
if (facilityInfo == null)
{
return(HttpNotFound());
}
return(View(facilityInfo));
}
public FacilityInfo GetFacilityInfo(string Name)
{
FacilityInfo Result = null;
foreach (var Facility in FacilityList)
{
if (Facility.Name == Name)
{
Result = Facility;
}
}
return(Result);
}
public AlarmRuleSaveResponse Execute(AlarmRuleSaveRequest request)
{
AlarmRuleSaveResponse ruleSaveResponse = new AlarmRuleSaveResponse();
if (string.IsNullOrEmpty(request.AlarmRuleDID))
{
AlarmRuleInfo alarmRuleInfo = new AlarmRuleInfo();
FacilityInfo facility = ServiceHelper.LoadService <IProductionService>().GetFacility(request.CraftDID);
alarmRuleInfo.RuleDID = ServiceHelper.LoadService <IAlarmService>().GetNextAlarmRuleDID(facility.Process.Craft.CraftNO);
alarmRuleInfo.FacilityDID = facility.FacilityDID;
alarmRuleInfo.UnitDID = facility.ProcessDID;
alarmRuleInfo.CraftDID = facility.Process.CraftDID;
alarmRuleInfo.UnitDID = request.UnitDID;
alarmRuleInfo.AlarmContent = request.AlarmContent;
alarmRuleInfo.AlarmReason = request.AlarmReason;
alarmRuleInfo.Solution = new SolutionInfo()
{
Content = request.SolutionText
};
alarmRuleInfo.AlarmTypeDID = request.AlarmTypeDID;
string str1 = "Upload/SolutionImages/";
string str2 = alarmRuleInfo.RuleDID + ".jpg";
if (!Directory.Exists(this.Server.MapPath("~/" + str1)))
{
Directory.CreateDirectory(this.Server.MapPath("~/" + str1));
}
ImageHelper.SaveImage(ImageHelper.BytesToImage(request.GetFileParameters()["SolutionImage"].GetContent()), this.Server.MapPath("~/" + str1 + str2));
string str3 = "Upload/AlarmLocationImages/";
string str4 = alarmRuleInfo.RuleDID + ".jpg";
if (!Directory.Exists(this.Server.MapPath("~/" + str3)))
{
Directory.CreateDirectory(this.Server.MapPath("~/" + str3));
}
ImageHelper.SaveImage(ImageHelper.BytesToImage(request.GetFileParameters()["AlarmLocationImage"].GetContent()), this.Server.MapPath("~/" + str3 + str4));
alarmRuleInfo.AlarmLocationImage = new AlarmLocationImageInfo()
{
Path = str3 + str4
};
alarmRuleInfo.SolutionImage = new SolutionImageInfo()
{
Path = str1 + str2
};
ServiceHelper.LoadService <IAlarmService>().AddAlarmRule(alarmRuleInfo);
ServiceHelper.LoadService <IAlarmService>().SaveAlarmRuleFields(alarmRuleInfo.RuleDID, request.Fields);
ruleSaveResponse.AlarmRuleDID = alarmRuleInfo.RuleDID;
}
return(ruleSaveResponse);
}
private void LoadDefaults()
{
myF = new FacilityInfo();
if (myF.ShowFacility() > 0)
{
strFcode = FacilityInfo.FCode;
txtFacility.Text = FacilityInfo.FName;
}
else
{
LiveClear();
Interactive.LInfoWarningOK("Facility informantion is required", "Facility Settings");
FrmFacility f = new FrmFacility();
f.ShowDialog();
}
}
private FacilityInfo GetFacilityInfo(SqlDataReader dr)
{
FacilityInfo facility = new FacilityInfo
{
Id = DatabaseHelper.GetInt32("FacilityId", dr),
DistrictId = DatabaseHelper.GetInt32("DistrictId", dr),
FacilityName = DatabaseHelper.GetString("FacilityName", dr),
DistrictName = DatabaseHelper.GetString("DistrictName", dr),
ProvinceName = DatabaseHelper.GetString("ProvinceName", dr),
FacilityCode = DatabaseHelper.GetString("FacilityCode", dr),
FacilityLevel = DatabaseHelper.GetString("FacilityLevel", dr),
ProvinceId = DatabaseHelper.GetInt32("ProvinceId", dr),
FacilityTypeName = DatabaseHelper.GetString("FacilityTypeName", dr),
};
return(facility);
}
public async Task <IActionResult> Create([Bind("User,FacilityId,ActiveStatus,DateEstablished,DistCode,FacilityName,FacilityNameDari,FacilityNamePashto,FacilityType,Gpslattitude,Gpslongtitude,Implementer,Lat,Location,LocationDari,LocationPashto,Lon,SubImplementer,ViliCode")] FacilityInfo facilityInfo)
{
if (ModelState.IsValid)
{
_context.Add(facilityInfo);
await _context.SaveChangesAsync();
return(RedirectToAction("Index"));
}
var users = _db.Users.Where(m => m.Active.Equals(true)).Select(m => new ApplicationUser()
{
FirstName = m.FirstName + " " + m.LastName + "-" + m.UserName,
UserName = m.UserName,
}).ToList();
ViewData["User"] = new SelectList(users, "UserName", "FirstName", facilityInfo.User);
ViewData["DistCode"] = new SelectList(_context.Districts, "DistCode", "DistName", facilityInfo.DistCode);
return(View(facilityInfo));
}
public async Task <IActionResult> Create([Bind("Implementer,FacilityId,ActiveStatus,DateEstablished,DistCode,FacilityName,FacilityNameDari,FacilityNamePashto,FacilityType,Gpslattitude,Gpslongtitude,Lat,Location,LocationDari,LocationPashto,Lon,SubImplementer,ViliCode")] FacilityInfo facilityInfo)
{
if (ModelState.IsValid)
{
_context.Add(facilityInfo);
await _context.SaveChangesAsync();
return(RedirectToAction("Index"));
}
var items = _context.FacilityTypes.Select(s => new
{
FacTypeCode = s.FacTypeCode,
description = string.Format("{0} - {1}", s.FacTypeCatCode, s.FacType)
});
var imps = _context.Implementers.ToList();
ViewData["fac"] = new SelectList(items, "FacTypeCode", "description");
ViewData["imps"] = new SelectList(imps, "ImpAcronym", "ImpAcronym");
ViewData["Districts"] = new SelectList(_context.Districts, "DistCode", "DistName");
return(View(facilityInfo));
}
public IList <AlarmTemporaryInfo> GetAlarmTemporarys()
{
DataTable tb = getAlarmTemporarys();
List <AlarmTemporaryInfo> lst = new List <AlarmTemporaryInfo>();
if (tb != null && tb.Rows.Count > 0)
{
foreach (DataRow row in tb.Rows)
{
AlarmTemporaryInfo info = new AlarmTemporaryInfo();
info.AlarmTemporaryDID = int.Parse(row[0].ToString());
info.RuleDID = row[1].ToString();
info.FacilityDID = int.Parse(row[2].ToString());
info.AlarmTime = DateTime.Parse(row[3].ToString());
if (row[4].ToString() != "")
{
info.DisposeState = int.Parse(row[4].ToString());
}
if (row[5].ToString() != "")
{
info.DisposeTime = DateTime.Parse(row[5].ToString());
}
info.Handler = row[6].ToString();
if (row[7].ToString() != "")
{
info.Duration = int.Parse(row[7].ToString());
}
info.Address = row[8].ToString();
info.Remark = row[9].ToString();
ProductionDB p = new ProductionDB();
FacilityInfo f = p.GetFacilityByID(info.FacilityDID);
info.Facility = f;
lst.Add(info);
}
}
return(lst);
}
public async Task <IActionResult> Edit(int id, [Bind("FacilityId,User,ActiveStatus,DateEstablished,DistCode,FacilityName,FacilityNameDari,FacilityNamePashto,FacilityType,Gpslattitude,Gpslongtitude,Implementer,Lat,Location,LocationDari,LocationPashto,Lon,SubImplementer,ViliCode")] FacilityInfo facilityInfo)
{
if (id != facilityInfo.FacilityId)
{
return(NotFound());
}
if (ModelState.IsValid)
{
try
{
_context.Update(facilityInfo);
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!FacilityInfoExists(facilityInfo.FacilityId))
{
return(NotFound());
}
else
{
throw;
}
}
return(RedirectToAction("Index"));
}
var users = _db.Users.Where(m => m.Active.Equals(true)).Select(m => new ApplicationUser()
{
FirstName = m.FirstName + " " + m.LastName + "-" + m.UserName,
UserName = m.UserName,
}).ToList();
ViewData["User"] = new SelectList(users, "UserName", "FirstName", facilityInfo.User);
ViewData["DistCode"] = new SelectList(_context.Districts, "DistCode", "DistName", facilityInfo.DistCode);
return(View(facilityInfo));
}
public AlarmTemporaryInfo GetAlarmTemporaryByID(int alarmTemporaryDID)
{
DataTable tb = getAlarmTemporaryByID(alarmTemporaryDID);
if (tb != null && tb.Rows.Count > 0)
{
AlarmTemporaryInfo info = new AlarmTemporaryInfo();
info.AlarmTemporaryDID = int.Parse(tb.Rows[0][0].ToString());
info.RuleDID = tb.Rows[0][1].ToString();
info.FacilityDID = int.Parse(tb.Rows[0][2].ToString());
info.AlarmTime = DateTime.Parse(tb.Rows[0][3].ToString());
if (tb.Rows[0][4].ToString() != "")
{
info.DisposeState = int.Parse(tb.Rows[0][4].ToString());
}
if (tb.Rows[0][5].ToString() != "")
{
info.DisposeTime = DateTime.Parse(tb.Rows[0][5].ToString());
}
info.Handler = tb.Rows[0][6].ToString();
if (tb.Rows[0][7].ToString() != "")
{
info.Duration = int.Parse(tb.Rows[0][7].ToString());
}
info.Address = tb.Rows[0][8].ToString();
info.Remark = tb.Rows[0][9].ToString();
ProductionDB p = new ProductionDB();
FacilityInfo f = p.GetFacilityByID(info.FacilityDID);
info.Facility = f;
return(info);
}
else
{
throw new Exception("执行 getAlarmTemporaryByID 查询到空值");
}
}
public async Task <IActionResult> Edit(int id, [Bind("Implementer,FacilityId,ActiveStatus,DateEstablished,DistCode,FacilityName,FacilityNameDari,FacilityNamePashto,FacilityType,Gpslattitude,Gpslongtitude,Lat,Location,LocationDari,LocationPashto,Lon,SubImplementer,ViliCode")] FacilityInfo facilityInfo)
{
if (id != facilityInfo.FacilityId)
{
return(NotFound());
}
if (ModelState.IsValid)
{
try
{
_context.Update(facilityInfo);
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!FacilityInfoExists(facilityInfo.FacilityId))
{
return(NotFound());
}
else
{
throw;
}
}
return(RedirectToAction("Index"));
}
var items = _context.FacilityTypes.Select(s => new
{
FacTypeCode = s.FacTypeCode,
description = string.Format("{0} - {1}", s.FacTypeCatCode, s.FacType)
});
ViewData["fac"] = new SelectList(items, "FacTypeCode", "description");
ViewData["Districts"] = new SelectList(_context.Districts, "DistCode", "DistName");
return(View(facilityInfo));
}
public void DeleteFacilityInfo(GameObject Object)
{
FacilityInfo Target = null;
foreach (var Info in FacilityList)
{
if (Info.Object == Object)
{
Target = Info;
break;
}
}
if (Target != null)
{
InstalledFacilityAmount--;
CompanyValueCall.GetEconomyValue().GetComponent <EconomyValue>().DeletePersistHistory(Object.name + "'s Upkeep Price");
CompanyValueCall.GetElectricityValue().GetComponent <ElectricityValue>().DeleteObject(Target);
CompanyValueCall.GetEmployeeValue().GetComponent <EmployeeValue>().DeleteLaborInfo(Target);
FacilityList.Remove(Target);
}
}
public HotelViewModel()
{
FriendlyMessage = new List <FriendlyMessage>();
Pager = new PaginationInfo();
Hotel = new HotelInfo();
Hotels = new List <HotelInfo>();
Cities = new List <CityInfo>();
RoomTypes = new List <RoomTypeInfo>();
HotelTypes = new List <HotelTypeInfo>();
Designations = new List <DesignationInfo>();
HotelFacility = new FacilityInfo();
HotelFacilities = new List <FacilityInfo>();
HotelRoomType = new HotelRoomTypeDetailsInfo();
HotelRoomTypes = new List <HotelRoomTypeDetailsInfo>();
ContactPerson = new HotelContactPersonInfo();
ContactPersons = new List <HotelContactPersonInfo>();
HotelFacilityDetails = new List <HotelFacilityDetailsInfo>();
HotelBankFilter = new HotelBankFilter();
Images = new List <AccessoriesInfo>();
}
public DataTable getFacSearch(FacilityInfo facInfo)
{
DataTable dtable = new DataTable();
try
{
SqlConnection con = new SqlConnection(conStr);
SqlCommand sqlCmd = new SqlCommand("select * from Facility_Info where Facility_Name = '" + facInfo.FacilityName + "' and Facility_Code = '" + facInfo.FacilityID + "'", con);
SqlDataReader sqlDr;
con.Open();
sqlDr = sqlCmd.ExecuteReader();
dtable.Load(sqlDr);
con.Close();
}
catch (Exception ex)
{
objNLog.Error("Exception : " + ex.Message);
}
return dtable;
}
public int Ins_FacilityInfo(FacilityInfo facInfo,Clinic clinic,string userID)
{
int flag = 0;
try
{
SqlConnection con = new SqlConnection(conStr);
SqlCommand sqlCmd = new SqlCommand();
sqlCmd.Connection = con;
sqlCmd.CommandText = "sp_set_Facility_Info";
sqlCmd.CommandType = CommandType.StoredProcedure;
SqlParameter FacilityID = sqlCmd.Parameters.Add("@Facility_ID", SqlDbType.VarChar, 15);
if (facInfo.FacilityID != null)
FacilityID.Value = facInfo.FacilityID;
else
FacilityID.Value = Convert.DBNull;
SqlParameter FacilityName = sqlCmd.Parameters.Add("@Facility_Name", SqlDbType.VarChar, 50);
if (facInfo.FacilityName != null)
FacilityName.Value = facInfo.FacilityName;
else
FacilityName.Value = Convert.DBNull;
SqlParameter FacilityAddress = sqlCmd.Parameters.Add("@Facility_Address", SqlDbType.VarChar, 50);
if(facInfo.FacilityAddress != null)
FacilityAddress.Value = facInfo.FacilityAddress;
else
FacilityAddress.Value = Convert.DBNull;
SqlParameter FacilityCity = sqlCmd.Parameters.Add("@Facility_City", SqlDbType.VarChar, 50);
if (facInfo.FacilityCity != null)
FacilityCity.Value = facInfo.FacilityCity;
else
FacilityCity.Value = Convert.DBNull;
SqlParameter FacilityState = sqlCmd.Parameters.Add("@Facility_State", SqlDbType.Char, 2);
if (facInfo.FacilityState != null)
FacilityState.Value = facInfo.FacilityState.ToCharArray();
else
FacilityState.Value = Convert.DBNull;
SqlParameter FacilityZip = sqlCmd.Parameters.Add("@Facility_Zip", SqlDbType.Char, 10);
if (facInfo.FacilityZip != null)
FacilityZip.Value = facInfo.FacilityZip.ToCharArray();
else
FacilityZip.Value = Convert.DBNull;
SqlParameter FacilityTPhone = sqlCmd.Parameters.Add("@Facility_TPhone", SqlDbType.VarChar, 15);
if (facInfo.FacilityTPhone != null)
FacilityTPhone.Value = facInfo.FacilityTPhone;
else
FacilityTPhone.Value = Convert.DBNull;
SqlParameter FacilityFax = sqlCmd.Parameters.Add("@Facility_Fax", SqlDbType.VarChar, 15);
if (FacilityFax != null)
FacilityFax.Value = facInfo.FacilityFax;
else
FacilityFax.Value = Convert.DBNull;
SqlParameter FacilityEMail = sqlCmd.Parameters.Add("@Facility_EMail", SqlDbType.VarChar, 50);
if (facInfo.FacilityEMail != null)
FacilityEMail.Value = facInfo.FacilityEMail;
else
FacilityEMail.Value = Convert.DBNull;
SqlParameter FacilityTaxID = sqlCmd.Parameters.Add("@Facility_TaxID", SqlDbType.VarChar, 20);
if (facInfo.FacilityTaxID != null)
FacilityTaxID.Value = facInfo.FacilityTaxID;
else
FacilityTaxID.Value = Convert.DBNull;
SqlParameter FacilitySpeciality = sqlCmd.Parameters.Add("@Facility_Speciality", SqlDbType.VarChar, 20);
if (facInfo.FacilitySpeciality != null)
FacilitySpeciality.Value = facInfo.FacilitySpeciality;
else
FacilitySpeciality.Value =Convert.DBNull;
SqlParameter FacilityProvID = sqlCmd.Parameters.Add("@Facility_ProvID", SqlDbType.VarChar, 20);
if (facInfo.FacilityProvID != null)
FacilityProvID.Value = facInfo.FacilityProvID;
else
FacilityProvID.Value = Convert.DBNull;
SqlParameter ClinicID = sqlCmd.Parameters.Add("@ClinicID",SqlDbType.Int);
if (clinic.ClinicID != null)
ClinicID.Value = clinic.ClinicID;
else
ClinicID.Value = Convert.DBNull;
SqlParameter pUserID = sqlCmd.Parameters.Add("@UserID", SqlDbType.VarChar, 20);
pUserID.Value = userID;
SqlParameter parmIsStamps = sqlCmd.Parameters.Add("@IsStamps", SqlDbType.Char, 1);
parmIsStamps.Value = facInfo.IsStamps;
con.Open();
sqlCmd.ExecuteNonQuery();
flag = 1;
con.Close();
}
catch (Exception ex)
{
objNLog.Error("Exception : " + ex.Message);
}
return flag;
}
public int Delete_facInfo(FacilityInfo facInfo,string userID)
{
int flag = 0;
try
{
SqlConnection con = new SqlConnection(conStr);
SqlCommand sqlCmd = new SqlCommand();
sqlCmd.Connection = con;
sqlCmd.CommandText = "sp_delete_Facility_Info";
sqlCmd.CommandType = CommandType.StoredProcedure;
SqlParameter FacilityNo = sqlCmd.Parameters.Add("@Facility_No", SqlDbType.Int);
FacilityNo.Value = facInfo.FacilityNO;
SqlParameter pUserID = sqlCmd.Parameters.Add("@UserID", SqlDbType.VarChar, 20);
pUserID.Value = userID;
SqlParameter parmFlag = sqlCmd.Parameters.Add("@Flag", SqlDbType.Int);
parmFlag.Direction = ParameterDirection.Output;
con.Open();
sqlCmd.ExecuteNonQuery();
flag = (int)parmFlag.Value;
con.Close();
}
catch (Exception ex)
{
objNLog.Error("Exception : " + ex.Message);
}
return flag ;
}
public DataTable get_LocationNamesByName(string prefixText)
{
SqlConnection sqlCon = new SqlConnection(conStr);
FacilityInfo facInfo = new FacilityInfo();
string Fac_Search_String = prefixText;
string[] words = Fac_Search_String.Split(',');
facInfo.FacilityName = words[0];
facInfo.FacilityID = words[1];
string sqlQuery = "select Facility_ID from Facility_Info where Facility_Name = '" + facInfo.FacilityName + "' and Facility_Code = '" +facInfo.FacilityID+"'";
SqlDataAdapter sqlDa = new SqlDataAdapter(sqlQuery, sqlCon);
DataSet dsLocnames = new DataSet();
try
{
sqlDa.Fill(dsLocnames, "Names");
}
catch (Exception ex)
{
objNLog.Error("Exception : " + ex.Message);
}
return dsLocnames.Tables["Names"];
}
public void Update(FacilityInfo facility)
{
_sqlHelper.ExecuteNonQuery(SetValuesInFacility(facility), Storeprocedures.spUpdateFacility.ToString(), CommandType.StoredProcedure);
}
public int Insert(FacilityInfo facility)
{
return(Convert.ToInt32(_sqlHelper.ExecuteScalerObj(SetValuesInFacility(facility), Storeprocedures.spInsertFacility.ToString(), CommandType.StoredProcedure)));
}
public int getFacilityID(FacilityInfo facInfo)
{
SqlConnection con = new SqlConnection(ConStr);
SqlCommand sqlCmd = new SqlCommand("select Facility_ID from Facility_Info where Facility_Name = '" + facInfo.FacilityName + "'", con);
// SqlDataReader sqlDr;
// DataTable dtable = new DataTable();
// DataRow dr;
con.Open();
int FacilityID = Convert.ToInt32(sqlCmd.ExecuteScalar());
con.Close();
return FacilityID;
}
/// <summary>
/// GetFacilities by craftDID
/// </summary>
/// <param name="craftDID">craftDID</param>
/// <returns></returns>
public IList <FacilityInfo> GetFacilities(int craftDID)
{
List <FacilityInfo> lst = new List <FacilityInfo>();
DataTable dt = getFacilities(craftDID);
if (dt != null && dt.Rows.Count > 0)
{
foreach (DataRow row in dt.Rows)
{
FacilityInfo info = new FacilityInfo();
info.FacilityDID = int.Parse(row[0].ToString());
info.MMName = row[1].ToString();
info.ProcessDID = int.Parse(row[2].ToString());
info.DeviceGroupDID = int.Parse(row[3].ToString());
info.State = int.Parse(row[4].ToString());
info.MMIP = row[5].ToString();
info.MMPort = row[6].ToString();
info.MMIsUse = row[7].ToString() == "1" ? true : false;
info.MMClearAddr = row[8].ToString();
info.MMRestAddr = row[9].ToString();
if (row[10].ToString() != "")
{
info.MMSeq = int.Parse(row[10].ToString());
}
info.MAAddress = row[11].ToString();
info.IsUse = row[12].ToString() == "1" ? true : false;
info.Remark = row[13].ToString();
ProcessInfo processInfo = new ProcessInfo();
DataTable tbProcess = getProcessesByID(info.ProcessDID);
if (tbProcess != null && tbProcess.Rows.Count > 0)
{
processInfo.ProcessDID = int.Parse(tbProcess.Rows[0][0].ToString());
processInfo.ProcessNO = tbProcess.Rows[0][1].ToString();
processInfo.ProcessName = tbProcess.Rows[0][2].ToString();
processInfo.CraftDID = int.Parse(tbProcess.Rows[0][3].ToString());
DataTable tb = getCraftsByID(processInfo.CraftDID);
if (tb != null && tb.Rows.Count > 0)
{
CraftInfo craftInfo = new CraftInfo();
craftInfo.CraftDID = processInfo.CraftDID;
craftInfo.CraftNO = tb.Rows[0][1].ToString();
craftInfo.CraftName = tb.Rows[0][2].ToString();
processInfo.Craft = craftInfo;
}
else
{
processInfo.Craft = null;
throw new Exception("执行getCraftsByID查询为空");
}
info.Process = processInfo;
}
else
{
info.Process = null;
processInfo = null;
throw new Exception("执行getProcessesByID查询为空");
}
DataTable tbDeviceGroup = getDeviceGroupByID(info.DeviceGroupDID);
if (tbDeviceGroup != null && tbDeviceGroup.Rows.Count > 0)
{
DeviceGroupInfo deviceGroupInfo = new DeviceGroupInfo();
deviceGroupInfo.DeviceGroupDID = info.DeviceGroupDID;
deviceGroupInfo.DeviceGroupNO = tbDeviceGroup.Rows[0][1].ToString();
deviceGroupInfo.DeviceGroupName = tbDeviceGroup.Rows[0][2].ToString();
deviceGroupInfo.CraftDID = int.Parse(tbDeviceGroup.Rows[0][3].ToString());
DataTable tb = getCraftsByID(deviceGroupInfo.CraftDID);
if (tb != null && tb.Rows.Count > 0)
{
CraftInfo craftInfo = new CraftInfo();
craftInfo.CraftDID = processInfo.CraftDID;
craftInfo.CraftNO = tb.Rows[0][1].ToString();
craftInfo.CraftName = tb.Rows[0][2].ToString();
deviceGroupInfo.Craft = craftInfo;
}
else
{
deviceGroupInfo.Craft = null;
throw new Exception("执行getCraftsByID查询为空");
}
info.DeviceGroup = deviceGroupInfo;
}
else
{
info.DeviceGroup = null;
throw new Exception("执行getDeviceGroupByID查询为空");
}
lst.Add(info);
}
}
return(lst);
}
public DayCareModel ExtractDayCareDetailList(string url)
{
var model = new DayCareModel();
model.FacilityInformation = new FacilityInfo();
model.DaysOpen = new DaysOpen();
model.LicenseeInformation = new LicenseeInfo();
model.LicenseInformation = new LicenseInfo();
model.ServicesOffered = new ServicesOffered();
HtmlDocument doc = web.Load(url);
HtmlNodeCollection dayCareCenterNodes = doc.DocumentNode.SelectNodes("//div[@class='col-lg-6 profile']");
foreach (HtmlNode table in dayCareCenterNodes)
{
var rows = table.SelectNodes("tr");
var title = rows[0].InnerHtml.Replace("\r", "").Replace(" ", "").Replace("\n", "");
if (title.IndexOf("FacilityInformation") > 0)
{
var facilityInformation = new FacilityInfo();
facilityInformation.Name = rows[1].SelectNodes("td")[1].FirstChild.InnerText;
var addressFont = rows[2].SelectNodes("td")[1].SelectNodes("font");
facilityInformation.Street = addressFont[0].InnerText.Replace("\r", "").Replace("\n", "").Replace(" ", "").Trim();
var address = addressFont[3].InnerText;
facilityInformation.City = address.Split(',')[0].Trim();
var stateAndZip = address.Split(',')[1].Replace(" ", ",");
facilityInformation.State = stateAndZip.Split(',')[0].Trim();
facilityInformation.ZipCode = stateAndZip.Split(',')[1].Trim();
//if(facilityInformation.ZipCode.Length>5)
//{
// facilityInformation.ZipCode = facilityInformation.ZipCode.Substring(0, 5);
//}
facilityInformation.ZipOrder = Convert.ToInt32(facilityInformation.ZipCode);
facilityInformation.County = rows[3].SelectNodes("td")[1].SelectSingleNode("font").InnerText;
facilityInformation.Phone = rows[4].SelectNodes("td")[1].SelectSingleNode("font").InnerText;
facilityInformation.LicenseStatus = rows[4].SelectNodes("td")[3].SelectSingleNode("font").InnerText;
facilityInformation.Status = "";
model.FacilityInformation = facilityInformation;
}
if (title.IndexOf("LicenseeInfo") > 0)
{
var licenseeInfo = new LicenseeInfo();
licenseeInfo.Name = rows[1].SelectNodes("td")[1].FirstChild.InnerText;
licenseeInfo.Address = rows[2].SelectNodes("td")[1].FirstChild.InnerText.Replace(" ", "");
licenseeInfo.Phone = rows[3].SelectNodes("td")[1].FirstChild.InnerText.Replace("\r", "").Replace("\n", "").TrimEnd().TrimStart();
model.LicenseeInformation = licenseeInfo;
}
if (title.IndexOf("LicenseInfo") > 0)
{
var licenseInfo = new LicenseInfo();
licenseInfo.Number = rows[2].SelectNodes("td")[0].SelectSingleNode("div").SelectSingleNode("font").InnerText;
licenseInfo.FacilityType = rows[2].SelectNodes("td")[1].SelectSingleNode("div").SelectSingleNode("font").InnerText.Replace("\r", "").Replace("\n", "").TrimEnd().TrimStart();
licenseInfo.Capacity = rows[2].SelectNodes("td")[2].SelectSingleNode("div").SelectSingleNode("font").InnerText;
licenseInfo.EffectiveDate = rows[2].SelectNodes("td")[3].SelectSingleNode("div").SelectSingleNode("font").InnerText;
licenseInfo.ExpirationDate = rows[2].SelectNodes("td")[4].SelectSingleNode("div").SelectSingleNode("font").InnerText;
licenseInfo.PeriodOfOperation = rows[2].SelectNodes("td")[5].SelectSingleNode("div").SelectSingleNode("font").InnerText;
model.LicenseInformation = licenseInfo;
}
if (title.IndexOf("DaysOpen") > 0)
{
var daysOpen = new DaysOpen();
daysOpen.Sunday = rows[2].SelectNodes("td")[0].SelectSingleNode("div").SelectSingleNode("font").InnerText;
daysOpen.Monday = rows[2].SelectNodes("td")[1].SelectSingleNode("div").SelectSingleNode("font").InnerText;
daysOpen.Tuesday = rows[2].SelectNodes("td")[2].SelectSingleNode("div").SelectSingleNode("font").InnerText;
daysOpen.Wednesday = rows[2].SelectNodes("td")[3].SelectSingleNode("div").SelectSingleNode("font").InnerText;
daysOpen.Thursday = rows[2].SelectNodes("td")[4].SelectSingleNode("div").SelectSingleNode("font").InnerText;
daysOpen.Friday = rows[2].SelectNodes("td")[5].SelectSingleNode("div").SelectSingleNode("font").InnerText;
daysOpen.Saturday = rows[2].SelectNodes("td")[6].SelectSingleNode("div").SelectSingleNode("font").InnerText;
model.DaysOpen = daysOpen;
}
if (title.IndexOf("ServicesOffered") > 0)
{
var servicesOffered = new ServicesOffered();
servicesOffered.FullDayProgram = rows[1].SelectNodes("td")[1].SelectSingleNode("font").InnerText;
servicesOffered.Provides = rows[2].SelectNodes("td")[1].SelectSingleNode("font").InnerText.Replace("\r", "").Replace("\n", "").TrimEnd().TrimStart();
model.ServicesOffered = servicesOffered;
}
}
return(model);
}
public FacilityApplyResponse Post([FromBody] FacilityApplyRequest req)
{
FacilityApplyResponse resp = new FacilityApplyResponse();
try
{
if (req.starttime >= req.endtime)
{
resp.result = "fail";
return(resp);
}
//确保申请时间晚于当前
DateTime today = DateTime.Now; //获取当前时间
string applyHour = req.starttime.ToString("00"); //转换小时为字符串
string testTime = req.date.ToString("yyyy-MM-dd") + " " + applyHour + ":00:00"; //连接成申请时刻
if (DateTime.Compare(today, Convert.ToDateTime(testTime)) > 0)
{
resp.result = "fail";
return(resp);
}
MySqlConnection conn = SQLManager.getConn(); //连接数据库
conn.Open(); //打开数据库连接
MySqlCommand test = null; //创建查询指令
test = new MySqlCommand("select start_time,end_time,max_capacity,start_day,end_day " +
"from facilities where facility_ID=?facility;", conn);
test.Parameters.AddWithValue("?facility", req.facility);
MySqlDataReader mdr = test.ExecuteReader();//查询设施信息
if (!mdr.HasRows)
{
resp.result = "wrong facility";//id错误
mdr.Close();
conn.Close();
return(resp);
}
else
{
mdr.Read();
FacilityInfo info = new FacilityInfo(); //存储设施信息类
info.start = Convert.ToInt32(mdr.GetValue(0)); //存储开放起始时间
info.end = Convert.ToInt32(mdr.GetValue(1)); //存储开放结束时间
info.capacity = Convert.ToInt32(mdr.GetValue(2)); //存储容量
info.startday = Convert.ToInt32(mdr.GetValue(3)); //开放起始日期
info.endday = Convert.ToInt32(mdr.GetValue(4)); //开放最后日期
mdr.Close();
if (req.starttime < info.start || req.endtime > info.end) //检查申请时间是否符合要求
{
conn.Close();
resp.result = "invalid time";
return(resp);
}
int weekday = GetWeek(req.date); //转换int星期几
if (weekday < info.startday || weekday > info.endday) //检查日期是否符合要求
{
conn.Close();
resp.result = "invalid date";
return(resp);
}
MySqlCommand cmd = null;//创建查询指令
//查询健康状态
cmd = new MySqlCommand("select currenthealth_status from student " +
"where student_ID=@id;", conn);
cmd.Parameters.AddWithValue("@id", req.id);
mdr = cmd.ExecuteReader();
mdr.Read();
if (!mdr.HasRows)
{
resp.result = "wrong id";//id错误
mdr.Close();
conn.Close();
return(resp);
}
int health = Convert.ToInt32(mdr.GetValue(0));
mdr.Close();
if (health != 0)//若健康状态不为“健康”，申请失败
{
conn.Close();
resp.result = "unqualified";
return(resp);
}
// 查询违约记录
cmd = new MySqlCommand("select count(*) from default_record " +
"where applicant_ID=@id;", conn);
cmd.Parameters.AddWithValue("@id", req.id);
mdr = cmd.ExecuteReader();
mdr.Read();
int count = Convert.ToInt32(mdr.GetValue(0));
mdr.Close();
if (count != 0 && count % 3 == 0)//若违约次数为3的整数倍，检查是否在最近一周违约
{
cmd = new MySqlCommand("select date from default_record " +
"where applicant_ID=@id and count=@count;", conn);
cmd.Parameters.AddWithValue("@id", req.id);
cmd.Parameters.AddWithValue("@count", count);
mdr = cmd.ExecuteReader();
mdr.Read();
DateTime lastdate = Convert.ToDateTime(mdr.GetValue(0));
mdr.Close();
DateTime current = DateTime.Now;
TimeSpan ts1 = new TimeSpan(lastdate.Ticks);
TimeSpan ts2 = new TimeSpan(current.Ticks);
TimeSpan ts = ts1.Subtract(ts2).Duration();
int days = Convert.ToInt32(ts.Days.ToString());
if (days < 7)//最后一次违约记录在7天以内
{
conn.Close();
resp.result = "unqualified";
return(resp);
}
}
string date = req.date.ToString("yyyy-MM-dd");
//检查同一申请人申请时间段是否已有其他申请
cmd = new MySqlCommand("select applicant_ID from application " +
"where applicant_ID=@id and date=@date and " +
"((start_time>=@start and start_time<@end) or (end_time<=@end and end_time>@start));", conn);
cmd.Parameters.AddWithValue("@id", req.id);
cmd.Parameters.AddWithValue("@date", date);
cmd.Parameters.AddWithValue("@start", req.starttime);
cmd.Parameters.AddWithValue("@end", req.endtime);
mdr = cmd.ExecuteReader();
if (mdr.HasRows)//已有其他申请
{
mdr.Close();
conn.Close();
resp.result = "time overlap";
return(resp);
}
mdr.Close();
/*
* int[] quantity;//存储每一时间段人数
* int hours = req.endtime - req.starttime;
* quantity = new int[hours];*/
//查看每一时间段申请总人数
for (int i = req.starttime; i < req.endtime; i++)
{
cmd = new MySqlCommand("select count(*) from application " +
"where facility_ID=@id and date=@date and start_time<=@start and end_time>=@end;", conn);
cmd.Parameters.AddWithValue("@id", req.facility);
cmd.Parameters.AddWithValue("@date", date);
cmd.Parameters.AddWithValue("@start", i);
cmd.Parameters.AddWithValue("@end", i + 1);
mdr = cmd.ExecuteReader();
if (mdr.HasRows)
{
mdr.Read(); /*
* quantity[i - req.starttime] = Convert.ToInt32(mdr.GetValue(0));*/
int number = Convert.ToInt32(mdr.GetValue(0));
if (number >= info.capacity) //若有时间段预约数已达到容量上限，预约失败
{
mdr.Close();
conn.Close();
resp.result = "no left";
return(resp);
}
}/*
* else
* quantity[i - req.starttime] = 0;*/
mdr.Close();
}
//所有条件符合，插入记录
cmd = new MySqlCommand("insert into application (applicant_ID,facility_ID,date,start_time,end_time)" +
"values(@id,@facility,@date,@start,@end);", conn);
cmd.Parameters.AddWithValue("@id", req.id);
cmd.Parameters.AddWithValue("@facility", req.facility);
cmd.Parameters.AddWithValue("@date", date);
cmd.Parameters.AddWithValue("@start", req.starttime);
cmd.Parameters.AddWithValue("@end", req.endtime);
cmd.Prepare();
cmd.ExecuteNonQuery();//执行insert语句
resp.result = "success";
}
conn.Close();//关闭连接
}
catch (Exception ex)
{
Console.WriteLine(ex);
resp.result = "fail";
}
return(resp);
}
public string Update_Patient(PatientName Pat_Name, PatientPersonalDetails Pat_Per_Details, PatientAddress Pat_Add,
PatientInsuranceDetails Pat_Ins_Details, PatientAllergies Pat_Allergies,
FacilityInfo Fac_Info, PharmacyInfo Phrm_Info,ProviderInfo Prov_Info)
{
SqlConnection sqlCon = new SqlConnection(ConStr);
SqlCommand sqlCmd = new SqlCommand("sp_update_Patient", sqlCon);
sqlCmd.CommandType = CommandType.StoredProcedure;
SqlParameter P_ID = sqlCmd.Parameters.Add("@Pat_ID", SqlDbType.Int);
P_ID.Value = Pat_Name.Pat_ID;
SqlParameter P_MName = sqlCmd.Parameters.Add("@Pat_MName", SqlDbType.VarChar, 50);
if (Pat_Name.MiddleName != null)
P_MName.Value = Pat_Name.MiddleName;
else
P_MName.Value = Convert.DBNull;
SqlParameter P_Gender = sqlCmd.Parameters.Add("@Pat_Gender", SqlDbType.Char, 1);
if (Pat_Per_Details.Gender != null)
P_Gender.Value = Pat_Per_Details.Gender;
else
P_Gender.Value = Convert.DBNull;
SqlParameter P_DOB = sqlCmd.Parameters.Add("@Pat_DOB", SqlDbType.DateTime);
if (Pat_Per_Details.DOB != null)
P_DOB.Value = DateTime.Parse(Pat_Per_Details.DOB);
else
{
Nullable<DateTime> NullDate = null;
P_DOB.Value = NullDate;
}
SqlParameter P_SSN = sqlCmd.Parameters.Add("@Pat_SSN", SqlDbType.VarChar, 50);
if (Pat_Per_Details.SSN != null)
P_SSN.Value = Pat_Per_Details.SSN;
else
P_SSN.Value = Convert.DBNull;
SqlParameter P_Address1 = sqlCmd.Parameters.Add("@Pat_Address1", SqlDbType.VarChar, 50);
if (Pat_Add.Address1 != null)
P_Address1.Value = Pat_Add.Address1;
else
P_Address1.Value = Convert.DBNull;
SqlParameter P_Address2 = sqlCmd.Parameters.Add("@Pat_Address2", SqlDbType.VarChar, 50);
if (Pat_Add.Address2 != null)
P_Address2.Value = Pat_Add.Address2;
else
P_Address2.Value = Convert.DBNull;
SqlParameter P_City = sqlCmd.Parameters.Add("@Pat_City", SqlDbType.VarChar, 50);
if (Pat_Add.City != null)
P_City.Value = Pat_Add.City;
else
P_City.Value = Convert.DBNull;
SqlParameter P_State = sqlCmd.Parameters.Add("@Pat_State", SqlDbType.VarChar, 50);
if (Pat_Add.State != null)
P_State.Value = Pat_Add.State;
else
P_State.Value = Convert.DBNull;
SqlParameter P_ZIP = sqlCmd.Parameters.Add("@Pat_Zip", SqlDbType.VarChar, 50);
if (Pat_Add.Zip != null)
P_ZIP.Value = Pat_Add.Zip;
else
P_ZIP.Value = Convert.DBNull;
SqlParameter P_PDoc = sqlCmd.Parameters.Add("@Pat_PDoc", SqlDbType.VarChar, 50);
if (Pat_Per_Details.Pat_Pre_Doc != null)
P_PDoc.Value = Pat_Per_Details.Pat_Pre_Doc;
else
P_PDoc.Value = Convert.DBNull;
SqlParameter P_MRN = sqlCmd.Parameters.Add("@Pat_MRN", SqlDbType.VarChar, 15);
if (Pat_Per_Details.MRN != null)
P_MRN.Value = Pat_Per_Details.MRN;
else
P_MRN.Value = Convert.DBNull;
SqlParameter Fac_ID = sqlCmd.Parameters.Add("@Fac_ID", SqlDbType.Int);
if (Fac_Info.FacilityNO != null)
Fac_ID.Value = Fac_Info.FacilityNO;
else
Fac_ID.Value = Convert.DBNull;
SqlParameter Phrm_ID = sqlCmd.Parameters.Add("@Phrm_ID", SqlDbType.Int);
if (Phrm_Info.PhrmID != null)
Phrm_ID.Value = Phrm_Info.PhrmID;
else
Phrm_ID.Value = Convert.DBNull;
//SqlParameter PI_InsName = sqlCmd.Parameters.Add("@Ins_Name", SqlDbType.VarChar, 50);
//if (Pat_Ins_Details.InsuranceName != null)
// PI_InsName.Value = Pat_Ins_Details.InsuranceName;
//else
// PI_InsName.Value = Convert.DBNull;
int InsID = getInsuranceID(Pat_Ins_Details);
Pat_Ins_Details.InsuranceID = InsID;
SqlParameter Ins_ID = sqlCmd.Parameters.Add("@Ins_ID", SqlDbType.Int);
if (Pat_Ins_Details.InsuranceID.ToString() != "0")
Ins_ID.Value = Pat_Ins_Details.InsuranceID;
else
Ins_ID.Value = Convert.DBNull;
SqlParameter PI_No = sqlCmd.Parameters.Add("@PI_Number", SqlDbType.Int);
if (Pat_Ins_Details.PI_PolicyNo.ToString() != "0")
PI_No.Value = Pat_Ins_Details.PI_PolicyNo;
else
PI_No.Value = Convert.DBNull;
SqlParameter PI_PolicyID = sqlCmd.Parameters.Add("@PI_PolicyID", SqlDbType.Int);
if (Pat_Ins_Details.PI_PolicyID.ToString() != "0")
PI_PolicyID.Value = Pat_Ins_Details.PI_PolicyID;
else
PI_PolicyID.Value = Convert.DBNull;
SqlParameter PI_GroupNo = sqlCmd.Parameters.Add("@PI_GroupNo", SqlDbType.Int);
if (Pat_Ins_Details.PI_GroupNo.ToString() != "0")
PI_GroupNo.Value = Pat_Ins_Details.PI_GroupNo;
else
PI_GroupNo.Value = Convert.DBNull;
SqlParameter PI_BINNo = sqlCmd.Parameters.Add("@PI_BINNo", SqlDbType.Int);
if (Pat_Ins_Details.PI_BINNo.ToString() != "0")
PI_BINNo.Value = Pat_Ins_Details.PI_BINNo;
else
PI_BINNo.Value = Convert.DBNull;
SqlParameter PI_InsdName = sqlCmd.Parameters.Add("@PI_InsdName", SqlDbType.VarChar, 50);
if (Pat_Ins_Details.InsuredName != null)
PI_InsdName.Value = Pat_Ins_Details.InsuredName;
else
PI_InsdName.Value = Convert.DBNull;
SqlParameter PI_InsdDOB = sqlCmd.Parameters.Add("@PI_InsdDOB", SqlDbType.DateTime);
if (Pat_Ins_Details.InsuredDOB != null)
PI_InsdDOB.Value = DateTime.Parse( Pat_Ins_Details.InsuredDOB);
else
{
Nullable<DateTime> NullDate = null;
PI_InsdDOB.Value = NullDate;
}
SqlParameter PI_InsdSSN = sqlCmd.Parameters.Add("@PI_InsdSSN", SqlDbType.VarChar, 50);
if (Pat_Ins_Details.InsuredSSN != null)
PI_InsdSSN.Value = Pat_Ins_Details.InsuredSSN;
else
PI_InsdSSN.Value = Convert.DBNull;
SqlParameter PI_InsdRel = sqlCmd.Parameters.Add("@PI_InsdRel", SqlDbType.VarChar, 50);
if (Pat_Ins_Details.InsuredRelation != null)
PI_InsdRel.Value = Pat_Ins_Details.InsuredRelation;
else
PI_InsdRel.Value = Convert.DBNull;
SqlParameter PA_Desc = sqlCmd.Parameters.Add("@PA_Desc", SqlDbType.VarChar, 200);
if (Pat_Allergies.AllergyDescription != null)
PA_Desc.Value = Pat_Allergies.AllergyDescription;
else
PA_Desc.Value = Convert.DBNull;
try
{
sqlCon.Open();
sqlCmd.ExecuteNonQuery();
}
catch (Exception ex)
{
return ex.ToString();
}
finally
{
sqlCon.Close();
}
return "Updated Patient Information Successfully";
}
public MockBredInfo()
{
FacilityInfo.AddRange(MockFacility.Facilities);
}
public void BuyFacility(FacilityInfo facilityInformation)
{
PlayerStats.instance.ChangeCompanyFunds(-facilityInformation.costToBuy);
ChangeFacility(facilityInformation);
}
public string getFacilityName(FacilityInfo facInfo)
{
SqlConnection con = new SqlConnection(ConStr);
SqlCommand sqlCmd = new SqlCommand("select Facility_Name from Facility_Info where Facility_ID = '" + facInfo.FacilityNO + "'", con);
// SqlDataReader sqlDr;
// DataTable dtable = new DataTable();
// DataRow dr;
con.Open();
string FacilityName = sqlCmd.ExecuteScalar().ToString();
con.Close();
return FacilityName;
}
void InitializingArray()
{
string[] FieldName;
List <string[]> DataList;
TechInfoList = new List <TechInfo>();
FieldName = new string[] { "Name", "UnlockFacility", "UnlockActor", "UpgradeType", "UpgradeAmount", "RequiredIndex", "RequiredValue", "WorkLoad" };
DataList = new List <string[]>();
xmlReader.xmlReaderAccess.ReadXml("Data/Tech/XML/TechInfo", "TechInfo/Tech", FieldName, DataList);
foreach (string[] Data in DataList)
{
TechInfo newRecipe = new TechInfo();
newRecipe.Name = Data[0];
newRecipe.UnlockFacility = Data[1].Split(',');
newRecipe.UnlockActor = Data[2].Split(',');
newRecipe.UpgradeValueType = Data[3];
newRecipe.UpgradeValueAmount = System.Convert.ToSingle(Data[4]);
string[] RequiredIndex = Data[5].Split(',');
newRecipe.RequiredTech = new int[RequiredIndex.Length];
for (int i = 0; i < RequiredIndex.Length; i++)
{
newRecipe.RequiredTech[i] = System.Convert.ToInt32(RequiredIndex[i]);
}
newRecipe.RequiredValue = System.Convert.ToInt32(Data[6]);
newRecipe.RequiredWorkLoad = System.Convert.ToInt32(Data[7]);
TechInfoList.Add(newRecipe);
}
FacilityList = new List <FacilityInfo>();
FieldName = new string[] { "Type", "Name", "Price", "UpkeepPrice", "UpkeepMonthTerm", "ElectricConsum", "LaborRequirement" };
DataList = new List <string[]>();
xmlReader.xmlReaderAccess.ReadXml("Data/Tech/XML/FacilityInfo", "FacilityInfo/Facility", FieldName, DataList);
foreach (string[] Data in DataList)
{
FacilityInfo newFacility = new FacilityInfo();
newFacility.Type = Data[0];
newFacility.Name = Data[1];
newFacility.Price = System.Convert.ToInt32(Data[2]);
newFacility.UpkeepPrice = System.Convert.ToInt32(Data[3]);
newFacility.UpkeepMonthTerm = System.Convert.ToInt32(Data[4]);
newFacility.ElectricConsum = System.Convert.ToSingle(Data[5]);
newFacility.LaborRequirement = System.Convert.ToSingle(Data[6]);
newFacility.Object = Resources.Load <GameObject>("GameSystem/InstallableObject/Object/" + newFacility.Name);
FacilityList.Add(newFacility);
}
ProcessorList = new List <ProcessorInfo>();
FieldName = new string[] { "Type", "Name", "PerformanceQuality", "PerformanceSpeed", "ActorList" };
DataList = new List <string[]>();
xmlReader.xmlReaderAccess.ReadXml("Data/Tech/XML/ProcessorInfo", "ProcessorInfo/Processor", FieldName, DataList);
foreach (string[] Data in DataList)
{
ProcessorInfo newProcessor = new ProcessorInfo();
newProcessor.Type = Data[0];
newProcessor.Name = Data[1];
newProcessor.PerformanceQuality = System.Convert.ToSingle(Data[2]);
newProcessor.PerformanceSpeed = System.Convert.ToSingle(Data[3]);
newProcessor.ActorList = Data[4].Split(',');
ProcessorList.Add(newProcessor);
}
ActorList = new List <ProcessActorInfo>();
FieldName = new string[] { "Name", "TechPoint", "Cost" };
DataList = new List <string[]>();
xmlReader.xmlReaderAccess.ReadXml("Data/Tech/XML/ActorInfo", "ActorInfo/Actor", FieldName, DataList);
foreach (string[] Data in DataList)
{
ProcessActorInfo newActor = new ProcessActorInfo();
newActor.Name = Data[0];
newActor.TechPoint = System.Convert.ToSingle(Data[1]);
newActor.Cost = System.Convert.ToInt32(Data[2]);
ActorList.Add(newActor);
}
}
public static FacilityModel ToModel(this FacilityInfo entity)
{
return(Mapper.Map <FacilityInfo, FacilityModel>(entity));
}
