public override List <DbObject> RetrieveMany(string id)
{
List <DbObject> lOutput = new List <DbObject>();
List <string> lIdList = _db.GetIDs;
foreach (string ids in lIdList)
{
Invoice.Invoice lInvoice = null;
switch (id.ToLower())
{
case "tax":
lInvoice = _db.Read(ids) as Tax;
break;
case "sale":
lInvoice = _db.Read(ids) as Sale;
break;
case "all":
lInvoice = _db.Read(ids) as Invoice.Invoice;
break;
default:
throw new ArgumentException("Needs to be either tax / sale or all");
}
if (lInvoice != null)
{
lOutput.Add(lInvoice);
}
}
return(lOutput);
}
public static bool ValidDateRangeCheck(Invoice.Invoice invoice, DateTime start, DateTime end)
{
int lStart = invoice.Date.CompareTo(start);
int lEnd = invoice.Date.CompareTo(end);
// Less than zero ; earlier date
// Greater than zero; later date
if (lStart >= 0 && lEnd <= 0)
{
return(true);
}
return(false);
}
public override string Add(DbObject item)
{
Invoice.Invoice i = item as Invoice.Invoice;
if (i == null)
{
throw new NullReferenceException("Not of type Invoice");
}
if (_db.Create(item))
{
return("Successfully added invoice.");
}
return("Duplication! Invoice already exists. ID:" + item.Id);
}
private void btndelete_Click(object sender, System.EventArgs e)
{
int InvoiceID = Convert.ToInt32(Request.QueryString["InvoiceID"].ToString());
string Category = Request.QueryString["InvoiceType"];
Invoice.Invoice objinvoice = new Invoice.Invoice();
if (objinvoice.Deleteinvoicecreditnote(InvoiceID, Category))
{
lblMessege.Text = "Deleted successfully";
Response.Write("<script>alert('Invoice deleted successfully');</script>");
Response.Write("<script>opener.location.reload(true);</script>");
Response.Write("<script>self.close();</script>");
}
else
{
lblMessege.Text = "Error in deleting document.";
}
}
static void Main(string[] args)
{
Console.Out.WriteLine("Invoice App");
Console.Out.WriteLine("Generating invoices, press any key to stop...");
Console.Out.WriteLine("Number\tDate\tDue date\tOver due");
Random r = new Random();
while (!Console.KeyAvailable)
{
int invNum = r.Next(8999) + 1000;
int invDateRange = r.Next(5) - 10;
int dueDateRange = r.Next(5) - 3;
Invoice.Invoice inv = new Invoice.Invoice(invNum.ToString(), DateTime.Now.AddDays(invDateRange), DateTime.Now.AddDays(dueDateRange));
Console.WriteLine(inv);
Thread.Sleep(1000);
}
Console.ReadKey();
Console.Out.WriteLine("Done. Press any key to exit.");
Console.ReadKey();
}
private void generateInvoiceBtn_Click(object sender, EventArgs e)
{
if (appointment == null || displayedAppointment == null)
{
return;
}
var invoicePatient = patientService.GetPatientById(appointment.patient_id);
var invoiceService = serviceService.GetServiceById(appointment.service_id);
serviceCost = invoiceService.cost;
var prescriptions = prescriptionService.GetPatientPrescriptionByPatientId(invoicePatient.patient_id);
List <string> drugNames = new List <string>();
foreach (var prescription in prescriptions)
{
drugNames.Add(drugService.GetDrugById(prescription.drug_id).drug_name);
drugCost += drugService.GetDrugById(prescription.drug_id).cost;
}
StringBuilder stringBuilder = new StringBuilder();
stringBuilder.AppendLine();
foreach (var drugName in drugNames)
{
stringBuilder.AppendLine(drugName);
}
var invoiceTotalCost = drugCost + serviceCost;
InvoiceService invoiceDAOService = new InvoiceService();
invoice = new Invoice.Invoice()
{
patient_id = invoicePatient.patient_id,
invoice_date = appointment.appointment_date,
service_id = invoiceService.service_id,
drug_names = stringBuilder.ToString(),
total_cost = invoiceTotalCost
};
var created = invoiceDAOService.CreateInvoice(invoice);
MessageBox.Show(created ? "Invoice Successfully Generated!" : "Failed to Generate Invoice");
if (!created)
{
return;
}
printPreviewDialog1.StartPosition = FormStartPosition.CenterScreen;
printPreviewDialog1.Size = new Size(480, 600);
ToolStripButton b = new ToolStripButton();
b.Image = Properties.Resources.PrintIcon;
b.DisplayStyle = ToolStripItemDisplayStyle.Image;
b.Click += printPreview_PrintClick;
((ToolStrip)(printPreviewDialog1.Controls[1])).Items.RemoveAt(0);
((ToolStrip)(printPreviewDialog1.Controls[1])).Items.Insert(0, b);
printPreviewDialog1.ShowDialog();
}
private void LoadDataSearch(int iCompanyID)
{
Invoice.Invoice objInvoice = new Invoice.Invoice();
string strStatus = "";
string strUserName = "";
string strEmail = "";
CreateTable();
if (Convert.ToInt32(ddldept.SelectedValue.Trim(), 10) == 0)
{
sqlConn = new SqlConnection(CBSAppUtils.PrimaryConnectionString);
sqlDA = new SqlDataAdapter("stpGetPurchaseInvoiceHistoryNL_CN", sqlConn);
sqlDA.SelectCommand.CommandType = CommandType.StoredProcedure;
sqlDA.SelectCommand.Parameters.Add("@CompanyID", iCompanyID); //13053); //iCompanyID);
sqlDA.SelectCommand.Parameters.Add("@SupplierCompanyID", ddlSupplier.SelectedValue.Trim());
sqlDA.SelectCommand.Parameters.Add("@ActionStatusID", ddlActionStatus.SelectedValue.Trim());
sqlDA.SelectCommand.Parameters.Add("@DocStatusID", ddlDocStatus.SelectedValue.Trim());
sqlDA.SelectCommand.Parameters.Add("@UserID", ddlUsers.SelectedValue.Trim());
sqlDA.SelectCommand.Parameters.Add("@InvoiceNo", ddlInvoiceNo.SelectedValue.Trim());
sqlDA.SelectCommand.Parameters.Add("@FromDate", strFromDate);
sqlDA.SelectCommand.Parameters.Add("@ToDate", strToDate);
sqlDA.SelectCommand.Parameters.Add("@FromPrice", FromPrice);
sqlDA.SelectCommand.Parameters.Add("@ToPrice", ToPrice);
}
else
{
sqlConn = new SqlConnection(CBSAppUtils.PrimaryConnectionString);
sqlDA = new SqlDataAdapter("stpGetPurchaseInvoiceHistorySerachNL_CN", sqlConn);
sqlDA.SelectCommand.CommandType = CommandType.StoredProcedure;
sqlDA.SelectCommand.Parameters.Add("@CompanyID", iCompanyID); //13053); //iCompanyID);
sqlDA.SelectCommand.Parameters.Add("@SupplierCompanyID", ddlSupplier.SelectedValue.Trim());
sqlDA.SelectCommand.Parameters.Add("@ActionStatusID", ddlActionStatus.SelectedValue.Trim());
sqlDA.SelectCommand.Parameters.Add("@DocStatusID", ddlDocStatus.SelectedValue.Trim());
sqlDA.SelectCommand.Parameters.Add("@UserID", ddlUsers.SelectedValue.Trim());
sqlDA.SelectCommand.Parameters.Add("@InvoiceNo", ddlInvoiceNo.SelectedValue.Trim());
sqlDA.SelectCommand.Parameters.Add("@FromDate", strFromDate);
sqlDA.SelectCommand.Parameters.Add("@ToDate", strToDate);
sqlDA.SelectCommand.Parameters.Add("@FromPrice", FromPrice);
sqlDA.SelectCommand.Parameters.Add("@ToPrice", ToPrice);
sqlDA.SelectCommand.Parameters.Add("@DepartmentID", ddldept.SelectedValue.Trim());
}
if (Convert.ToInt32(Session["UserTypeID"]) > 1)
{
sqlDA.SelectCommand.Parameters.Add("@PassedToUserID", DBNull.Value);
sqlDA.SelectCommand.Parameters.Add("@Option", 1);
}
else
{
sqlDA.SelectCommand.Parameters.Add("@PassedToUserID", Session["UserID"].ToString().Trim());
sqlDA.SelectCommand.Parameters.Add("@Option", DBNull.Value);
}
sqlDA.TableMappings.Add("InvoiceDetails", "InvoiceHeader");
ds = new DataSet();
try
{
sqlDA.Fill(ds, "InvoiceDetails");
}
catch (Exception ex) { string ss = ex.Message.ToString(); }
finally
{
sqlDA.Dispose();
sqlConn.Close();
}
foreach (DataRow drInvoiceHeader in ds.Tables["InvoiceHeader"].Rows)
{
dr = objDataTable.NewRow();
dr["CreditNoteID"] = drInvoiceHeader["CreditNoteID"];
dr["ReferenceNo"] = drInvoiceHeader["ReferenceNo"];
dr["SupplierCode"] = drInvoiceHeader["SupplierCode"];
dr["Supplier"] = drInvoiceHeader["Supplier"];
dr["VendorID"] = drInvoiceHeader["VendorID"];
dr["InvoiceDate"] = drInvoiceHeader["InvoiceDate"];
dr["DeliveryDate"] = drInvoiceHeader["DeliveryDate"];
dr["Net"] = drInvoiceHeader["Net"];
dr["VAT"] = drInvoiceHeader["VAT"];
dr["Total"] = drInvoiceHeader["Total"];
// CURRENT STATUS
objInvoice.GetCurrentStatus(Convert.ToInt32(drInvoiceHeader["StatusID"]), out strStatus);
dr["DocStatus"] = strStatus;
dr["ActionStatus"] = drInvoiceHeader["ActionStatus"];
// USER NAME
objInvoice.GetUserName(Convert.ToInt32(drInvoiceHeader["ModUserID"]), out strUserName, out strEmail);
dr["User"] = strUserName;
dr["Comment"] = strUserName;
dr["ActionDate"] = drInvoiceHeader["ModDate"];
dr["DocAttachments"] = drInvoiceHeader["Document"];
dr["DocType"] = "INV";
dr["ParentRowFlag"] = "1";
if (drInvoiceHeader["BranchCode"] != DBNull.Value)
{
dr["BranchCode"] = drInvoiceHeader["BranchCode"];
}
objDataTable.Rows.Add(dr);
}
ViewState["objDataTable"] = objDataTable;
PopulateGrid();
CheckDuplicateValues();
}
public void PopulateData()
{
int iCurrencyTypeID = 0;
Invoice.Invoice objInvoice = new Invoice.Invoice();
Company objCompany = new Company();
grdInvoiceDetails.DataSource = rsInvoiceDetail.ParentTable;
grdInvoiceDetails.DataBind();
if (rsInvoiceHead["InvoiceNo"] != DBNull.Value)
{
strInvoiceNo = rsInvoiceHead["InvoiceNo"].ToString().Trim();
}
if (rsInvoiceHead["InvoiceDate"] != DBNull.Value)
{
strInvoiceDate = Convert.ToDateTime(rsInvoiceHead["InvoiceDate"]).ToString("dd/MM/yyyy");
}
if (rsInvoiceHead["SellerVATNo"] != DBNull.Value)
{
strSellerVatRegNo = rsInvoiceHead["SellerVATNo"].ToString().Trim();
}
if (rsInvoiceHead["New_TaxCountryNumber"] != DBNull.Value)
{
strCountryTaxNo = rsInvoiceHead["New_TaxCountryNumber"].ToString().Trim();
}
strTradersReference = objCompany.GetTradersReference(Convert.ToInt32(rsInvoiceHead["SupplierCompanyID"]));
if (rsInvoiceHead["CurrencyTypeID"] != DBNull.Value)
{
iCurrencyTypeID = Convert.ToInt32(rsInvoiceHead["CurrencyTypeID"]);
strCurrency = objInvoice.GetCurrencyName(Convert.ToInt32(rsInvoiceHead["CurrencyTypeID"]));
}
#region Manipulating VAT IN GBP amount
if (Session["StrVATAmt_CN"] != null)
{
if (Utility.IsNumeric(Session["StrVATAmt_CN"].ToString().Trim()))
{
strVatInGBP = Convert.ToString(Math.Round(Convert.ToDouble(Session["StrVATAmt_CN"].ToString().Trim()), 2));
}
}
else
{
Invoice.Invoice oInvoice = new Invoice.Invoice();
Double dGBPEquivalentAmount = 0;
dGBPEquivalentAmount = oInvoice.GetGBPEquivalentAmount(invoiceID);
if (dGBPEquivalentAmount != 0)
{
strVatInGBP = dGBPEquivalentAmount.ToString();
if (Utility.IsNumeric(strVatInGBP))
{
strVatInGBP = Convert.ToString(Math.Round(Convert.ToDouble(strVatInGBP), 2));
}
}
oInvoice = null;
}
#endregion
}
private void btndelete_Click(object sender, System.EventArgs e)
{
Invoice.Invoice objinvoice = new Invoice.Invoice();
if (txtComment.Text.Trim() == "")
{
lblErrorMsg.Text = "Please enter a comment.";
return;
}
else
{
lblErrorMsg.Text = "";
iApproverStatusID = 7;
strComments = txtComment.Text.Trim();
UserTypeID = objinvoice.GetUserType(System.Convert.ToInt32(Session["UserID"].ToString()));
if (DocType == "INV")
{
StatusUpdate = objinvoice.UpdateInvStatusToDelete(System.Convert.ToInt32(Session["eInvoiceID"].ToString()));
if (StatusUpdate == 1)
{
objinvoice.UpdateInvoiceStatusLogApproverWise(System.Convert.ToInt32(Session["eInvoiceID"]), System.Convert.ToInt32(Session["UserID"]), UserTypeID, iApproverStatusID, strComments, "");
lblErrorMsg.Text = "Invoice deleted successfully";
Response.Write("<script>alert('Invoice Deleted Successfully');</script>");
Response.Write("<script>window.opener.Form1.btnSearch.click();</script>");
Response.Write("<script>self.close();</script>");
}
else
{
lblErrorMsg.Text = "Invoice cannot be deleted";
}
}
else if (DocType == "CRN")
{
StatusUpdate = objinvoice.UpdateCrnStatusToDelete(System.Convert.ToInt32(Session["eInvoiceID"].ToString()));
if (StatusUpdate == 1)
{
objinvoice.UpdateInvoiceStatusLogApproverWise_CN(System.Convert.ToInt32(Session["eInvoiceID"]), System.Convert.ToInt32(Session["UserID"]), UserTypeID, iApproverStatusID, strComments);
lblErrorMsg.Text = "CreditNote deleted successfully";
Response.Write("<script>alert('Credit Note Deleted Successfully');</script>");
Response.Write("<script>window.opener.Form1.btnSearch.click();</script>");
Response.Write("<script>self.close();</script>");
}
else
{
lblErrorMsg.Text = "CreditNote cannot be deleted";
}
}
else
{
StatusUpdate = objinvoice.UpdateDebitNoteStatusToDelete(System.Convert.ToInt32(Session["eInvoiceID"].ToString()));
if (StatusUpdate == 1)
{
objinvoice.UpdateInvoiceStatusLogApproverWise_DN(System.Convert.ToInt32(Session["eInvoiceID"]), System.Convert.ToInt32(Session["UserID"]), UserTypeID, iApproverStatusID, strComments);
lblErrorMsg.Text = "CreditNote deleted successfully";
Response.Write("<script> alert('Credit Note Deleted Successfully'); </script>");
Response.Write("<script>window.opener.Form1.btnSearch.click();</script>");
Response.Write("<script> self.close(); </script>");
}
else
{
lblErrorMsg.Text = "CreditNote cannot be deleted";
}
}
}
}
