public Inv_Master GetInvoiceByIDForUpdate(long id)
{
Inv_Master Invoice = new Inv_Master();
Invoice = Database.Inv_Masters.Single(i => i.IID == id && i.IsRemoved == 0);
return(Invoice);
}
protected void lvItem_ItemCommand(object sender, ListViewCommandEventArgs e)
{
if (e.CommandName == "DoDelete")
{
using (TheFacade _facade = new TheFacade())
{
Inv_Master item = new Inv_Master();
//ddlInvoiceList.SelectedValue = item.CurrencyId.ToString();
//IsNew = -1;
}
}
else
{
using (TheFacade _facade = new TheFacade())
{
Item item = new Item();
//item = _facade.ItemFacade.GetItemByID(Convert.ToInt64(e.CommandArgument.ToString()));
//CurrentItemID = item.IID;
//txtName.Text = item.Name;
//txtCode.Text = item.Code;
//ddlMeasurementUnit.SelectedValue = item.MeasurementUnitID.ToString();
//IsNew = 0;
}
}
}
public Inv_Master GetInvoiceByID(long id)
{
Inv_Master Invoice = new Inv_Master();
Invoice = Database.Inv_Masters.Single(i => i.IID == id && i.IsRemoved == 0);
Invoice.Currency = Invoice.Currency;
Invoice.InvoiceDetailList = Invoice.Inv_Details.ToList();
return(Invoice);
}
protected void lvItem_ItemDataBound(object sender, ListViewItemEventArgs e)
{
if (e.Item.ItemType == ListViewItemType.DataItem)
{
ListViewDataItem currentItem = (ListViewDataItem)e.Item;
Inv_Master item = (Inv_Master)((ListViewDataItem)(e.Item)).DataItem;
Label txtInvoiceNumber = (Label)currentItem.FindControl("txtInvoiceNumber");
Label txtInvoiceDate = (Label)currentItem.FindControl("txtInvoiceDate");
Label txtInvoiceQuientity = (Label)currentItem.FindControl("txtInvoiceQuientity");
Label txtInvoiceQuintityValue = (Label)currentItem.FindControl("txtInvoiceQuintityValue");
Label txtExportProductUsedQuintity = (Label)currentItem.FindControl("txtExportProductUsedQuintity");
Label txtUsedProductQuantity = (Label)currentItem.FindControl("txtUsedProductQuantity");
Label txtUsedProductQuantityValue = (Label)currentItem.FindControl("txtUsedProductQuantityValue");
Label txtSupplierNameAndAddress = (Label)currentItem.FindControl("txtSupplierNameAndAddress");
LinkButton lnkRemove = (LinkButton)currentItem.FindControl("lnkRemove");
var invoiceItemCount = item.InvoiceDetailList.Select(s => s.Quantity).Count();
txtSupplierNameAndAddress.Text = item.ExportedLocalDistrubuterNameAndAddress; // item.; TODO: ADD this field to DB
txtInvoiceQuientity.Text = invoiceItemCount.ToString(); //item.
txtInvoiceQuintityValue.Text = item.CurrencyAmount.HasValue ? item.CurrencyAmount.Value.ToString("0.00") : string.Empty;
txtExportProductUsedQuintity.Text = item.ExportedLocalItemQuantity;
txtUsedProductQuantity.Text = item.ExportedLocalItemQuantity;
txtUsedProductQuantityValue.Text = Convert.ToInt64(item.ExportedLocalItemAmount).ToString();
txtInvoiceNumber.Text = Convert.ToInt64(item.IID).ToString();
txtInvoiceDate.Text = Convert.ToDateTime(item.Date).ToString();
lnkRemove.CommandName = "removeInvoice";
lnkRemove.CommandArgument = item.IID.ToString();
if (IsForSubmit)
{
lnkRemove.Enabled = false;
lnkRemove.Visible = false;
}
else
{
lnkRemove.Enabled = true;
lnkRemove.Visible = true;
}
if (CurrentChaFormStatus == (int)EnumCollection.ChaFormStatus.Submited || CurrentChaFormStatus == (int)EnumCollection.ChaFormStatus.ReSubmit || CurrentChaFormStatus == (int)EnumCollection.ChaFormStatus.Approved)
{
lnkRemove.Enabled = false;
lnkRemove.Visible = false;
}
}
}
private void UpdateDollarAmount(TheFacade facade2, long invoiceId)
{
using (TheFacade facade = new TheFacade())
{
Inv_Master invoice = facade.InvoiceFacade.GetInvoiceByID(InvoiceId);
if (invoice.InvoiceDetailList?.Count > 0)
{
invoice.CurrencyAmount = invoice.InvoiceDetailList.Sum(s => s.TotalPrice);
invoice.DollarAmount = invoice.InvoiceDetailList.Sum(s => s.TotalPrice) *
invoice.DollarCounversionRate;
facade.Update <Inv_Master>(invoice);
}
}
}
private void LoadPageData()
{
using (TheFacade facade = new TheFacade())
{
List <Member> members = facade.InsentiveFacade.GetMemberAll();
DDLHelper.Bind <Member>(ddlMember, members, "Name", "ID", EnumCollection.ListItemType.Select, true);
List <Currency> currencies = facade.CommonFacade.GetCurrencyAll();
DDLHelper.Bind <Currency>(ddlCurrency, currencies, "CurrencyCode", "IID", EnumCollection.ListItemType.Select, true);
List <Country> countries = facade.CommonFacade.GetCountryAll();
DDLHelper.Bind <Country>(ddlCountry, countries, "Name", "IID", EnumCollection.ListItemType.Select, true);
LoadMemberItem();
////List<Ins_ItemCategory> categories = facade.InsentiveFacade.GetCategoryAll();
////DDLHelper.Bind<Ins_ItemCategory>(ddlCategory, categories, "Name", "IID", EnumCollection.ListItemType.Select, true);
if (InvoiceId > 0)
{
Inv_Master invoice = facade.InvoiceFacade.GetInvoiceByID(InvoiceId);
if (invoice.MemberId > 0)
{
MemberID = invoice.MemberId.Value;
}
ddlCurrency.SelectedValue = invoice.CurrencyId.ToString();
txtDate.Text = invoice.Date.ToString("dd/MM/yyyy");//, CultureInfo.InvariantCulture);
txtDollarAmount.Text = invoice.DollarAmount.ToString("#.##");
txtTotalcurrency.Text = invoice.CurrencyAmount.HasValue ? invoice.CurrencyAmount.Value.ToString("#.##") : string.Empty;
txtConversionRate.Text = invoice.DollarCounversionRate.ToString("#.##");
txtInvoiceNo.Text = invoice.Number;
txtLocalItemDescription.Text = invoice.ExportedLocalItemDescription;
txtLoacItemQuantity.Text = invoice.ExportedLocalItemQuantity;
txtLocalItemAmount.Text = invoice.ExportedLocalItemAmount.HasValue ? invoice.ExportedLocalItemAmount.Value.ToString("#.##") : string.Empty;
txtLocalDistrubuterNameAndAddress.Text = invoice.ExportedLocalDistrubuterNameAndAddress;
ddlCountry.SelectedValue = (invoice.CountryID > 0)?invoice.CountryID.ToString():"-1";
List <Inv_Detail> invoDetails = facade.InvoiceFacade.GetInvoiceDetailByInvoiceId(InvoiceId);
lvInvoiceDetail.DataSource = invoDetails;
lvInvoiceDetail.DataBind();
}
}
}
protected void lvItem_ItemDataBound(object sender, ListViewItemEventArgs e)
{
if (e.Item.ItemType == ListViewItemType.DataItem)
{
ListViewDataItem currentItem = (ListViewDataItem)e.Item;
Inv_Master item = (Inv_Master)((ListViewDataItem)(e.Item)).DataItem;
Label txtInvoiceNumber = (Label)currentItem.FindControl("txtInvoiceNumber");
Label txtInvoiceDate = (Label)currentItem.FindControl("txtInvoiceDate");
Label txtInvoiceQuientity = (Label)currentItem.FindControl("txtInvoiceQuientity");
Label txtInvoiceQuintityValue = (Label)currentItem.FindControl("txtInvoiceQuintityValue");
Label txtExportProductUsedQuintity = (Label)currentItem.FindControl("txtExportProductUsedQuintity");
Label txtUsedProductQuantity = (Label)currentItem.FindControl("txtUsedProductQuantity");
Label txtUsedProductQuantityValue = (Label)currentItem.FindControl("txtUsedProductQuantityValue");
Label txtSupplierNameAndAddress = (Label)currentItem.FindControl("txtSupplierNameAndAddress");
LinkButton lnkEdit = (LinkButton)currentItem.FindControl("lnkEdit");
LinkButton lnkDelete = (LinkButton)currentItem.FindControl("lnkDelete");
var invoiceItemCount = item.InvoiceDetailList.Select(s => s.Quantity).Count();
txtSupplierNameAndAddress.Text = "name Address"; // item.; TODO: ADD this field to DB
txtInvoiceQuientity.Text = invoiceItemCount.ToString(); //item.
txtInvoiceQuintityValue.Text = item.DollarAmount.ToString();
txtExportProductUsedQuintity.Text = item.ExportedLocalItemQuantity;
txtUsedProductQuantity.Text = item.ExportedLocalItemQuantity;
txtUsedProductQuantityValue.Text = Convert.ToInt64(item.ExportedLocalItemAmount).ToString();
txtInvoiceNumber.Text = Convert.ToInt64(item.IID).ToString();
txtInvoiceDate.Text = Convert.ToDateTime(item.Date).ToString();
//lnkEdit.CommandName = "DoEdit";
//lnkEdit.CommandArgument = item.IID.ToString();
//lnkDelete.CommandName = "DoDelete";
//lnkDelete.CommandArgument = item.IID.ToString();
}
}
protected void lvInvoiceList_ItemDataBound(object sender, ListViewItemEventArgs e)
{
if (e.Item.ItemType == ListViewItemType.DataItem)
{
ListViewDataItem dataItem = (ListViewDataItem)e.Item;
//Label lblInvoice = (Label)e.Item.FindControl("lblInvoice");
Label lblInvoiceNo = (Label)e.Item.FindControl("lblInvoiceNo");
Label lblInvoiceAmount = (Label)e.Item.FindControl("lblInvoiceAmount");
Label lblInvoiceDate = (Label)e.Item.FindControl("lblInvoiceDate");
HyperLink lnkBtnEdit = (HyperLink)e.Item.FindControl("lnkBtnEdit");
Inv_Master item = dataItem.DataItem as Inv_Master;
//lblInvoice.Text = item.Name;
lblInvoiceNo.Text = item.Number.ToString();
lblInvoiceAmount.Text = item.DollarAmount.ToString("#.##");
lblInvoiceDate.Text = item.Date.ToString("dd/M/yyyy");
lnkBtnEdit.NavigateUrl = "~/Admin/Invoice.aspx?invId=" + item.IID.ToString();
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
if (IsDuplicateInvoiceNo())
{
lblMessage.Text = string.Format("The Invoice No {0} already exist. Please try with another Invoice No", txtInvoiceNo.Text);
return;
}
using (TheFacade facade = new TheFacade())
{
if (InvoiceId <= 0)
{
Inv_Master invoice = new Inv_Master();
invoice.CurrencyId = Convert.ToInt32(ddlCurrency.SelectedValue);
//invoice.Date = Convert.ToDateTime(txtDate.Text);
//DateTime dt = DateTime.ParseExact(txtDate.Text, "dd/M/yyyy", CultureInfo.InvariantCulture);
//invoice.Date = dt;//
invoice.Date = Convert.ToDateTime(txtDate.Text);
invoice.DollarAmount = 0;//will be updated later
invoice.DollarCounversionRate = Convert.ToDecimal(txtConversionRate.Text);
invoice.Number = txtInvoiceNo.Text;
invoice.CreateBy = 1;//sustemuserid
invoice.CreateDate = DateTime.Now;
invoice.IsRemoved = 0;
invoice.UpdateBy = 1;//sustemuserid
invoice.UpdateDate = DateTime.Now;
invoice.MemberId = MemberID;
invoice.ExportedLocalItemDescription = txtLocalItemDescription.Text;
invoice.ExportedLocalItemQuantity = txtLoacItemQuantity.Text;
invoice.ExportedLocalItemAmount = Convert.ToDecimal(txtLocalItemAmount.Text);
invoice.ExportedLocalDistrubuterNameAndAddress = txtLocalDistrubuterNameAndAddress.Text;
invoice.CountryID = Convert.ToInt64(ddlCountry.SelectedValue.ToString());
try {
facade.Insert <Inv_Master>(invoice);
SaveUpdateInvoiceDetail(invoice.IID, facade);
InvoiceId = invoice.IID;
}
catch (Exception ex)
{
if (ex.Message.Contains("Violation of UNIQUE KEY constraint"))
{
lblMessage.Text = "Please Insert Unique Invoice Number";
}
else
{
lblMessage.Text = "Data Not Successfully Saved";
}
}
}
else
{
Inv_Master invoice = facade.InvoiceFacade.GetInvoiceByIDForUpdate(InvoiceId);
invoice.CurrencyId = Convert.ToInt32(ddlCurrency.SelectedValue);
//DateTime dt = DateTime.ParseExact(txtDate.Text, "dd/MM/yyyy", CultureInfo.InvariantCulture);
//invoice.Date = dt;// Convert.ToDateTime(txtDate.Text);
invoice.Date = Convert.ToDateTime(txtDate.Text);
invoice.DollarAmount = 0;;//will be updated later
invoice.DollarCounversionRate = Convert.ToDecimal(txtConversionRate.Text);
invoice.Number = txtInvoiceNo.Text;
invoice.UpdateBy = 1;//sustemuserid
invoice.UpdateDate = DateTime.Now;
invoice.MemberId = MemberID;
invoice.ExportedLocalItemDescription = txtLocalItemDescription.Text;
invoice.ExportedLocalItemQuantity = txtLoacItemQuantity.Text;
invoice.ExportedLocalItemAmount = Convert.ToDecimal(txtLocalItemAmount.Text);
invoice.ExportedLocalDistrubuterNameAndAddress = txtLocalDistrubuterNameAndAddress.Text;
invoice.CountryID = Convert.ToInt64(ddlCountry.SelectedValue.ToString());
facade.Update <Inv_Master>(invoice);
SaveUpdateInvoiceDetail(invoice.IID, facade);
}
UpdateDollarAmount(facade, InvoiceId);
}
//Response.Redirect(Request.Url.ToString());
//SHUVO
string redirectUrl = Request.Url.GetLeftPart(UriPartial.Path).ToString() + "?invId=" + InvoiceId.ToString();
Response.Redirect(redirectUrl);
}
