Example #1
0
        public TestRequestClass GetDateandTotalSearchedValue(PaymentClass aPaymentClass)
        {
            SqlConnection           connection        = new SqlConnection(connectionString);
            string                  query             = "SELECT * from  t_TestReqEntry WHERE BillNo='" + aPaymentClass.BillNo + "' OR MobileNo='" + aPaymentClass.BillNo + "' ";
            TestRequestClass        aTestRequestClass = null;
            List <TestRequestClass> aList             = new List <TestRequestClass>();
            SqlCommand              command           = new SqlCommand(query, connection);

            connection.Open();
            SqlDataReader reader = command.ExecuteReader();

            if (reader.HasRows)
            {
                while (reader.Read())
                {
                    aTestRequestClass            = new TestRequestClass();
                    aTestRequestClass.date       = Convert.ToDateTime(reader["Date"].ToString());
                    aTestRequestClass.TotalFee   = int.Parse(reader["TotalFee"].ToString());
                    aTestRequestClass.PaidAmount = Convert.ToDouble(reader["PaidAmount"].ToString());
                    aTestRequestClass.DueAmount  = Convert.ToDouble(reader["DueAmount"].ToString());
                }
                reader.Close();
            }
            connection.Close();
            return(aTestRequestClass);
        }
        protected void addButton_Click(object sender, EventArgs e)
        {
            TestRequestManager aRequestManager = new TestRequestManager();
            TestRequestClass   aRequestClass   = new TestRequestClass();

            aRequestClass.MobileNo = mobileNoTextBox.Text;
            if (patientNameTextBox.Text == string.Empty || dateTextBox.Text == string.Empty ||
                mobileNoTextBox.Text == string.Empty || feeTextBox.Text == string.Empty)
            {
                messageLabel.Text = "Insert All Values !";
            }
            else
            {
                if (aRequestManager.GetAllInfoByMobileNo(aRequestClass.MobileNo) == true)
                {
                    messageLabel.Text = "This Mobile No Already Exist";
                }
                else
                {
                    messageLabel.Text = string.Empty;
                    TestRequestClass aTestRequestClass = new TestRequestClass();
                    aTestRequestClass.Fee      = Convert.ToDouble(feeTextBox.Text);
                    aTestRequestClass.MobileNo = mobileNoTextBox.Text;
                    TestSetupManger aTestSetupManger = new TestSetupManger();
                    TestClass       adropClass       = aTestSetupManger.GetAllInfoByTestId(selectTestDropDownList.SelectedValue);



                    DataTable dt = (DataTable)ViewState["TestEntry"];
                    dt.Rows.Add(adropClass.Name.Trim(), feeTextBox.Text.Trim());
                    ViewState["TestEntry"] = dt;
                    this.BindGrid();

                    selectTestDropDownList.SelectedValue = null;

                    double i;
                    if (totalTextBox.Text.Length != 0)
                    {
                        i = int.Parse(totalTextBox.Text);
                        i = i + aTestRequestClass.GetFullFee(aTestRequestClass.Fee);
                    }
                    else
                    {
                        i = int.Parse(feeTextBox.Text);
                    }
                    totalTextBox.Text = i.ToString();
                    feeTextBox.Text   = string.Empty;

                    if (aRequestManager.SaveTestGridview(adropClass, aTestRequestClass) > 0)
                    {
                        messageLabel.Text = "Added";
                    }
                    else
                    {
                        messageLabel.Text = "Failed to Insert";
                    }
                }
            }
        }
        public int SaveTestGridview(TestClass adropClass, TestRequestClass aTestRequestClass)
        {
            SqlConnection connection = new SqlConnection(connectionString);

            string query = "insert into t_testgridview(MobileNogridview,TestName,Fee) values ('" +
                           aTestRequestClass.MobileNo +
                           "','" + adropClass.Name + "','" + aTestRequestClass.Fee + "')";
            SqlCommand command = new SqlCommand(query, connection);

            connection.Open();
            int rowsAffecte = command.ExecuteNonQuery();

            connection.Close();
            return(rowsAffecte);
        }
Example #4
0
        public async Task SaveFileDataAsyncCallsCorrectMethodsTest()
        {
            var mockWebApiClient = new Mock <IRestClient>();

            var filesPersistenceClient = new FilesPersistenceClient(mockWebApiClient.Object);

            var byteArray   = new byte[] { 0x20, 0x20, 0x20, 0x20, 0x20, 0x20, 0x20 };
            var testRequest = new TestRequestClass {
                Bytes = byteArray, ContentType = "img", FileName = "MyTest.img"
            };

            await filesPersistenceClient.SaveFileDataAsync <TestRequestClass, TestResponseClass>(testRequest);

            mockWebApiClient.Verify(m => m.PostItemAsync <TestRequestClass, TestResponseClass>(It.IsAny <string>(), It.IsAny <TestRequestClass>()), Times.Once());
        }
        public int SavePatientTestInfo(TestRequestClass aTestRequestClass)
        {
            SqlConnection connection = new SqlConnection(connectionString);

            string query =
                "insert into t_TestReqEntry(Name,DateofBirth,MobileNo,Date,TotalFee,DueAmount,PaidAmount) values ('" +
                aTestRequestClass.Name + "','" + aTestRequestClass.DateofBirth + "','" +
                aTestRequestClass.MobileNo + "','" + aTestRequestClass.date + "','" +
                aTestRequestClass.TotalFee + "','" + aTestRequestClass.DueAmount + "','" + aTestRequestClass.PaidAmount +
                "')";
            SqlCommand command = new SqlCommand(query, connection);

            connection.Open();
            int rowsAffecte = command.ExecuteNonQuery();

            connection.Close();
            return(rowsAffecte);
        }
Example #6
0
        protected void searchButton_Click(object sender, EventArgs e)
        {
            PaymentManager aPaymentManager = new PaymentManager();

            PaymentClass aPaymentClass = new PaymentClass();

            aPaymentClass.BillNo = Convert.ToInt32(billNoTextBox.Text);
            List <AllPatientInfo> alist = aPaymentManager.GetAllBYSearchedValue(aPaymentClass);

            showGridView.DataSource = alist;
            showGridView.DataBind();

            TestRequestClass abc = aPaymentManager.GetDateandTotalSearchedValue(aPaymentClass);

            billDateLabel.Text   = abc.date.ToString();
            totalFeeLabel.Text   = abc.TotalFee.ToString();
            paidAmountLabel.Text = abc.PaidAmount.ToString();
            dueAmountLabel.Text  = abc.DueAmount.ToString();
        }
        protected void saveButton_Click(object sender, EventArgs e)
        {
            TestRequestManager aTestRequestManager = new TestRequestManager();
            TestRequestClass   aTestRequestClass   = new TestRequestClass();

            aTestRequestClass.Name        = patientNameTextBox.Text;
            aTestRequestClass.DateofBirth = dateTextBox.Text;
            aTestRequestClass.MobileNo    = mobileNoTextBox.Text;
            aTestRequestClass.date        = Convert.ToDateTime((DateTime.Now.ToString("yyyy/MM/dd")));
            aTestRequestClass.PaidAmount  = 0;
            aTestRequestClass.TotalFee    = 0;
            if (patientNameTextBox.Text == string.Empty || dateTextBox.Text == string.Empty ||
                mobileNoTextBox.Text == string.Empty || totalTextBox.Text == string.Empty)
            {
                messageLabel.Text = "Insert All Values !";
            }

            else
            {
                aTestRequestClass.TotalFee  = int.Parse(totalTextBox.Text);
                aTestRequestClass.DueAmount = aTestRequestClass.TotalFee;
                if (aTestRequestManager.SavePatientTestInfo(aTestRequestClass) > 0)
                {
                    messageLabel.Text       = "inserted successfully";
                    patientNameTextBox.Text = string.Empty;
                    dateTextBox.Text        = string.Empty;
                    mobileNoTextBox.Text    = string.Empty;
                    showGridView.DataSource = null;
                    DataTable dt = (DataTable)ViewState["TestEntry"];
                    dt.Rows.Clear();
                }
                else
                {
                    messageLabel.Text = "Failed to Insert";
                }
                totalTextBox.Text = 0.ToString();
            }

            aTestRequestManager.GetAllInfoByMobileNo(aTestRequestClass);

            GetPDFValue(aTestRequestClass);
        }
        public void GetAllInfoByMobileNo(TestRequestClass aTestRequestClass)
        {
            SqlConnection connection = new SqlConnection(connectionString);
            string        query      = "Select * from t_TestReqEntry WHERE MobileNo='" + aTestRequestClass.MobileNo + "'";
            SqlCommand    Command    = new SqlCommand(query, connection);

            connection.Open();
            SqlDataReader reader = Command.ExecuteReader();

            if (reader.HasRows)
            {
                while (reader.Read())
                {
                    aTestRequestClass.BillNo = Convert.ToInt32(reader["BillNo"].ToString());
                }
                reader.Close();
            }

            connection.Close();
        }
        public void GetPDFValue(TestRequestClass aTestRequestClass)
        {
            int       noOfColumns = 0, noOfRows = 0;
            DataTable tbl = null;

            if (showGridView.AutoGenerateColumns)
            {
                tbl         = showGridView.DataSource as DataTable; // Gets the DataSource of the GridView Control.
                noOfColumns = tbl.Columns.Count;
                noOfRows    = tbl.Rows.Count;
            }
            else
            {
                noOfColumns = showGridView.Columns.Count;
                noOfRows    = showGridView.Rows.Count;
            }
            float HeaderTextSize      = 8;
            float ReportNameSize      = 10;
            float ReportTextSize      = 8;
            float ApplicationNameSize = 12;

            Document document = null;

            if (LandScape == true)
            {
                document = new Document(PageSize.A4.Rotate(), 0, 0, 15, 5);
            }
            else
            {
                document = new Document(PageSize.A4, 0, 0, 15, 5);
            }
            iTextSharp.text.pdf.PdfPTable mainTable = new iTextSharp.text.pdf.PdfPTable(noOfColumns);
            mainTable.HeaderRows = 5;
            iTextSharp.text.pdf.PdfPTable headerTable = new iTextSharp.text.pdf.PdfPTable(2);
            Phrase phApplicationName =
                new Phrase(
                    "Bill No:" + aTestRequestClass.BillNo + "\nName: " + aTestRequestClass.Name + "\nMobile No: " +
                    aTestRequestClass.MobileNo + "\nDate Of Birth: " + aTestRequestClass.DateofBirth + " ",
                    FontFactory.GetFont("Arial", ApplicationNameSize, iTextSharp.text.Font.BOLD));
            PdfPCell clApplicationName = new PdfPCell(phApplicationName);

            clApplicationName.Border = PdfPCell.NO_BORDER;
            clApplicationName.HorizontalAlignment = Element.ALIGN_LEFT;
            Phrase aphSpace = new Phrase("\n");

            PdfPCell aclSpace = new PdfPCell(aphSpace);

            aclSpace.Border  = PdfPCell.NO_BORDER;
            aclSpace.Colspan = noOfColumns;
            mainTable.AddCell(aclSpace);


            Phrase phDate = new Phrase("Entry Date: " + DateTime.Now.Date.ToString("dd/MM/yyyy"),
                                       FontFactory.GetFont("Arial", ApplicationNameSize, iTextSharp.text.Font.NORMAL));
            PdfPCell clDate = new PdfPCell(phDate);

            clDate.HorizontalAlignment = Element.ALIGN_RIGHT;
            clDate.Border = PdfPCell.NO_BORDER;
            headerTable.AddCell(clApplicationName);
            headerTable.AddCell(clDate);
            headerTable.DefaultCell.Border = PdfPCell.NO_BORDER;

            Phrase phHeader = new Phrase("PATIENT BILL ",
                                         FontFactory.GetFont("Arial", ReportNameSize, iTextSharp.text.Font.BOLD));
            PdfPCell clHeader = new PdfPCell(phHeader);

            clHeader.Colspan             = noOfColumns;
            clHeader.Border              = PdfPCell.NO_BORDER;
            clHeader.HorizontalAlignment = Element.ALIGN_CENTER;
            mainTable.AddCell(clHeader);

            PdfPCell cellHeader = new PdfPCell(headerTable);

            cellHeader.Border  = PdfPCell.NO_BORDER;
            cellHeader.Colspan = noOfColumns;
            mainTable.AddCell(cellHeader);

            Phrase   phSpace = new Phrase("\n");
            PdfPCell clSpace = new PdfPCell(phSpace);

            clSpace.Border  = PdfPCell.NO_BORDER;
            clSpace.Colspan = noOfColumns;
            mainTable.AddCell(clSpace);

            for (int i = 0; i < noOfColumns; i++)
            {
                Phrase ph = null;
                if (showGridView.AutoGenerateColumns)
                {
                    ph = new Phrase(tbl.Columns[i].ColumnName,
                                    FontFactory.GetFont("Arial", HeaderTextSize, iTextSharp.text.Font.BOLD));
                }
                else
                {
                    ph = new Phrase(showGridView.Columns[i].HeaderText,
                                    FontFactory.GetFont("Arial", HeaderTextSize, iTextSharp.text.Font.BOLD));
                }
                mainTable.AddCell(ph);
            }
            for (int rowNo = 0; rowNo < noOfRows; rowNo++)
            {
                for (int columnNo = 0; columnNo < noOfColumns; columnNo++)
                {
                    if (showGridView.AutoGenerateColumns)
                    {
                        string s  = showGridView.Rows[rowNo].Cells[columnNo].Text.Trim();
                        Phrase ph = new Phrase(s, FontFactory.GetFont("Arial", ReportTextSize, iTextSharp.text.Font.NORMAL));
                        mainTable.AddCell(ph);
                    }
                    else
                    {
                        if (showGridView.Columns[columnNo] is TemplateField)
                        {
                            DataBoundLiteralControl lc =
                                showGridView.Rows[rowNo].Cells[columnNo].Controls[0] as DataBoundLiteralControl;
                            string s  = lc.Text.Trim();
                            Phrase ph = new Phrase(s, FontFactory.GetFont("Arial", ReportTextSize, iTextSharp.text.Font.NORMAL));
                            mainTable.AddCell(ph);
                        }
                        else
                        {
                            string s  = showGridView.Rows[rowNo].Cells[columnNo].Text.Trim();
                            Phrase ph = new Phrase(s, FontFactory.GetFont("Arial", ReportTextSize, iTextSharp.text.Font.NORMAL));
                            mainTable.AddCell(ph);
                        }
                    }
                }
                mainTable.CompleteRow();
            }

            Phrase phHeaderTotal = new Phrase("Total: " + aTestRequestClass.TotalFee + " TK ",
                                              FontFactory.GetFont("Arial", ReportNameSize, iTextSharp.text.Font.BOLD));
            PdfPCell clHeaderTotal = new PdfPCell(phHeaderTotal);

            clHeaderTotal.Colspan             = noOfColumns;
            clHeaderTotal.Border              = PdfPCell.BOX;
            clHeaderTotal.HorizontalAlignment = Element.ALIGN_RIGHT;
            mainTable.AddCell(clHeaderTotal);

            PdfWriter.GetInstance(document, Response.OutputStream);
            document.Open();
            document.Add(mainTable);
            document.Close();
            Response.ContentType = "application/pdf";
            Response.AddHeader("content-disposition", "attachment; filename= PatientBill.pdf");
            Response.End();
        }
Example #10
0
 public void GetAllInfoByMobileNo(TestRequestClass aTestRequestClass)
 {
     aTestRequestGetWay.GetAllInfoByMobileNo(aTestRequestClass);
 }
Example #11
0
 public int SavePatientTestInfo(TestRequestClass aTestRequestClass)
 {
     return(aTestRequestGetWay.SavePatientTestInfo(aTestRequestClass));
 }
Example #12
0
 public int SaveTestGridview(TestClass adropClass, TestRequestClass aTestRequestClass)
 {
     return(aTestRequestGetWay.SaveTestGridview(adropClass, aTestRequestClass));
 }