///<summary>Must run UsedBy before running this.</summary> public static void Delete(County Cur){ if(RemotingClient.RemotingRole==RemotingRole.ClientWeb) { Meth.GetVoid(MethodBase.GetCurrentMethod(),Cur); return; } string command= "DELETE from county WHERE CountyName = '"+POut.String(Cur.CountyName)+"'"; Db.NonQ(command); }
///<summary>Updates the Countyname and code in the County table, and also updates all patients that were using the oldCounty name.</summary> public static void Update(County county){ if(RemotingClient.RemotingRole==RemotingRole.ClientWeb) { Meth.GetVoid(MethodBase.GetCurrentMethod(),county); return; } //Can't use CRUD here because we're updating by the OldCountyName string command = "UPDATE county SET " +"CountyName ='" +POut.String(county.CountyName)+"'" +",CountyCode ='" +POut.String(county.CountyCode)+"'" +" WHERE CountyName = '"+POut.String(county.OldCountyName)+"'"; Db.NonQ(command); //then, update all patients using that County command = "UPDATE patient SET " +"County ='" +POut.String(county.CountyName)+"'" +" WHERE County = '"+POut.String(county.OldCountyName)+"'"; Db.NonQ(command); }
///<summary>Updates the Countyname and code in the County table, and also updates all patients that were using the oldCounty name.</summary> public static void Update(County county) { if (RemotingClient.RemotingRole == RemotingRole.ClientWeb) { Meth.GetVoid(MethodBase.GetCurrentMethod(), county); return; } //Can't use CRUD here because we're updating by the OldCountyName string command = "UPDATE county SET " + "CountyName ='" + POut.String(county.CountyName) + "'" + ",CountyCode ='" + POut.String(county.CountyCode) + "'" + " WHERE CountyName = '" + POut.String(county.OldCountyName) + "'"; Db.NonQ(command); //then, update all patients using that County command = "UPDATE patient SET " + "County ='" + POut.String(county.CountyName) + "'" + " WHERE County = '" + POut.String(county.OldCountyName) + "'"; Db.NonQ(command); }
///<summary>Need to make sure Countyname not already in db.</summary> public static long Insert(County county){ if(RemotingClient.RemotingRole==RemotingRole.ClientWeb) { return Meth.GetLong(MethodBase.GetCurrentMethod(),county); } return Crud.CountyCrud.Insert(county); }