///<summary>Inserts one EmailAutograph into the database. Returns the new priKey.</summary>
public static long Insert(EmailAutograph emailAutograph)
{
if (DataConnection.DBtype == DatabaseType.Oracle)
{
emailAutograph.EmailAutographNum = DbHelper.GetNextOracleKey("emailautograph", "EmailAutographNum");
int loopcount = 0;
while (loopcount < 100)
{
try {
return(Insert(emailAutograph, true));
}
catch (Oracle.ManagedDataAccess.Client.OracleException ex) {
if (ex.Number == 1 && ex.Message.ToLower().Contains("unique constraint") && ex.Message.ToLower().Contains("violated"))
{
emailAutograph.EmailAutographNum++;
loopcount++;
}
else
{
throw ex;
}
}
}
throw new ApplicationException("Insert failed. Could not generate primary key.");
}
else
{
return(Insert(emailAutograph, false));
}
}
///<summary></summary>
public FormEmailAutographEdit(EmailAutograph emailAutograph)
{
//
// Required for Windows Form Designer support
//
InitializeComponent();
Lan.F(this);
_emailAutograph = emailAutograph;
}
private void toolBarAutograph_MenuItemClick(object sender, EventArgs e)
{
if (sender.GetType() == typeof(MenuItem))
{
MenuItem itemCur = (MenuItem)sender;
if (itemCur.Tag.GetType() == typeof(EmailAutograph))
{
EmailAutograph autograph = (EmailAutograph)itemCur.Tag;
InsertAutograph(autograph);
}
}
}
///<summary>Updates one EmailAutograph 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(EmailAutograph emailAutograph, EmailAutograph oldEmailAutograph)
{
string command = "";
if (emailAutograph.Description != oldEmailAutograph.Description)
{
if (command != "")
{
command += ",";
}
command += "Description = " + DbHelper.ParamChar + "paramDescription";
}
if (emailAutograph.EmailAddress != oldEmailAutograph.EmailAddress)
{
if (command != "")
{
command += ",";
}
command += "EmailAddress = '" + POut.String(emailAutograph.EmailAddress) + "'";
}
if (emailAutograph.AutographText != oldEmailAutograph.AutographText)
{
if (command != "")
{
command += ",";
}
command += "AutographText = " + DbHelper.ParamChar + "paramAutographText";
}
if (command == "")
{
return(false);
}
if (emailAutograph.Description == null)
{
emailAutograph.Description = "";
}
OdSqlParameter paramDescription = new OdSqlParameter("paramDescription", OdDbType.Text, POut.StringParam(emailAutograph.Description));
if (emailAutograph.AutographText == null)
{
emailAutograph.AutographText = "";
}
OdSqlParameter paramAutographText = new OdSqlParameter("paramAutographText", OdDbType.Text, POut.StringParam(emailAutograph.AutographText));
command = "UPDATE emailautograph SET " + command
+ " WHERE EmailAutographNum = " + POut.Long(emailAutograph.EmailAutographNum);
Db.NonQ(command, paramDescription, paramAutographText);
return(true);
}
///<summary>Inserts one EmailAutograph into the database. Returns the new priKey. Doesn't use the cache.</summary>
public static long InsertNoCache(EmailAutograph emailAutograph)
{
if (DataConnection.DBtype == DatabaseType.MySql)
{
return(InsertNoCache(emailAutograph, false));
}
else
{
if (DataConnection.DBtype == DatabaseType.Oracle)
{
emailAutograph.EmailAutographNum = DbHelper.GetNextOracleKey("emailautograph", "EmailAutographNum"); //Cacheless method
}
return(InsertNoCache(emailAutograph, true));
}
}
///<summary>Converts a DataTable to a list of objects.</summary>
public static List <EmailAutograph> TableToList(DataTable table)
{
List <EmailAutograph> retVal = new List <EmailAutograph>();
EmailAutograph emailAutograph;
foreach (DataRow row in table.Rows)
{
emailAutograph = new EmailAutograph();
emailAutograph.EmailAutographNum = PIn.Long(row["EmailAutographNum"].ToString());
emailAutograph.Description = PIn.String(row["Description"].ToString());
emailAutograph.EmailAddress = PIn.String(row["EmailAddress"].ToString());
emailAutograph.AutographText = PIn.String(row["AutographText"].ToString());
retVal.Add(emailAutograph);
}
return(retVal);
}
///<summary>Returns true if Update(EmailAutograph,EmailAutograph) 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(EmailAutograph emailAutograph, EmailAutograph oldEmailAutograph)
{
if (emailAutograph.Description != oldEmailAutograph.Description)
{
return(true);
}
if (emailAutograph.EmailAddress != oldEmailAutograph.EmailAddress)
{
return(true);
}
if (emailAutograph.AutographText != oldEmailAutograph.AutographText)
{
return(true);
}
return(false);
}
///<summary>Inserts one EmailAutograph into the database. Provides option to use the existing priKey. Doesn't use the cache.</summary>
public static long InsertNoCache(EmailAutograph emailAutograph, bool useExistingPK)
{
bool isRandomKeys = Prefs.GetBoolNoCache(PrefName.RandomPrimaryKeys);
string command = "INSERT INTO emailautograph (";
if (!useExistingPK && isRandomKeys)
{
emailAutograph.EmailAutographNum = ReplicationServers.GetKeyNoCache("emailautograph", "EmailAutographNum");
}
if (isRandomKeys || useExistingPK)
{
command += "EmailAutographNum,";
}
command += "Description,EmailAddress,AutographText) VALUES(";
if (isRandomKeys || useExistingPK)
{
command += POut.Long(emailAutograph.EmailAutographNum) + ",";
}
command +=
DbHelper.ParamChar + "paramDescription,"
+ "'" + POut.String(emailAutograph.EmailAddress) + "',"
+ DbHelper.ParamChar + "paramAutographText)";
if (emailAutograph.Description == null)
{
emailAutograph.Description = "";
}
OdSqlParameter paramDescription = new OdSqlParameter("paramDescription", OdDbType.Text, POut.StringParam(emailAutograph.Description));
if (emailAutograph.AutographText == null)
{
emailAutograph.AutographText = "";
}
OdSqlParameter paramAutographText = new OdSqlParameter("paramAutographText", OdDbType.Text, POut.StringParam(emailAutograph.AutographText));
if (useExistingPK || isRandomKeys)
{
Db.NonQ(command, paramDescription, paramAutographText);
}
else
{
emailAutograph.EmailAutographNum = Db.NonQ(command, true, "EmailAutographNum", "emailAutograph", paramDescription, paramAutographText);
}
return(emailAutograph.EmailAutographNum);
}
///<summary>Updates one EmailAutograph in the database.</summary>
public static void Update(EmailAutograph emailAutograph)
{
string command = "UPDATE emailautograph SET "
+ "Description = " + DbHelper.ParamChar + "paramDescription, "
+ "EmailAddress = '" + POut.String(emailAutograph.EmailAddress) + "', "
+ "AutographText = " + DbHelper.ParamChar + "paramAutographText "
+ "WHERE EmailAutographNum = " + POut.Long(emailAutograph.EmailAutographNum);
if (emailAutograph.Description == null)
{
emailAutograph.Description = "";
}
OdSqlParameter paramDescription = new OdSqlParameter("paramDescription", OdDbType.Text, POut.StringParam(emailAutograph.Description));
if (emailAutograph.AutographText == null)
{
emailAutograph.AutographText = "";
}
OdSqlParameter paramAutographText = new OdSqlParameter("paramAutographText", OdDbType.Text, POut.StringParam(emailAutograph.AutographText));
Db.NonQ(command, paramDescription, paramAutographText);
}
private void InsertAutograph(EmailAutograph autograph)
{
textContentEmail.SelectionLength = 0;
textContentEmail.SelectedText = autograph.AutographText;
}
///<summary>Inserts one EmailAutograph into the database. Returns the new priKey.</summary>
public static long Insert(EmailAutograph emailAutograph)
{
return(Insert(emailAutograph, false));
}
