///<summary></summary>
public static void Reformat()
{
string oldTel;
string newTel;
string idNum;
Queries.CurReport.Query = "select * from patient";
Queries.SubmitCur();
for (int i = 0; i < Queries.TableQ.Rows.Count; i++)
{
idNum = PIn.PString(Queries.TableQ.Rows[i][0].ToString());
//home
oldTel = PIn.PString(Queries.TableQ.Rows[i][15].ToString());
newTel = TelephoneNumbers.ReFormat(oldTel);
if (oldTel != newTel)
{
Queries.CurReport.Query = "UPDATE patient SET hmphone = '"
+ POut.PString(newTel) + "' WHERE patNum = '" + idNum + "'";
Queries.SubmitNonQ();
}
//wk:
oldTel = PIn.PString(Queries.TableQ.Rows[i][16].ToString());
newTel = TelephoneNumbers.ReFormat(oldTel);
if (oldTel != newTel)
{
Queries.CurReport.Query = "UPDATE patient SET wkphone = '"
+ POut.PString(newTel) + "' WHERE patNum = '" + idNum + "'";
Queries.SubmitNonQ();
}
//wireless
oldTel = PIn.PString(Queries.TableQ.Rows[i][17].ToString());
newTel = TelephoneNumbers.ReFormat(oldTel);
if (oldTel != newTel) // Keyush Shah 04/21/04 Bug, was overwriting wireless with work phone here
{
Queries.CurReport.Query = "UPDATE patient SET wirelessphone = '"
+ POut.PString(newTel) + "' WHERE patNum = '" + idNum + "'";
Queries.SubmitNonQ();
}
}
Queries.CurReport.Query = "select * from carrier";
Queries.SubmitCur();
for (int i = 0; i < Queries.TableQ.Rows.Count; i++)
{
idNum = PIn.PString(Queries.TableQ.Rows[i][0].ToString());
//ph
oldTel = PIn.PString(Queries.TableQ.Rows[i][7].ToString());
newTel = TelephoneNumbers.ReFormat(oldTel);
if (oldTel != newTel)
{
Queries.CurReport.Query = "UPDATE carrier SET Phone = '"
+ POut.PString(newTel) + "' WHERE CarrierNum = '" + idNum + "'";
Queries.SubmitNonQ();
}
}
//this last part will only be run once during conversion to 2.8. It can be dropped from a future version.
/*Queries.CurReport.Query="select * from insplan";
* Queries.SubmitCur();
* for(int i=0;i<Queries.TableQ.Rows.Count;i++){
* idNum=PIn.PString(Queries.TableQ.Rows[i][0].ToString());
* //ph
* oldTel=PIn.PString(Queries.TableQ.Rows[i][5].ToString());
* newTel=TelephoneNumbers.ReFormat(oldTel);
* if(oldTel!=newTel){
* Queries.CurReport.Query="UPDATE insplan SET Phone = '"
+newTel+"' WHERE PlanNum = '"+idNum+"'";
* Queries.SubmitNonQ();
* }
* }*/
} //reformat
