public int SaveTestData(TestNameModel test)
{
PersonalInformationModel aInformationModel = new PersonalInformationModel();
aInformationModel.Id = GetPatientTestId();
test.Id = GetTestId(test);
Query = "INSERT INTO PatientTest VALUES (@patientId, @testId, @entryDate)";
Command = new SqlCommand(Query, Connection);
Command.Parameters.Clear();
Command.Parameters.Add("patientId", SqlDbType.Int);
Command.Parameters["patientId"].Value = aInformationModel.Id;
Command.Parameters.Add("testId", SqlDbType.Int);
Command.Parameters["testId"].Value = test.Id;
Command.Parameters.Add("entryDate", SqlDbType.Date);
Command.Parameters["entryDate"].Value = test.EntryDate;
Connection.Open();
int rowAffected = Command.ExecuteNonQuery();
Connection.Close();
return(rowAffected);
}
public List <TestNameModel> GetTestWiseReport(string formDate, string toDate)
{
Query = @"SELECT TestName, COUNT(PatientTest.TestId) AS TotalTest, Fee, TotalAmount = Fee*COUNT(*)
FROM TestNameInfo LEFT JOIN PatientTest ON TestNameInfo.Id = PatientTest.TestId WHERE PatientTest.DueDate
BETWEEN '" + formDate + "' AND '" + toDate + "' GROUP BY TestName, Fee";
Command = new SqlCommand(Query, Connection);
Connection.Open();
List <TestNameModel> tests = new List <TestNameModel>();
Reader = Command.ExecuteReader();
while (Reader.Read())
{
TestNameModel test = new TestNameModel();
test.TestName = Reader["TestName"].ToString();
test.Fee = Convert.ToDecimal(Reader["Fee"]);
test.TotalTest = (int)Reader["TotalTest"];
test.TotalAmount = (decimal)Reader["Totalamount"];
tests.Add(test);
}
Reader.Close();
Connection.Close();
return(tests);
}
public List <TestNameModel> GetAllTestbyFee(int id)
{
Query = "SELECT * FROM TestNameInfo where TestNameInfo.Id= '" + id + "' ";
Command = new SqlCommand(Query, Connection);
Connection.Open();
List <TestNameModel> tests = new List <TestNameModel>();
Reader = Command.ExecuteReader();
if (Reader.HasRows)
{
while (Reader.Read())
{
TestNameModel test = new TestNameModel();
test.TestName = Reader["TestName"].ToString();
test.Fee = Convert.ToDecimal(Reader["Fee"]);
tests.Add(test);
}
}
Reader.Close();
Connection.Close();
return(tests);
}
public int GetTestId(TestNameModel test)
{
Query = "SELECT Id AS Testid FROM TestNameInfo WHERE TestName = @testName";
Command = new SqlCommand(Query, Connection);
Command.Parameters.Clear();
Command.Parameters.Add("testName", SqlDbType.VarChar);
Command.Parameters["testName"].Value = test.TestName;
Connection.Open();
Reader = Command.ExecuteReader();
int testId = 0;
while (Reader.Read())
{
testId = Convert.ToInt32(Reader["Testid"]);
}
Reader.Close();
Connection.Close();
return(testId);
}
public List <TestNameModel> GetAllTest()
{
Query = "SELECT * FROM TestNameInfo ORDER BY TestName";
Command = new SqlCommand(Query, Connection);
Connection.Open();
List <TestNameModel> tests = new List <TestNameModel>();
Reader = Command.ExecuteReader();
while (Reader.Read())
{
TestNameModel test = new TestNameModel();
test.Id = (int)Reader["Id"];
test.TestName = Reader["TestName"].ToString();
test.Fee = Convert.ToDecimal(Reader["Fee"]);
test.TypeId = (int)Reader["TypeId"];
tests.Add(test);
}
Reader.Close();
Connection.Close();
return(tests);
}
public int SaveTest(TestNameModel test)
{
Query = "INSERT INTO TestNameInfo(TestName,Fee,TypeId) VALUES(@testName, @testFee, @testTypeId)";
Command = new SqlCommand(Query, Connection);
Command.Parameters.Clear();
Command.Parameters.Add("testName", SqlDbType.VarChar);
Command.Parameters["testName"].Value = test.TestName;
Command.Parameters.Add("testFee", SqlDbType.Decimal);
Command.Parameters["testFee"].Value = test.Fee;
Command.Parameters.Add("testTypeId", SqlDbType.Int);
Command.Parameters["testTypeId"].Value = test.TypeId;
Connection.Open();
int rowAffected = Command.ExecuteNonQuery();
Connection.Close();
return(rowAffected);
}
protected void saveButton_Click(object sender, EventArgs e)
{
TestNameModel test = new TestNameModel();
person.PatientName = patientNameTextBox.Text;
person.BirthDate = datepicker.Value;
person.MobileNo = mobileNoTextBox.Text;
person.TotalBill = Convert.ToDecimal(totalTextBox.Text);
person.PatientEntryDate = DateTime.Today.ToString("yyyy-MM-dd");
messageShowlabel.Text = aManager.SavePatientInfo(person);
List <TestNameModel> types = aTestManager.GetAllTypes();
testSelectDropDownList.DataSource = types;
testSelectDropDownList.DataTextField = "TestName";
testSelectDropDownList.DataValueField = "Id";
testSelectDropDownList.DataBind();
testSelectDropDownList.Items.Insert(0, new ListItem("--- Please Select ---", ""));
test.EntryDate = DateTime.Today.ToString("yyyy-MM-dd");
foreach (GridViewRow row in testSelectGridView.Rows)
{
test.TestName = ((Label)row.FindControl("nameLabel")).Text;
test.Fee = Convert.ToDecimal(((Label)row.FindControl("feeLabel")).Text);
aManager.SaveTestData(test);
}
}
protected void addButton_Click(object sender, EventArgs e)
{
TestNameModel name = new TestNameModel();
List <TestNameModel> test = new List <TestNameModel>();
if (ViewState["Test"] != null)
{
test = (List <TestNameModel>)ViewState["Test"];
name.TestName = testSelectDropDownList.SelectedItem.Text;
name.Fee = Convert.ToDecimal(feeTextBox.Text);
test.Add(name);
testSelectGridView.DataSource = test;
testSelectGridView.DataBind();
totalTextBox.Text = (Convert.ToDecimal(feeTextBox.Text) + Convert.ToDecimal(totalTextBox.Text)).ToString();
}
else
{
name.TestName = testSelectDropDownList.SelectedItem.Text;
name.Fee = Convert.ToDecimal(feeTextBox.Text);
test.Add(name);
testSelectGridView.DataSource = test;
testSelectGridView.DataBind();
totalTextBox.Text = (Convert.ToDecimal(feeTextBox.Text) + Convert.ToDecimal(totalTextBox.Text)).ToString();
}
ViewState["Test"] = test;
}
public string SaveTestData(TestNameModel test)
{
if (!MobileExists)
{
int row = aGateway.SaveTestData(test);
if (row > 0)
{
return("Saved Succefully");
}
else
{
return("Failed");
}
}
return("Mobile number exists already");
}
public string SaveTest(TestNameModel test)
{
bool existsTestName = aGateway.IsTestNameExists(test.TestName);
if (existsTestName)
{
return("Test Name exists already");
}
else
{
int row = aGateway.SaveTest(test);
if (row > 0)
{
return("Saved Succefully");
}
else
{
return("Failed");
}
}
}
protected void saveButton_Click(object sender, EventArgs e)
{
TestNameModel aTest = new TestNameModel();
aTest.TestName = testNameTextBox.Text;
aTest.Fee = Convert.ToDecimal(feeTextBox.Text);
aTest.TypeId = Convert.ToInt32(testTypeDropDownList.SelectedValue);
messageShowlabel.Text = aTestManager.SaveTest(aTest);
List <TypeNameModel> types = aTypeManager.GetAllTypes();
testTypeDropDownList.DataSource = types;
testTypeDropDownList.DataTextField = "TypeName";
testTypeDropDownList.DataValueField = "Id";
testTypeDropDownList.DataBind();
testTypeDropDownList.Items.Insert(0, new ListItem("--- Please Select ---", ""));
testNameTextBox.Text = "";
feeTextBox.Text = "";
PopulateGridview();
}
