Exemplo n.º 1
0
 protected void BtnEdit_Click(object sender, EventArgs e)
 {
     try
     {
         List <TestAllocation> lst = new List <TestAllocation>();
         tblTestInvoice        obj = new tblTestInvoice();
         obj.Amount        = Convert.ToDecimal(txtNetAmount.Text);
         obj.TestInvoiceNo = Convert.ToInt32(Session["TestInvoiceId"]);
         obj.Discount      = Convert.ToDecimal(txtDiscountAmt.Text);
         obj.PatientId     = Convert.ToInt32(ddlPatient.SelectedValue);
         string[] arr = txtAllocDate.Text.Split('/');
         obj.TestInvoiceDate = new DateTime(Convert.ToInt32(arr[arr.Length - 1]), Convert.ToInt32(arr[0]), Convert.ToInt32(arr[1]));
         foreach (GridViewRow item in dgvAllTests.Rows)
         {
             CheckBox chk = (CheckBox)item.FindControl("chkSelect");
             if (chk.Checked)
             {
                 lst.Add(new TestAllocation()
                 {
                     IsTestDone = false, TestId = Convert.ToInt32(dgvAllTests.DataKeys[item.RowIndex].Value), Charges = Convert.ToDecimal(item.Cells[2].Text)
                 });
             }
         }
         bool IsCash = chkIsCash.Checked ? true : false;
         int  i      = new clsTestAllocation().Update(lst, obj, IsCash);
         GetInvoiceList();
     }
     catch (Exception ex)
     {
         lblMessage.Text = ex.Message;
     }
     MultiView1.SetActiveView(View2);
 }
Exemplo n.º 2
0
        protected void BtnSave_Click(object sender, EventArgs e)
        {
            try
            {
                if (dgvAllTests.Rows.Count == 0)
                {
                    lblMessage.Text = "Please Add Test before Allocate to Patient.";
                    ddlPatient.Focus();
                    return;
                }

                List <TestAllocation> lst = new List <TestAllocation>();
                tblTestInvoice        obj = new tblTestInvoice();
                obj.Amount          = Convert.ToDecimal(txtNetAmount.Text);
                obj.Discount        = Convert.ToDecimal(txtDiscountAmt.Text);
                obj.PatientId       = Convert.ToInt32(ddlPatient.SelectedValue);
                obj.TestInvoiceDate = Convert.ToDateTime(txtAllocDate.Text);

                foreach (GridViewRow item in dgvAllTests.Rows)
                {
                    CheckBox chk = (CheckBox)item.FindControl("chkSelect");
                    if (chk.Checked)
                    {
                        lst.Add(new TestAllocation()
                        {
                            IsTestDone = false, TestId = Convert.ToInt32(dgvAllTests.DataKeys[item.RowIndex].Value), Charges = Convert.ToDecimal(item.Cells[2].Text), TestInvoiceNo = Convert.ToInt32(Session["TestInvoiceId"])
                        });
                    }
                }
                bool IsCash = chkIsCash.Checked ? true : false;

                int i = new clsTestAllocation().Save(lst, obj, IsCash);

                lblMsg.Text = "Record Saved Successfully";
                BindTests();
                GetInvoiceList();
                //Response.Redirect("frmNewIPDPatient.aspx", false);
            }
            catch (Exception ex)
            {
                lblMsg.Text = ex.Message;
            }
            MultiView1.SetActiveView(View2);
        }
Exemplo n.º 3
0
        public int Save(List <TestAllocation> lst, tblTestInvoice obj, bool IsCash)
        {
            int?Id = 0;

            objData.STP_Insert_tblTestInvoice(Convert.ToDateTime(DateTime.Now.Date), ref Id, Convert.ToInt32(obj.PatientId), Convert.ToDecimal(obj.Amount), Convert.ToDecimal(obj.Discount));
            foreach (TestAllocation item in lst)
            {
                tblTestInvoiceDetail objtestDetails = new tblTestInvoiceDetail()
                {
                    TestInvoiceId = Convert.ToInt32(Id),
                    TestId        = item.TestId,
                    IsDelete      = false,
                    Charges       = Convert.ToDecimal(item.Charges)
                };
                objData.tblTestInvoiceDetails.InsertOnSubmit(objtestDetails);
            }
            int TransactionId = new PatientInvoiceBLL().GetTransactionId();

            if (IsCash)
            {
                tblCustomerTransaction objDebit = new tblCustomerTransaction()
                {
                    TransactionId    = TransactionId,
                    IsCash           = true,
                    TransactionDocNo = Id,
                    TransactionType  = "TestInvoice",
                    BillAmount       = obj.Amount,
                    PayAmount        = 0,
                    PatientId        = obj.PatientId,
                    IsDelete         = false,
                    ReceiptDate      = obj.TestInvoiceDate,
                };
                objData.tblCustomerTransactions.InsertOnSubmit(objDebit);
                //objData.SubmitChanges();
                tblCustomerTransaction objCrReceipt = new tblCustomerTransaction()
                {
                    TransactionId    = TransactionId,
                    IsCash           = true,
                    TransactionDocNo = Id,
                    TransactionType  = "TestInvoice",
                    PayAmount        = obj.Amount,
                    BillAmount       = 0,
                    PatientId        = obj.PatientId,
                    IsDelete         = false,
                    ReceiptDate      = obj.TestInvoiceDate,
                };
                objData.tblCustomerTransactions.InsertOnSubmit(objCrReceipt);
                //objData.SubmitChanges();
            }
            else
            {
                tblCustomerTransaction objDebit = new tblCustomerTransaction()
                {
                    TransactionId    = TransactionId,
                    IsCash           = false,
                    TransactionDocNo = Id,
                    TransactionType  = "TestInvoice",
                    BillAmount       = obj.Amount,
                    PatientId        = obj.PatientId,
                    IsDelete         = false,
                    ReceiptDate      = obj.TestInvoiceDate,
                };
                objData.tblCustomerTransactions.InsertOnSubmit(objDebit);
                //objData.SubmitChanges();
            }
            objData.SubmitChanges();
            return(1);
        }
Exemplo n.º 4
0
        public int Update(List <TestAllocation> lst, tblTestInvoice obj, bool IsCash)
        {
            try
            {
                tblTestInvoice objTest = (from tbl in objData.tblTestInvoices
                                          where tbl.IsDelete == false &&
                                          tbl.TestInvoiceNo == obj.TestInvoiceNo
                                          select tbl).FirstOrDefault();

                List <TestAllocation> lstTemp = new List <TestAllocation>();

                List <tblTestInvoiceDetail> lstCurrent = (from tbl in objData.tblTestInvoiceDetails
                                                          where tbl.TestInvoiceId == obj.TestInvoiceNo &&
                                                          tbl.IsDelete == false
                                                          select tbl).ToList();

                List <tblCustomerTransaction> objCust = (from tbl in objData.tblCustomerTransactions
                                                         where tbl.IsDelete == false &&
                                                         tbl.TransactionDocNo.Equals(Convert.ToString(obj.TestInvoiceNo)) &&
                                                         tbl.TransactionType.Equals("TestInvoice")
                                                         select tbl).ToList();
                if (objTest != null)
                {
                    objTest.TestInvoiceDate = obj.TestInvoiceDate;
                    objTest.Amount          = obj.Amount;
                    objTest.Discount        = obj.Discount;
                    objTest.PatientId       = obj.PatientId;
                }
                if (objCust.Count == 1)
                {
                    if (IsCash)
                    {
                        tblCustomerTransaction objC = new tblCustomerTransaction()
                        {
                            PayAmount        = obj.Amount,
                            ReceiptDate      = obj.TestInvoiceDate,
                            IsCash           = IsCash,
                            IsDelete         = false,
                            TransactionDocNo = obj.TestInvoiceNo,
                            TransactionId    = objCust[0].TransactionId,
                            TransactionType  = "TestInvoice",
                            PatientId        = obj.PatientId,
                            BillAmount       = 0
                        };
                        objData.tblCustomerTransactions.InsertOnSubmit(objC);
                        foreach (tblCustomerTransaction item in objCust)
                        {
                            item.BillAmount  = obj.Amount;
                            item.ReceiptDate = obj.TestInvoiceDate;
                            item.IsCash      = IsCash;
                            if (item.IsCash == false)
                            {
                                if (item.PayAmount > 0)
                                {
                                    item.IsDelete = true;
                                }
                            }
                            else
                            {
                                if (item.PayAmount > 0)
                                {
                                    item.PayAmount = obj.Amount;
                                }
                                else
                                {
                                    item.PayAmount = 0;
                                }
                            }
                        }
                    }
                    else
                    {
                        foreach (tblCustomerTransaction item in objCust)
                        {
                            item.BillAmount  = obj.Amount;
                            item.ReceiptDate = obj.TestInvoiceDate;
                            item.IsCash      = IsCash;
                            if (item.IsCash == false)
                            {
                                if (item.PayAmount > 0)
                                {
                                    item.IsDelete = true;
                                }
                            }
                            else
                            {
                                if (item.PayAmount > 0)
                                {
                                    item.PayAmount = obj.Amount;
                                }
                                else
                                {
                                    item.PayAmount = 0;
                                }
                            }
                        }
                    }
                }
                else
                {
                    foreach (tblCustomerTransaction item in objCust)
                    {
                        item.BillAmount  = obj.Amount;
                        item.ReceiptDate = obj.TestInvoiceDate;
                        item.IsCash      = IsCash;
                        if (item.IsCash == false)
                        {
                            if (item.PayAmount > 0)
                            {
                                item.IsDelete = true;
                            }
                        }
                        else
                        {
                            if (item.PayAmount > 0)
                            {
                                item.PayAmount = obj.Amount;
                            }
                            else
                            {
                                item.PayAmount = 0;
                            }
                        }
                    }
                }

                foreach (TestAllocation item in lst)
                {
                    int cnt = (from tbl in objData.tblTestInvoiceDetails
                               where tbl.TestInvoiceId == obj.TestInvoiceNo &&
                               tbl.TestId == item.TestId &&
                               tbl.IsDelete == false
                               select tbl).ToList().Count;
                    if (cnt == 0)
                    {
                        tblTestInvoiceDetail objNewAdded = new tblTestInvoiceDetail()
                        {
                            TestInvoiceId = obj.TestInvoiceNo,
                            TestId        = item.TestId,
                            Charges       = item.Charges,
                            IsDelete      = false,
                        };
                        objData.tblTestInvoiceDetails.InsertOnSubmit(objNewAdded);
                        objData.SubmitChanges();
                    }
                    else
                    {
                        lstTemp.Add(item);
                    }
                }


                foreach (tblTestInvoiceDetail item in lstCurrent)
                {
                    int cnt = (from tbl in lst
                               where tbl.TestInvoiceNo == item.TestInvoiceId &&
                               tbl.TestId == item.TestId
                               select tbl).ToList().Count;

                    if (cnt == 0)
                    {
                        int checkExist = (from tbl in lstTemp
                                          where tbl.TestId == item.TestId
                                          select tbl).ToList().Count;
                        if (checkExist == 0)
                        {
                            item.IsDelete = true;
                        }
                    }
                }
                objData.SubmitChanges();
                return(1);
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }