///<summary>Updates the given key data to the database.</summary> public static void Update(RegistrationKey registrationKey){ if(RemotingClient.RemotingRole==RemotingRole.ClientWeb) { Meth.GetVoid(MethodBase.GetCurrentMethod(),registrationKey); return; } Crud.RegistrationKeyCrud.Update(registrationKey); }
///<summary>Inserts a new and unique registration key into the database.</summary> public static long Insert(RegistrationKey registrationKey){ if(RemotingClient.RemotingRole==RemotingRole.ClientWeb) { registrationKey.RegistrationKeyNum=Meth.GetLong(MethodBase.GetCurrentMethod(),registrationKey); return registrationKey.RegistrationKeyNum; } do{ if(registrationKey.IsForeign){ Random rand=new Random(); StringBuilder strBuild=new StringBuilder(); for(int i=0;i<16;i++){ int r=rand.Next(0,35); if(r<10){ strBuild.Append((char)('0'+r)); } else{ strBuild.Append((char)('A'+r-10)); } } registrationKey.RegKey=strBuild.ToString(); } else{ registrationKey.RegKey=CDT.Class1.GenerateRandKey(); } if(registrationKey.RegKey==""){ //Don't loop forever when software is unverified. return 0;//not sure what consequence this would have. } } while(KeyIsInUse(registrationKey.RegKey)); return Crud.RegistrationKeyCrud.Insert(registrationKey); }
///<summary>Updates the given key data to the database.</summary> public static void Update(RegistrationKey registrationKey) { if (RemotingClient.RemotingRole == RemotingRole.ClientWeb) { Meth.GetVoid(MethodBase.GetCurrentMethod(), registrationKey); return; } Crud.RegistrationKeyCrud.Update(registrationKey); }
///<summary></summary> public static bool KeyIsEnabled(RegistrationKey registrationKey) { //No need to check RemotingRole; no call to db. if (registrationKey.DateDisabled.Year > 1880 || registrationKey.DateStarted > DateTime.Today || (registrationKey.DateEnded.Year > 1880 && registrationKey.DateEnded < DateTime.Today)) { return(false); } return(true); }
///<summary>Throws exceptions.</summary> public static RegistrationKey GetByKey(string regKey) { if (RemotingClient.RemotingRole == RemotingRole.ClientWeb) { return(Meth.GetObject <RegistrationKey>(MethodBase.GetCurrentMethod(), regKey)); } if (!Regex.IsMatch(regKey, @"^[A-Z0-9]{16}$")) { throw new ApplicationException("Invalid registration key format."); } string command = "SELECT * FROM registrationkey WHERE RegKey='" + POut.String(regKey) + "'"; RegistrationKey key = Crud.RegistrationKeyCrud.SelectOne(command); if (key == null) { throw new ApplicationException("Invalid registration key."); } return(key); }
public static RegistrationKey GetByKey(string regKey) { if (RemotingClient.RemotingRole == RemotingRole.ClientWeb) { return(Meth.GetObject <RegistrationKey>(MethodBase.GetCurrentMethod(), regKey)); } if (!Regex.IsMatch(regKey, @"^[A-Z0-9]{16}$")) { throw new ApplicationException("Invalid registration key format."); } string command = "SELECT * FROM registrationkey WHERE RegKey='" + POut.String(regKey) + "'"; DataTable table = Db.GetTable(command); if (table.Rows.Count == 0) { throw new ApplicationException("Invalid registration key."); } RegistrationKey key = null; for (int i = 0; i < table.Rows.Count; i++) { key = new RegistrationKey(); key.RegistrationKeyNum = PIn.Int(table.Rows[i][0].ToString()); key.PatNum = PIn.Int(table.Rows[i][1].ToString()); key.RegKey = PIn.String(table.Rows[i][2].ToString()); key.Note = PIn.String(table.Rows[i][3].ToString()); key.DateStarted = PIn.Date(table.Rows[i][4].ToString()); key.DateDisabled = PIn.Date(table.Rows[i][5].ToString()); key.DateEnded = PIn.Date(table.Rows[i][6].ToString()); key.IsForeign = PIn.Bool(table.Rows[i][7].ToString()); //key.UsesServerVersion =PIn.PBool(table.Rows[i][8].ToString()); key.IsFreeVersion = PIn.Bool(table.Rows[i][9].ToString()); key.IsOnlyForTesting = PIn.Bool(table.Rows[i][10].ToString()); //key.VotesAllotted =PIn.PInt(table.Rows[i][11].ToString()); } //if(key.DateDisabled.Year>1880){ // throw new ApplicationException("This key has been disabled. Please call for assistance."); //} return(key); }
///<summary>Inserts a new and unique registration key into the database.</summary> public static long Insert(RegistrationKey registrationKey) { if (RemotingClient.RemotingRole == RemotingRole.ClientWeb) { registrationKey.RegistrationKeyNum = Meth.GetLong(MethodBase.GetCurrentMethod(), registrationKey); return(registrationKey.RegistrationKeyNum); } do { if (registrationKey.IsForeign) { Random rand = new Random(); StringBuilder strBuild = new StringBuilder(); for (int i = 0; i < 16; i++) { int r = rand.Next(0, 35); if (r < 10) { strBuild.Append((char)('0' + r)); } else { strBuild.Append((char)('A' + r - 10)); } } registrationKey.RegKey = strBuild.ToString(); } else { registrationKey.RegKey = CDT.Class1.GenerateRandKey(); } if (registrationKey.RegKey == "") { //Don't loop forever when software is unverified. return(0); //not sure what consequence this would have. } }while(KeyIsInUse(registrationKey.RegKey)); return(Crud.RegistrationKeyCrud.Insert(registrationKey)); }
public static RegistrationKey GetByKey(string regKey) { if(RemotingClient.RemotingRole==RemotingRole.ClientWeb) { return Meth.GetObject<RegistrationKey>(MethodBase.GetCurrentMethod(),regKey); } if(!Regex.IsMatch(regKey,@"^[A-Z0-9]{16}$")) { throw new ApplicationException("Invalid registration key format."); } string command="SELECT * FROM registrationkey WHERE RegKey='"+POut.String(regKey)+"'"; DataTable table=Db.GetTable(command); if(table.Rows.Count==0) { throw new ApplicationException("Invalid registration key."); } RegistrationKey key=null; for(int i=0;i<table.Rows.Count;i++) { key=new RegistrationKey(); key.RegistrationKeyNum =PIn.Int(table.Rows[i][0].ToString()); key.PatNum =PIn.Int(table.Rows[i][1].ToString()); key.RegKey =PIn.String(table.Rows[i][2].ToString()); key.Note =PIn.String(table.Rows[i][3].ToString()); key.DateStarted =PIn.Date(table.Rows[i][4].ToString()); key.DateDisabled =PIn.Date(table.Rows[i][5].ToString()); key.DateEnded =PIn.Date(table.Rows[i][6].ToString()); key.IsForeign =PIn.Bool(table.Rows[i][7].ToString()); //key.UsesServerVersion =PIn.PBool(table.Rows[i][8].ToString()); key.IsFreeVersion =PIn.Bool(table.Rows[i][9].ToString()); key.IsOnlyForTesting =PIn.Bool(table.Rows[i][10].ToString()); //key.VotesAllotted =PIn.PInt(table.Rows[i][11].ToString()); } //if(key.DateDisabled.Year>1880){ // throw new ApplicationException("This key has been disabled. Please call for assistance."); //} return key; }
private void butForeignKey_Click(object sender,EventArgs e) { RegistrationKey key=new RegistrationKey(); key.PatNum=PatCur.PatNum; key.Note=""; key.DateStarted=DateTime.Today; key.IsForeign=true; key.VotesAllotted=100; RegistrationKeys.Insert(key); FillPtInfo(); }
private void butAddKey_Click(object sender,EventArgs e) { RegistrationKey key=new RegistrationKey(); key.PatNum=PatCur.PatNum; //Notes are not commonly necessary, because most customers have only one office (thus only 1 key is necessary). //A tech can edit the note later after it is added if necessary. key.Note=""; key.DateStarted=DateTime.Today; key.IsForeign=false; key.VotesAllotted=100; RegistrationKeys.Insert(key); FillPtInfo();//Refresh registration key list in patient info grid. }