/*
* Only pull out the methods below as you need them. Otherwise, leave them commented out.
*
* ///<summary></summary>
* public static List<ApptFieldDef> Refresh(long patNum){
* if(RemotingClient.RemotingRole==RemotingRole.ClientWeb) {
* return Meth.GetObject<List<ApptFieldDef>>(MethodBase.GetCurrentMethod(),patNum);
* }
* string command="SELECT * FROM apptfielddef WHERE PatNum = "+POut.Long(patNum);
* return Crud.ApptFieldDefCrud.SelectMany(command);
* }
*
* ///<summary>Gets one ApptFieldDef from the db.</summary>
* public static ApptFieldDef GetOne(long apptFieldDefNum){
* if(RemotingClient.RemotingRole==RemotingRole.ClientWeb){
* return Meth.GetObject<ApptFieldDef>(MethodBase.GetCurrentMethod(),apptFieldDefNum);
* }
* return Crud.ApptFieldDefCrud.SelectOne(apptFieldDefNum);
* }
*/
public static string GetFieldName(long apptFieldDefNum)
{
//No need to check RemotingRole; no call to db.
ApptFieldDef apptFieldDef = GetFirstOrDefault(x => x.ApptFieldDefNum == apptFieldDefNum);
return(apptFieldDef == null ? "" : apptFieldDef.FieldName);
}
/// <summary>GetPickListByFieldName returns the pick list identified by the field name passed as a parameter.</summary>
public static string GetPickListByFieldName(string FieldName)
{
//No need to check RemotingRole; no call to db.
ApptFieldDef apptFieldDef = GetFirstOrDefault(x => x.FieldName == FieldName);
return(apptFieldDef == null ? "" : apptFieldDef.PickList);
}
///<summary>Surround with try/catch, because it will throw an exception if any appointment is using this def.</summary>
public static void Delete(ApptFieldDef apptFieldDef) {
if(RemotingClient.RemotingRole==RemotingRole.ClientWeb) {
Meth.GetVoid(MethodBase.GetCurrentMethod(),apptFieldDef);
return;
}
string command="SELECT LName,FName,AptDateTime "
+"FROM patient,apptfield,appointment WHERE "
+"patient.PatNum=appointment.PatNum "
+"AND appointment.AptNum=apptfield.AptNum "
+"AND FieldName='"+POut.String(apptFieldDef.FieldName)+"'";
DataTable table=Db.GetTable(command);
DateTime aptDateTime;
if(table.Rows.Count>0) {
string s=Lans.g("FormApptFieldDefEdit","Not allowed to delete. Already in use by ")+table.Rows.Count.ToString()
+" "+Lans.g("FormApptFieldDefEdit","appointments, including")+" \r\n";
for(int i=0;i<table.Rows.Count;i++) {
if(i>5) {
break;
}
aptDateTime=PIn.DateT(table.Rows[i]["AptDateTime"].ToString());
s+=table.Rows[i]["LName"].ToString()+", "+table.Rows[i]["FName"].ToString()+POut.DateT(aptDateTime,false)+"\r\n";
}
throw new ApplicationException(s);
}
command="DELETE FROM apptfielddef WHERE ApptFieldDefNum ="+POut.Long(apptFieldDef.ApptFieldDefNum);
Db.NonQ(command);
}
///<summary>Surround with try/catch, because it will throw an exception if any appointment is using this def.</summary>
public static void Delete(ApptFieldDef apptFieldDef)
{
if (RemotingClient.RemotingRole == RemotingRole.ClientWeb)
{
Meth.GetVoid(MethodBase.GetCurrentMethod(), apptFieldDef);
return;
}
string command = "SELECT LName,FName,AptDateTime "
+ "FROM patient,apptfield,appointment WHERE "
+ "patient.PatNum=appointment.PatNum "
+ "AND appointment.AptNum=apptfield.AptNum "
+ "AND FieldName='" + POut.String(apptFieldDef.FieldName) + "'";
DataTable table = Db.GetTable(command);
DateTime aptDateTime;
if (table.Rows.Count > 0)
{
string s = Lans.g("FormApptFieldDefEdit", "Not allowed to delete. Already in use by ") + table.Rows.Count.ToString()
+ " " + Lans.g("FormApptFieldDefEdit", "appointments, including") + " \r\n";
for (int i = 0; i < table.Rows.Count; i++)
{
if (i > 5)
{
break;
}
aptDateTime = PIn.DateT(table.Rows[i]["AptDateTime"].ToString());
s += table.Rows[i]["LName"].ToString() + ", " + table.Rows[i]["FName"].ToString() + POut.DateT(aptDateTime, false) + "\r\n";
}
throw new ApplicationException(s);
}
command = "DELETE FROM apptfielddef WHERE ApptFieldDefNum =" + POut.Long(apptFieldDef.ApptFieldDefNum);
Db.NonQ(command);
}
///<summary></summary>
public FormApptFieldDefEdit(ApptFieldDef fieldDef)
{
//
// Required for Windows Form Designer support
//
InitializeComponent();
Lan.F(this);
FieldDef=fieldDef;
}
///<summary>Surround with try/catch in case field name already in use.</summary>
public static long Insert(ApptFieldDef apptFieldDef) {
if(RemotingClient.RemotingRole==RemotingRole.ClientWeb) {
apptFieldDef.ApptFieldDefNum=Meth.GetLong(MethodBase.GetCurrentMethod(),apptFieldDef);
return apptFieldDef.ApptFieldDefNum;
}
string command="SELECT COUNT(*) FROM apptfielddef WHERE FieldName='"+POut.String(apptFieldDef.FieldName)+"'";
if(Db.GetCount(command)!="0") {
throw new ApplicationException(Lans.g("FormApptFieldDefEdit","Field name already in use."));
}
return Crud.ApptFieldDefCrud.Insert(apptFieldDef);
}
///<summary>Surround with try/catch in case field name already in use.</summary>
public static long Insert(ApptFieldDef apptFieldDef)
{
if (RemotingClient.RemotingRole == RemotingRole.ClientWeb)
{
apptFieldDef.ApptFieldDefNum = Meth.GetLong(MethodBase.GetCurrentMethod(), apptFieldDef);
return(apptFieldDef.ApptFieldDefNum);
}
string command = "SELECT COUNT(*) FROM apptfielddef WHERE FieldName='" + POut.String(apptFieldDef.FieldName) + "'";
if (Db.GetCount(command) != "0")
{
throw new ApplicationException(Lans.g("FormApptFieldDefEdit", "Field name already in use."));
}
return(Crud.ApptFieldDefCrud.Insert(apptFieldDef));
}
///<summary>Must supply the old field name so that the apptFields attached to appointments can be updated. Will throw exception if new FieldName is already in use.</summary>
public static void Update(ApptFieldDef apptFieldDef,string oldFieldName) {
if(RemotingClient.RemotingRole==RemotingRole.ClientWeb) {
Meth.GetVoid(MethodBase.GetCurrentMethod(),apptFieldDef,oldFieldName);
return;
}
string command="SELECT COUNT(*) FROM apptfielddef WHERE FieldName='"+POut.String(apptFieldDef.FieldName)+"' "
+"AND ApptFieldDefNum != "+POut.Long(apptFieldDef.ApptFieldDefNum);
if(Db.GetCount(command)!="0"){
throw new ApplicationException(Lans.g("FormApptFieldDefEdit","Field name already in use."));
}
Crud.ApptFieldDefCrud.Update(apptFieldDef);
command="UPDATE apptfield SET FieldName='"+POut.String(apptFieldDef.FieldName)+"' "
+"WHERE FieldName='"+POut.String(oldFieldName)+"'";
Db.NonQ(command);
}
///<summary>Must supply the old field name so that the apptFields attached to appointments can be updated. Will throw exception if new FieldName is already in use.</summary>
public static void Update(ApptFieldDef apptFieldDef, string oldFieldName)
{
if (RemotingClient.RemotingRole == RemotingRole.ClientWeb)
{
Meth.GetVoid(MethodBase.GetCurrentMethod(), apptFieldDef, oldFieldName);
return;
}
string command = "SELECT COUNT(*) FROM apptfielddef WHERE FieldName='" + POut.String(apptFieldDef.FieldName) + "' "
+ "AND ApptFieldDefNum != " + POut.Long(apptFieldDef.ApptFieldDefNum);
if (Db.GetCount(command) != "0")
{
throw new ApplicationException(Lans.g("FormApptFieldDefEdit", "Field name already in use."));
}
Crud.ApptFieldDefCrud.Update(apptFieldDef);
command = "UPDATE apptfield SET FieldName='" + POut.String(apptFieldDef.FieldName) + "' "
+ "WHERE FieldName='" + POut.String(oldFieldName) + "'";
Db.NonQ(command);
}
private void butAdd_Click(object sender, System.EventArgs e) {
ApptFieldDef def=new ApptFieldDef();
FormApptFieldDefEdit FormP=new FormApptFieldDefEdit(def);
FormP.IsNew=true;
FormP.ShowDialog();
FillGrid();
}
