///<summary>Inserts one ElectID into the database. Returns the new priKey.</summary> internal static long Insert(ElectID electID) { if(DataConnection.DBtype==DatabaseType.Oracle) { electID.ElectIDNum=DbHelper.GetNextOracleKey("electid","ElectIDNum"); int loopcount=0; while(loopcount<100){ try { return Insert(electID,true); } catch(Oracle.DataAccess.Client.OracleException ex){ if(ex.Number==1 && ex.Message.ToLower().Contains("unique constraint") && ex.Message.ToLower().Contains("violated")){ electID.ElectIDNum++; loopcount++; } else{ throw ex; } } } throw new ApplicationException("Insert failed. Could not generate primary key."); } else { return Insert(electID,false); } }
///<summary>Inserts one ElectID into the database. Provides option to use the existing priKey.</summary> internal static long Insert(ElectID electID,bool useExistingPK) { if(!useExistingPK && PrefC.RandomKeys) { electID.ElectIDNum=ReplicationServers.GetKey("electid","ElectIDNum"); } string command="INSERT INTO electid ("; if(useExistingPK || PrefC.RandomKeys) { command+="ElectIDNum,"; } command+="PayorID,CarrierName,IsMedicaid,ProviderTypes,Comments) VALUES("; if(useExistingPK || PrefC.RandomKeys) { command+=POut.Long(electID.ElectIDNum)+","; } command+= "'"+POut.String(electID.PayorID)+"'," +"'"+POut.String(electID.CarrierName)+"'," + POut.Bool (electID.IsMedicaid)+"," +"'"+POut.String(electID.ProviderTypes)+"'," +"'"+POut.String(electID.Comments)+"')"; if(useExistingPK || PrefC.RandomKeys) { Db.NonQ(command); } else { electID.ElectIDNum=Db.NonQ(command,true); } return electID.ElectIDNum; }
///<summary>Updates one ElectID in the database.</summary> public static void Update(ElectID electID) { string command = "UPDATE electid SET " + "PayorID = '" + POut.String(electID.PayorID) + "', " + "CarrierName = '" + POut.String(electID.CarrierName) + "', " + "IsMedicaid = " + POut.Bool(electID.IsMedicaid) + ", " + "ProviderTypes= '" + POut.String(electID.ProviderTypes) + "', " + "Comments = '" + POut.String(electID.Comments) + "' " + "WHERE ElectIDNum = " + POut.Long(electID.ElectIDNum); Db.NonQ(command); }
///<summary>Updates one ElectID 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> internal static void Update(ElectID electID, ElectID oldElectID) { string command = ""; if (electID.PayorID != oldElectID.PayorID) { if (command != "") { command += ","; } command += "PayorID = '" + POut.String(electID.PayorID) + "'"; } if (electID.CarrierName != oldElectID.CarrierName) { if (command != "") { command += ","; } command += "CarrierName = '" + POut.String(electID.CarrierName) + "'"; } if (electID.IsMedicaid != oldElectID.IsMedicaid) { if (command != "") { command += ","; } command += "IsMedicaid = " + POut.Bool(electID.IsMedicaid) + ""; } if (electID.ProviderTypes != oldElectID.ProviderTypes) { if (command != "") { command += ","; } command += "ProviderTypes = '" + POut.String(electID.ProviderTypes) + "'"; } if (electID.Comments != oldElectID.Comments) { if (command != "") { command += ","; } command += "Comments = '" + POut.String(electID.Comments) + "'"; } if (command == "") { return; } command = "UPDATE electid SET " + command + " WHERE ElectIDNum = " + POut.Long(electID.ElectIDNum); Db.NonQ(command); }
private void butOK_Click(object sender, System.EventArgs e) { if (IsSelectMode) { if (gridElectIDs.SelectedIndices.Length < 1) { MessageBox.Show(Lan.g(this, "Please select an item first.")); return; } selectedID = _listElectIDs[gridElectIDs.SelectedIndices[0]]; } DialogResult = DialogResult.OK; }
///<summary>Inserts one ElectID into the database. Returns the new priKey. Doesn't use the cache.</summary> public static long InsertNoCache(ElectID electID) { if (DataConnection.DBtype == DatabaseType.MySql) { return(InsertNoCache(electID, false)); } else { if (DataConnection.DBtype == DatabaseType.Oracle) { electID.ElectIDNum = DbHelper.GetNextOracleKey("electid", "ElectIDNum"); //Cacheless method } return(InsertNoCache(electID, true)); } }
///<summary>Converts a DataTable to a list of objects.</summary> public static List<ElectID> TableToList(DataTable table){ List<ElectID> retVal=new List<ElectID>(); ElectID electID; for(int i=0;i<table.Rows.Count;i++) { electID=new ElectID(); electID.ElectIDNum = PIn.Long (table.Rows[i]["ElectIDNum"].ToString()); electID.PayorID = PIn.String(table.Rows[i]["PayorID"].ToString()); electID.CarrierName = PIn.String(table.Rows[i]["CarrierName"].ToString()); electID.IsMedicaid = PIn.Bool (table.Rows[i]["IsMedicaid"].ToString()); electID.ProviderTypes= PIn.String(table.Rows[i]["ProviderTypes"].ToString()); electID.Comments = PIn.String(table.Rows[i]["Comments"].ToString()); retVal.Add(electID); } return retVal; }
private void gridElectIDs_CellDoubleClick(object sender, ODGridClickEventArgs e) { if (IsSelectMode) { selectedID = _listElectIDs[e.Row]; DialogResult = DialogResult.OK; } else { FormElectIDEdit FormEdit = new FormElectIDEdit(); FormEdit.electIDCur = _listElectIDs[e.Row]; if (FormEdit.ShowDialog() == DialogResult.OK) { FillElectIDs(FormEdit.electIDCur.ElectIDNum); } } }
///<summary>Converts a DataTable to a list of objects.</summary> internal static List <ElectID> TableToList(DataTable table) { List <ElectID> retVal = new List <ElectID>(); ElectID electID; for (int i = 0; i < table.Rows.Count; i++) { electID = new ElectID(); electID.ElectIDNum = PIn.Long(table.Rows[i]["ElectIDNum"].ToString()); electID.PayorID = PIn.String(table.Rows[i]["PayorID"].ToString()); electID.CarrierName = PIn.String(table.Rows[i]["CarrierName"].ToString()); electID.IsMedicaid = PIn.Bool(table.Rows[i]["IsMedicaid"].ToString()); electID.ProviderTypes = PIn.String(table.Rows[i]["ProviderTypes"].ToString()); electID.Comments = PIn.String(table.Rows[i]["Comments"].ToString()); retVal.Add(electID); } return(retVal); }
///<summary>Converts a DataTable to a list of objects.</summary> public static List <ElectID> TableToList(DataTable table) { List <ElectID> retVal = new List <ElectID>(); ElectID electID; foreach (DataRow row in table.Rows) { electID = new ElectID(); electID.ElectIDNum = PIn.Long(row["ElectIDNum"].ToString()); electID.PayorID = PIn.String(row["PayorID"].ToString()); electID.CarrierName = PIn.String(row["CarrierName"].ToString()); electID.IsMedicaid = PIn.Bool(row["IsMedicaid"].ToString()); electID.ProviderTypes = PIn.String(row["ProviderTypes"].ToString()); electID.Comments = PIn.String(row["Comments"].ToString()); retVal.Add(electID); } return(retVal); }
///<summary>Updates one ElectID in the database.</summary> public static void Update(ElectID electID) { string command = "UPDATE electid SET " + "PayorID = '" + POut.String(electID.PayorID) + "', " + "CarrierName = '" + POut.String(electID.CarrierName) + "', " + "IsMedicaid = " + POut.Bool(electID.IsMedicaid) + ", " + "ProviderTypes= '" + POut.String(electID.ProviderTypes) + "', " + "Comments = " + DbHelper.ParamChar + "paramComments " + "WHERE ElectIDNum = " + POut.Long(electID.ElectIDNum); if (electID.Comments == null) { electID.Comments = ""; } OdSqlParameter paramComments = new OdSqlParameter("paramComments", OdDbType.Text, POut.StringParam(electID.Comments)); Db.NonQ(command, paramComments); }
///<summary>Since users not allowed to edit, this only gets run on startup.</summary> public static void Refresh() { string command = "SELECT * from electid " + "ORDER BY CarrierName"; DataTable table = General.GetTable(command); List = new ElectID[table.Rows.Count]; for (int i = 0; i < table.Rows.Count; i++) { List[i] = new ElectID(); List[i].ElectIDNum = PIn.PInt(table.Rows[i][0].ToString()); List[i].PayorID = PIn.PString(table.Rows[i][1].ToString()); List[i].CarrierName = PIn.PString(table.Rows[i][2].ToString()); List[i].IsMedicaid = PIn.PBool(table.Rows[i][3].ToString()); List[i].ProviderTypes = PIn.PString(table.Rows[i][4].ToString()); List[i].Comments = PIn.PString(table.Rows[i][5].ToString()); } }
///<summary>Inserts one ElectID into the database. Provides option to use the existing priKey. Doesn't use the cache.</summary> public static long InsertNoCache(ElectID electID, bool useExistingPK) { bool isRandomKeys = Prefs.GetBoolNoCache(PrefName.RandomPrimaryKeys); string command = "INSERT INTO electid ("; if (!useExistingPK && isRandomKeys) { electID.ElectIDNum = ReplicationServers.GetKeyNoCache("electid", "ElectIDNum"); } if (isRandomKeys || useExistingPK) { command += "ElectIDNum,"; } command += "PayorID,CarrierName,IsMedicaid,ProviderTypes,Comments) VALUES("; if (isRandomKeys || useExistingPK) { command += POut.Long(electID.ElectIDNum) + ","; } command += "'" + POut.String(electID.PayorID) + "'," + "'" + POut.String(electID.CarrierName) + "'," + POut.Bool(electID.IsMedicaid) + "," + "'" + POut.String(electID.ProviderTypes) + "'," + DbHelper.ParamChar + "paramComments)"; if (electID.Comments == null) { electID.Comments = ""; } OdSqlParameter paramComments = new OdSqlParameter("paramComments", OdDbType.Text, POut.StringParam(electID.Comments)); if (useExistingPK || isRandomKeys) { Db.NonQ(command, paramComments); } else { electID.ElectIDNum = Db.NonQ(command, true, "ElectIDNum", "electID", paramComments); } return(electID.ElectIDNum); }
///<summary>Returns true if Update(ElectID,ElectID) 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(ElectID electID, ElectID oldElectID) { if (electID.PayorID != oldElectID.PayorID) { return(true); } if (electID.CarrierName != oldElectID.CarrierName) { return(true); } if (electID.IsMedicaid != oldElectID.IsMedicaid) { return(true); } if (electID.ProviderTypes != oldElectID.ProviderTypes) { return(true); } if (electID.Comments != oldElectID.Comments) { return(true); } return(false); }
///<summary>Inserts one ElectID into the database. Returns the new priKey. Doesn't use the cache.</summary> public static long InsertNoCache(ElectID electID) { return(InsertNoCache(electID, false)); }
///<summary>Inserts one ElectID into the database. Returns the new priKey.</summary> public static long Insert(ElectID electID) { return(Insert(electID, false)); }
///<summary>Updates one ElectID in the database.</summary> public static void Update(ElectID electID){ string command="UPDATE electid SET " +"PayorID = '"+POut.String(electID.PayorID)+"', " +"CarrierName = '"+POut.String(electID.CarrierName)+"', " +"IsMedicaid = "+POut.Bool (electID.IsMedicaid)+", " +"ProviderTypes= '"+POut.String(electID.ProviderTypes)+"', " +"Comments = '"+POut.String(electID.Comments)+"' " +"WHERE ElectIDNum = "+POut.Long(electID.ElectIDNum); Db.NonQ(command); }
///<summary>Updates one ElectID 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(ElectID electID,ElectID oldElectID){ string command=""; if(electID.PayorID != oldElectID.PayorID) { if(command!=""){ command+=",";} command+="PayorID = '"+POut.String(electID.PayorID)+"'"; } if(electID.CarrierName != oldElectID.CarrierName) { if(command!=""){ command+=",";} command+="CarrierName = '"+POut.String(electID.CarrierName)+"'"; } if(electID.IsMedicaid != oldElectID.IsMedicaid) { if(command!=""){ command+=",";} command+="IsMedicaid = "+POut.Bool(electID.IsMedicaid)+""; } if(electID.ProviderTypes != oldElectID.ProviderTypes) { if(command!=""){ command+=",";} command+="ProviderTypes = '"+POut.String(electID.ProviderTypes)+"'"; } if(electID.Comments != oldElectID.Comments) { if(command!=""){ command+=",";} command+="Comments = '"+POut.String(electID.Comments)+"'"; } if(command==""){ return; } command="UPDATE electid SET "+command +" WHERE ElectIDNum = "+POut.Long(electID.ElectIDNum); Db.NonQ(command); }