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)); }