private Procedure CalculateScreenTimeWindow(ProcedureEntity procedureEntity)
{
if (procedureEntity == null)
{
return(null);
}
string currentTime = procedureEntity.CurrentTime.ToString("HH:mm");
Procedure procedure = new Procedure(currentTime);
int.TryParse(procedureEntity.CurrentTime.ToString("HH"), out int currentHour);
// set the startpoint and end point of the procedure screen.
// start point is -2hr of the current hour and end is +8hr of start hour
// below logic is to handle if current time is 0 hr, 1 hr
int stPoint = (currentHour - 2) % 24;
if (stPoint < 0)
{
stPoint += 24;
}
procedure.StartTime = Helper.StringToIntTime($"{stPoint.ToString()}:00");
procedure.EndTime = Helper.StringToIntTime($"{((currentHour + 6) % 24).ToString()}:00");
return(procedure);
}
public List <ProcedureEntity> GetDataFromDB(ProjectAllocationFramework.Statues.ProgressChangedEventHandler OnProgress, ProcedureSearchCondtion searchCondition = null)
{
List <ProcedureEntity> entityList = new List <ProcedureEntity>();
string sql = "select ProcedureCode, ProcedureName, Percent FROM [Procedure] WHERE 1=1 and ProcedureCode like @ProcedureCode and ProcedureName like @ProcedureName ORDER BY ProcedureCode";
DbCommand cmd = DatabaseUtil.GetCommand(db.GetSqlStringCommand(sql));
string procedureCode = string.Empty;
string procedureName = string.Empty;
if (searchCondition != null)
{
procedureCode = searchCondition.ProcedureCode.Trim();
procedureName = searchCondition.ProcedureName.Trim();
}
db.AddInParameter(cmd, "ProcedureCode", DbType.String, '%' + procedureCode + '%');
db.AddInParameter(cmd, "ProcedureName", DbType.String, '%' + procedureName + '%');
using (IDataReader reader = db.ExecuteReader(cmd))
{
while (reader.Read())
{
ProcedureEntity item = new ProcedureEntity();
item.ProcedureCode = ConvertUtil.ToString(reader["ProcedureCode"]);
item.ProcedureName = ConvertUtil.ToString(reader["ProcedureName"]);
item.Percent = ConvertUtil.ToString(reader["Percent"]);
item.Action = Constant.ACTION_UPDATE;
item.ReadOnly = true;
//throw new Exception();
entityList.Add(item);
}
}
return(entityList);
}
public StructureModel(ProcedureEntity procedureEntity)
{
Type = "v";
Name = procedureEntity.ProcedureName;
if (string.IsNullOrEmpty(procedureEntity.Comment) == false)
{
Comment = procedureEntity.Comment;
}
Items = new List <StructureItemModel>();
}
private PatientInfo GetPatientData(ProcedureEntity pro)
{
PatientInfo patientInfo = new PatientInfo();
patientInfo.Name = $"{pro.FirstName},{pro.LastName}";
patientInfo.Info = pro.MRN;
patientInfo.SurgeonName = $"{pro.SurgeonFirstName},{pro.SurgeonLastName}";
patientInfo.Anesthologist = $"{pro.AnestFirstName},{pro.AnestLastName}";
patientInfo.Crna = $"{pro.CrnaFirstName},{pro.CrnaLastName}";
patientInfo.CircleNurse = $"{pro.NuresFirstName},{pro.NurseLastName}";
return(patientInfo);
}
public ProcedureEntity GetProcedure(string connStr, string databaseName, string schemaName, string procedureName)
{
var sql = $"SHOW PROCEDURE STATUS WHERE Db='{databaseName}' and Name='{procedureName}'";
var helper = SqlHelperFactory.OpenDatabase(connStr, _provider.GetProviderFactory(), SqlType.MySql);
var dt = helper.ExecuteDataTable(sql);
helper.Dispose();
ProcedureEntity result = new ProcedureEntity();
result.DatabaseName = databaseName;
result.ProcedureName = procedureName;
result.Comment = dt.Rows[0]["Comment"].ToString();
result.Params = GetProcedureParams(connStr, databaseName, schemaName, procedureName);
return(result);
}
public List <ProcedureEntity> GetProcedures(string connStr, string databaseName)
{
var sql = $"SHOW PROCEDURE STATUS WHERE Db='{databaseName}'";
var helper = SqlHelperFactory.OpenDatabase(connStr, _provider.GetProviderFactory(), SqlType.MySql);
var dt = helper.ExecuteDataTable(sql);
helper.Dispose();
List <ProcedureEntity> procedureEntities = new List <ProcedureEntity>();
for (int i = 0; i < dt.Rows.Count; i++)
{
var row = dt.Rows[i];
var entity = new ProcedureEntity {
DatabaseName = row["Db"].ToString(),
ProcedureName = row["Name"].ToString(),
Comment = row["Comment"].ToString(),
};
procedureEntities.Add(entity);
}
return(procedureEntities);
}
public override IList <ProcedureEntity> GetProcedures(DataBaseEntity database)
{
IList <ProcedureEntity> list = null;
using (MySqlConnection connection = new MySqlConnection(database.DbConnectionStringBuilder.ConnectionString))
{
connection.Open();
DataTable procedures = connection.GetSchema(SqlClientMetaDataCollectionNames.Procedures, new string[] { null, null, null, "PROCEDURE" });
if (procedures != null && procedures.Rows.Count > 0)
{
list = new List <ProcedureEntity>();
foreach (DataRow procedure in procedures.Rows)
{
string name = string.Format("{0}", procedure["SPECIFIC_NAME"]);
string des = string.Format("{0}.{1}", procedure["ROUTINE_SCHEMA"], procedure["SPECIFIC_NAME"]);
ProcedureEntity proc = new ProcedureEntity(database.DbConnectionStringBuilder, name, des);
proc.DataBase = database;
list.Add(proc);
}
}
}
return(list);
}
public List <ProcedureEntity> GetData(params object[] paras)
{
this.EndEdit();
List <ProcedureEntity> entityList = new List <ProcedureEntity>();
int rowIdx = 1;
foreach (DataGridViewRow item in this.Rows)
{
ProcedureEntity entity = new ProcedureEntity();
entity.Del = ConvertUtil.ToBoolean(item.Cells[this.delColumn.Name].Value);
entity.ProcedureCode = ConvertUtil.ToString(item.Cells[this.procedureCodeColumn.Name].Value);
entity.ProcedureName = ConvertUtil.ToString(item.Cells[this.procedureNameColumn.Name].Value);
entity.Percent = ConvertUtil.ToString(item.Cells[this.percentColumn.Name].Value, "0.00");
entity.ReadOnly = item.Cells[this.procedureCodeColumn.Name].ReadOnly;
entity.Row = rowIdx;
rowIdx++;
if (!string.IsNullOrEmpty(entity.ProcedureCode))
{
entityList.Add(entity);
}
}
return(entityList);
}
