private void butAddProc_Click(object sender, EventArgs e)
{
List <GridColumn> listGridCols = new List <GridColumn>()
{
new GridColumn(Lan.g(this, "Code"), 70),
new GridColumn(Lan.g(this, "Abbreviation"), 90, HorizontalAlignment.Center),
new GridColumn(Lan.g(this, "Description"), 0, HorizontalAlignment.Right)
};
List <ProcedureCode> listMouthProcCodes = ProcedureCodes.GetProcCodesByTreatmentArea(false, TreatmentArea.Mouth, TreatmentArea.None)
.OrderBy(x => x.ProcCode).ToList();
List <GridRow> listGridRows = new List <GridRow>();
listMouthProcCodes.ForEach(x => {
GridRow row = new GridRow(x.ProcCode, x.AbbrDesc, x.Descript);
row.Tag = x;
listGridRows.Add(row);
});
FormGridSelection formGridSelect = new FormGridSelection(listGridCols, listGridRows, "Add Procedure", "Procedures");
if (formGridSelect.ShowDialog() != DialogResult.OK)
{
return;
}
foreach (object tag in formGridSelect.ListSelectedTags)
{
string fieldName = "Proc:" + ((ProcedureCode)tag).ProcCode;
listBoxFields.Items.Add(new ODBoxItem <SheetFieldDef>(fieldName, SheetFieldDef.NewCheckBox(fieldName, 0, 0, 0, 0)));
listBoxFields.SetSelected(listBoxFields.Items.Count - 1, true);
}
}
private void AddProblem(SheetFieldDef SheetFieldDefCur)
{
if (!Security.IsAuthorized(Permissions.ProblemEdit))
{
return;
}
DiseaseDef def = new DiseaseDef()
{
ICD9Code = "",
Icd10Code = "",
SnomedCode = "",
ItemOrder = DiseaseDefs.GetCount(),
DiseaseName = SheetFieldDefCur?.FieldName.Replace("problem:", "") ?? ""
};
FormDiseaseDefEdit formDDE = new FormDiseaseDefEdit(def, false);
formDDE.IsNew = true;
formDDE.ShowDialog();
if (formDDE.DialogResult != DialogResult.OK)
{
return;
}
DiseaseDefs.Insert(formDDE.DiseaseDefCur);
DataValid.SetInvalid(InvalidType.Diseases);
_listDiseaseDefs = DiseaseDefs.GetDeepCopy(true);
SecurityLogs.MakeLogEntry(Permissions.ProblemEdit, 0, formDDE.SecurityLogMsgText);
FillListMedical(MedicalListType.problem);
}
///<summary>Attempts to return a corresponding control for the given fieldDef from dictControls.
///Returns null if not found.</summary>
private Control GetControlForField(SheetFieldDef sheetFieldDef, Dictionary <string, Control> dictionaryControls)
{
Control control;
dictionaryControls.TryGetValue(sheetFieldDef.FieldName, out control);
return(control); //Can be null
}
///<summary>Converts a DataTable to a list of objects.</summary>
public static List<SheetFieldDef> TableToList(DataTable table){
List<SheetFieldDef> retVal=new List<SheetFieldDef>();
SheetFieldDef sheetFieldDef;
for(int i=0;i<table.Rows.Count;i++) {
sheetFieldDef=new SheetFieldDef();
sheetFieldDef.SheetFieldDefNum= PIn.Long (table.Rows[i]["SheetFieldDefNum"].ToString());
sheetFieldDef.SheetDefNum = PIn.Long (table.Rows[i]["SheetDefNum"].ToString());
sheetFieldDef.FieldType = (SheetFieldType)PIn.Int(table.Rows[i]["FieldType"].ToString());
sheetFieldDef.FieldName = PIn.String(table.Rows[i]["FieldName"].ToString());
sheetFieldDef.FieldValue = PIn.String(table.Rows[i]["FieldValue"].ToString());
sheetFieldDef.FontSize = PIn.Float (table.Rows[i]["FontSize"].ToString());
sheetFieldDef.FontName = PIn.String(table.Rows[i]["FontName"].ToString());
sheetFieldDef.FontIsBold = PIn.Bool (table.Rows[i]["FontIsBold"].ToString());
sheetFieldDef.XPos = PIn.Int (table.Rows[i]["XPos"].ToString());
sheetFieldDef.YPos = PIn.Int (table.Rows[i]["YPos"].ToString());
sheetFieldDef.Width = PIn.Int (table.Rows[i]["Width"].ToString());
sheetFieldDef.Height = PIn.Int (table.Rows[i]["Height"].ToString());
sheetFieldDef.GrowthBehavior = (GrowthBehaviorEnum)PIn.Int(table.Rows[i]["GrowthBehavior"].ToString());
sheetFieldDef.RadioButtonValue= PIn.String(table.Rows[i]["RadioButtonValue"].ToString());
sheetFieldDef.RadioButtonGroup= PIn.String(table.Rows[i]["RadioButtonGroup"].ToString());
sheetFieldDef.IsRequired = PIn.Bool (table.Rows[i]["IsRequired"].ToString());
sheetFieldDef.TabOrder = PIn.Int (table.Rows[i]["TabOrder"].ToString());
sheetFieldDef.ReportableName = PIn.String(table.Rows[i]["ReportableName"].ToString());
retVal.Add(sheetFieldDef);
}
return retVal;
}
///<summary>Converts a DataTable to a list of objects.</summary>
public static List<SheetFieldDef> TableToList(DataTable table){
List<SheetFieldDef> retVal=new List<SheetFieldDef>();
SheetFieldDef sheetFieldDef;
for(int i=0;i<table.Rows.Count;i++) {
sheetFieldDef=new SheetFieldDef();
sheetFieldDef.SheetFieldDefNum= PIn.Long (table.Rows[i]["SheetFieldDefNum"].ToString());
sheetFieldDef.SheetDefNum = PIn.Long (table.Rows[i]["SheetDefNum"].ToString());
sheetFieldDef.FieldType = (OpenDentBusiness.SheetFieldType)PIn.Int(table.Rows[i]["FieldType"].ToString());
sheetFieldDef.FieldName = PIn.String(table.Rows[i]["FieldName"].ToString());
sheetFieldDef.FieldValue = PIn.String(table.Rows[i]["FieldValue"].ToString());
sheetFieldDef.FontSize = PIn.Float (table.Rows[i]["FontSize"].ToString());
sheetFieldDef.FontName = PIn.String(table.Rows[i]["FontName"].ToString());
sheetFieldDef.FontIsBold = PIn.Bool (table.Rows[i]["FontIsBold"].ToString());
sheetFieldDef.XPos = PIn.Int (table.Rows[i]["XPos"].ToString());
sheetFieldDef.YPos = PIn.Int (table.Rows[i]["YPos"].ToString());
sheetFieldDef.Width = PIn.Int (table.Rows[i]["Width"].ToString());
sheetFieldDef.Height = PIn.Int (table.Rows[i]["Height"].ToString());
sheetFieldDef.GrowthBehavior = (OpenDentBusiness.GrowthBehaviorEnum)PIn.Int(table.Rows[i]["GrowthBehavior"].ToString());
sheetFieldDef.RadioButtonValue= PIn.String(table.Rows[i]["RadioButtonValue"].ToString());
sheetFieldDef.RadioButtonGroup= PIn.String(table.Rows[i]["RadioButtonGroup"].ToString());
sheetFieldDef.IsRequired = PIn.Bool (table.Rows[i]["IsRequired"].ToString());
sheetFieldDef.TabOrder = PIn.Int (table.Rows[i]["TabOrder"].ToString());
sheetFieldDef.ReportableName = PIn.String(table.Rows[i]["ReportableName"].ToString());
sheetFieldDef.TextAlign = (System.Windows.Forms.HorizontalAlignment)PIn.Int(table.Rows[i]["TextAlign"].ToString());
sheetFieldDef.IsPaymentOption = PIn.Bool (table.Rows[i]["IsPaymentOption"].ToString());
sheetFieldDef.ItemColor = Color.FromArgb(PIn.Int(table.Rows[i]["ItemColor"].ToString()));
retVal.Add(sheetFieldDef);
}
return retVal;
}
///<summary>Converts a DataTable to a list of objects.</summary>
public static List <SheetFieldDef> TableToList(DataTable table)
{
List <SheetFieldDef> retVal = new List <SheetFieldDef>();
SheetFieldDef sheetFieldDef;
foreach (DataRow row in table.Rows)
{
sheetFieldDef = new SheetFieldDef();
sheetFieldDef.SheetFieldDefNum = PIn.Long(row["SheetFieldDefNum"].ToString());
sheetFieldDef.SheetDefNum = PIn.Long(row["SheetDefNum"].ToString());
sheetFieldDef.FieldType = (OpenDentBusiness.SheetFieldType)PIn.Int(row["FieldType"].ToString());
sheetFieldDef.FieldName = PIn.String(row["FieldName"].ToString());
sheetFieldDef.FieldValue = PIn.String(row["FieldValue"].ToString());
sheetFieldDef.FontSize = PIn.Float(row["FontSize"].ToString());
sheetFieldDef.FontName = PIn.String(row["FontName"].ToString());
sheetFieldDef.FontIsBold = PIn.Bool(row["FontIsBold"].ToString());
sheetFieldDef.XPos = PIn.Int(row["XPos"].ToString());
sheetFieldDef.YPos = PIn.Int(row["YPos"].ToString());
sheetFieldDef.Width = PIn.Int(row["Width"].ToString());
sheetFieldDef.Height = PIn.Int(row["Height"].ToString());
sheetFieldDef.GrowthBehavior = (OpenDentBusiness.GrowthBehaviorEnum)PIn.Int(row["GrowthBehavior"].ToString());
sheetFieldDef.RadioButtonValue = PIn.String(row["RadioButtonValue"].ToString());
sheetFieldDef.RadioButtonGroup = PIn.String(row["RadioButtonGroup"].ToString());
sheetFieldDef.IsRequired = PIn.Bool(row["IsRequired"].ToString());
sheetFieldDef.TabOrder = PIn.Int(row["TabOrder"].ToString());
sheetFieldDef.ReportableName = PIn.String(row["ReportableName"].ToString());
sheetFieldDef.TextAlign = (System.Windows.Forms.HorizontalAlignment)PIn.Int(row["TextAlign"].ToString());
sheetFieldDef.IsPaymentOption = PIn.Bool(row["IsPaymentOption"].ToString());
sheetFieldDef.IsLocked = PIn.Bool(row["IsLocked"].ToString());
sheetFieldDef.ItemColor = Color.FromArgb(PIn.Int(row["ItemColor"].ToString()));
retVal.Add(sheetFieldDef);
}
return(retVal);
}
///<summary>Updates one SheetFieldDef in the database.</summary>
public static void Update(SheetFieldDef sheetFieldDef)
{
string command = "UPDATE sheetfielddef SET "
+ "SheetDefNum = " + POut.Long(sheetFieldDef.SheetDefNum) + ", "
+ "FieldType = " + POut.Int((int)sheetFieldDef.FieldType) + ", "
+ "FieldName = '" + POut.String(sheetFieldDef.FieldName) + "', "
+ "FieldValue = " + DbHelper.ParamChar + "paramFieldValue, "
+ "FontSize = " + POut.Float(sheetFieldDef.FontSize) + ", "
+ "FontName = '" + POut.String(sheetFieldDef.FontName) + "', "
+ "FontIsBold = " + POut.Bool(sheetFieldDef.FontIsBold) + ", "
+ "XPos = " + POut.Int(sheetFieldDef.XPos) + ", "
+ "YPos = " + POut.Int(sheetFieldDef.YPos) + ", "
+ "Width = " + POut.Int(sheetFieldDef.Width) + ", "
+ "Height = " + POut.Int(sheetFieldDef.Height) + ", "
+ "GrowthBehavior = " + POut.Int((int)sheetFieldDef.GrowthBehavior) + ", "
+ "RadioButtonValue= '" + POut.String(sheetFieldDef.RadioButtonValue) + "', "
+ "RadioButtonGroup= '" + POut.String(sheetFieldDef.RadioButtonGroup) + "', "
+ "IsRequired = " + POut.Bool(sheetFieldDef.IsRequired) + ", "
+ "TabOrder = " + POut.Int(sheetFieldDef.TabOrder) + ", "
+ "ReportableName = '" + POut.String(sheetFieldDef.ReportableName) + "' "
+ "WHERE SheetFieldDefNum = " + POut.Long(sheetFieldDef.SheetFieldDefNum);
if (sheetFieldDef.FieldValue == null)
{
sheetFieldDef.FieldValue = "";
}
OdSqlParameter paramFieldValue = new OdSqlParameter("paramFieldValue", OdDbType.Text, sheetFieldDef.FieldValue);
Db.NonQ(command, paramFieldValue);
}
public FormSheetFieldBase(SheetDef sheetDef, SheetFieldDef sheetFieldDef, bool isReadOnly, bool isEditMobile = false)
{
SheetFieldDefCur = sheetFieldDef;
_sheetDefCur = sheetDef;
_isReadOnly = isReadOnly;
_isEditMobile = isEditMobile;
if (_isReadOnly)
{
butOK.Enabled = false;
butDelete.Enabled = false;
}
if (_isEditMobile)
{
textXPos.Enabled = false;
textYPos.Enabled = false;
textWidth.Enabled = false;
textHeight.Enabled = false;
}
textYPos.MaxVal = _sheetDefCur.HeightTotal - 1;//The maximum y-value of the sheet field must be within the page vertically.
textXPos.Text = SheetFieldDefCur.XPos.ToString();
textYPos.Text = SheetFieldDefCur.YPos.ToString();
textWidth.Text = SheetFieldDefCur.Width.ToString();
textHeight.Text = SheetFieldDefCur.Height.ToString();
this.butOK.Click += new System.EventHandler(this.butOK_Click);
this.butCancel.Click += new System.EventHandler(this.butCancel_Click);
this.butDelete.Click += new System.EventHandler(this.butDelete_Click);
}
///<summary>Converts a DataTable to a list of objects.</summary>
public static List <SheetFieldDef> TableToList(DataTable table)
{
List <SheetFieldDef> retVal = new List <SheetFieldDef>();
SheetFieldDef sheetFieldDef;
for (int i = 0; i < table.Rows.Count; i++)
{
sheetFieldDef = new SheetFieldDef();
sheetFieldDef.SheetFieldDefNum = PIn.Long(table.Rows[i]["SheetFieldDefNum"].ToString());
sheetFieldDef.SheetDefNum = PIn.Long(table.Rows[i]["SheetDefNum"].ToString());
sheetFieldDef.FieldType = (SheetFieldType)PIn.Int(table.Rows[i]["FieldType"].ToString());
sheetFieldDef.FieldName = PIn.String(table.Rows[i]["FieldName"].ToString());
sheetFieldDef.FieldValue = PIn.String(table.Rows[i]["FieldValue"].ToString());
sheetFieldDef.FontSize = PIn.Float(table.Rows[i]["FontSize"].ToString());
sheetFieldDef.FontName = PIn.String(table.Rows[i]["FontName"].ToString());
sheetFieldDef.FontIsBold = PIn.Bool(table.Rows[i]["FontIsBold"].ToString());
sheetFieldDef.XPos = PIn.Int(table.Rows[i]["XPos"].ToString());
sheetFieldDef.YPos = PIn.Int(table.Rows[i]["YPos"].ToString());
sheetFieldDef.Width = PIn.Int(table.Rows[i]["Width"].ToString());
sheetFieldDef.Height = PIn.Int(table.Rows[i]["Height"].ToString());
sheetFieldDef.GrowthBehavior = (GrowthBehaviorEnum)PIn.Int(table.Rows[i]["GrowthBehavior"].ToString());
sheetFieldDef.RadioButtonValue = PIn.String(table.Rows[i]["RadioButtonValue"].ToString());
sheetFieldDef.RadioButtonGroup = PIn.String(table.Rows[i]["RadioButtonGroup"].ToString());
sheetFieldDef.IsRequired = PIn.Bool(table.Rows[i]["IsRequired"].ToString());
sheetFieldDef.TabOrder = PIn.Int(table.Rows[i]["TabOrder"].ToString());
sheetFieldDef.ReportableName = PIn.String(table.Rows[i]["ReportableName"].ToString());
retVal.Add(sheetFieldDef);
}
return(retVal);
}
///<summary>Inserts one SheetFieldDef into the database. Returns the new priKey.</summary>
public static long Insert(SheetFieldDef sheetFieldDef)
{
if (DataConnection.DBtype == DatabaseType.Oracle)
{
sheetFieldDef.SheetFieldDefNum = DbHelper.GetNextOracleKey("sheetfielddef", "SheetFieldDefNum");
int loopcount = 0;
while (loopcount < 100)
{
try {
return(Insert(sheetFieldDef, true));
}
catch (Oracle.DataAccess.Client.OracleException ex) {
if (ex.Number == 1 && ex.Message.ToLower().Contains("unique constraint") && ex.Message.ToLower().Contains("violated"))
{
sheetFieldDef.SheetFieldDefNum++;
loopcount++;
}
else
{
throw ex;
}
}
}
throw new ApplicationException("Insert failed. Could not generate primary key.");
}
else
{
return(Insert(sheetFieldDef, false));
}
}
///<summary>Inserts one SheetFieldDef into the database. Returns the new priKey.</summary>
internal static long Insert(SheetFieldDef sheetFieldDef)
{
if(DataConnection.DBtype==DatabaseType.Oracle) {
sheetFieldDef.SheetFieldDefNum=DbHelper.GetNextOracleKey("sheetfielddef","SheetFieldDefNum");
int loopcount=0;
while(loopcount<100){
try {
return Insert(sheetFieldDef,true);
}
catch(Oracle.DataAccess.Client.OracleException ex){
if(ex.Number==1 && ex.Message.ToLower().Contains("unique constraint") && ex.Message.ToLower().Contains("violated")){
sheetFieldDef.SheetFieldDefNum++;
loopcount++;
}
else{
throw ex;
}
}
}
throw new ApplicationException("Insert failed. Could not generate primary key.");
}
else {
return Insert(sheetFieldDef,false);
}
}
///<summary>Inserts one SheetFieldDef into the database. Provides option to use the existing priKey. Doesn't use the cache.</summary>
public static long InsertNoCache(SheetFieldDef sheetFieldDef, bool useExistingPK)
{
bool isRandomKeys = Prefs.GetBoolNoCache(PrefName.RandomPrimaryKeys);
string command = "INSERT INTO sheetfielddef (";
if (!useExistingPK && isRandomKeys)
{
sheetFieldDef.SheetFieldDefNum = ReplicationServers.GetKeyNoCache("sheetfielddef", "SheetFieldDefNum");
}
if (isRandomKeys || useExistingPK)
{
command += "SheetFieldDefNum,";
}
command += "SheetDefNum,FieldType,FieldName,FieldValue,FontSize,FontName,FontIsBold,XPos,YPos,Width,Height,GrowthBehavior,RadioButtonValue,RadioButtonGroup,IsRequired,TabOrder,ReportableName,TextAlign,IsPaymentOption,IsLocked,ItemColor) VALUES(";
if (isRandomKeys || useExistingPK)
{
command += POut.Long(sheetFieldDef.SheetFieldDefNum) + ",";
}
command +=
POut.Long(sheetFieldDef.SheetDefNum) + ","
+ POut.Int((int)sheetFieldDef.FieldType) + ","
+ "'" + POut.String(sheetFieldDef.FieldName) + "',"
+ DbHelper.ParamChar + "paramFieldValue,"
+ POut.Float(sheetFieldDef.FontSize) + ","
+ "'" + POut.String(sheetFieldDef.FontName) + "',"
+ POut.Bool(sheetFieldDef.FontIsBold) + ","
+ POut.Int(sheetFieldDef.XPos) + ","
+ POut.Int(sheetFieldDef.YPos) + ","
+ POut.Int(sheetFieldDef.Width) + ","
+ POut.Int(sheetFieldDef.Height) + ","
+ POut.Int((int)sheetFieldDef.GrowthBehavior) + ","
+ "'" + POut.String(sheetFieldDef.RadioButtonValue) + "',"
+ "'" + POut.String(sheetFieldDef.RadioButtonGroup) + "',"
+ POut.Bool(sheetFieldDef.IsRequired) + ","
+ POut.Int(sheetFieldDef.TabOrder) + ","
+ "'" + POut.String(sheetFieldDef.ReportableName) + "',"
+ POut.Int((int)sheetFieldDef.TextAlign) + ","
+ POut.Bool(sheetFieldDef.IsPaymentOption) + ","
+ POut.Bool(sheetFieldDef.IsLocked) + ","
+ POut.Int(sheetFieldDef.ItemColor.ToArgb()) + ")";
if (sheetFieldDef.FieldValue == null)
{
sheetFieldDef.FieldValue = "";
}
OdSqlParameter paramFieldValue = new OdSqlParameter("paramFieldValue", OdDbType.Text, POut.StringParam(sheetFieldDef.FieldValue));
if (useExistingPK || isRandomKeys)
{
Db.NonQ(command, paramFieldValue);
}
else
{
sheetFieldDef.SheetFieldDefNum = Db.NonQ(command, true, "SheetFieldDefNum", "sheetFieldDef", paramFieldValue);
}
return(sheetFieldDef.SheetFieldDefNum);
}
/// <summary>Helper function that adjusts the Y position of a grid with growth behavior based on controls that are above it. Takes in an optional existing-adjustment parameter</summary>
private void AdjustGridYPosition(SheetFieldDef sheetFieldDef, Control fieldControl, List <Control> listDynamicControls, int adjustment = 0)
{
List <Control> listAboveControls = listDynamicControls.FindAll(x => IsControlAbove(fieldControl, x));
if (listAboveControls.Count > 0)
{
adjustment = listAboveControls.Max(x => x.Bottom) + 1; //Move the grid underneath any existing controls above it
}
sheetFieldDef.YPos = adjustment;
}
private void butDelete_Click(object sender, EventArgs e)
{
SheetFieldDefCur = null;
if (IsNew)
{
DialogResult = DialogResult.Cancel;
}
else
{
DialogResult = DialogResult.OK;
}
}
public void MiddleTier_SendSheetDefWithFieldDefs()
{
SheetDef sheetdef = new SheetDef();
sheetdef.SheetFieldDefs = new List <SheetFieldDef>();
sheetdef.Parameters = new List <SheetParameter>();
SheetFieldDef fielddef = new SheetFieldDef();
fielddef.FieldName = "FieldName";
sheetdef.SheetFieldDefs.Add(fielddef);
Assert.AreEqual("FieldName", WebServiceTests.SendSheetDefWithFieldDefs(sheetdef));
}
private void listBoxAvailable_SelectedIndexChanged(object sender, EventArgs e)
{
if (!IsNew)
{
return; //should never happen
}
if (listBoxAvailable.SelectedIndices.Count == 0 || listBoxAvailable.SelectedIndex < 0)
{
return;
}
SheetFieldDefCur = _listFieldDefsAvailable[listBoxAvailable.SelectedIndex];
FillFields();
}
///<summary>Inserts one SheetFieldDef into the database. Provides option to use the existing priKey.</summary>
public static long Insert(SheetFieldDef sheetFieldDef, bool useExistingPK)
{
if (!useExistingPK && PrefC.RandomKeys)
{
sheetFieldDef.SheetFieldDefNum = ReplicationServers.GetKey("sheetfielddef", "SheetFieldDefNum");
}
string command = "INSERT INTO sheetfielddef (";
if (useExistingPK || PrefC.RandomKeys)
{
command += "SheetFieldDefNum,";
}
command += "SheetDefNum,FieldType,FieldName,FieldValue,FontSize,FontName,FontIsBold,XPos,YPos,Width,Height,GrowthBehavior,RadioButtonValue,RadioButtonGroup,IsRequired,TabOrder,ReportableName) VALUES(";
if (useExistingPK || PrefC.RandomKeys)
{
command += POut.Long(sheetFieldDef.SheetFieldDefNum) + ",";
}
command +=
POut.Long(sheetFieldDef.SheetDefNum) + ","
+ POut.Int((int)sheetFieldDef.FieldType) + ","
+ "'" + POut.String(sheetFieldDef.FieldName) + "',"
+ DbHelper.ParamChar + "paramFieldValue,"
+ POut.Float(sheetFieldDef.FontSize) + ","
+ "'" + POut.String(sheetFieldDef.FontName) + "',"
+ POut.Bool(sheetFieldDef.FontIsBold) + ","
+ POut.Int(sheetFieldDef.XPos) + ","
+ POut.Int(sheetFieldDef.YPos) + ","
+ POut.Int(sheetFieldDef.Width) + ","
+ POut.Int(sheetFieldDef.Height) + ","
+ POut.Int((int)sheetFieldDef.GrowthBehavior) + ","
+ "'" + POut.String(sheetFieldDef.RadioButtonValue) + "',"
+ "'" + POut.String(sheetFieldDef.RadioButtonGroup) + "',"
+ POut.Bool(sheetFieldDef.IsRequired) + ","
+ POut.Int(sheetFieldDef.TabOrder) + ","
+ "'" + POut.String(sheetFieldDef.ReportableName) + "')";
if (sheetFieldDef.FieldValue == null)
{
sheetFieldDef.FieldValue = "";
}
OdSqlParameter paramFieldValue = new OdSqlParameter("paramFieldValue", OdDbType.Text, sheetFieldDef.FieldValue);
if (useExistingPK || PrefC.RandomKeys)
{
Db.NonQ(command, paramFieldValue);
}
else
{
sheetFieldDef.SheetFieldDefNum = Db.NonQ(command, true, paramFieldValue);
}
return(sheetFieldDef.SheetFieldDefNum);
}
///<summary>Updates one SheetFieldDef in the database.</summary>
public static void Update(SheetFieldDef sheetFieldDef)
{
string command = "UPDATE sheetfielddef SET "
+ "SheetDefNum = " + POut.Long(sheetFieldDef.SheetDefNum) + ", "
+ "FieldType = " + POut.Int((int)sheetFieldDef.FieldType) + ", "
+ "FieldName = '" + POut.String(sheetFieldDef.FieldName) + "', "
+ "FieldValue = " + DbHelper.ParamChar + "paramFieldValue, "
+ "FontSize = " + POut.Float(sheetFieldDef.FontSize) + ", "
+ "FontName = '" + POut.String(sheetFieldDef.FontName) + "', "
+ "FontIsBold = " + POut.Bool(sheetFieldDef.FontIsBold) + ", "
+ "XPos = " + POut.Int(sheetFieldDef.XPos) + ", "
+ "YPos = " + POut.Int(sheetFieldDef.YPos) + ", "
+ "Width = " + POut.Int(sheetFieldDef.Width) + ", "
+ "Height = " + POut.Int(sheetFieldDef.Height) + ", "
+ "GrowthBehavior = " + POut.Int((int)sheetFieldDef.GrowthBehavior) + ", "
+ "RadioButtonValue = '" + POut.String(sheetFieldDef.RadioButtonValue) + "', "
+ "RadioButtonGroup = '" + POut.String(sheetFieldDef.RadioButtonGroup) + "', "
+ "IsRequired = " + POut.Bool(sheetFieldDef.IsRequired) + ", "
+ "TabOrder = " + POut.Int(sheetFieldDef.TabOrder) + ", "
+ "ReportableName = '" + POut.String(sheetFieldDef.ReportableName) + "', "
+ "TextAlign = " + POut.Int((int)sheetFieldDef.TextAlign) + ", "
+ "IsPaymentOption = " + POut.Bool(sheetFieldDef.IsPaymentOption) + ", "
+ "IsLocked = " + POut.Bool(sheetFieldDef.IsLocked) + ", "
+ "ItemColor = " + POut.Int(sheetFieldDef.ItemColor.ToArgb()) + ", "
+ "TabOrderMobile = " + POut.Int(sheetFieldDef.TabOrderMobile) + ", "
+ "UiLabelMobile = " + DbHelper.ParamChar + "paramUiLabelMobile, "
+ "UiLabelMobileRadioButton= " + DbHelper.ParamChar + "paramUiLabelMobileRadioButton, "
+ "LayoutMode = " + POut.Int((int)sheetFieldDef.LayoutMode) + " "
+ "WHERE SheetFieldDefNum = " + POut.Long(sheetFieldDef.SheetFieldDefNum);
if (sheetFieldDef.FieldValue == null)
{
sheetFieldDef.FieldValue = "";
}
OdSqlParameter paramFieldValue = new OdSqlParameter("paramFieldValue", OdDbType.Text, POut.StringParam(sheetFieldDef.FieldValue));
if (sheetFieldDef.UiLabelMobile == null)
{
sheetFieldDef.UiLabelMobile = "";
}
OdSqlParameter paramUiLabelMobile = new OdSqlParameter("paramUiLabelMobile", OdDbType.Text, POut.StringParam(sheetFieldDef.UiLabelMobile));
if (sheetFieldDef.UiLabelMobileRadioButton == null)
{
sheetFieldDef.UiLabelMobileRadioButton = "";
}
OdSqlParameter paramUiLabelMobileRadioButton = new OdSqlParameter("paramUiLabelMobileRadioButton", OdDbType.Text, POut.StringParam(sheetFieldDef.UiLabelMobileRadioButton));
Db.NonQ(command, paramFieldValue, paramUiLabelMobile, paramUiLabelMobileRadioButton);
}
/// <summary>Returns the height beneath a given SheetFieldDef</summary>
private int GetSheetFieldsHeightBelow(SheetFieldDef fieldDef, int heightOffset, List <SheetFieldDef> listSheetFieldDefs, Dictionary <string, Control> dictControls, out bool anchorToBottom)
{
anchorToBottom = false;
Control control = GetControlForField(fieldDef, dictControls);
List <Control> listBelowSheetFieldDefs = listSheetFieldDefs.FindAll(x => !x.FieldName.Contains("Button") && IsControlBelow(control, GetControlForField(x, dictControls)))
.Select(x => GetControlForField(x, dictControls)).ToList();
if (listBelowSheetFieldDefs.Count == 0) //If there are no controls under the initially-provided SheetFieldDef
{
anchorToBottom = true;
return(0);
}
return(Math.Max(0, (_controlHosting.Height - GetStaticControlsHeightBelow(fieldDef.YPos + heightOffset)) - (listBelowSheetFieldDefs.Min(x => x.Top))));
}
private void AddAllergy(SheetFieldDef SheetFieldDefCur)
{
FormAllergyDefEdit formADE = new FormAllergyDefEdit();
formADE.AllergyDefCur = new AllergyDef();
formADE.AllergyDefCur.IsNew = true;
formADE.AllergyDefCur.Description = SheetFieldDefCur?.FieldName.Replace("allergy:", "") ?? "";
formADE.ShowDialog();
if (formADE.DialogResult != DialogResult.OK)
{
return;
}
_listAllergies.Add(formADE.AllergyDefCur);
FillListMedical(MedicalListType.allergy);
}
///<summary>Inserts one SheetFieldDef into the database. Returns the new priKey. Doesn't use the cache.</summary>
public static long InsertNoCache(SheetFieldDef sheetFieldDef)
{
if (DataConnection.DBtype == DatabaseType.MySql)
{
return(InsertNoCache(sheetFieldDef, false));
}
else
{
if (DataConnection.DBtype == DatabaseType.Oracle)
{
sheetFieldDef.SheetFieldDefNum = DbHelper.GetNextOracleKey("sheetfielddef", "SheetFieldDefNum"); //Cacheless method
}
return(InsertNoCache(sheetFieldDef, true));
}
}
///<summary>Inserts one SheetFieldDef into the database. Provides option to use the existing priKey.</summary>
internal static long Insert(SheetFieldDef sheetFieldDef,bool useExistingPK)
{
if(!useExistingPK && PrefC.RandomKeys) {
sheetFieldDef.SheetFieldDefNum=ReplicationServers.GetKey("sheetfielddef","SheetFieldDefNum");
}
string command="INSERT INTO sheetfielddef (";
if(useExistingPK || PrefC.RandomKeys) {
command+="SheetFieldDefNum,";
}
command+="SheetDefNum,FieldType,FieldName,FieldValue,FontSize,FontName,FontIsBold,XPos,YPos,Width,Height,GrowthBehavior,RadioButtonValue,RadioButtonGroup,IsRequired,TabOrder) VALUES(";
if(useExistingPK || PrefC.RandomKeys) {
command+=POut.Long(sheetFieldDef.SheetFieldDefNum)+",";
}
command+=
POut.Long (sheetFieldDef.SheetDefNum)+","
+ POut.Int ((int)sheetFieldDef.FieldType)+","
+"'"+POut.String(sheetFieldDef.FieldName)+"',"
+DbHelper.ParamChar+"paramFieldValue,"
+ POut.Float (sheetFieldDef.FontSize)+","
+"'"+POut.String(sheetFieldDef.FontName)+"',"
+ POut.Bool (sheetFieldDef.FontIsBold)+","
+ POut.Int (sheetFieldDef.XPos)+","
+ POut.Int (sheetFieldDef.YPos)+","
+ POut.Int (sheetFieldDef.Width)+","
+ POut.Int (sheetFieldDef.Height)+","
+ POut.Int ((int)sheetFieldDef.GrowthBehavior)+","
+"'"+POut.String(sheetFieldDef.RadioButtonValue)+"',"
+"'"+POut.String(sheetFieldDef.RadioButtonGroup)+"',"
+ POut.Bool (sheetFieldDef.IsRequired)+","
+ POut.Int (sheetFieldDef.TabOrder)+")";
if(sheetFieldDef.FieldValue==null) {
sheetFieldDef.FieldValue="";
}
OdSqlParameter paramFieldValue=new OdSqlParameter("paramFieldValue",OdDbType.Text,sheetFieldDef.FieldValue);
if(useExistingPK || PrefC.RandomKeys) {
Db.NonQ(command,paramFieldValue);
}
else {
sheetFieldDef.SheetFieldDefNum=Db.NonQ(command,true,paramFieldValue);
}
return sheetFieldDef.SheetFieldDefNum;
}
///<summary>Determines if the SheetFieldDef is supported in a Patient Dashboard.</summary>
public static bool IsSheetFieldDefSupported(SheetFieldDef sheetFieldDef)
{
SheetField field = new SheetField()
{
FieldName = sheetFieldDef.FieldName,
FieldType = sheetFieldDef.FieldType,
};
if (IsSheetFieldDrawnDirectlyToGraphics(field))
{
return(true);
}
try {
GetControlTypeForDisplay(field);
return(true);
}
catch {
return(false);
}
}
private void FormSheetFieldDefEdit_Load(object sender, EventArgs e)
{
textYPos.MaxVal = SheetDefCur.HeightTotal - 1; //The maximum y-value of the sheet field must be within the page vertically.
if (IsReadOnly)
{
butOK.Enabled = false;
butDelete.Enabled = false;
}
_listFieldDefsAvailable = SheetFieldsAvailable.GetSpecial(SheetDefCur.SheetType);
listBoxAvailable.Items.AddRange(_listFieldDefsAvailable.Select(x => (object)x.FieldName).ToArray());
if (IsNew)
{
listBoxAvailable.SetSelected(0, true);
SheetFieldDefCur = _listFieldDefsAvailable[0];
}
else
{
listBoxAvailable.SetSelected(_listFieldDefsAvailable.FindIndex(x => x.FieldName == SheetFieldDefCur.FieldName), true);
listBoxAvailable.Enabled = false;
}
FillFields();
}
public FormSheetFieldPatImage(SheetDef sheetDef, SheetFieldDef sheetFieldDef, bool isReadOnly) : base(sheetDef, sheetFieldDef, isReadOnly)
{
InitializeComponent();
Lan.F(this);
}
///<summary>Updates one SheetFieldDef in the database. Uses an old object to compare to, and only alters changed fields. This prevents collisions and concurrency problems in heavily used tables. Returns true if an update occurred.</summary>
public static bool Update(SheetFieldDef sheetFieldDef, SheetFieldDef oldSheetFieldDef)
{
string command = "";
if (sheetFieldDef.SheetDefNum != oldSheetFieldDef.SheetDefNum)
{
if (command != "")
{
command += ",";
}
command += "SheetDefNum = " + POut.Long(sheetFieldDef.SheetDefNum) + "";
}
if (sheetFieldDef.FieldType != oldSheetFieldDef.FieldType)
{
if (command != "")
{
command += ",";
}
command += "FieldType = " + POut.Int((int)sheetFieldDef.FieldType) + "";
}
if (sheetFieldDef.FieldName != oldSheetFieldDef.FieldName)
{
if (command != "")
{
command += ",";
}
command += "FieldName = '" + POut.String(sheetFieldDef.FieldName) + "'";
}
if (sheetFieldDef.FieldValue != oldSheetFieldDef.FieldValue)
{
if (command != "")
{
command += ",";
}
command += "FieldValue = " + DbHelper.ParamChar + "paramFieldValue";
}
if (sheetFieldDef.FontSize != oldSheetFieldDef.FontSize)
{
if (command != "")
{
command += ",";
}
command += "FontSize = " + POut.Float(sheetFieldDef.FontSize) + "";
}
if (sheetFieldDef.FontName != oldSheetFieldDef.FontName)
{
if (command != "")
{
command += ",";
}
command += "FontName = '" + POut.String(sheetFieldDef.FontName) + "'";
}
if (sheetFieldDef.FontIsBold != oldSheetFieldDef.FontIsBold)
{
if (command != "")
{
command += ",";
}
command += "FontIsBold = " + POut.Bool(sheetFieldDef.FontIsBold) + "";
}
if (sheetFieldDef.XPos != oldSheetFieldDef.XPos)
{
if (command != "")
{
command += ",";
}
command += "XPos = " + POut.Int(sheetFieldDef.XPos) + "";
}
if (sheetFieldDef.YPos != oldSheetFieldDef.YPos)
{
if (command != "")
{
command += ",";
}
command += "YPos = " + POut.Int(sheetFieldDef.YPos) + "";
}
if (sheetFieldDef.Width != oldSheetFieldDef.Width)
{
if (command != "")
{
command += ",";
}
command += "Width = " + POut.Int(sheetFieldDef.Width) + "";
}
if (sheetFieldDef.Height != oldSheetFieldDef.Height)
{
if (command != "")
{
command += ",";
}
command += "Height = " + POut.Int(sheetFieldDef.Height) + "";
}
if (sheetFieldDef.GrowthBehavior != oldSheetFieldDef.GrowthBehavior)
{
if (command != "")
{
command += ",";
}
command += "GrowthBehavior = " + POut.Int((int)sheetFieldDef.GrowthBehavior) + "";
}
if (sheetFieldDef.RadioButtonValue != oldSheetFieldDef.RadioButtonValue)
{
if (command != "")
{
command += ",";
}
command += "RadioButtonValue = '" + POut.String(sheetFieldDef.RadioButtonValue) + "'";
}
if (sheetFieldDef.RadioButtonGroup != oldSheetFieldDef.RadioButtonGroup)
{
if (command != "")
{
command += ",";
}
command += "RadioButtonGroup = '" + POut.String(sheetFieldDef.RadioButtonGroup) + "'";
}
if (sheetFieldDef.IsRequired != oldSheetFieldDef.IsRequired)
{
if (command != "")
{
command += ",";
}
command += "IsRequired = " + POut.Bool(sheetFieldDef.IsRequired) + "";
}
if (sheetFieldDef.TabOrder != oldSheetFieldDef.TabOrder)
{
if (command != "")
{
command += ",";
}
command += "TabOrder = " + POut.Int(sheetFieldDef.TabOrder) + "";
}
if (sheetFieldDef.ReportableName != oldSheetFieldDef.ReportableName)
{
if (command != "")
{
command += ",";
}
command += "ReportableName = '" + POut.String(sheetFieldDef.ReportableName) + "'";
}
if (sheetFieldDef.TextAlign != oldSheetFieldDef.TextAlign)
{
if (command != "")
{
command += ",";
}
command += "TextAlign = " + POut.Int((int)sheetFieldDef.TextAlign) + "";
}
if (sheetFieldDef.IsPaymentOption != oldSheetFieldDef.IsPaymentOption)
{
if (command != "")
{
command += ",";
}
command += "IsPaymentOption = " + POut.Bool(sheetFieldDef.IsPaymentOption) + "";
}
if (sheetFieldDef.IsLocked != oldSheetFieldDef.IsLocked)
{
if (command != "")
{
command += ",";
}
command += "IsLocked = " + POut.Bool(sheetFieldDef.IsLocked) + "";
}
if (sheetFieldDef.ItemColor != oldSheetFieldDef.ItemColor)
{
if (command != "")
{
command += ",";
}
command += "ItemColor = " + POut.Int(sheetFieldDef.ItemColor.ToArgb()) + "";
}
if (sheetFieldDef.TabOrderMobile != oldSheetFieldDef.TabOrderMobile)
{
if (command != "")
{
command += ",";
}
command += "TabOrderMobile = " + POut.Int(sheetFieldDef.TabOrderMobile) + "";
}
if (sheetFieldDef.UiLabelMobile != oldSheetFieldDef.UiLabelMobile)
{
if (command != "")
{
command += ",";
}
command += "UiLabelMobile = " + DbHelper.ParamChar + "paramUiLabelMobile";
}
if (sheetFieldDef.UiLabelMobileRadioButton != oldSheetFieldDef.UiLabelMobileRadioButton)
{
if (command != "")
{
command += ",";
}
command += "UiLabelMobileRadioButton = " + DbHelper.ParamChar + "paramUiLabelMobileRadioButton";
}
if (sheetFieldDef.LayoutMode != oldSheetFieldDef.LayoutMode)
{
if (command != "")
{
command += ",";
}
command += "LayoutMode = " + POut.Int((int)sheetFieldDef.LayoutMode) + "";
}
if (command == "")
{
return(false);
}
if (sheetFieldDef.FieldValue == null)
{
sheetFieldDef.FieldValue = "";
}
OdSqlParameter paramFieldValue = new OdSqlParameter("paramFieldValue", OdDbType.Text, POut.StringParam(sheetFieldDef.FieldValue));
if (sheetFieldDef.UiLabelMobile == null)
{
sheetFieldDef.UiLabelMobile = "";
}
OdSqlParameter paramUiLabelMobile = new OdSqlParameter("paramUiLabelMobile", OdDbType.Text, POut.StringParam(sheetFieldDef.UiLabelMobile));
if (sheetFieldDef.UiLabelMobileRadioButton == null)
{
sheetFieldDef.UiLabelMobileRadioButton = "";
}
OdSqlParameter paramUiLabelMobileRadioButton = new OdSqlParameter("paramUiLabelMobileRadioButton", OdDbType.Text, POut.StringParam(sheetFieldDef.UiLabelMobileRadioButton));
command = "UPDATE sheetfielddef SET " + command
+ " WHERE SheetFieldDefNum = " + POut.Long(sheetFieldDef.SheetFieldDefNum);
Db.NonQ(command, paramFieldValue, paramUiLabelMobile, paramUiLabelMobileRadioButton);
return(true);
}
private void butDelete_Click(object sender, EventArgs e)
{
SheetFieldDefCur = null;
DialogResult = DialogResult.OK;
}
///<summary>Updates one SheetFieldDef in the database. Uses an old object to compare to, and only alters changed fields. This prevents collisions and concurrency problems in heavily used tables.</summary>
public static void Update(SheetFieldDef sheetFieldDef, SheetFieldDef oldSheetFieldDef)
{
string command = "";
if (sheetFieldDef.SheetDefNum != oldSheetFieldDef.SheetDefNum)
{
if (command != "")
{
command += ",";
}
command += "SheetDefNum = " + POut.Long(sheetFieldDef.SheetDefNum) + "";
}
if (sheetFieldDef.FieldType != oldSheetFieldDef.FieldType)
{
if (command != "")
{
command += ",";
}
command += "FieldType = " + POut.Int((int)sheetFieldDef.FieldType) + "";
}
if (sheetFieldDef.FieldName != oldSheetFieldDef.FieldName)
{
if (command != "")
{
command += ",";
}
command += "FieldName = '" + POut.String(sheetFieldDef.FieldName) + "'";
}
if (sheetFieldDef.FieldValue != oldSheetFieldDef.FieldValue)
{
if (command != "")
{
command += ",";
}
command += "FieldValue = " + DbHelper.ParamChar + "paramFieldValue";
}
if (sheetFieldDef.FontSize != oldSheetFieldDef.FontSize)
{
if (command != "")
{
command += ",";
}
command += "FontSize = " + POut.Float(sheetFieldDef.FontSize) + "";
}
if (sheetFieldDef.FontName != oldSheetFieldDef.FontName)
{
if (command != "")
{
command += ",";
}
command += "FontName = '" + POut.String(sheetFieldDef.FontName) + "'";
}
if (sheetFieldDef.FontIsBold != oldSheetFieldDef.FontIsBold)
{
if (command != "")
{
command += ",";
}
command += "FontIsBold = " + POut.Bool(sheetFieldDef.FontIsBold) + "";
}
if (sheetFieldDef.XPos != oldSheetFieldDef.XPos)
{
if (command != "")
{
command += ",";
}
command += "XPos = " + POut.Int(sheetFieldDef.XPos) + "";
}
if (sheetFieldDef.YPos != oldSheetFieldDef.YPos)
{
if (command != "")
{
command += ",";
}
command += "YPos = " + POut.Int(sheetFieldDef.YPos) + "";
}
if (sheetFieldDef.Width != oldSheetFieldDef.Width)
{
if (command != "")
{
command += ",";
}
command += "Width = " + POut.Int(sheetFieldDef.Width) + "";
}
if (sheetFieldDef.Height != oldSheetFieldDef.Height)
{
if (command != "")
{
command += ",";
}
command += "Height = " + POut.Int(sheetFieldDef.Height) + "";
}
if (sheetFieldDef.GrowthBehavior != oldSheetFieldDef.GrowthBehavior)
{
if (command != "")
{
command += ",";
}
command += "GrowthBehavior = " + POut.Int((int)sheetFieldDef.GrowthBehavior) + "";
}
if (sheetFieldDef.RadioButtonValue != oldSheetFieldDef.RadioButtonValue)
{
if (command != "")
{
command += ",";
}
command += "RadioButtonValue = '" + POut.String(sheetFieldDef.RadioButtonValue) + "'";
}
if (sheetFieldDef.RadioButtonGroup != oldSheetFieldDef.RadioButtonGroup)
{
if (command != "")
{
command += ",";
}
command += "RadioButtonGroup = '" + POut.String(sheetFieldDef.RadioButtonGroup) + "'";
}
if (sheetFieldDef.IsRequired != oldSheetFieldDef.IsRequired)
{
if (command != "")
{
command += ",";
}
command += "IsRequired = " + POut.Bool(sheetFieldDef.IsRequired) + "";
}
if (sheetFieldDef.TabOrder != oldSheetFieldDef.TabOrder)
{
if (command != "")
{
command += ",";
}
command += "TabOrder = " + POut.Int(sheetFieldDef.TabOrder) + "";
}
if (sheetFieldDef.ReportableName != oldSheetFieldDef.ReportableName)
{
if (command != "")
{
command += ",";
}
command += "ReportableName = '" + POut.String(sheetFieldDef.ReportableName) + "'";
}
if (command == "")
{
return;
}
if (sheetFieldDef.FieldValue == null)
{
sheetFieldDef.FieldValue = "";
}
OdSqlParameter paramFieldValue = new OdSqlParameter("paramFieldValue", OdDbType.Text, sheetFieldDef.FieldValue);
command = "UPDATE sheetfielddef SET " + command
+ " WHERE SheetFieldDefNum = " + POut.Long(sheetFieldDef.SheetFieldDefNum);
Db.NonQ(command, paramFieldValue);
}
public FormSheetFieldSpecial(SheetDef sheetDef, SheetFieldDef sheetFieldDef, bool isReadOnly, SheetFieldLayoutMode layoutMode) : base(sheetDef, sheetFieldDef, isReadOnly)
{
InitializeComponent();
Lan.F(this);
LayoutMode = layoutMode;
}
///<summary>Updates one SheetFieldDef in the database.</summary>
public static void Update(SheetFieldDef sheetFieldDef){
string command="UPDATE sheetfielddef SET "
+"SheetDefNum = "+POut.Long (sheetFieldDef.SheetDefNum)+", "
+"FieldType = "+POut.Int ((int)sheetFieldDef.FieldType)+", "
+"FieldName = '"+POut.String(sheetFieldDef.FieldName)+"', "
+"FieldValue = "+DbHelper.ParamChar+"paramFieldValue, "
+"FontSize = "+POut.Float (sheetFieldDef.FontSize)+", "
+"FontName = '"+POut.String(sheetFieldDef.FontName)+"', "
+"FontIsBold = "+POut.Bool (sheetFieldDef.FontIsBold)+", "
+"XPos = "+POut.Int (sheetFieldDef.XPos)+", "
+"YPos = "+POut.Int (sheetFieldDef.YPos)+", "
+"Width = "+POut.Int (sheetFieldDef.Width)+", "
+"Height = "+POut.Int (sheetFieldDef.Height)+", "
+"GrowthBehavior = "+POut.Int ((int)sheetFieldDef.GrowthBehavior)+", "
+"RadioButtonValue= '"+POut.String(sheetFieldDef.RadioButtonValue)+"', "
+"RadioButtonGroup= '"+POut.String(sheetFieldDef.RadioButtonGroup)+"', "
+"IsRequired = "+POut.Bool (sheetFieldDef.IsRequired)+", "
+"TabOrder = "+POut.Int (sheetFieldDef.TabOrder)+", "
+"ReportableName = '"+POut.String(sheetFieldDef.ReportableName)+"', "
+"TextAlign = "+POut.Int ((int)sheetFieldDef.TextAlign)+", "
+"IsPaymentOption = "+POut.Bool (sheetFieldDef.IsPaymentOption)+", "
+"ItemColor = "+POut.Int (sheetFieldDef.ItemColor.ToArgb())+" "
+"WHERE SheetFieldDefNum = "+POut.Long(sheetFieldDef.SheetFieldDefNum);
if(sheetFieldDef.FieldValue==null) {
sheetFieldDef.FieldValue="";
}
OdSqlParameter paramFieldValue=new OdSqlParameter("paramFieldValue",OdDbType.Text,sheetFieldDef.FieldValue);
Db.NonQ(command,paramFieldValue);
}
///<summary>Returns true if Update(SheetFieldDef,SheetFieldDef) would make changes to the database.
///Does not make any changes to the database and can be called before remoting role is checked.</summary>
public static bool UpdateComparison(SheetFieldDef sheetFieldDef, SheetFieldDef oldSheetFieldDef)
{
if (sheetFieldDef.SheetDefNum != oldSheetFieldDef.SheetDefNum)
{
return(true);
}
if (sheetFieldDef.FieldType != oldSheetFieldDef.FieldType)
{
return(true);
}
if (sheetFieldDef.FieldName != oldSheetFieldDef.FieldName)
{
return(true);
}
if (sheetFieldDef.FieldValue != oldSheetFieldDef.FieldValue)
{
return(true);
}
if (sheetFieldDef.FontSize != oldSheetFieldDef.FontSize)
{
return(true);
}
if (sheetFieldDef.FontName != oldSheetFieldDef.FontName)
{
return(true);
}
if (sheetFieldDef.FontIsBold != oldSheetFieldDef.FontIsBold)
{
return(true);
}
if (sheetFieldDef.XPos != oldSheetFieldDef.XPos)
{
return(true);
}
if (sheetFieldDef.YPos != oldSheetFieldDef.YPos)
{
return(true);
}
if (sheetFieldDef.Width != oldSheetFieldDef.Width)
{
return(true);
}
if (sheetFieldDef.Height != oldSheetFieldDef.Height)
{
return(true);
}
if (sheetFieldDef.GrowthBehavior != oldSheetFieldDef.GrowthBehavior)
{
return(true);
}
if (sheetFieldDef.RadioButtonValue != oldSheetFieldDef.RadioButtonValue)
{
return(true);
}
if (sheetFieldDef.RadioButtonGroup != oldSheetFieldDef.RadioButtonGroup)
{
return(true);
}
if (sheetFieldDef.IsRequired != oldSheetFieldDef.IsRequired)
{
return(true);
}
if (sheetFieldDef.TabOrder != oldSheetFieldDef.TabOrder)
{
return(true);
}
if (sheetFieldDef.ReportableName != oldSheetFieldDef.ReportableName)
{
return(true);
}
if (sheetFieldDef.TextAlign != oldSheetFieldDef.TextAlign)
{
return(true);
}
if (sheetFieldDef.IsPaymentOption != oldSheetFieldDef.IsPaymentOption)
{
return(true);
}
if (sheetFieldDef.IsLocked != oldSheetFieldDef.IsLocked)
{
return(true);
}
if (sheetFieldDef.ItemColor != oldSheetFieldDef.ItemColor)
{
return(true);
}
return(false);
}
public FormSheetFieldInput(SheetDef sheetDef, SheetFieldDef sheetFieldDef, bool isReadOnly, bool isEditMobile = false) : base(sheetDef, sheetFieldDef, isReadOnly, isEditMobile)
{
InitializeComponent();
Lan.F(this);
}
///<summary>Updates one SheetFieldDef in the database. Uses an old object to compare to, and only alters changed fields. This prevents collisions and concurrency problems in heavily used tables. Returns true if an update occurred.</summary>
public static bool Update(SheetFieldDef sheetFieldDef,SheetFieldDef oldSheetFieldDef){
string command="";
if(sheetFieldDef.SheetDefNum != oldSheetFieldDef.SheetDefNum) {
if(command!=""){ command+=",";}
command+="SheetDefNum = "+POut.Long(sheetFieldDef.SheetDefNum)+"";
}
if(sheetFieldDef.FieldType != oldSheetFieldDef.FieldType) {
if(command!=""){ command+=",";}
command+="FieldType = "+POut.Int ((int)sheetFieldDef.FieldType)+"";
}
if(sheetFieldDef.FieldName != oldSheetFieldDef.FieldName) {
if(command!=""){ command+=",";}
command+="FieldName = '"+POut.String(sheetFieldDef.FieldName)+"'";
}
if(sheetFieldDef.FieldValue != oldSheetFieldDef.FieldValue) {
if(command!=""){ command+=",";}
command+="FieldValue = "+DbHelper.ParamChar+"paramFieldValue";
}
if(sheetFieldDef.FontSize != oldSheetFieldDef.FontSize) {
if(command!=""){ command+=",";}
command+="FontSize = "+POut.Float(sheetFieldDef.FontSize)+"";
}
if(sheetFieldDef.FontName != oldSheetFieldDef.FontName) {
if(command!=""){ command+=",";}
command+="FontName = '"+POut.String(sheetFieldDef.FontName)+"'";
}
if(sheetFieldDef.FontIsBold != oldSheetFieldDef.FontIsBold) {
if(command!=""){ command+=",";}
command+="FontIsBold = "+POut.Bool(sheetFieldDef.FontIsBold)+"";
}
if(sheetFieldDef.XPos != oldSheetFieldDef.XPos) {
if(command!=""){ command+=",";}
command+="XPos = "+POut.Int(sheetFieldDef.XPos)+"";
}
if(sheetFieldDef.YPos != oldSheetFieldDef.YPos) {
if(command!=""){ command+=",";}
command+="YPos = "+POut.Int(sheetFieldDef.YPos)+"";
}
if(sheetFieldDef.Width != oldSheetFieldDef.Width) {
if(command!=""){ command+=",";}
command+="Width = "+POut.Int(sheetFieldDef.Width)+"";
}
if(sheetFieldDef.Height != oldSheetFieldDef.Height) {
if(command!=""){ command+=",";}
command+="Height = "+POut.Int(sheetFieldDef.Height)+"";
}
if(sheetFieldDef.GrowthBehavior != oldSheetFieldDef.GrowthBehavior) {
if(command!=""){ command+=",";}
command+="GrowthBehavior = "+POut.Int ((int)sheetFieldDef.GrowthBehavior)+"";
}
if(sheetFieldDef.RadioButtonValue != oldSheetFieldDef.RadioButtonValue) {
if(command!=""){ command+=",";}
command+="RadioButtonValue = '"+POut.String(sheetFieldDef.RadioButtonValue)+"'";
}
if(sheetFieldDef.RadioButtonGroup != oldSheetFieldDef.RadioButtonGroup) {
if(command!=""){ command+=",";}
command+="RadioButtonGroup = '"+POut.String(sheetFieldDef.RadioButtonGroup)+"'";
}
if(sheetFieldDef.IsRequired != oldSheetFieldDef.IsRequired) {
if(command!=""){ command+=",";}
command+="IsRequired = "+POut.Bool(sheetFieldDef.IsRequired)+"";
}
if(sheetFieldDef.TabOrder != oldSheetFieldDef.TabOrder) {
if(command!=""){ command+=",";}
command+="TabOrder = "+POut.Int(sheetFieldDef.TabOrder)+"";
}
if(sheetFieldDef.ReportableName != oldSheetFieldDef.ReportableName) {
if(command!=""){ command+=",";}
command+="ReportableName = '"+POut.String(sheetFieldDef.ReportableName)+"'";
}
if(sheetFieldDef.TextAlign != oldSheetFieldDef.TextAlign) {
if(command!=""){ command+=",";}
command+="TextAlign = "+POut.Int ((int)sheetFieldDef.TextAlign)+"";
}
if(sheetFieldDef.IsPaymentOption != oldSheetFieldDef.IsPaymentOption) {
if(command!=""){ command+=",";}
command+="IsPaymentOption = "+POut.Bool(sheetFieldDef.IsPaymentOption)+"";
}
if(sheetFieldDef.ItemColor != oldSheetFieldDef.ItemColor) {
if(command!=""){ command+=",";}
command+="ItemColor = "+POut.Int(sheetFieldDef.ItemColor.ToArgb())+"";
}
if(command==""){
return false;
}
if(sheetFieldDef.FieldValue==null) {
sheetFieldDef.FieldValue="";
}
OdSqlParameter paramFieldValue=new OdSqlParameter("paramFieldValue",OdDbType.Text,sheetFieldDef.FieldValue);
command="UPDATE sheetfielddef SET "+command
+" WHERE SheetFieldDefNum = "+POut.Long(sheetFieldDef.SheetFieldDefNum);
Db.NonQ(command,paramFieldValue);
return true;
}
/// <summary></summary>
public static string RunAll()
{
string retVal = "";
//GetString
string strResult = WebServiceTests.GetString("Input");
if (strResult != "Input-Processed")
{
throw new Exception("Should be Input-Processed");
}
retVal += "GetString: Passed.\r\n";
strResult = WebServiceTests.GetStringNull("Input");
if (strResult != null)
{
throw new Exception("Should be null");
}
retVal += "GetStringNull: Passed.\r\n";
strResult = WebServiceTests.GetStringCarriageReturn("Carriage\r\nReturn");
if (strResult != "Carriage\r\nReturn-Processed")
{
throw new Exception("Should be Carriage\r\nReturn-Processed");
}
retVal += "GetStringCarriageReturn: Passed.\r\n";
//GetInt
int intResult = WebServiceTests.GetInt(1);
if (intResult != 2)
{
throw new Exception("Should be 2");
}
retVal += "GetInt: Passed.\r\n";
//GetLong
long longResult = WebServiceTests.GetLong(1);
if (longResult != 2)
{
throw new Exception("Should be 2");
}
retVal += "GetLong: Passed.\r\n";
//GetVoid
WebServiceTests.GetVoid();
retVal += "GetVoid: Passed.\r\n";
//GetBool
bool boolResult = WebServiceTests.GetBool();
if (boolResult != true)
{
throw new Exception("Should be true");
}
retVal += "GetBool: Passed.\r\n";
//GetObject
Patient pat = WebServiceTests.GetObjectPat();
if (pat.LName != "Smith")
{
throw new Exception("Should be Smith");
}
if (pat.FName != null)
{
throw new Exception("Should be null");
}
retVal += "GetObjectPat: Passed.\r\n";
//GetTable
DataTable table = WebServiceTests.GetTable();
if (table.Rows[0][0].ToString() != "cell00")
{
throw new Exception("Should be cell00");
}
retVal += "GetTable: Passed.\r\n";
//GetTable with carriage return
table = WebServiceTests.GetTableCarriageReturn();
if (table.Rows[0][0].ToString() != "cell\r\n00")
{
throw new Exception("Should be cell\r\n00");
}
retVal += "GetTableCarriageReturn: Passed.\r\n";
//GetDataSet
DataSet ds = WebServiceTests.GetDataSet();
if (ds.Tables[0].TableName != "table0")
{
throw new Exception("Should be table0");
}
retVal += "GetDataSet: Passed.\r\n";
//GetList
List <int> listInt = WebServiceTests.GetListInt();
if (listInt[0] != 2)
{
throw new Exception("Should be 2");
}
retVal += "GetListInt: Passed.\r\n";
//GetArrayPatient
Patient[] arrayPat = WebServiceTests.GetArrayPatient();
if (arrayPat[0].LName != "Jones")
{
throw new Exception("Should be Jones");
}
if (arrayPat[1] != null)
{
throw new Exception("Should be null");
}
retVal += "GetArrayPatient: Passed.\r\n";
//SendNullParam
strResult = WebServiceTests.SendNullParam(null);
if (strResult != "nullOK")
{
throw new Exception("Should be nullOK");
}
retVal += "SendNullParam: Passed.\r\n";
//GetObjectNull
Patient pat2 = WebServiceTests.GetObjectNull();
if (pat2 != null)
{
throw new Exception("Should be null");
}
retVal += "GetObjectNull: Passed.\r\n";
//SendColorParam
Color colorResult = WebServiceTests.SendColorParam(Color.Fuchsia);
if (colorResult.ToArgb() != Color.Green.ToArgb())
{
throw new Exception("Should be green.");
}
retVal += "SendColorParam: Passed.\r\n";
//SendProviderColor
Provider prov = new Provider();
prov.ProvColor = Color.Fuchsia;
strResult = WebServiceTests.SendProviderColor(prov);
if (strResult != "fuchsiaOK")
{
throw new Exception("Should be fuchsiaOK.");
}
retVal += "SendProviderColor: Passed.\r\n";
//SendSheetParameter
SheetParameter sheetParam = new SheetParameter(false, "ParamNameOK");
strResult = WebServiceTests.SendSheetParameter(sheetParam);
if (strResult != "paramNameOK")
{
throw new Exception("Should be paramNameOK.");
}
retVal += "SendSheetParameter: Passed.\r\n";
//SendSheetWithFields
Sheet sheet = new Sheet();
sheet.SheetFields = new List <SheetField>();
sheet.Parameters = new List <SheetParameter>();
SheetField field = new SheetField();
field.FieldName = "FieldNameGreen";
sheet.SheetFields.Add(field);
strResult = WebServiceTests.SendSheetWithFields(sheet);
if (strResult != "fieldOK")
{
throw new Exception("Should be fieldOK.");
}
retVal += "SendSheetWithFields: Passed.\r\n";
//SendSheetDefWithFields
SheetDef sheetdef = new SheetDef();
sheetdef.SheetFieldDefs = new List <SheetFieldDef>();
sheetdef.Parameters = new List <SheetParameter>();
SheetFieldDef fielddef = new SheetFieldDef();
fielddef.FieldName = "FieldNameTeal";
sheetdef.SheetFieldDefs.Add(fielddef);
strResult = WebServiceTests.SendSheetDefWithFieldDefs(sheetdef);
if (strResult != "fielddefOK")
{
throw new Exception("Should be fielddefOK.");
}
retVal += "SendSheetDefWithFieldDefs: Passed.\r\n";
//TimeSpanNeg
TimeSpan tspan = WebServiceTests.GetTimeSpan();
if (tspan != new TimeSpan(1, 0, 0))
{
throw new Exception("Should be 1 hour.");
}
retVal += "GetTimeSpan: Passed.\r\n";
//GetStringContainingCR
//fails, but we have a strategy to fix some day by putting serialization code into the crud layer.
/*
* strResult=WebServiceTests.GetStringContainingCR();
* strResult=strResult.Replace("\\r","\r");
* if(strResult!="Line1\r\nLine2") {
* throw new Exception("Should be Line1\r\nLine2");
* }
* retVal+="GetStringContainingCR: Passed.\r\n";
* //GetListTasksContainingCR
* Task task=WebServiceTests.GetListTasksContainingCR()[0];
* if(task.Descript!="Line1\r\nLine2") {
* throw new Exception("Should be Line1\r\nLine2");
* }
* retVal+="GetListTasksContainingCR: Passed.\r\n";*/
return(retVal);
}
/// <summary></summary>
public static string RunAll()
{
string retVal = "";
//GetString
string strResult = WebServiceTests.GetString("Input");
if (strResult != "Input-Processed")
{
throw new Exception("Should be Input-Processed");
}
retVal += "GetString: Passed.\r\n";
strResult = WebServiceTests.GetStringNull("Input");
if (strResult != null)
{
throw new Exception("Should be null");
}
retVal += "GetStringNull: Passed.\r\n";
strResult = WebServiceTests.GetStringCarriageReturn("Carriage\r\nReturn");
if (strResult != "Carriage\r\nReturn-Processed")
{
throw new Exception("Should be Carriage\r\nReturn-Processed");
}
retVal += "GetStringCarriageReturn: Passed.\r\n";
//GetInt
int intResult = WebServiceTests.GetInt(1);
if (intResult != 2)
{
throw new Exception("Should be 2");
}
retVal += "GetInt: Passed.\r\n";
//GetLong
long longResult = WebServiceTests.GetLong(1);
if (longResult != 2)
{
throw new Exception("Should be 2");
}
retVal += "GetLong: Passed.\r\n";
//GetVoid
WebServiceTests.GetVoid();
retVal += "GetVoid: Passed.\r\n";
//GetBool
bool boolResult = WebServiceTests.GetBool();
if (boolResult != true)
{
throw new Exception("Should be true");
}
retVal += "GetBool: Passed.\r\n";
//GetObject
Patient pat = WebServiceTests.GetObjectPat();
if (pat.LName != "Smith")
{
throw new Exception("Should be Smith");
}
if (pat.FName != null)
{
throw new Exception("Should be null");
}
retVal += "GetObjectPat: Passed.\r\n";
//GetTable
DataTable table = WebServiceTests.GetTable();
if (table.Rows[0][0].ToString() != "cell00")
{
throw new Exception("Should be cell00");
}
retVal += "GetTable: Passed.\r\n";
//GetTable with carriage return
table = WebServiceTests.GetTableCarriageReturn();
if (table.Rows[0][0].ToString() != "cell\r\n00")
{
throw new Exception("Should be cell\r\n00");
}
retVal += "GetTableCarriageReturn: Passed.\r\n";
//Get2by3
table = WebServiceTests.GetTable2by3();
for (int i = 0; i < table.Rows.Count; i++)
{
for (int j = 0; j < table.Columns.Count; j++)
{
if (table.Rows[i][j].ToString() != "cell" + i.ToString() + j.ToString())
{
throw new Exception("Should be cell" + i.ToString() + j.ToString());
}
}
}
retVal += "GetTable2by3: Passed.\r\n";
//GetSpecialChars
table = WebServiceTests.GetTableSpecialChars();
char[] chars = { '|', '<', '>', '&', '\'', '"', '\\', '/' };
for (int i = 0; i < table.Rows.Count; i++)
{
for (int j = 0; j < table.Columns.Count; j++)
{
if (table.Rows[i][j].ToString() != "cell" + i.ToString() + j.ToString() + chars[i * 2 + j].ToString())
{
throw new Exception("Should be cell" + i.ToString() + j.ToString() + chars[i * 2 + j].ToString());
}
}
}
retVal += "GetTableSpecialChars: Passed.\r\n";
//GetDataTypes
table = WebServiceTests.GetTableDataTypes();
if (table.Rows[0][0].GetType() != typeof(string))
{
throw new Exception("Should be " + typeof(string).ToString());
}
if (table.Rows[0][1].GetType() != typeof(decimal))
{
throw new Exception("Should be " + typeof(decimal).ToString());
}
if (table.Rows[0][2].GetType() != typeof(DateTime))
{
throw new Exception("Should be " + typeof(DateTime).ToString());
}
retVal += "GetTableDataTypes: Passed.\r\n";
//GetDataSet
DataSet ds = WebServiceTests.GetDataSet();
if (ds.Tables[0].TableName != "table0")
{
throw new Exception("Should be table0");
}
retVal += "GetDataSet: Passed.\r\n";
//GetList
List <int> listInt = WebServiceTests.GetListInt();
if (listInt[0] != 2)
{
throw new Exception("Should be 2");
}
retVal += "GetListInt: Passed.\r\n";
//GetArrayPatient
Patient[] arrayPat = WebServiceTests.GetArrayPatient();
if (arrayPat[0].LName != "Jones")
{
throw new Exception("Should be Jones");
}
if (arrayPat[1] != null)
{
throw new Exception("Should be null");
}
retVal += "GetArrayPatient: Passed.\r\n";
//SendNullParam
strResult = WebServiceTests.SendNullParam(null);
if (strResult != "nullOK")
{
throw new Exception("Should be nullOK");
}
retVal += "SendNullParam: Passed.\r\n";
//GetObjectNull
Patient pat2 = WebServiceTests.GetObjectNull();
if (pat2 != null)
{
throw new Exception("Should be null");
}
retVal += "GetObjectNull: Passed.\r\n";
//SendColorParam
Color colorResult = WebServiceTests.SendColorParam(Color.Fuchsia);
if (colorResult.ToArgb() != Color.Green.ToArgb())
{
throw new Exception("Should be green.");
}
retVal += "SendColorParam: Passed.\r\n";
//SendProviderColor
Provider prov = new Provider();
prov.ProvColor = Color.Fuchsia;
strResult = WebServiceTests.SendProviderColor(prov);
if (strResult != "fuchsiaOK")
{
throw new Exception("Should be fuchsiaOK.");
}
retVal += "SendProviderColor: Passed.\r\n";
//SendSheetParameter
SheetParameter sheetParam = new SheetParameter(false, "ParamNameOK");
strResult = WebServiceTests.SendSheetParameter(sheetParam);
if (strResult != "paramNameOK")
{
throw new Exception("Should be paramNameOK.");
}
retVal += "SendSheetParameter: Passed.\r\n";
//SendSheetWithFields
Sheet sheet = new Sheet();
sheet.SheetFields = new List <SheetField>();
sheet.Parameters = new List <SheetParameter>();
SheetField field = new SheetField();
field.FieldName = "FieldNameGreen";
sheet.SheetFields.Add(field);
strResult = WebServiceTests.SendSheetWithFields(sheet);
if (strResult != "fieldOK")
{
throw new Exception("Should be fieldOK.");
}
retVal += "SendSheetWithFields: Passed.\r\n";
//SendSheetDefWithFields
SheetDef sheetdef = new SheetDef();
sheetdef.SheetFieldDefs = new List <SheetFieldDef>();
sheetdef.Parameters = new List <SheetParameter>();
SheetFieldDef fielddef = new SheetFieldDef();
fielddef.FieldName = "FieldNameTeal";
sheetdef.SheetFieldDefs.Add(fielddef);
strResult = WebServiceTests.SendSheetDefWithFieldDefs(sheetdef);
if (strResult != "fielddefOK")
{
throw new Exception("Should be fielddefOK.");
}
retVal += "SendSheetDefWithFieldDefs: Passed.\r\n";
//TimeSpanNeg
TimeSpan tspan = WebServiceTests.GetTimeSpan();
if (tspan != new TimeSpan(1, 0, 0))
{
throw new Exception("Should be 1 hour.");
}
retVal += "GetTimeSpan: Passed.\r\n";
//GetStringContainingCR
strResult = WebServiceTests.GetStringContainingCR();
//strResult=strResult.Replace("\\r","\r");
if (strResult != "Line1\r\nLine2")
{
throw new Exception("Should be Line1\r\nLine2");
}
retVal += "GetStringContainingCR: Passed.\r\n";
/*
* //GetListTasksContainingCR
* Task task=WebServiceTests.GetListTasksContainingCR()[0];
* if(task.Descript!="Line1\r\nLine2") {
* throw new Exception("Should be Line1\r\nLine2");
* }
* retVal+="GetListTasksContainingCR: Passed.\r\n";*/
return(retVal);
}
protected virtual void OnDelete()
{
SheetFieldDefCur = null;
DialogResult = DialogResult.OK;
}
