///<summary>Inserts one ApptViewItem into the database. Returns the new priKey.</summary>
public static long Insert(ApptViewItem apptViewItem)
{
if (DataConnection.DBtype == DatabaseType.Oracle)
{
apptViewItem.ApptViewItemNum = DbHelper.GetNextOracleKey("apptviewitem", "ApptViewItemNum");
int loopcount = 0;
while (loopcount < 100)
{
try {
return(Insert(apptViewItem, true));
}
catch (Oracle.ManagedDataAccess.Client.OracleException ex) {
if (ex.Number == 1 && ex.Message.ToLower().Contains("unique constraint") && ex.Message.ToLower().Contains("violated"))
{
apptViewItem.ApptViewItemNum++;
loopcount++;
}
else
{
throw ex;
}
}
}
throw new ApplicationException("Insert failed. Could not generate primary key.");
}
else
{
return(Insert(apptViewItem, false));
}
}
///<summary>Inserts one ApptViewItem into the database. Returns the new priKey.</summary>
internal static long Insert(ApptViewItem apptViewItem)
{
if(DataConnection.DBtype==DatabaseType.Oracle) {
apptViewItem.ApptViewItemNum=DbHelper.GetNextOracleKey("apptviewitem","ApptViewItemNum");
int loopcount=0;
while(loopcount<100){
try {
return Insert(apptViewItem,true);
}
catch(Oracle.DataAccess.Client.OracleException ex){
if(ex.Number==1 && ex.Message.ToLower().Contains("unique constraint") && ex.Message.ToLower().Contains("violated")){
apptViewItem.ApptViewItemNum++;
loopcount++;
}
else{
throw ex;
}
}
}
throw new ApplicationException("Insert failed. Could not generate primary key.");
}
else {
return Insert(apptViewItem,false);
}
}
///<summary></summary>
public static void Delete(ApptViewItem Cur)
{
string command = "DELETE from apptviewitem WHERE ApptViewItemNum = '"
+ POut.PInt(Cur.ApptViewItemNum) + "'";
General.NonQ(command);
}
///<summary>Inserts one ApptViewItem into the database. Provides option to use the existing priKey.</summary>
internal static long Insert(ApptViewItem apptViewItem,bool useExistingPK)
{
if(!useExistingPK && PrefC.RandomKeys) {
apptViewItem.ApptViewItemNum=ReplicationServers.GetKey("apptviewitem","ApptViewItemNum");
}
string command="INSERT INTO apptviewitem (";
if(useExistingPK || PrefC.RandomKeys) {
command+="ApptViewItemNum,";
}
command+="ApptViewNum,OpNum,ProvNum,ElementDesc,ElementOrder,ElementColor,ElementAlignment,ApptFieldDefNum,PatFieldDefNum) VALUES(";
if(useExistingPK || PrefC.RandomKeys) {
command+=POut.Long(apptViewItem.ApptViewItemNum)+",";
}
command+=
POut.Long (apptViewItem.ApptViewNum)+","
+ POut.Long (apptViewItem.OpNum)+","
+ POut.Long (apptViewItem.ProvNum)+","
+"'"+POut.String(apptViewItem.ElementDesc)+"',"
+ POut.Byte (apptViewItem.ElementOrder)+","
+ POut.Int (apptViewItem.ElementColor.ToArgb())+","
+ POut.Int ((int)apptViewItem.ElementAlignment)+","
+ POut.Long (apptViewItem.ApptFieldDefNum)+","
+ POut.Long (apptViewItem.PatFieldDefNum)+")";
if(useExistingPK || PrefC.RandomKeys) {
Db.NonQ(command);
}
else {
apptViewItem.ApptViewItemNum=Db.NonQ(command,true);
}
return apptViewItem.ApptViewItemNum;
}
///<summary></summary>
public static void Update(ApptViewItem Cur)
{
string command = "UPDATE apptviewitem SET "
+ "ApptViewNum='" + POut.PInt(Cur.ApptViewNum) + "'"
+ ",OpNum = '" + POut.PInt(Cur.OpNum) + "'"
+ ",ProvNum = '" + POut.PInt(Cur.ProvNum) + "'"
+ ",ElementDesc = '" + POut.PString(Cur.ElementDesc) + "'"
+ ",ElementOrder = '" + POut.PInt(Cur.ElementOrder) + "'"
+ ",ElementColor = '" + POut.PInt(Cur.ElementColor.ToArgb()) + "'"
+ " WHERE ApptViewItemNum = '" + POut.PInt(Cur.ApptViewItemNum) + "'";
General.NonQ(command);
}
private void butOK_Click(object sender, System.EventArgs e)
{
if (listOps.SelectedIndices.Count == 0 || listProv.SelectedIndices.Count == 0)
{
MessageBox.Show(Lan.g(this, "At least one operatory and one provider must be selected."));
return;
}
if (textDescription.Text == "")
{
MessageBox.Show(Lan.g(this, "A description must be entered."));
return;
}
if (displayedElements.Count == 0)
{
MessageBox.Show(Lan.g(this, "At least one row type must be displayed."));
return;
}
ApptViewItems.DeleteAllForView(ApptViewCur); //start with a clean slate
for (int i = 0; i < Operatories.ListShort.Length; i++)
{
if (listOps.SelectedIndices.Contains(i))
{
ApptViewItem ApptViewItemCur = new ApptViewItem();
ApptViewItemCur.ApptViewNum = ApptViewCur.ApptViewNum;
ApptViewItemCur.OpNum = Operatories.ListShort[i].OperatoryNum;
ApptViewItems.Insert(ApptViewItemCur);
}
}
for (int i = 0; i < Providers.List.Length; i++)
{
if (listProv.SelectedIndices.Contains(i))
{
ApptViewItem ApptViewItemCur = new ApptViewItem();
ApptViewItemCur.ApptViewNum = ApptViewCur.ApptViewNum;
ApptViewItemCur.ProvNum = Providers.List[i].ProvNum;
ApptViewItems.Insert(ApptViewItemCur);
}
}
for (int i = 0; i < displayedElements.Count; i++)
{
ApptViewItem ApptViewItemCur = (ApptViewItem)displayedElements[i];
ApptViewItemCur.ApptViewNum = ApptViewCur.ApptViewNum;
//elementDesc and elementColor already handled.
ApptViewItemCur.ElementOrder = i;
ApptViewItems.Insert(ApptViewItemCur);
}
ApptViewCur.Description = textDescription.Text;
ApptViewCur.RowsPerIncr = PIn.PInt(textRowsPerIncr.Text);
ApptViews.Update(ApptViewCur); //same whether isnew or not
DialogResult = DialogResult.OK;
}
///<summary>Inserts one ApptViewItem into the database. Returns the new priKey. Doesn't use the cache.</summary>
public static long InsertNoCache(ApptViewItem apptViewItem)
{
if (DataConnection.DBtype == DatabaseType.MySql)
{
return(InsertNoCache(apptViewItem, false));
}
else
{
if (DataConnection.DBtype == DatabaseType.Oracle)
{
apptViewItem.ApptViewItemNum = DbHelper.GetNextOracleKey("apptviewitem", "ApptViewItemNum"); //Cacheless method
}
return(InsertNoCache(apptViewItem, true));
}
}
///<summary></summary>
public static void Insert(ApptViewItem Cur)
{
string command = "INSERT INTO apptviewitem (ApptViewNum,OpNum,ProvNum,ElementDesc,"
+ "ElementOrder,ElementColor) "
+ "VALUES ("
+ "'" + POut.PInt(Cur.ApptViewNum) + "', "
+ "'" + POut.PInt(Cur.OpNum) + "', "
+ "'" + POut.PInt(Cur.ProvNum) + "', "
+ "'" + POut.PString(Cur.ElementDesc) + "', "
+ "'" + POut.PInt(Cur.ElementOrder) + "', "
+ "'" + POut.PInt(Cur.ElementColor.ToArgb()) + "')";
//MessageBox.Show(string command);
General.NonQ(command);
//Cur.ApptViewNum=InsertID;
}
///<summary>Updates one ApptViewItem in the database.</summary>
public static void Update(ApptViewItem apptViewItem)
{
string command = "UPDATE apptviewitem SET "
+ "ApptViewNum = " + POut.Long(apptViewItem.ApptViewNum) + ", "
+ "OpNum = " + POut.Long(apptViewItem.OpNum) + ", "
+ "ProvNum = " + POut.Long(apptViewItem.ProvNum) + ", "
+ "ElementDesc = '" + POut.String(apptViewItem.ElementDesc) + "', "
+ "ElementOrder = " + POut.Byte(apptViewItem.ElementOrder) + ", "
+ "ElementColor = " + POut.Int(apptViewItem.ElementColor.ToArgb()) + ", "
+ "ElementAlignment= " + POut.Int((int)apptViewItem.ElementAlignment) + ", "
+ "ApptFieldDefNum = " + POut.Long(apptViewItem.ApptFieldDefNum) + ", "
+ "PatFieldDefNum = " + POut.Long(apptViewItem.PatFieldDefNum) + " "
+ "WHERE ApptViewItemNum = " + POut.Long(apptViewItem.ApptViewItemNum);
Db.NonQ(command);
}
///<summary>Creates an appointment view with amount of operatories specified from list of op nums passed in for the
///specified clinic. Does not handle assigning providers to operatories. </summary>
public static ApptView SetApptView(List <long> listOpNums, long clinicNum = 0) //Create aptView items for list of providers passed in, list of ops passed in
{
ApptView aptView = new ApptView();
aptView.ClinicNum = clinicNum;
ApptViews.Insert(aptView);
for (int i = 0; i < listOpNums.Count; i++)
{
ApptViewItem viewItem = new ApptViewItem();
viewItem.ApptViewNum = aptView.ApptViewNum;
viewItem.OpNum = listOpNums[i];
ApptViewItems.Insert(viewItem);
}
ApptViews.RefreshCache();
ApptViewItems.RefreshCache();
return(aptView);
}
///<summary></summary>
public static void Refresh()
{
string command = "SELECT * from apptviewitem ORDER BY ElementOrder";
DataTable table = General.GetTable(command);
List = new ApptViewItem[table.Rows.Count];
for (int i = 0; i < List.Length; i++)
{
List[i] = new ApptViewItem();
List[i].ApptViewItemNum = PIn.PInt(table.Rows[i][0].ToString());
List[i].ApptViewNum = PIn.PInt(table.Rows[i][1].ToString());
List[i].OpNum = PIn.PInt(table.Rows[i][2].ToString());
List[i].ProvNum = PIn.PInt(table.Rows[i][3].ToString());
List[i].ElementDesc = PIn.PString(table.Rows[i][4].ToString());
List[i].ElementOrder = PIn.PInt(table.Rows[i][5].ToString());
List[i].ElementColor = Color.FromArgb(PIn.PInt(table.Rows[i][6].ToString()));
}
}
private void butDown_Click(object sender, System.EventArgs e)
{
if (listViewDisplay.SelectedIndices.Count == 0)
{
return;
}
int originalI = listViewDisplay.SelectedIndices[0];
if (originalI == displayedElements.Count - 1)
{
return; //can't move down any more
}
ApptViewItem item = (ApptViewItem)displayedElements[originalI];
displayedElements.RemoveAt(originalI);
displayedElements.Insert(originalI + 1, item);
FillElements();
listViewDisplay.Items[originalI + 1].Selected = true;
}
private void butLeft_Click(object sender, System.EventArgs e)
{
if (listViewAvailable.SelectedIndices.Count == 0)
{
return;
}
//the item order is not used until saving to db.
ApptViewItem item = new ApptViewItem(listViewAvailable.SelectedItems[0].Text, 0, Color.Black);
if (listViewDisplay.SelectedItems.Count == 1) //insert
{
displayedElements.Insert(listViewDisplay.SelectedItems[0].Index, item);
}
else //add to end
{
displayedElements.Add(item);
}
FillElements();
}
///<summary>Converts a DataTable to a list of objects.</summary>
public static List<ApptViewItem> TableToList(DataTable table){
List<ApptViewItem> retVal=new List<ApptViewItem>();
ApptViewItem apptViewItem;
for(int i=0;i<table.Rows.Count;i++) {
apptViewItem=new ApptViewItem();
apptViewItem.ApptViewItemNum = PIn.Long (table.Rows[i]["ApptViewItemNum"].ToString());
apptViewItem.ApptViewNum = PIn.Long (table.Rows[i]["ApptViewNum"].ToString());
apptViewItem.OpNum = PIn.Long (table.Rows[i]["OpNum"].ToString());
apptViewItem.ProvNum = PIn.Long (table.Rows[i]["ProvNum"].ToString());
apptViewItem.ElementDesc = PIn.String(table.Rows[i]["ElementDesc"].ToString());
apptViewItem.ElementOrder = PIn.Byte (table.Rows[i]["ElementOrder"].ToString());
apptViewItem.ElementColor = Color.FromArgb(PIn.Int(table.Rows[i]["ElementColor"].ToString()));
apptViewItem.ElementAlignment= (ApptViewAlignment)PIn.Int(table.Rows[i]["ElementAlignment"].ToString());
apptViewItem.ApptFieldDefNum = PIn.Long (table.Rows[i]["ApptFieldDefNum"].ToString());
apptViewItem.PatFieldDefNum = PIn.Long (table.Rows[i]["PatFieldDefNum"].ToString());
retVal.Add(apptViewItem);
}
return retVal;
}
private void listViewDisplay_DoubleClick(object sender, System.EventArgs e)
{
if (listViewDisplay.SelectedIndices.Count == 0)
{
return;
}
int originalI = listViewDisplay.SelectedIndices[0];
ApptViewItem item = (ApptViewItem)displayedElements[originalI];
colorDialog1 = new ColorDialog();
colorDialog1.Color = item.ElementColor;
if (colorDialog1.ShowDialog() != DialogResult.OK)
{
return;
}
item.ElementColor = colorDialog1.Color;
displayedElements.RemoveAt(originalI);
displayedElements.Insert(originalI, item);
FillElements();
}
///<summary>Returns true if Update(ApptViewItem,ApptViewItem) 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(ApptViewItem apptViewItem, ApptViewItem oldApptViewItem)
{
if (apptViewItem.ApptViewNum != oldApptViewItem.ApptViewNum)
{
return(true);
}
if (apptViewItem.OpNum != oldApptViewItem.OpNum)
{
return(true);
}
if (apptViewItem.ProvNum != oldApptViewItem.ProvNum)
{
return(true);
}
if (apptViewItem.ElementDesc != oldApptViewItem.ElementDesc)
{
return(true);
}
if (apptViewItem.ElementOrder != oldApptViewItem.ElementOrder)
{
return(true);
}
if (apptViewItem.ElementColor != oldApptViewItem.ElementColor)
{
return(true);
}
if (apptViewItem.ElementAlignment != oldApptViewItem.ElementAlignment)
{
return(true);
}
if (apptViewItem.ApptFieldDefNum != oldApptViewItem.ApptFieldDefNum)
{
return(true);
}
if (apptViewItem.PatFieldDefNum != oldApptViewItem.PatFieldDefNum)
{
return(true);
}
return(false);
}
///<summary>Converts a DataTable to a list of objects.</summary>
public static List <ApptViewItem> TableToList(DataTable table)
{
List <ApptViewItem> retVal = new List <ApptViewItem>();
ApptViewItem apptViewItem;
for (int i = 0; i < table.Rows.Count; i++)
{
apptViewItem = new ApptViewItem();
apptViewItem.ApptViewItemNum = PIn.Long(table.Rows[i]["ApptViewItemNum"].ToString());
apptViewItem.ApptViewNum = PIn.Long(table.Rows[i]["ApptViewNum"].ToString());
apptViewItem.OpNum = PIn.Long(table.Rows[i]["OpNum"].ToString());
apptViewItem.ProvNum = PIn.Long(table.Rows[i]["ProvNum"].ToString());
apptViewItem.ElementDesc = PIn.String(table.Rows[i]["ElementDesc"].ToString());
apptViewItem.ElementOrder = PIn.Byte(table.Rows[i]["ElementOrder"].ToString());
apptViewItem.ElementColor = Color.FromArgb(PIn.Int(table.Rows[i]["ElementColor"].ToString()));
apptViewItem.ElementAlignment = (ApptViewAlignment)PIn.Int(table.Rows[i]["ElementAlignment"].ToString());
apptViewItem.ApptFieldDefNum = PIn.Long(table.Rows[i]["ApptFieldDefNum"].ToString());
apptViewItem.PatFieldDefNum = PIn.Long(table.Rows[i]["PatFieldDefNum"].ToString());
retVal.Add(apptViewItem);
}
return(retVal);
}
///<summary>Converts a DataTable to a list of objects.</summary>
public static List <ApptViewItem> TableToList(DataTable table)
{
List <ApptViewItem> retVal = new List <ApptViewItem>();
ApptViewItem apptViewItem;
foreach (DataRow row in table.Rows)
{
apptViewItem = new ApptViewItem();
apptViewItem.ApptViewItemNum = PIn.Long(row["ApptViewItemNum"].ToString());
apptViewItem.ApptViewNum = PIn.Long(row["ApptViewNum"].ToString());
apptViewItem.OpNum = PIn.Long(row["OpNum"].ToString());
apptViewItem.ProvNum = PIn.Long(row["ProvNum"].ToString());
apptViewItem.ElementDesc = PIn.String(row["ElementDesc"].ToString());
apptViewItem.ElementOrder = PIn.Byte(row["ElementOrder"].ToString());
apptViewItem.ElementColor = Color.FromArgb(PIn.Int(row["ElementColor"].ToString()));
apptViewItem.ElementAlignment = (OpenDentBusiness.ApptViewAlignment)PIn.Int(row["ElementAlignment"].ToString());
apptViewItem.ApptFieldDefNum = PIn.Long(row["ApptFieldDefNum"].ToString());
apptViewItem.PatFieldDefNum = PIn.Long(row["PatFieldDefNum"].ToString());
retVal.Add(apptViewItem);
}
return(retVal);
}
///<summary>Inserts one ApptViewItem into the database. Provides option to use the existing priKey. Doesn't use the cache.</summary>
public static long InsertNoCache(ApptViewItem apptViewItem, bool useExistingPK)
{
bool isRandomKeys = Prefs.GetBoolNoCache(PrefName.RandomPrimaryKeys);
string command = "INSERT INTO apptviewitem (";
if (!useExistingPK && isRandomKeys)
{
apptViewItem.ApptViewItemNum = ReplicationServers.GetKeyNoCache("apptviewitem", "ApptViewItemNum");
}
if (isRandomKeys || useExistingPK)
{
command += "ApptViewItemNum,";
}
command += "ApptViewNum,OpNum,ProvNum,ElementDesc,ElementOrder,ElementColor,ElementAlignment,ApptFieldDefNum,PatFieldDefNum) VALUES(";
if (isRandomKeys || useExistingPK)
{
command += POut.Long(apptViewItem.ApptViewItemNum) + ",";
}
command +=
POut.Long(apptViewItem.ApptViewNum) + ","
+ POut.Long(apptViewItem.OpNum) + ","
+ POut.Long(apptViewItem.ProvNum) + ","
+ "'" + POut.String(apptViewItem.ElementDesc) + "',"
+ POut.Byte(apptViewItem.ElementOrder) + ","
+ POut.Int(apptViewItem.ElementColor.ToArgb()) + ","
+ POut.Int((int)apptViewItem.ElementAlignment) + ","
+ POut.Long(apptViewItem.ApptFieldDefNum) + ","
+ POut.Long(apptViewItem.PatFieldDefNum) + ")";
if (useExistingPK || isRandomKeys)
{
Db.NonQ(command);
}
else
{
apptViewItem.ApptViewItemNum = Db.NonQ(command, true, "ApptViewItemNum", "apptViewItem");
}
return(apptViewItem.ApptViewItemNum);
}
///<summary>Inserts one ApptViewItem into the database. Provides option to use the existing priKey.</summary>
internal static long Insert(ApptViewItem apptViewItem, bool useExistingPK)
{
if (!useExistingPK && PrefC.RandomKeys)
{
apptViewItem.ApptViewItemNum = ReplicationServers.GetKey("apptviewitem", "ApptViewItemNum");
}
string command = "INSERT INTO apptviewitem (";
if (useExistingPK || PrefC.RandomKeys)
{
command += "ApptViewItemNum,";
}
command += "ApptViewNum,OpNum,ProvNum,ElementDesc,ElementOrder,ElementColor,ElementAlignment,ApptFieldDefNum,PatFieldDefNum) VALUES(";
if (useExistingPK || PrefC.RandomKeys)
{
command += POut.Long(apptViewItem.ApptViewItemNum) + ",";
}
command +=
POut.Long(apptViewItem.ApptViewNum) + ","
+ POut.Long(apptViewItem.OpNum) + ","
+ POut.Long(apptViewItem.ProvNum) + ","
+ "'" + POut.String(apptViewItem.ElementDesc) + "',"
+ POut.Byte(apptViewItem.ElementOrder) + ","
+ POut.Int(apptViewItem.ElementColor.ToArgb()) + ","
+ POut.Int((int)apptViewItem.ElementAlignment) + ","
+ POut.Long(apptViewItem.ApptFieldDefNum) + ","
+ POut.Long(apptViewItem.PatFieldDefNum) + ")";
if (useExistingPK || PrefC.RandomKeys)
{
Db.NonQ(command);
}
else
{
apptViewItem.ApptViewItemNum = Db.NonQ(command, true);
}
return(apptViewItem.ApptViewItemNum);
}
public static ApptViewItem CreateApptViewItem(long opNum, long provNum, long clinicNum = 0, string apptViewDesc = "All")
{
return(DataAction.GetPractice(() => {
ApptView aptView = ApptViews.GetForClinic(clinicNum).FirstOrDefault(x => x.Description.ToLower() == apptViewDesc.ToLower());
if (aptView == null)
{
aptView = new ApptView()
{
Description = apptViewDesc,
ItemOrder = 99,
ClinicNum = clinicNum,
};
ApptViews.Insert(aptView);
}
ApptViewItem ret = new ApptViewItem()
{
ApptViewNum = aptView.ApptViewNum,
OpNum = opNum,
ProvNum = provNum,
};
ApptViewItems.Insert(ret);
return ret;
}));
}
///<summary>Updates one ApptViewItem in the database.</summary>
public static void Update(ApptViewItem apptViewItem){
string command="UPDATE apptviewitem SET "
+"ApptViewNum = "+POut.Long (apptViewItem.ApptViewNum)+", "
+"OpNum = "+POut.Long (apptViewItem.OpNum)+", "
+"ProvNum = "+POut.Long (apptViewItem.ProvNum)+", "
+"ElementDesc = '"+POut.String(apptViewItem.ElementDesc)+"', "
+"ElementOrder = "+POut.Byte (apptViewItem.ElementOrder)+", "
+"ElementColor = "+POut.Int (apptViewItem.ElementColor.ToArgb())+", "
+"ElementAlignment= "+POut.Int ((int)apptViewItem.ElementAlignment)+", "
+"ApptFieldDefNum = "+POut.Long (apptViewItem.ApptFieldDefNum)+", "
+"PatFieldDefNum = "+POut.Long (apptViewItem.PatFieldDefNum)+" "
+"WHERE ApptViewItemNum = "+POut.Long(apptViewItem.ApptViewItemNum);
Db.NonQ(command);
}
///<summary>Updates one ApptViewItem 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(ApptViewItem apptViewItem, ApptViewItem oldApptViewItem)
{
string command = "";
if (apptViewItem.ApptViewNum != oldApptViewItem.ApptViewNum)
{
if (command != "")
{
command += ",";
}
command += "ApptViewNum = " + POut.Long(apptViewItem.ApptViewNum) + "";
}
if (apptViewItem.OpNum != oldApptViewItem.OpNum)
{
if (command != "")
{
command += ",";
}
command += "OpNum = " + POut.Long(apptViewItem.OpNum) + "";
}
if (apptViewItem.ProvNum != oldApptViewItem.ProvNum)
{
if (command != "")
{
command += ",";
}
command += "ProvNum = " + POut.Long(apptViewItem.ProvNum) + "";
}
if (apptViewItem.ElementDesc != oldApptViewItem.ElementDesc)
{
if (command != "")
{
command += ",";
}
command += "ElementDesc = '" + POut.String(apptViewItem.ElementDesc) + "'";
}
if (apptViewItem.ElementOrder != oldApptViewItem.ElementOrder)
{
if (command != "")
{
command += ",";
}
command += "ElementOrder = " + POut.Byte(apptViewItem.ElementOrder) + "";
}
if (apptViewItem.ElementColor != oldApptViewItem.ElementColor)
{
if (command != "")
{
command += ",";
}
command += "ElementColor = " + POut.Int(apptViewItem.ElementColor.ToArgb()) + "";
}
if (apptViewItem.ElementAlignment != oldApptViewItem.ElementAlignment)
{
if (command != "")
{
command += ",";
}
command += "ElementAlignment = " + POut.Int((int)apptViewItem.ElementAlignment) + "";
}
if (apptViewItem.ApptFieldDefNum != oldApptViewItem.ApptFieldDefNum)
{
if (command != "")
{
command += ",";
}
command += "ApptFieldDefNum = " + POut.Long(apptViewItem.ApptFieldDefNum) + "";
}
if (apptViewItem.PatFieldDefNum != oldApptViewItem.PatFieldDefNum)
{
if (command != "")
{
command += ",";
}
command += "PatFieldDefNum = " + POut.Long(apptViewItem.PatFieldDefNum) + "";
}
if (command == "")
{
return(false);
}
command = "UPDATE apptviewitem SET " + command
+ " WHERE ApptViewItemNum = " + POut.Long(apptViewItem.ApptViewItemNum);
Db.NonQ(command);
return(true);
}
///<summary>Inserts one ApptViewItem into the database. Returns the new priKey. Doesn't use the cache.</summary>
public static long InsertNoCache(ApptViewItem apptViewItem)
{
return(InsertNoCache(apptViewItem, false));
}
///<summary>Updates one ApptViewItem 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(ApptViewItem apptViewItem,ApptViewItem oldApptViewItem){
string command="";
if(apptViewItem.ApptViewNum != oldApptViewItem.ApptViewNum) {
if(command!=""){ command+=",";}
command+="ApptViewNum = "+POut.Long(apptViewItem.ApptViewNum)+"";
}
if(apptViewItem.OpNum != oldApptViewItem.OpNum) {
if(command!=""){ command+=",";}
command+="OpNum = "+POut.Long(apptViewItem.OpNum)+"";
}
if(apptViewItem.ProvNum != oldApptViewItem.ProvNum) {
if(command!=""){ command+=",";}
command+="ProvNum = "+POut.Long(apptViewItem.ProvNum)+"";
}
if(apptViewItem.ElementDesc != oldApptViewItem.ElementDesc) {
if(command!=""){ command+=",";}
command+="ElementDesc = '"+POut.String(apptViewItem.ElementDesc)+"'";
}
if(apptViewItem.ElementOrder != oldApptViewItem.ElementOrder) {
if(command!=""){ command+=",";}
command+="ElementOrder = "+POut.Byte(apptViewItem.ElementOrder)+"";
}
if(apptViewItem.ElementColor != oldApptViewItem.ElementColor) {
if(command!=""){ command+=",";}
command+="ElementColor = "+POut.Int(apptViewItem.ElementColor.ToArgb())+"";
}
if(apptViewItem.ElementAlignment != oldApptViewItem.ElementAlignment) {
if(command!=""){ command+=",";}
command+="ElementAlignment = "+POut.Int ((int)apptViewItem.ElementAlignment)+"";
}
if(apptViewItem.ApptFieldDefNum != oldApptViewItem.ApptFieldDefNum) {
if(command!=""){ command+=",";}
command+="ApptFieldDefNum = "+POut.Long(apptViewItem.ApptFieldDefNum)+"";
}
if(apptViewItem.PatFieldDefNum != oldApptViewItem.PatFieldDefNum) {
if(command!=""){ command+=",";}
command+="PatFieldDefNum = "+POut.Long(apptViewItem.PatFieldDefNum)+"";
}
if(command==""){
return;
}
command="UPDATE apptviewitem SET "+command
+" WHERE ApptViewItemNum = "+POut.Long(apptViewItem.ApptViewItemNum);
Db.NonQ(command);
}