public Ins_MemberItem GetMemberItemByIdForUpdate(long id)
{
Ins_MemberItem memberItem = new Ins_MemberItem();
memberItem = Database.Ins_MemberItems.Single(c => c.IID == id && c.IsRemoved == 0);
return(memberItem);
}
protected void lvMemberItem_ItemDataBound(object sender, ListViewItemEventArgs e)
{
if (e.Item.ItemType == ListViewItemType.DataItem)
{
ListViewDataItem dataItem = (ListViewDataItem)e.Item;
Label lblMemberItemName = (Label)e.Item.FindControl("lblMemberItemName");
Label lblMember = (Label)e.Item.FindControl("lblMember");
Label lblItemName = (Label)e.Item.FindControl("lblItemName");
Label lblCode = (Label)e.Item.FindControl("lblCode");
Label lblMesurementUnit = (Label)e.Item.FindControl("lblMesurementUnit");
Label lblCategory = (Label)e.Item.FindControl("lblCategory");
Label lblWeight = (Label)e.Item.FindControl("lblWeight");
LinkButton lnkBtnEdit = (LinkButton)e.Item.FindControl("lnkBtnEdit");
Ins_MemberItem item = dataItem.DataItem as Ins_MemberItem;
lblMember.Text = item.Member.Name;
lblMemberItemName.Text = item.Name;
lblItemName.Text = item.Ins_Item.Name;
lblCode.Text = item.Code;
lblMesurementUnit.Text = item.Ins_Item.MeasurementUnit.Name;
lblCategory.Text = item.Ins_Item.Ins_ItemCategory.Name;
lnkBtnEdit.CommandArgument = item.IID.ToString();
lblWeight.Text = item.ItemWeight.HasValue ? item.ItemWeight.Value.ToString("0.000") : "0";
lnkBtnEdit.CommandName = "editMemberItem";
lnkBtnEdit.Text = "Edit";
}
}
public Ins_MemberItem GetMemberItemById(long id)
{
Ins_MemberItem memberItem = new Ins_MemberItem();
memberItem = Database.Ins_MemberItems.Single(c => c.IID == id && c.IsRemoved == 0);
memberItem.Ins_Item = memberItem.Ins_Item;
memberItem.Ins_Item.Ins_ItemCategory = memberItem.Ins_Item.Ins_ItemCategory;
return(memberItem);
}
private void SaveUpdateInvoiceDetail(long invoiceID, TheFacade facade)
{
Inv_Detail invoiceDetail;
Ins_MemberItem item = facade.InsentiveFacade.GetMemberItemById(Convert.ToInt64(ddlItem.SelectedValue));
if (InvoiceDetailId <= 0)
{
if (!string.IsNullOrWhiteSpace(txtUnitPrice.Text) && !string.IsNullOrWhiteSpace(txtQuantity.Text) &&
Convert.ToInt32(ddlItem.SelectedValue) > 0)
{
invoiceDetail = new Inv_Detail();
invoiceDetail.InvMasterId = invoiceID;
invoiceDetail.InsMemberItemId = Convert.ToInt64(ddlItem.SelectedValue);
invoiceDetail.Quantity = Convert.ToInt32(txtQuantity.Text);
//invoiceDetail.UnitPrice = Convert.ToInt32(txtUnitPrice.Text);
invoiceDetail.UnitPrice = Convert.ToDecimal(txtUnitPrice.Text);
invoiceDetail.CartonSize = Convert.ToInt32(txtCartonSize.Text);
invoiceDetail.TotalItemCount = invoiceDetail.Quantity * invoiceDetail.CartonSize;
invoiceDetail.TotalAmount = invoiceDetail.Quantity * invoiceDetail.UnitPrice;
invoiceDetail.TotalWeight = string.IsNullOrEmpty(txtNetWeight.Text)?0: Convert.ToDecimal(txtNetWeight.Text); //item.ItemWeight.Value * invoiceDetail.TotalItemCount;
invoiceDetail.GrossWeight = string.IsNullOrEmpty(txtGrossWeight.Text) ? 0 : Convert.ToDecimal(txtGrossWeight.Text); //invoiceDetail.TotalWeight + Convert.ToDecimal(invoiceDetail.CartonSize * 0.2);
invoiceDetail.CreateBy = 1; //sustemuserid
invoiceDetail.CreateDate = DateTime.Now;
invoiceDetail.IsRemoved = 0;
invoiceDetail.UpdateBy = 1; //sustemuserid
invoiceDetail.UpdateDate = DateTime.Now;
facade.Insert <Inv_Detail>(invoiceDetail);
}
}
else
{
invoiceDetail = facade.InvoiceFacade.GetInvoiceDetailByID(InvoiceDetailId);
invoiceDetail.InvMasterId = invoiceID;
invoiceDetail.InsMemberItemId = Convert.ToInt32(ddlItem.SelectedValue);
invoiceDetail.Quantity = Convert.ToInt32(txtQuantity.Text);
invoiceDetail.UnitPrice = Convert.ToDecimal(txtUnitPrice.Text);
invoiceDetail.CartonSize = Convert.ToInt32(txtCartonSize.Text);
invoiceDetail.TotalItemCount = invoiceDetail.Quantity * invoiceDetail.CartonSize;
invoiceDetail.TotalAmount = invoiceDetail.Quantity * invoiceDetail.UnitPrice;
invoiceDetail.TotalWeight = string.IsNullOrEmpty(txtNetWeight.Text) ? 0 : Convert.ToDecimal(txtNetWeight.Text); //item.ItemWeight.Value * invoiceDetail.TotalItemCount;
invoiceDetail.GrossWeight = string.IsNullOrEmpty(txtGrossWeight.Text) ? 0 : Convert.ToDecimal(txtGrossWeight.Text); //invoiceDetail.TotalWeight + Convert.ToDecimal(invoiceDetail.CartonSize * 0.2);
//invoiceDetail.TotalWeight = item.ItemWeight.Value * invoiceDetail.TotalItemCount;
//invoiceDetail.GrossWeight = invoiceDetail.TotalWeight + Convert.ToDecimal(invoiceDetail.CartonSize * 0.2);
invoiceDetail.UpdateBy = 1;//sustemuserid
invoiceDetail.UpdateDate = DateTime.Now;
facade.Update <Inv_Detail>(invoiceDetail);
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
if (SelectedItemId <= 0)
{
Ins_MemberItem item = new Ins_MemberItem();
item.Name = txtName.Text;
item.ItemID = Convert.ToInt32(ddlItem.SelectedValue);
item.MemberID = Convert.ToInt32(ddlMember.SelectedValue);
item.Code = txtProductCode.Text;
item.ItemWeight = Convert.ToDecimal(txtProductWeight.Text);
item.CreateBy = 1;//sustemuserid
item.CreateDate = DateTime.Now;
item.IsRemoved = 0;
item.UpdateBy = 1;//sustemuserid
item.UpdateDate = DateTime.Now;
using (TheFacade facade = new TheFacade())
{
facade.Insert <Ins_MemberItem>(item);
Response.Redirect(Request.Url.ToString());
}
}
else
{
using (TheFacade facade = new TheFacade())
{
Ins_MemberItem item = facade.InsentiveFacade.GetMemberItemByIdForUpdate(SelectedItemId);
item.Name = txtName.Text;
item.MemberID = Convert.ToInt32(ddlMember.SelectedValue);
item.ItemID = Convert.ToInt32(ddlItem.SelectedValue);
item.Code = txtProductCode.Text;
item.ItemWeight = Convert.ToDecimal(txtProductWeight.Text);
item.UpdateBy = 1;//sustemuserid
item.UpdateDate = DateTime.Now;
facade.Update <Ins_MemberItem>(item);
Response.Redirect(Request.Url.ToString());
}
}
}
private void LoadMemberItemDetails()
{
using (TheFacade facade = new TheFacade())
{
Ins_MemberItem memberItem = facade.InsentiveFacade.GetMemberItemById(SelectedItemId);
if (memberItem != null)
{
ddlMember.SelectedValue = memberItem.MemberID.ToString();
MemberID = memberItem.MemberID;
ddlMember.Enabled = false;
txtName.Text = memberItem.Name;
ddlCategory.SelectedValue = memberItem.Ins_Item.CategoryID.ToString();
ddlCategory_SelectedIndexChanged(null, null);
// BindItemDropdownList(memberItem.Ins_Item.CategoryID);
//BindItemDropdownListForUpdate(memberItem.Ins_Item.CategoryID, memberItem.Ins_Item.IID);
ddlItem.SelectedValue = memberItem.Ins_Item.IID.ToString();
txtProductCode.Text = memberItem.Code;
txtMeasurementUnit.Text = memberItem.Ins_Item.MeasurementUnit.Unit;
txtProductWeight.Text = memberItem.ItemWeight.HasValue ? memberItem.ItemWeight.Value.ToString("0.000") : "0";
}
}
}
