///<summary>Inserts one Dunning into the database. Returns the new priKey.</summary>
internal static long Insert(Dunning dunning)
{
if(DataConnection.DBtype==DatabaseType.Oracle) {
dunning.DunningNum=DbHelper.GetNextOracleKey("dunning","DunningNum");
int loopcount=0;
while(loopcount<100){
try {
return Insert(dunning,true);
}
catch(Oracle.DataAccess.Client.OracleException ex){
if(ex.Number==1 && ex.Message.ToLower().Contains("unique constraint") && ex.Message.ToLower().Contains("violated")){
dunning.DunningNum++;
loopcount++;
}
else{
throw ex;
}
}
}
throw new ApplicationException("Insert failed. Could not generate primary key.");
}
else {
return Insert(dunning,false);
}
}
///<summary>Inserts one Dunning into the database. Provides option to use the existing priKey.</summary>
internal static long Insert(Dunning dunning, bool useExistingPK)
{
if (!useExistingPK && PrefC.RandomKeys)
{
dunning.DunningNum = ReplicationServers.GetKey("dunning", "DunningNum");
}
string command = "INSERT INTO dunning (";
if (useExistingPK || PrefC.RandomKeys)
{
command += "DunningNum,";
}
command += "DunMessage,BillingType,AgeAccount,InsIsPending,MessageBold) VALUES(";
if (useExistingPK || PrefC.RandomKeys)
{
command += POut.Long(dunning.DunningNum) + ",";
}
command +=
"'" + POut.String(dunning.DunMessage) + "',"
+ POut.Long(dunning.BillingType) + ","
+ POut.Byte(dunning.AgeAccount) + ","
+ POut.Int((int)dunning.InsIsPending) + ","
+ "'" + POut.String(dunning.MessageBold) + "')";
if (useExistingPK || PrefC.RandomKeys)
{
Db.NonQ(command);
}
else
{
dunning.DunningNum = Db.NonQ(command, true);
}
return(dunning.DunningNum);
}
///<summary>Inserts one Dunning into the database. Provides option to use the existing priKey.</summary>
internal static long Insert(Dunning dunning,bool useExistingPK)
{
if(!useExistingPK && PrefC.RandomKeys) {
dunning.DunningNum=ReplicationServers.GetKey("dunning","DunningNum");
}
string command="INSERT INTO dunning (";
if(useExistingPK || PrefC.RandomKeys) {
command+="DunningNum,";
}
command+="DunMessage,BillingType,AgeAccount,InsIsPending,MessageBold) VALUES(";
if(useExistingPK || PrefC.RandomKeys) {
command+=POut.Long(dunning.DunningNum)+",";
}
command+=
"'"+POut.String(dunning.DunMessage)+"',"
+ POut.Long (dunning.BillingType)+","
+ POut.Byte (dunning.AgeAccount)+","
+ POut.Int ((int)dunning.InsIsPending)+","
+"'"+POut.String(dunning.MessageBold)+"')";
if(useExistingPK || PrefC.RandomKeys) {
Db.NonQ(command);
}
else {
dunning.DunningNum=Db.NonQ(command,true);
}
return dunning.DunningNum;
}
///<summary>Updates one Dunning in the database.</summary>
public static void Update(Dunning dunning)
{
string command = "UPDATE dunning SET "
+ "DunMessage = " + DbHelper.ParamChar + "paramDunMessage, "
+ "BillingType = " + POut.Long(dunning.BillingType) + ", "
+ "AgeAccount = " + POut.Byte(dunning.AgeAccount) + ", "
+ "InsIsPending = " + POut.Int((int)dunning.InsIsPending) + ", "
+ "MessageBold = " + DbHelper.ParamChar + "paramMessageBold, "
+ "EmailSubject = '" + POut.String(dunning.EmailSubject) + "', "
+ "EmailBody = " + DbHelper.ParamChar + "paramEmailBody, "
+ "DaysInAdvance= " + POut.Int(dunning.DaysInAdvance) + ", "
+ "ClinicNum = " + POut.Long(dunning.ClinicNum) + " "
+ "WHERE DunningNum = " + POut.Long(dunning.DunningNum);
if (dunning.DunMessage == null)
{
dunning.DunMessage = "";
}
OdSqlParameter paramDunMessage = new OdSqlParameter("paramDunMessage", OdDbType.Text, POut.StringParam(dunning.DunMessage));
if (dunning.MessageBold == null)
{
dunning.MessageBold = "";
}
OdSqlParameter paramMessageBold = new OdSqlParameter("paramMessageBold", OdDbType.Text, POut.StringParam(dunning.MessageBold));
if (dunning.EmailBody == null)
{
dunning.EmailBody = "";
}
OdSqlParameter paramEmailBody = new OdSqlParameter("paramEmailBody", OdDbType.Text, POut.StringParam(dunning.EmailBody));
Db.NonQ(command, paramDunMessage, paramMessageBold, paramEmailBody);
}
///<summary>Inserts one Dunning into the database. Returns the new priKey.</summary>
public static long Insert(Dunning dunning)
{
if (DataConnection.DBtype == DatabaseType.Oracle)
{
dunning.DunningNum = DbHelper.GetNextOracleKey("dunning", "DunningNum");
int loopcount = 0;
while (loopcount < 100)
{
try {
return(Insert(dunning, true));
}
catch (Oracle.ManagedDataAccess.Client.OracleException ex) {
if (ex.Number == 1 && ex.Message.ToLower().Contains("unique constraint") && ex.Message.ToLower().Contains("violated"))
{
dunning.DunningNum++;
loopcount++;
}
else
{
throw ex;
}
}
}
throw new ApplicationException("Insert failed. Could not generate primary key.");
}
else
{
return(Insert(dunning, false));
}
}
///<summary></summary>
public static void Delete(Dunning dun)
{
string command = "DELETE FROM dunning"
+ " WHERE DunningNum = " + POut.PInt(dun.DunningNum);
General.NonQ(command);
}
///<summary></summary>
public FormDunningEdit(Dunning dunningCur)
{
//
// Required for Windows Form Designer support
//
DunningCur = dunningCur.Copy();
InitializeComponent();
Lan.F(this);
}
///<summary>Inserts one Dunning into the database. Provides option to use the existing priKey. Doesn't use the cache.</summary>
public static long InsertNoCache(Dunning dunning, bool useExistingPK)
{
bool isRandomKeys = Prefs.GetBoolNoCache(PrefName.RandomPrimaryKeys);
string command = "INSERT INTO dunning (";
if (!useExistingPK && isRandomKeys)
{
dunning.DunningNum = ReplicationServers.GetKeyNoCache("dunning", "DunningNum");
}
if (isRandomKeys || useExistingPK)
{
command += "DunningNum,";
}
command += "DunMessage,BillingType,AgeAccount,InsIsPending,MessageBold,EmailSubject,EmailBody,DaysInAdvance,ClinicNum,IsSuperFamily) VALUES(";
if (isRandomKeys || useExistingPK)
{
command += POut.Long(dunning.DunningNum) + ",";
}
command +=
DbHelper.ParamChar + "paramDunMessage,"
+ POut.Long(dunning.BillingType) + ","
+ POut.Byte(dunning.AgeAccount) + ","
+ POut.Int((int)dunning.InsIsPending) + ","
+ DbHelper.ParamChar + "paramMessageBold,"
+ "'" + POut.String(dunning.EmailSubject) + "',"
+ DbHelper.ParamChar + "paramEmailBody,"
+ POut.Int(dunning.DaysInAdvance) + ","
+ POut.Long(dunning.ClinicNum) + ","
+ POut.Bool(dunning.IsSuperFamily) + ")";
if (dunning.DunMessage == null)
{
dunning.DunMessage = "";
}
OdSqlParameter paramDunMessage = new OdSqlParameter("paramDunMessage", OdDbType.Text, POut.StringParam(dunning.DunMessage));
if (dunning.MessageBold == null)
{
dunning.MessageBold = "";
}
OdSqlParameter paramMessageBold = new OdSqlParameter("paramMessageBold", OdDbType.Text, POut.StringParam(dunning.MessageBold));
if (dunning.EmailBody == null)
{
dunning.EmailBody = "";
}
OdSqlParameter paramEmailBody = new OdSqlParameter("paramEmailBody", OdDbType.Text, POut.StringParam(dunning.EmailBody));
if (useExistingPK || isRandomKeys)
{
Db.NonQ(command, paramDunMessage, paramMessageBold, paramEmailBody);
}
else
{
dunning.DunningNum = Db.NonQ(command, true, "DunningNum", "dunning", paramDunMessage, paramMessageBold, paramEmailBody);
}
return(dunning.DunningNum);
}
///<summary></summary>
private static void Insert(Dunning dun)
{
string command = "INSERT INTO dunning (DunMessage,BillingType,AgeAccount,InsIsPending) VALUES("
+ "'" + POut.PString(dun.DunMessage) + "', "
+ "'" + POut.PInt(dun.BillingType) + "', "
+ "'" + POut.PInt(dun.AgeAccount) + "', "
+ "'" + POut.PInt((int)dun.InsIsPending) + "')";
dun.DunningNum = General.NonQ(command, true);
}
///<summary></summary>
private static void Update(Dunning dun)
{
string command = "UPDATE dunning SET "
+ "DunMessage = '" + POut.PString(dun.DunMessage) + "'"
+ ",BillingType = '" + POut.PInt(dun.BillingType) + "'"
+ ",AgeAccount = '" + POut.PInt(dun.AgeAccount) + "'"
+ ",InsIsPending = '" + POut.PInt((int)dun.InsIsPending) + "'"
+ " WHERE DunningNum = '" + POut.PInt(dun.DunningNum) + "'";
General.NonQ(command);
}
///<summary>Updates one Dunning in the database.</summary>
internal static void Update(Dunning dunning)
{
string command = "UPDATE dunning SET "
+ "DunMessage = '" + POut.String(dunning.DunMessage) + "', "
+ "BillingType = " + POut.Long(dunning.BillingType) + ", "
+ "AgeAccount = " + POut.Byte(dunning.AgeAccount) + ", "
+ "InsIsPending= " + POut.Int((int)dunning.InsIsPending) + ", "
+ "MessageBold = '" + POut.String(dunning.MessageBold) + "' "
+ "WHERE DunningNum = " + POut.Long(dunning.DunningNum);
Db.NonQ(command);
}
///<summary>Updates one Dunning 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(Dunning dunning, Dunning oldDunning)
{
string command = "";
if (dunning.DunMessage != oldDunning.DunMessage)
{
if (command != "")
{
command += ",";
}
command += "DunMessage = '" + POut.String(dunning.DunMessage) + "'";
}
if (dunning.BillingType != oldDunning.BillingType)
{
if (command != "")
{
command += ",";
}
command += "BillingType = " + POut.Long(dunning.BillingType) + "";
}
if (dunning.AgeAccount != oldDunning.AgeAccount)
{
if (command != "")
{
command += ",";
}
command += "AgeAccount = " + POut.Byte(dunning.AgeAccount) + "";
}
if (dunning.InsIsPending != oldDunning.InsIsPending)
{
if (command != "")
{
command += ",";
}
command += "InsIsPending = " + POut.Int((int)dunning.InsIsPending) + "";
}
if (dunning.MessageBold != oldDunning.MessageBold)
{
if (command != "")
{
command += ",";
}
command += "MessageBold = '" + POut.String(dunning.MessageBold) + "'";
}
if (command == "")
{
return;
}
command = "UPDATE dunning SET " + command
+ " WHERE DunningNum = " + POut.Long(dunning.DunningNum);
Db.NonQ(command);
}
private void butDuplicate_Click(object sender, EventArgs e)
{
if (gridDunning.SelectedIndices.Count() == 0)
{
MsgBox.Show(this, "Please select a message to duplicate first.");
return;
}
Dunning dun = ((Dunning)gridDunning.ListGridRows[gridDunning.GetSelectedIndex()].Tag).Copy();
Dunnings.Insert(dun);
FillGrids(true);
gridDunning.SetSelected(gridDunning.ListGridRows.OfType <GridRow>().ToList().FindIndex(x => ((Dunning)x.Tag).DunningNum == dun.DunningNum), true);
}
private void butAdd_Click(object sender, System.EventArgs e)
{
Dunning dun = new Dunning();
FormDunningEdit FormD = new FormDunningEdit(dun);
FormD.IsNew = true;
FormD.ShowDialog();
if (FormD.DialogResult == DialogResult.Cancel)
{
return;
}
FillDunning();
}
///<summary></summary>
public static void InsertOrUpdate(Dunning dun, bool IsNew)
{
//if(){
//throw new Exception(Lan.g(this,""));
//}
if (IsNew)
{
Insert(dun);
}
else
{
Update(dun);
}
}
///<summary>Inserts one Dunning into the database. Returns the new priKey. Doesn't use the cache.</summary>
public static long InsertNoCache(Dunning dunning)
{
if (DataConnection.DBtype == DatabaseType.MySql)
{
return(InsertNoCache(dunning, false));
}
else
{
if (DataConnection.DBtype == DatabaseType.Oracle)
{
dunning.DunningNum = DbHelper.GetNextOracleKey("dunning", "DunningNum"); //Cacheless method
}
return(InsertNoCache(dunning, true));
}
}
private void butAdd_Click(object sender, EventArgs e)
{
Dunning dun = new Dunning();
long clinicNum = GetSelectedClinicNum();
if (clinicNum != -1) //If 'All' is selected, then ClinicNums=0
{
dun.ClinicNum = clinicNum;
}
FormDunningEdit FormD = new FormDunningEdit(dun);
FormD.IsNew = true;
if (FormD.ShowDialog() == DialogResult.OK)
{
FillGrids(true);
}
}
///<summary>Converts a DataTable to a list of objects.</summary>
public static List<Dunning> TableToList(DataTable table){
List<Dunning> retVal=new List<Dunning>();
Dunning dunning;
for(int i=0;i<table.Rows.Count;i++) {
dunning=new Dunning();
dunning.DunningNum = PIn.Long (table.Rows[i]["DunningNum"].ToString());
dunning.DunMessage = PIn.String(table.Rows[i]["DunMessage"].ToString());
dunning.BillingType = PIn.Long (table.Rows[i]["BillingType"].ToString());
dunning.AgeAccount = PIn.Byte (table.Rows[i]["AgeAccount"].ToString());
dunning.InsIsPending= (YN)PIn.Int(table.Rows[i]["InsIsPending"].ToString());
dunning.MessageBold = PIn.String(table.Rows[i]["MessageBold"].ToString());
dunning.EmailSubject= PIn.String(table.Rows[i]["EmailSubject"].ToString());
dunning.EmailBody = PIn.String(table.Rows[i]["EmailBody"].ToString());
retVal.Add(dunning);
}
return retVal;
}
///<summary>Converts a DataTable to a list of objects.</summary>
internal static List <Dunning> TableToList(DataTable table)
{
List <Dunning> retVal = new List <Dunning>();
Dunning dunning;
for (int i = 0; i < table.Rows.Count; i++)
{
dunning = new Dunning();
dunning.DunningNum = PIn.Long(table.Rows[i]["DunningNum"].ToString());
dunning.DunMessage = PIn.String(table.Rows[i]["DunMessage"].ToString());
dunning.BillingType = PIn.Long(table.Rows[i]["BillingType"].ToString());
dunning.AgeAccount = PIn.Byte(table.Rows[i]["AgeAccount"].ToString());
dunning.InsIsPending = (YN)PIn.Int(table.Rows[i]["InsIsPending"].ToString());
dunning.MessageBold = PIn.String(table.Rows[i]["MessageBold"].ToString());
retVal.Add(dunning);
}
return(retVal);
}
///<summary>Gets a list of all dunnings.</summary>
public static Dunning[] Refresh()
{
string command = "SELECT * FROM dunning "
+ "ORDER BY BillingType,AgeAccount,InsIsPending";
DataTable table = General.GetTable(command);
Dunning[] List = new Dunning[table.Rows.Count];
for (int i = 0; i < table.Rows.Count; i++)
{
List[i] = new Dunning();
List[i].DunningNum = PIn.PInt(table.Rows[i][0].ToString());
List[i].DunMessage = PIn.PString(table.Rows[i][1].ToString());
List[i].BillingType = PIn.PInt(table.Rows[i][2].ToString());
List[i].AgeAccount = PIn.PInt(table.Rows[i][3].ToString());
List[i].InsIsPending = (YN)PIn.PInt(table.Rows[i][4].ToString());
}
return(List);
}
private bool ValidateDunningFilters(Dunning dunning)
{
long clinicNum = GetSelectedClinicNum();
if ((clinicNum != -1 && clinicNum != dunning.ClinicNum) ||
(!listBill.SelectedIndices.Contains(0) && !listBill.SelectedIndices.OfType <int>().Select(x => _listBillingTypeDefs[x - 1].DefNum).Contains(dunning.BillingType)) ||
(!radioAny.Checked && dunning.AgeAccount != (byte)(30 * new List <RadioButton> {
radioAny, radio30, radio60, radio90
}.FindIndex(x => x.Checked))) || //0, 30, 60, or 90
(!string.IsNullOrWhiteSpace(textAdv.Text) && dunning.DaysInAdvance != PIn.Int(textAdv.Text, false)) || //blank=0
(!radioU.Checked && dunning.InsIsPending != (YN) new List <RadioButton> {
radioU, radioY, radioN
}.FindIndex(x => x.Checked))) //0=Unknown, 1=Yes, 2=No+
{
return(false);
}
return(true);
}
///<summary>Returns true if Update(Dunning,Dunning) 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(Dunning dunning, Dunning oldDunning)
{
if (dunning.DunMessage != oldDunning.DunMessage)
{
return(true);
}
if (dunning.BillingType != oldDunning.BillingType)
{
return(true);
}
if (dunning.AgeAccount != oldDunning.AgeAccount)
{
return(true);
}
if (dunning.InsIsPending != oldDunning.InsIsPending)
{
return(true);
}
if (dunning.MessageBold != oldDunning.MessageBold)
{
return(true);
}
if (dunning.EmailSubject != oldDunning.EmailSubject)
{
return(true);
}
if (dunning.EmailBody != oldDunning.EmailBody)
{
return(true);
}
if (dunning.DaysInAdvance != oldDunning.DaysInAdvance)
{
return(true);
}
if (dunning.ClinicNum != oldDunning.ClinicNum)
{
return(true);
}
if (dunning.IsSuperFamily != oldDunning.IsSuperFamily)
{
return(true);
}
return(false);
}
///<summary>Inserts one Dunning into the database. Provides option to use the existing priKey.</summary>
public static long Insert(Dunning dunning, bool useExistingPK)
{
if (!useExistingPK && PrefC.RandomKeys)
{
dunning.DunningNum = ReplicationServers.GetKey("dunning", "DunningNum");
}
string command = "INSERT INTO dunning (";
if (useExistingPK || PrefC.RandomKeys)
{
command += "DunningNum,";
}
command += "DunMessage,BillingType,AgeAccount,InsIsPending,MessageBold,EmailSubject,EmailBody) VALUES(";
if (useExistingPK || PrefC.RandomKeys)
{
command += POut.Long(dunning.DunningNum) + ",";
}
command +=
"'" + POut.String(dunning.DunMessage) + "',"
+ POut.Long(dunning.BillingType) + ","
+ POut.Byte(dunning.AgeAccount) + ","
+ POut.Int((int)dunning.InsIsPending) + ","
+ "'" + POut.String(dunning.MessageBold) + "',"
+ "'" + POut.String(dunning.EmailSubject) + "',"
+ DbHelper.ParamChar + "paramEmailBody)";
if (dunning.EmailBody == null)
{
dunning.EmailBody = "";
}
OdSqlParameter paramEmailBody = new OdSqlParameter("paramEmailBody", OdDbType.Text, dunning.EmailBody);
if (useExistingPK || PrefC.RandomKeys)
{
Db.NonQ(command, paramEmailBody);
}
else
{
dunning.DunningNum = Db.NonQ(command, true, paramEmailBody);
}
return(dunning.DunningNum);
}
///<summary>Converts a DataTable to a list of objects.</summary>
public static List <Dunning> TableToList(DataTable table)
{
List <Dunning> retVal = new List <Dunning>();
Dunning dunning;
foreach (DataRow row in table.Rows)
{
dunning = new Dunning();
dunning.DunningNum = PIn.Long(row["DunningNum"].ToString());
dunning.DunMessage = PIn.String(row["DunMessage"].ToString());
dunning.BillingType = PIn.Long(row["BillingType"].ToString());
dunning.AgeAccount = PIn.Byte(row["AgeAccount"].ToString());
dunning.InsIsPending = (OpenDentBusiness.YN)PIn.Int(row["InsIsPending"].ToString());
dunning.MessageBold = PIn.String(row["MessageBold"].ToString());
dunning.EmailSubject = PIn.String(row["EmailSubject"].ToString());
dunning.EmailBody = PIn.String(row["EmailBody"].ToString());
dunning.DaysInAdvance = PIn.Int(row["DaysInAdvance"].ToString());
dunning.ClinicNum = PIn.Long(row["ClinicNum"].ToString());
retVal.Add(dunning);
}
return(retVal);
}
///<summary>Inserts one Dunning into the database. Returns the new priKey.</summary>
public static long Insert(Dunning dunning)
{
return(Insert(dunning, false));
}
///<summary>Updates one Dunning 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(Dunning dunning, Dunning oldDunning)
{
string command = "";
if (dunning.DunMessage != oldDunning.DunMessage)
{
if (command != "")
{
command += ",";
}
command += "DunMessage = '" + POut.String(dunning.DunMessage) + "'";
}
if (dunning.BillingType != oldDunning.BillingType)
{
if (command != "")
{
command += ",";
}
command += "BillingType = " + POut.Long(dunning.BillingType) + "";
}
if (dunning.AgeAccount != oldDunning.AgeAccount)
{
if (command != "")
{
command += ",";
}
command += "AgeAccount = " + POut.Byte(dunning.AgeAccount) + "";
}
if (dunning.InsIsPending != oldDunning.InsIsPending)
{
if (command != "")
{
command += ",";
}
command += "InsIsPending = " + POut.Int((int)dunning.InsIsPending) + "";
}
if (dunning.MessageBold != oldDunning.MessageBold)
{
if (command != "")
{
command += ",";
}
command += "MessageBold = '" + POut.String(dunning.MessageBold) + "'";
}
if (dunning.EmailSubject != oldDunning.EmailSubject)
{
if (command != "")
{
command += ",";
}
command += "EmailSubject = '" + POut.String(dunning.EmailSubject) + "'";
}
if (dunning.EmailBody != oldDunning.EmailBody)
{
if (command != "")
{
command += ",";
}
command += "EmailBody = " + DbHelper.ParamChar + "paramEmailBody";
}
if (command == "")
{
return;
}
if (dunning.EmailBody == null)
{
dunning.EmailBody = "";
}
OdSqlParameter paramEmailBody = new OdSqlParameter("paramEmailBody", OdDbType.Text, dunning.EmailBody);
command = "UPDATE dunning SET " + command
+ " WHERE DunningNum = " + POut.Long(dunning.DunningNum);
Db.NonQ(command, paramEmailBody);
}
///<summary>Inserts one Dunning into the database. Provides option to use the existing priKey.</summary>
public static long Insert(Dunning dunning,bool useExistingPK){
if(!useExistingPK && PrefC.RandomKeys) {
dunning.DunningNum=ReplicationServers.GetKey("dunning","DunningNum");
}
string command="INSERT INTO dunning (";
if(useExistingPK || PrefC.RandomKeys) {
command+="DunningNum,";
}
command+="DunMessage,BillingType,AgeAccount,InsIsPending,MessageBold,EmailSubject,EmailBody) VALUES(";
if(useExistingPK || PrefC.RandomKeys) {
command+=POut.Long(dunning.DunningNum)+",";
}
command+=
"'"+POut.String(dunning.DunMessage)+"',"
+ POut.Long (dunning.BillingType)+","
+ POut.Byte (dunning.AgeAccount)+","
+ POut.Int ((int)dunning.InsIsPending)+","
+"'"+POut.String(dunning.MessageBold)+"',"
+"'"+POut.String(dunning.EmailSubject)+"',"
+DbHelper.ParamChar+"paramEmailBody)";
if(dunning.EmailBody==null) {
dunning.EmailBody="";
}
OdSqlParameter paramEmailBody=new OdSqlParameter("paramEmailBody",OdDbType.Text,dunning.EmailBody);
if(useExistingPK || PrefC.RandomKeys) {
Db.NonQ(command,paramEmailBody);
}
else {
dunning.DunningNum=Db.NonQ(command,true,paramEmailBody);
}
return dunning.DunningNum;
}
///<summary>Updates one Dunning 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(Dunning dunning,Dunning oldDunning){
string command="";
if(dunning.DunMessage != oldDunning.DunMessage) {
if(command!=""){ command+=",";}
command+="DunMessage = '"+POut.String(dunning.DunMessage)+"'";
}
if(dunning.BillingType != oldDunning.BillingType) {
if(command!=""){ command+=",";}
command+="BillingType = "+POut.Long(dunning.BillingType)+"";
}
if(dunning.AgeAccount != oldDunning.AgeAccount) {
if(command!=""){ command+=",";}
command+="AgeAccount = "+POut.Byte(dunning.AgeAccount)+"";
}
if(dunning.InsIsPending != oldDunning.InsIsPending) {
if(command!=""){ command+=",";}
command+="InsIsPending = "+POut.Int ((int)dunning.InsIsPending)+"";
}
if(dunning.MessageBold != oldDunning.MessageBold) {
if(command!=""){ command+=",";}
command+="MessageBold = '"+POut.String(dunning.MessageBold)+"'";
}
if(dunning.EmailSubject != oldDunning.EmailSubject) {
if(command!=""){ command+=",";}
command+="EmailSubject = '"+POut.String(dunning.EmailSubject)+"'";
}
if(dunning.EmailBody != oldDunning.EmailBody) {
if(command!=""){ command+=",";}
command+="EmailBody = "+DbHelper.ParamChar+"paramEmailBody";
}
if(command==""){
return;
}
if(dunning.EmailBody==null) {
dunning.EmailBody="";
}
OdSqlParameter paramEmailBody=new OdSqlParameter("paramEmailBody",OdDbType.Text,dunning.EmailBody);
command="UPDATE dunning SET "+command
+" WHERE DunningNum = "+POut.Long(dunning.DunningNum);
Db.NonQ(command,paramEmailBody);
}
///<summary>Updates one Dunning in the database.</summary>
public static void Update(Dunning dunning){
string command="UPDATE dunning SET "
+"DunMessage = '"+POut.String(dunning.DunMessage)+"', "
+"BillingType = "+POut.Long (dunning.BillingType)+", "
+"AgeAccount = "+POut.Byte (dunning.AgeAccount)+", "
+"InsIsPending= "+POut.Int ((int)dunning.InsIsPending)+", "
+"MessageBold = '"+POut.String(dunning.MessageBold)+"', "
+"EmailSubject= '"+POut.String(dunning.EmailSubject)+"', "
+"EmailBody = "+DbHelper.ParamChar+"paramEmailBody "
+"WHERE DunningNum = "+POut.Long(dunning.DunningNum);
if(dunning.EmailBody==null) {
dunning.EmailBody="";
}
OdSqlParameter paramEmailBody=new OdSqlParameter("paramEmailBody",OdDbType.Text,dunning.EmailBody);
Db.NonQ(command,paramEmailBody);
}
///<summary>Updates one Dunning 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(Dunning dunning, Dunning oldDunning)
{
string command = "";
if (dunning.DunMessage != oldDunning.DunMessage)
{
if (command != "")
{
command += ",";
}
command += "DunMessage = " + DbHelper.ParamChar + "paramDunMessage";
}
if (dunning.BillingType != oldDunning.BillingType)
{
if (command != "")
{
command += ",";
}
command += "BillingType = " + POut.Long(dunning.BillingType) + "";
}
if (dunning.AgeAccount != oldDunning.AgeAccount)
{
if (command != "")
{
command += ",";
}
command += "AgeAccount = " + POut.Byte(dunning.AgeAccount) + "";
}
if (dunning.InsIsPending != oldDunning.InsIsPending)
{
if (command != "")
{
command += ",";
}
command += "InsIsPending = " + POut.Int((int)dunning.InsIsPending) + "";
}
if (dunning.MessageBold != oldDunning.MessageBold)
{
if (command != "")
{
command += ",";
}
command += "MessageBold = " + DbHelper.ParamChar + "paramMessageBold";
}
if (dunning.EmailSubject != oldDunning.EmailSubject)
{
if (command != "")
{
command += ",";
}
command += "EmailSubject = '" + POut.String(dunning.EmailSubject) + "'";
}
if (dunning.EmailBody != oldDunning.EmailBody)
{
if (command != "")
{
command += ",";
}
command += "EmailBody = " + DbHelper.ParamChar + "paramEmailBody";
}
if (dunning.DaysInAdvance != oldDunning.DaysInAdvance)
{
if (command != "")
{
command += ",";
}
command += "DaysInAdvance = " + POut.Int(dunning.DaysInAdvance) + "";
}
if (dunning.ClinicNum != oldDunning.ClinicNum)
{
if (command != "")
{
command += ",";
}
command += "ClinicNum = " + POut.Long(dunning.ClinicNum) + "";
}
if (command == "")
{
return(false);
}
if (dunning.DunMessage == null)
{
dunning.DunMessage = "";
}
OdSqlParameter paramDunMessage = new OdSqlParameter("paramDunMessage", OdDbType.Text, POut.StringParam(dunning.DunMessage));
if (dunning.MessageBold == null)
{
dunning.MessageBold = "";
}
OdSqlParameter paramMessageBold = new OdSqlParameter("paramMessageBold", OdDbType.Text, POut.StringParam(dunning.MessageBold));
if (dunning.EmailBody == null)
{
dunning.EmailBody = "";
}
OdSqlParameter paramEmailBody = new OdSqlParameter("paramEmailBody", OdDbType.Text, POut.StringParam(dunning.EmailBody));
command = "UPDATE dunning SET " + command
+ " WHERE DunningNum = " + POut.Long(dunning.DunningNum);
Db.NonQ(command, paramDunMessage, paramMessageBold, paramEmailBody);
return(true);
}
///<summary>Updates one Dunning 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(Dunning dunning,Dunning oldDunning)
{
string command="";
if(dunning.DunMessage != oldDunning.DunMessage) {
if(command!=""){ command+=",";}
command+="DunMessage = '"+POut.String(dunning.DunMessage)+"'";
}
if(dunning.BillingType != oldDunning.BillingType) {
if(command!=""){ command+=",";}
command+="BillingType = "+POut.Long(dunning.BillingType)+"";
}
if(dunning.AgeAccount != oldDunning.AgeAccount) {
if(command!=""){ command+=",";}
command+="AgeAccount = "+POut.Byte(dunning.AgeAccount)+"";
}
if(dunning.InsIsPending != oldDunning.InsIsPending) {
if(command!=""){ command+=",";}
command+="InsIsPending = "+POut.Int ((int)dunning.InsIsPending)+"";
}
if(dunning.MessageBold != oldDunning.MessageBold) {
if(command!=""){ command+=",";}
command+="MessageBold = '"+POut.String(dunning.MessageBold)+"'";
}
if(command==""){
return;
}
command="UPDATE dunning SET "+command
+" WHERE DunningNum = "+POut.Long(dunning.DunningNum);
Db.NonQ(command);
}
///<summary>Updates one Dunning in the database.</summary>
internal static void Update(Dunning dunning)
{
string command="UPDATE dunning SET "
+"DunMessage = '"+POut.String(dunning.DunMessage)+"', "
+"BillingType = "+POut.Long (dunning.BillingType)+", "
+"AgeAccount = "+POut.Byte (dunning.AgeAccount)+", "
+"InsIsPending= "+POut.Int ((int)dunning.InsIsPending)+", "
+"MessageBold = '"+POut.String(dunning.MessageBold)+"' "
+"WHERE DunningNum = "+POut.Long(dunning.DunningNum);
Db.NonQ(command);
}
///<summary>Inserts one Dunning into the database. Returns the new priKey. Doesn't use the cache.</summary>
public static long InsertNoCache(Dunning dunning)
{
return(InsertNoCache(dunning, false));
}
