public IHttpActionResult Remove(DeletedObject obj)
{
_dialogService.SendInPopupForUser(PopupType.Warning,
string.Format(DialogResources.Warning_ProductDeleted, obj.Name), User.SignalRConnectionId);
_productService.Delete(obj.Id);
return(Successful());
}
///<summary>Inserts one DeletedObject into the database. Returns the new priKey.</summary>
public static long Insert(DeletedObject deletedObject)
{
if (DataConnection.DBtype == DatabaseType.Oracle)
{
deletedObject.DeletedObjectNum = DbHelper.GetNextOracleKey("deletedobject", "DeletedObjectNum");
int loopcount = 0;
while (loopcount < 100)
{
try {
return(Insert(deletedObject, true));
}
catch (Oracle.ManagedDataAccess.Client.OracleException ex) {
if (ex.Number == 1 && ex.Message.ToLower().Contains("unique constraint") && ex.Message.ToLower().Contains("violated"))
{
deletedObject.DeletedObjectNum++;
loopcount++;
}
else
{
throw ex;
}
}
}
throw new ApplicationException("Insert failed. Could not generate primary key.");
}
else
{
return(Insert(deletedObject, false));
}
}
///<summary>Inserts one DeletedObject into the database. Returns the new priKey.</summary>
internal static long Insert(DeletedObject deletedObject)
{
if(DataConnection.DBtype==DatabaseType.Oracle) {
deletedObject.DeletedObjectNum=DbHelper.GetNextOracleKey("deletedobject","DeletedObjectNum");
int loopcount=0;
while(loopcount<100){
try {
return Insert(deletedObject,true);
}
catch(Oracle.DataAccess.Client.OracleException ex){
if(ex.Number==1 && ex.Message.ToLower().Contains("unique constraint") && ex.Message.ToLower().Contains("violated")){
deletedObject.DeletedObjectNum++;
loopcount++;
}
else{
throw ex;
}
}
}
throw new ApplicationException("Insert failed. Could not generate primary key.");
}
else {
return Insert(deletedObject,false);
}
}
///<summary>Inserts one DeletedObject into the database. Provides option to use the existing priKey.</summary>
internal static long Insert(DeletedObject deletedObject,bool useExistingPK)
{
if(!useExistingPK && PrefC.RandomKeys) {
deletedObject.DeletedObjectNum=ReplicationServers.GetKey("deletedobject","DeletedObjectNum");
}
string command="INSERT INTO deletedobject (";
if(useExistingPK || PrefC.RandomKeys) {
command+="DeletedObjectNum,";
}
command+="ObjectNum,ObjectType) VALUES(";
if(useExistingPK || PrefC.RandomKeys) {
command+=POut.Long(deletedObject.DeletedObjectNum)+",";
}
command+=
POut.Long (deletedObject.ObjectNum)+","
+ POut.Int ((int)deletedObject.ObjectType)+")";
//DateTStamp can only be set by MySQL
if(useExistingPK || PrefC.RandomKeys) {
Db.NonQ(command);
}
else {
deletedObject.DeletedObjectNum=Db.NonQ(command,true);
}
return deletedObject.DeletedObjectNum;
}
///<summary>Updates one DeletedObject 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(DeletedObject deletedObject, DeletedObject oldDeletedObject)
{
string command = "";
if (deletedObject.ObjectNum != oldDeletedObject.ObjectNum)
{
if (command != "")
{
command += ",";
}
command += "ObjectNum = " + POut.Long(deletedObject.ObjectNum) + "";
}
if (deletedObject.ObjectType != oldDeletedObject.ObjectType)
{
if (command != "")
{
command += ",";
}
command += "ObjectType = " + POut.Int((int)deletedObject.ObjectType) + "";
}
//DateTStamp can only be set by MySQL
if (command == "")
{
return(false);
}
command = "UPDATE deletedobject SET " + command
+ " WHERE DeletedObjectNum = " + POut.Long(deletedObject.DeletedObjectNum);
Db.NonQ(command);
return(true);
}
///<summary>Inserts one DeletedObject into the database. Provides option to use the existing priKey. Doesn't use the cache.</summary>
public static long InsertNoCache(DeletedObject deletedObject, bool useExistingPK)
{
bool isRandomKeys = Prefs.GetBoolNoCache(PrefName.RandomPrimaryKeys);
string command = "INSERT INTO deletedobject (";
if (!useExistingPK && isRandomKeys)
{
deletedObject.DeletedObjectNum = ReplicationServers.GetKeyNoCache("deletedobject", "DeletedObjectNum");
}
if (isRandomKeys || useExistingPK)
{
command += "DeletedObjectNum,";
}
command += "ObjectNum,ObjectType) VALUES(";
if (isRandomKeys || useExistingPK)
{
command += POut.Long(deletedObject.DeletedObjectNum) + ",";
}
command +=
POut.Long(deletedObject.ObjectNum) + ","
+ POut.Int((int)deletedObject.ObjectType) + ")";
//DateTStamp can only be set by MySQL
if (useExistingPK || isRandomKeys)
{
Db.NonQ(command);
}
else
{
deletedObject.DeletedObjectNum = Db.NonQ(command, true, "DeletedObjectNum", "deletedObject");
}
return(deletedObject.DeletedObjectNum);
}
///<summary>Inserts one DeletedObject into the database. Provides option to use the existing priKey.</summary>
public static long Insert(DeletedObject deletedObject, bool useExistingPK)
{
if (!useExistingPK && PrefC.RandomKeys)
{
deletedObject.DeletedObjectNum = ReplicationServers.GetKey("deletedobject", "DeletedObjectNum");
}
string command = "INSERT INTO deletedobject (";
if (useExistingPK || PrefC.RandomKeys)
{
command += "DeletedObjectNum,";
}
command += "ObjectNum,ObjectType) VALUES(";
if (useExistingPK || PrefC.RandomKeys)
{
command += POut.Long(deletedObject.DeletedObjectNum) + ",";
}
command +=
POut.Long(deletedObject.ObjectNum) + ","
+ POut.Int((int)deletedObject.ObjectType) + ")";
//DateTStamp can only be set by MySQL
if (useExistingPK || PrefC.RandomKeys)
{
Db.NonQ(command);
}
else
{
deletedObject.DeletedObjectNum = Db.NonQ(command, true, "DeletedObjectNum", "deletedObject");
}
return(deletedObject.DeletedObjectNum);
}
///<summary>Updates one DeletedObject in the database.</summary>
public static void Update(DeletedObject deletedObject)
{
string command = "UPDATE deletedobject SET "
+ "ObjectNum = " + POut.Long(deletedObject.ObjectNum) + ", "
+ "ObjectType = " + POut.Int((int)deletedObject.ObjectType) + " "
//DateTStamp can only be set by MySQL
+ "WHERE DeletedObjectNum = " + POut.Long(deletedObject.DeletedObjectNum);
Db.NonQ(command);
}
///<summary>Returns true if Update(DeletedObject,DeletedObject) 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(DeletedObject deletedObject, DeletedObject oldDeletedObject)
{
if (deletedObject.ObjectNum != oldDeletedObject.ObjectNum)
{
return(true);
}
if (deletedObject.ObjectType != oldDeletedObject.ObjectType)
{
return(true);
}
//DateTStamp can only be set by MySQL
return(false);
}
///<summary>Converts a DataTable to a list of objects.</summary>
public static List<DeletedObject> TableToList(DataTable table){
List<DeletedObject> retVal=new List<DeletedObject>();
DeletedObject deletedObject;
for(int i=0;i<table.Rows.Count;i++) {
deletedObject=new DeletedObject();
deletedObject.DeletedObjectNum= PIn.Long (table.Rows[i]["DeletedObjectNum"].ToString());
deletedObject.ObjectNum = PIn.Long (table.Rows[i]["ObjectNum"].ToString());
deletedObject.ObjectType = (DeletedObjectType)PIn.Int(table.Rows[i]["ObjectType"].ToString());
deletedObject.DateTStamp = PIn.DateT (table.Rows[i]["DateTStamp"].ToString());
retVal.Add(deletedObject);
}
return retVal;
}
///<summary>Inserts one DeletedObject into the database. Returns the new priKey. Doesn't use the cache.</summary>
public static long InsertNoCache(DeletedObject deletedObject)
{
if (DataConnection.DBtype == DatabaseType.MySql)
{
return(InsertNoCache(deletedObject, false));
}
else
{
if (DataConnection.DBtype == DatabaseType.Oracle)
{
deletedObject.DeletedObjectNum = DbHelper.GetNextOracleKey("deletedobject", "DeletedObjectNum"); //Cacheless method
}
return(InsertNoCache(deletedObject, true));
}
}
///<summary>Converts a DataTable to a list of objects.</summary>
public static List <DeletedObject> TableToList(DataTable table)
{
List <DeletedObject> retVal = new List <DeletedObject>();
DeletedObject deletedObject;
foreach (DataRow row in table.Rows)
{
deletedObject = new DeletedObject();
deletedObject.DeletedObjectNum = PIn.Long(row["DeletedObjectNum"].ToString());
deletedObject.ObjectNum = PIn.Long(row["ObjectNum"].ToString());
deletedObject.ObjectType = (OpenDentBusiness.DeletedObjectType)PIn.Int(row["ObjectType"].ToString());
deletedObject.DateTStamp = PIn.DateT(row["DateTStamp"].ToString());
retVal.Add(deletedObject);
}
return(retVal);
}
///<summary>Converts a DataTable to a list of objects.</summary>
internal static List <DeletedObject> TableToList(DataTable table)
{
List <DeletedObject> retVal = new List <DeletedObject>();
DeletedObject deletedObject;
for (int i = 0; i < table.Rows.Count; i++)
{
deletedObject = new DeletedObject();
deletedObject.DeletedObjectNum = PIn.Long(table.Rows[i]["DeletedObjectNum"].ToString());
deletedObject.ObjectNum = PIn.Long(table.Rows[i]["ObjectNum"].ToString());
deletedObject.ObjectType = (DeletedObjectType)PIn.Int(table.Rows[i]["ObjectType"].ToString());
deletedObject.DateTStamp = PIn.DateT(table.Rows[i]["DateTStamp"].ToString());
retVal.Add(deletedObject);
}
return(retVal);
}
///<summary>Inserts one DeletedObject into the database. Returns the new priKey.</summary>
public static long Insert(DeletedObject deletedObject)
{
return(Insert(deletedObject, false));
}
///<summary>Inserts many DeletedObjects into the database. Provides option to use the existing priKey.</summary>
public static void InsertMany(List <DeletedObject> listDeletedObjects, bool useExistingPK)
{
if (!useExistingPK && PrefC.RandomKeys)
{
foreach (DeletedObject deletedObject in listDeletedObjects)
{
Insert(deletedObject);
}
}
else
{
StringBuilder sbCommands = null;
int index = 0;
int countRows = 0;
while (index < listDeletedObjects.Count)
{
DeletedObject deletedObject = listDeletedObjects[index];
StringBuilder sbRow = new StringBuilder("(");
bool hasComma = false;
if (sbCommands == null)
{
sbCommands = new StringBuilder();
sbCommands.Append("INSERT INTO deletedobject (");
if (useExistingPK)
{
sbCommands.Append("DeletedObjectNum,");
}
sbCommands.Append("ObjectNum,ObjectType) VALUES ");
countRows = 0;
}
else
{
hasComma = true;
}
if (useExistingPK)
{
sbRow.Append(POut.Long(deletedObject.DeletedObjectNum)); sbRow.Append(",");
}
sbRow.Append(POut.Long(deletedObject.ObjectNum)); sbRow.Append(",");
sbRow.Append(POut.Int((int)deletedObject.ObjectType)); sbRow.Append(")");
//DateTStamp can only be set by MySQL
if (sbCommands.Length + sbRow.Length + 1 > TableBase.MaxAllowedPacketCount && countRows > 0)
{
Db.NonQ(sbCommands.ToString());
sbCommands = null;
}
else
{
if (hasComma)
{
sbCommands.Append(",");
}
sbCommands.Append(sbRow.ToString());
countRows++;
if (index == listDeletedObjects.Count - 1)
{
Db.NonQ(sbCommands.ToString());
}
index++;
}
}
}
}
///<summary>Updates one DeletedObject 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(DeletedObject deletedObject,DeletedObject oldDeletedObject){
string command="";
if(deletedObject.ObjectNum != oldDeletedObject.ObjectNum) {
if(command!=""){ command+=",";}
command+="ObjectNum = "+POut.Long(deletedObject.ObjectNum)+"";
}
if(deletedObject.ObjectType != oldDeletedObject.ObjectType) {
if(command!=""){ command+=",";}
command+="ObjectType = "+POut.Int ((int)deletedObject.ObjectType)+"";
}
//DateTStamp can only be set by MySQL
if(command==""){
return;
}
command="UPDATE deletedobject SET "+command
+" WHERE DeletedObjectNum = "+POut.Long(deletedObject.DeletedObjectNum);
Db.NonQ(command);
}
///<summary>Updates one DeletedObject in the database.</summary>
public static void Update(DeletedObject deletedObject){
string command="UPDATE deletedobject SET "
+"ObjectNum = "+POut.Long (deletedObject.ObjectNum)+", "
+"ObjectType = "+POut.Int ((int)deletedObject.ObjectType)+" "
//DateTStamp can only be set by MySQL
+"WHERE DeletedObjectNum = "+POut.Long(deletedObject.DeletedObjectNum);
Db.NonQ(command);
}
