public void CreateChaForm(Ins_ChaForm chaForm)
{
chaForm.MemberID = MemberID;
chaForm.ExportLCNo = txtAgrementNumber.Text.Trim();
chaForm.ExportValuation = Convert.ToDecimal(txtAggrementValue.Text.Trim());
chaForm.ForignCustomerName = txtForiegnBuyer.Text.Trim();
chaForm.ForignCustomerAddress = txtForignAddress.Text.Trim();
chaForm.ForignCustomerBankName = txtForiegnBankName.Text.Trim();
chaForm.ForignCustomerBankAddress = txtForiegnBankAddress.Text.Trim();
chaForm.DestinationPort = txtDestinationAddress.Text.Trim();
chaForm.EKIMPNumber = txtEXPINumber.Text.Trim();
chaForm.EKIMPAmount = Convert.ToDecimal(txtEXPIValue.Text.Trim());
chaForm.ProposedExportedAmount = Convert.ToDecimal(txtExportProductRate.Text.Trim());
chaForm.ProposedExportedCertificateNo = txtExportPriceCertificateNumber.Text.Trim();
chaForm.NetFOBAmount = Convert.ToDecimal(txtNitFOBValue.Text.Trim());
chaForm.CurrencyId = Convert.ToInt32(ddlCurrencyType.SelectedValue);
chaForm.EKIMPDate = Convert.ToDateTime(txtEXPINumberDate.Text.Trim());
chaForm.LCDate = Convert.ToDateTime(txtAgrementDate.Text.Trim());
chaForm.ShipmentDate = Convert.ToDateTime(txtShippingDate.Text.Trim());
chaForm.ProposedExportedCertificateDate = Convert.ToDateTime(txtExportPriceCertificateDate.Text.Trim());
if (chaForm.ID <= 0)
{
chaForm.UpdateBy = 1;
chaForm.UpdateDate = DateTime.Now;
}
chaForm.CreateBy = 1;
chaForm.CreateDate = DateTime.Now;
chaForm.IsRemoved = 0;
}
protected void lvIDraftChaForm_ItemDataBound(object sender, ListViewItemEventArgs e)
{
if (e.Item.ItemType == ListViewItemType.DataItem)
{
ListViewDataItem dataItem = (ListViewDataItem)e.Item;
Label lblAggrementNo = (Label)e.Item.FindControl("lblAggrementNo");
Label lblAggrementDate = (Label)e.Item.FindControl("lblAggrementDate");
Label lblForignCustomerName = (Label)e.Item.FindControl("lblForignCustomerName");
Label lblForignCustomerBankName = (Label)e.Item.FindControl("lblForignCustomerBankName");
Label lblCurrency = (Label)e.Item.FindControl("lblCurrency");
Label lblShipmentDate = (Label)e.Item.FindControl("lblShipmentDate");
LinkButton lnkBtnEdit = (LinkButton)e.Item.FindControl("lnkBtnEdit");
LinkButton lnkBtnSummit = (LinkButton)e.Item.FindControl("lnkBtnSummit");
Ins_ChaForm chaForm = dataItem.DataItem as Ins_ChaForm;
lblAggrementNo.Text = chaForm.ExportLCNo;
lblAggrementDate.Text = chaForm.LCDate.ToString("dd/MM/yyyy");
lblForignCustomerName.Text = chaForm.ForignCustomerName;
lblForignCustomerBankName.Text = chaForm.ForignCustomerBankName;
lblCurrency.Text = chaForm.Currency.CurrencyCode;
lblShipmentDate.Text = chaForm.ShipmentDate.ToString("dd/MM/yyyy");
lnkBtnEdit.CommandArgument = chaForm.ID.ToString();
lnkBtnEdit.CommandName = "editItem";
lnkBtnEdit.Text = "Edit";
lnkBtnSummit.CommandArgument = chaForm.ID.ToString();
lnkBtnSummit.CommandName = "submitItem";
lnkBtnSummit.Text = "Submit";
}
}
public Ins_ChaForm GetChaFormByID(long id)
{
Ins_ChaForm chaform = Database.Ins_ChaForms.Where(c => c.ID == id).FirstOrDefault();
if (chaform != null)
{
chaform.Ins_ChaFormInvoices = chaform.Ins_ChaFormInvoices;
chaform.Member = chaform.Member;
}
return(chaform);
}
protected void btnSubmited_Click(object sender, EventArgs e)
{
if (CurrentChaFormID > 0)
{
using (TheFacade facade = new TheFacade())
{
Ins_ChaForm chaForm = facade.InsentiveFacade.GetChaFormByID(CurrentChaFormID);
chaForm.Status = Convert.ToInt32(EnumCollection.ChaFormStatus.Submited);
facade.Update <Ins_ChaForm>(chaForm);
}
Response.Redirect("~/insMember/MemberChaFormListing.aspx");
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
Ins_ChaForm chaForm = new Ins_ChaForm();
using (TheFacade facade = new TheFacade())
{
if (CurrentChaFormID > 0)
{
chaForm = facade.InsentiveFacade.GetChaFormByID(CurrentChaFormID);
}
CreateChaForm(chaForm);
if (CurrentChaFormID > 0)
{
facade.Update <Ins_ChaForm>(chaForm);
}
else
{
chaForm.Status = Convert.ToInt32(EnumCollection.ChaFormStatus.Draft);
facade.Insert <Ins_ChaForm>(chaForm);
}
List <Ins_ChaFormInvoice> chaFormInvoices = facade.InsentiveFacade.GetchaFormInvoiceByChaFormID(chaForm.ID);
//TODO: Get invoiceIds from Session["InvoiceIds"];
foreach (Ins_ChaFormInvoice item in chaFormInvoices)
{
facade.Delete <Ins_ChaFormInvoice>(item);
}
var invoiceIds = new List <long>();
//List<Ins_ChaFormInvoice> list = new List<Ins_ChaFormInvoice>();
if (Session["InvoiceIds"] != null)
{
var invoiceIdsFromSession = (List <long>)Session["InvoiceIds"];
invoiceIds.AddRange(invoiceIdsFromSession);
}
foreach (var invoiceId in invoiceIds)
{
var chaInvoice = new Ins_ChaFormInvoice();
chaInvoice.InvoiceMasterId = invoiceId;
chaInvoice.ChaFormId = chaForm.ID;
facade.Insert <Ins_ChaFormInvoice>(chaInvoice);
}
}
lblmessage.Text = "Data save successfully";
lblmessage.Visible = true;
}
protected void btnApproved_Click(object sender, EventArgs e)
{
if (CurrentChaFormID <= 0)
{
return;
}
using (TheFacade facade = new TheFacade())
{
Ins_ChaForm chaForm = facade.InsentiveFacade.GetChaFormByID(CurrentChaFormID);
chaForm.Status = (int)EnumCollection.ChaFormStatus.Approved;
chaForm.ChaFormNo = txtChaFormNo.Text;
facade.Update <Ins_ChaForm>(chaForm);
}
Response.Redirect("~/Admin/MemberChaForm.aspx");
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
if (Request.QueryString["CurrentChaFormID"] != null)
{
CurrentChaFormID = Convert.ToInt64(Request.QueryString["CurrentChaFormID"]);
}
Session["InvoiceIds"] = null;
if (CurrentChaFormID <= 0)
{
if (Session["MemberID"] == null)
{
Session.Abandon();
//Response.Redirect("~/Login/login.aspx?returnurl="+Request.Url );
Response.Redirect("~/Login/login.aspx");
}
else
{
MemberID = Convert.ToInt64(Session["MemberID"].ToString());
}
}
using (TheFacade facade = new TheFacade())
{
Ins_ChaForm chaForm = facade.InsentiveFacade.GetChaFormByID(CurrentChaFormID);
MemberID = chaForm.MemberID;
}
if (Request.QueryString["IsForSubmit"] != null)
{
IsForSubmit = Convert.ToBoolean(Convert.ToInt32(Request.QueryString["IsForSubmit"].ToString()));
}
lblNowDate.Text = (DateTime.Now).ToString();
LoadCurrencyType();
LoadInvoice();
LoadChaFormDetails();
ChangeButtonStatus();
}
}
protected void lvSubmittedChaForm_ItemDataBound(object sender, ListViewItemEventArgs e)
{
if (e.Item.ItemType == ListViewItemType.DataItem)
{
ListViewDataItem dataItem = (ListViewDataItem)e.Item;
Label lblMemberNo = (Label)e.Item.FindControl("lblMemberNo");
Label lblMemberName = (Label)e.Item.FindControl("lblMemberName");
Label lblAggrementNo = (Label)e.Item.FindControl("lblAggrementNo");
Label lblAggrementDate = (Label)e.Item.FindControl("lblAggrementDate");
Label lblForignCustomerName = (Label)e.Item.FindControl("lblForignCustomerName");
Label lblForignCustomerBankName = (Label)e.Item.FindControl("lblForignCustomerBankName");
Label lblCurrency = (Label)e.Item.FindControl("lblCurrency");
Label lblShipmentDate = (Label)e.Item.FindControl("lblShipmentDate");
LinkButton lnkBtnView = (LinkButton)e.Item.FindControl("lnkBtnView");
LinkButton lnkBtnApprove = (LinkButton)e.Item.FindControl("lnkBtnApprove");
Ins_ChaForm chaForm = dataItem.DataItem as Ins_ChaForm;
lblMemberNo.Text = chaForm.Member.MembershipCode;
lblMemberName.Text = chaForm.Member.Name;
lblAggrementNo.Text = chaForm.ExportLCNo;
lblAggrementDate.Text = chaForm.LCDate.ToString("dd/MM/yyyy");
lblForignCustomerName.Text = chaForm.ForignCustomerName;
lblForignCustomerBankName.Text = chaForm.ForignCustomerBankName;
lblCurrency.Text = chaForm.Currency.CurrencyCode;
lblShipmentDate.Text = chaForm.ShipmentDate.ToString("dd/MM/yyyy");
lnkBtnView.CommandArgument = chaForm.ID.ToString();
lnkBtnView.CommandName = "viewItem";
lnkBtnView.Text = "View";
lnkBtnApprove.CommandArgument = chaForm.ID.ToString();
lnkBtnApprove.CommandName = "approveItem";
lnkBtnApprove.Text = "Approve";
}
}
public void LoadChaFormDetails()
{
if (CurrentChaFormID <= 0)
{
using (TheFacade facade = new TheFacade())
{
Member member = facade.MemberFacade.GetMemberById(MemberID);
if (member != null)
{
txtCompanyName.Text = member.NameBangla;
txtAddress.Text = member.AddressBangla;
}
}
}
else
{
using (TheFacade facade = new TheFacade())
{
Ins_ChaForm chaForm = new Ins_ChaForm();
chaForm = facade.InsentiveFacade.GetChaFormByID(CurrentChaFormID);
if (chaForm == null)
{
return;//should be shown a message that caanto find the Cha-Form
}
//CurrentChaFormStatus = chaForm.Status;
txtCompanyName.Text = chaForm.Member.NameBangla;
txtAddress.Text = chaForm.Member.AddressBangla;
txtAggrementValue.Text = chaForm.ExportValuation.ToString();
txtForiegnBuyer.Text = chaForm.ForignCustomerName;
txtForignAddress.Text = chaForm.ForignCustomerAddress;
txtForiegnBankName.Text = chaForm.ForignCustomerBankName;
txtForiegnBankAddress.Text = chaForm.ForignCustomerBankAddress;
txtDestinationAddress.Text = chaForm.DestinationPort;
txtEXPINumber.Text = chaForm.EKIMPNumber;
txtEXPIValue.Text = chaForm.EKIMPAmount.ToString();
txtExportProductRate.Text = chaForm.ProposedExportedAmount.ToString();
txtExportPriceCertificateNumber.Text = chaForm.ProposedExportedCertificateNo;
txtNitFOBValue.Text = chaForm.NetFOBAmount.ToString();
//ddlCurrencyType.SelectedValue = member.CurrencyId.ToString();
txtEXPINumberDate.Text = chaForm.EKIMPDate.ToString();
txtAgrementDate.Text = chaForm.LCDate.ToString();
txtShippingDate.Text = chaForm.ShipmentDate.ToString();
txtExportPriceCertificateDate.Text = chaForm.ProposedExportedCertificateDate.ToString();
//member.MemberID = MemberID;
txtAgrementNumber.Text = chaForm.ExportLCNo;
//Invoice Loading
List <Ins_ChaFormInvoice> chaFormInvoices = facade.InsentiveFacade.GetchaFormInvoiceByChaFormID(chaForm.ID);
var invoiceIds = new List <long>();
if (Session["InvoiceIds"] != null)
{
var invoiceIdsFromSession = (List <long>)Session["InvoiceIds"];
invoiceIds.AddRange(invoiceIdsFromSession);
}
foreach (Ins_ChaFormInvoice item in chaFormInvoices)
{
invoiceIds.Add(item.InvoiceMasterId);
}
Session["InvoiceIds"] = invoiceIds;
LoadItemListView(invoiceIds);
//lvItem.DataSource = master;
//lvItem.DataBind();
}
}
}
