private void butDelete_Click(object sender, System.EventArgs e)
{
if (!MsgBox.Show(this, MsgBoxButtons.YesNo, "Delete this Reactivation?"))
{
return;
}
if (!_reactivationCur.IsNew)
{
Reactivations.Delete(_reactivationCur.ReactivationNum);
}
_reactivationCur = null;
DialogResult = DialogResult.Abort;
}
///<summary>Updates one Reactivation 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(Reactivation reactivation, Reactivation oldReactivation)
{
string command = "";
if (reactivation.PatNum != oldReactivation.PatNum)
{
if (command != "")
{
command += ",";
}
command += "PatNum = " + POut.Long(reactivation.PatNum) + "";
}
if (reactivation.ReactivationStatus != oldReactivation.ReactivationStatus)
{
if (command != "")
{
command += ",";
}
command += "ReactivationStatus = " + POut.Long(reactivation.ReactivationStatus) + "";
}
if (reactivation.ReactivationNote != oldReactivation.ReactivationNote)
{
if (command != "")
{
command += ",";
}
command += "ReactivationNote = " + DbHelper.ParamChar + "paramReactivationNote";
}
if (reactivation.DoNotContact != oldReactivation.DoNotContact)
{
if (command != "")
{
command += ",";
}
command += "DoNotContact = " + POut.Bool(reactivation.DoNotContact) + "";
}
if (command == "")
{
return(false);
}
if (reactivation.ReactivationNote == null)
{
reactivation.ReactivationNote = "";
}
OdSqlParameter paramReactivationNote = new OdSqlParameter("paramReactivationNote", OdDbType.Text, POut.StringParam(reactivation.ReactivationNote));
command = "UPDATE reactivation SET " + command
+ " WHERE ReactivationNum = " + POut.Long(reactivation.ReactivationNum);
Db.NonQ(command, paramReactivationNote);
return(true);
}
///<summary>Converts a DataTable to a list of objects.</summary>
public static List <Reactivation> TableToList(DataTable table)
{
List <Reactivation> retVal = new List <Reactivation>();
Reactivation reactivation;
foreach (DataRow row in table.Rows)
{
reactivation = new Reactivation();
reactivation.ReactivationNum = PIn.Long(row["ReactivationNum"].ToString());
reactivation.PatNum = PIn.Long(row["PatNum"].ToString());
reactivation.ReactivationStatus = PIn.Long(row["ReactivationStatus"].ToString());
reactivation.ReactivationNote = PIn.String(row["ReactivationNote"].ToString());
reactivation.DoNotContact = PIn.Bool(row["DoNotContact"].ToString());
retVal.Add(reactivation);
}
return(retVal);
}
///<summary>Updates one Reactivation in the database.</summary>
public static void Update(Reactivation reactivation)
{
string command = "UPDATE reactivation SET "
+ "PatNum = " + POut.Long(reactivation.PatNum) + ", "
+ "ReactivationStatus= " + POut.Long(reactivation.ReactivationStatus) + ", "
+ "ReactivationNote = " + DbHelper.ParamChar + "paramReactivationNote, "
+ "DoNotContact = " + POut.Bool(reactivation.DoNotContact) + " "
+ "WHERE ReactivationNum = " + POut.Long(reactivation.ReactivationNum);
if (reactivation.ReactivationNote == null)
{
reactivation.ReactivationNote = "";
}
OdSqlParameter paramReactivationNote = new OdSqlParameter("paramReactivationNote", OdDbType.Text, POut.StringParam(reactivation.ReactivationNote));
Db.NonQ(command, paramReactivationNote);
}
///<summary>Returns true if Update(Reactivation,Reactivation) 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(Reactivation reactivation, Reactivation oldReactivation)
{
if (reactivation.PatNum != oldReactivation.PatNum)
{
return(true);
}
if (reactivation.ReactivationStatus != oldReactivation.ReactivationStatus)
{
return(true);
}
if (reactivation.ReactivationNote != oldReactivation.ReactivationNote)
{
return(true);
}
if (reactivation.DoNotContact != oldReactivation.DoNotContact)
{
return(true);
}
return(false);
}
///<summary>Inserts one Reactivation into the database. Provides option to use the existing priKey. Doesn't use the cache.</summary>
public static long InsertNoCache(Reactivation reactivation, bool useExistingPK)
{
bool isRandomKeys = Prefs.GetBoolNoCache(PrefName.RandomPrimaryKeys);
string command = "INSERT INTO reactivation (";
if (!useExistingPK && isRandomKeys)
{
reactivation.ReactivationNum = ReplicationServers.GetKeyNoCache("reactivation", "ReactivationNum");
}
if (isRandomKeys || useExistingPK)
{
command += "ReactivationNum,";
}
command += "PatNum,ReactivationStatus,ReactivationNote,DoNotContact) VALUES(";
if (isRandomKeys || useExistingPK)
{
command += POut.Long(reactivation.ReactivationNum) + ",";
}
command +=
POut.Long(reactivation.PatNum) + ","
+ POut.Long(reactivation.ReactivationStatus) + ","
+ DbHelper.ParamChar + "paramReactivationNote,"
+ POut.Bool(reactivation.DoNotContact) + ")";
if (reactivation.ReactivationNote == null)
{
reactivation.ReactivationNote = "";
}
OdSqlParameter paramReactivationNote = new OdSqlParameter("paramReactivationNote", OdDbType.Text, POut.StringParam(reactivation.ReactivationNote));
if (useExistingPK || isRandomKeys)
{
Db.NonQ(command, paramReactivationNote);
}
else
{
reactivation.ReactivationNum = Db.NonQ(command, true, "ReactivationNum", "reactivation", paramReactivationNote);
}
return(reactivation.ReactivationNum);
}
///<summary></summary>
public FormReactivationEdit(Reactivation reactivationCur)
{
InitializeComponent();
Lan.F(this);
_reactivationCur = reactivationCur;
}
///<summary>Inserts one Reactivation into the database. Returns the new priKey.</summary>
public static long Insert(Reactivation reactivation)
{
return(Insert(reactivation, false));
}
