///<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);
}