public bool SavePatientCategory(PatientCategory pc)
{
try
{
int VID = 0;
con = new OleDbConnection();
this.readconfile = new ReadConfigFile();
con.ConnectionString = this.readconfile.ConfigString(ConfigFiles.ProjectConfigFile);
con.Open();
tran = con.BeginTransaction();
if (pc.CategoryID == 0)
{
cmd = new OleDbCommand("Select IsNull(Max(PatientCategoryID),0) +1 From PatientCategories", con);
cmd.Transaction = tran;
VID = Convert.ToInt32(cmd.ExecuteScalar());
}
else
{
VID = pc.CategoryID;
}
string insert = "if exists(select * from PatientCategories where PatientCategoryID=" + VID + ")Begin Update PatientCategories set PatientCategoryName='" + pc.CategoryName + "',DiscountPercentage=" + pc.DiscountPercentage + " where PatientCategoryID=" + VID + " End Else Begin Insert into PatientCategories(PatientCategoryName,DiscountPercentage) Values(" + "'" + pc.CategoryName + "\'," + pc.DiscountPercentage + " )End";
cmd = new OleDbCommand(insert, con);
cmd.Transaction = tran;
cmd.ExecuteNonQuery();
tran.Commit();
}
catch (Exception ex)
{
tran.Rollback();
throw ex;
}
finally
{ con.Close(); }
return(true);
}
private void tsDelete_Click(object sender, EventArgs e)
{
try
{
PatientCategory pc = (PatientCategory)this.lbxPatientCategories.SelectedItem;
if (pctrl.DeletePatientCategory(pc) == true)
{
MessageBox.Show(pc.CategoryName + " Catgory Deleted, successfully", "Deletion Completed");
}
LoadPatientCategories();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void lbxPatientCategories_SelectedIndexChanged(object sender, EventArgs e)
{
try
{
if (lbxPatientCategories.DataSource == null)
{
return;
}
PatientCategory pc = (PatientCategory)this.lbxPatientCategories.SelectedItem;
this.txtCategoryName.Text = pc.CategoryName;
this.txtDiscountPercentage.Text = pc.DiscountPercentage.ToString("0.00");
this.txtId.Text = pc.CategoryID.ToString();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
public void SavePatientCategory()
{
try
{
PatientCategory pc = new PatientCategory();
if (txtId.Text.Length > 0)
{
pc.CategoryID = Convert.ToInt32(txtId.Text);
}
pc.CategoryName = this.txtCategoryName.Text;
pc.DiscountPercentage = Convert.ToDouble(this.txtDiscountPercentage.Text.Trim());
pctrl.SavePatientCategory(pc);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
public void AddPatientCategories()
{
try
{
PatientCategory newPc;
while (dr.Read())
{
newPc = new PatientCategory(Convert.ToInt32(dr["PatientCategoryID"]), (string)dr["PatientCategoryName"], Convert.ToDouble(dr["DiscountPercentage"]));
Pcs.Add(newPc);
}
dr.Close();
con.Close();
}
catch (Exception ex) { throw ex; }
finally { dr.Close(); }
}
public static PatientCategory GetPatientCategory(string hn, CacheConnection con)
{
var result = new PatientCategory();
var query = QueryString.GetPatientCategory(hn);
try
{
using (var cmd = new CacheCommand(query.Item1, con))
{
foreach (var pair in query.Item2)
{
cmd.AddInputParameters(new { key = pair.Value });
}
using (var reader = cmd.ExecuteReader())
{
if (reader.Read())
{
result = new PatientCategory()
{
PCAT_CODE = reader["PCAT_CODE"].ToString(),
PCAT_Desc = reader["PCAT_Desc"].ToString()
};
return(result);
}
}
}
}
catch (Exception e)
{
Console.WriteLine(e);
throw;
}
return(result);
}
public bool DeletePatientCategory(PatientCategory Pc)
{
try
{
string delete = "Delete From PatientCategories where PatientCategoryID=" + Pc.CategoryID;
con = new OleDbConnection();
this.readconfile = new ReadConfigFile();
con.ConnectionString = this.readconfile.ConfigString(ConfigFiles.ProjectConfigFile);
con.Open();
tran = con.BeginTransaction();
cmd = new OleDbCommand(delete, con);
cmd.Transaction = tran;
cmd.ExecuteNonQuery();
tran.Commit();
return(true);
}
catch (Exception ex)
{
tran.Rollback();
throw ex;
}
finally
{ con.Close(); }
}
public bool DeletePatientCategory(PatientCategory pc)
{
return(new PatientDAL().DeletePatientCategory(pc));
}
public bool SavePatientCategory(PatientCategory pc)
{
return(new PatientDAL().SavePatientCategory(pc));
}
