using System;
using System.Collections;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Web;
using System.Web.SessionState;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.HtmlControls;
using CommonV2;
using System.Web.Mail;

public partial class sendpo : System.Web.UI.Page
{

	protected void Page_Load(object sender, System.EventArgs e)
	{
		if (!eCateLib.MemberLoginStatus()) Response.Redirect("~/general/login.aspx");

		if(!Page.IsPostBack)
		{
			try
			{
				PopulateDetail();
				if (Util.DefaultSystemSetting.Flag_MemberModule) 
				{
					if(Util.Member!=null && Util.Member.Email != "") 
					{
						PopulateForm();
					}
				}
				if (Util.DefaultSystemSetting.Flag_StoreRFQ) PopulateForm();
			}
			catch(Exception ex)
			{
				Util.TmpString=ex.Message;
				Response.Redirect("~/general/status.aspx");	
			}
		}
	}

	private void PopulateForm()
	{
		MemberProxy mp = Util.MemberProxy;
		Member member = (Member)mp.FindByID(Util.Member.MemberID);

		//txtComp.Text = member.Company;
        //txtName.Text = member.Name;
        //txtAdd1.Text = member.Address1;
        //txtAdd2.Text = member.Address2;
        //txtAdd3.Text = member.Address3;			
        //txtPostal.Text = member.Postal;
        //txtTel.Text = member.Tel;
        //txtFax.Text = member.Fax;
        //txtEmail.Text = member.Email;

        //foreach(ListItem li in txtCountry.Items)
        //{
        //    if(li.Text == member.Country ) li.Selected = true;
        //}
	}

	private void PopulateDetail()
	{
		Decimal totalamt = 0;
		Decimal gstamt = 0;
		if (Request.QueryString["RFQID"]!=null && Request.QueryString["RFQID"]!="")
		{
			int id = Int32.Parse(Request.QueryString["RFQID"]);
			RFQProxy rp = Util.RFQProxy;
			dgCart.DataSource = rp.GetDetail(id);
			dgCart.DataKeyField = "i_detail_id";

			totalamt = rp.GetTotlaAmt(id);
		}
		else
		{
			ShoppingCartProxy scp = Util.ShoppingCartProxy;
			dgCart.DataSource = scp.GetAll(Util.GetShoppingCartId);

			totalamt = scp.GetTotalAmt(Util.GetShoppingCartId);
		}			

		dgCart.DataBind();			

		if (Util.DefaultSystemSetting.Flag_GST) 
		{
			lbGSTTitle.Text = "GST " + Util.DefaultSystemSetting.GSTRate.ToString() + " %: ";
			trGST.Visible = true;
			gstamt = totalamt * (Decimal)Util.DefaultSystemSetting.GSTRate/100;

			lbGST.Text = String.Format("{0:c}",gstamt);
			lbTotal.Text	= String.Format("{0:c}", totalamt + gstamt);
		} 
		else
		{
			trGST.Visible = false;
			lbTotal.Text = String.Format("{0:c}",totalamt);
		}

        //CountryProxy cp = Util.CountryProxy;
        //txtCountry.DataSource = cp.GetAll();
        //txtCountry.DataBind();

		if (!Util.DefaultSystemSetting.Flag_MemberModule)
		{
			#region set default to singapore

            //foreach(ListItem  li in txtCountry.Items)
            //{
            //    if(li.Text == "Singapore")
            //    {
            //        li.Selected = true; 
            //    }
            //}			
			#endregion
		}

		txtDate.Text = DateTime.Today.ToString("dd/MM/yyyy");
		
	}

	protected void btRFQ_Click(object sender, System.EventArgs e)
	{		
		this.Page.Validate();
		if( this.Page.IsValid )
		{	
            OrderHeader header = new OrderHeader();
            DataSet cart = new DataSet();

            if (Request.QueryString["RFQID"] != null && Request.QueryString["RFQID"] != "")
            {
                int id = Int32.Parse(Request.QueryString["RFQID"]);
                RFQProxy rp = Util.RFQProxy;
                cart = (DataSet)rp.GetDetail(id);
                header.Amount = rp.GetTotlaAmt(id);
            }
            else
            {
                ShoppingCartProxy scp = Util.ShoppingCartProxy;
                cart = (DataSet)scp.GetAll(Util.GetShoppingCartId);
                header.Amount = scp.GetTotalAmt(Util.GetShoppingCartId);
            }

            //if (Util.DefaultSystemSetting.Flag_GST) 
            //{
            //    Decimal gstamt = header.Amount * (Decimal)Util.DefaultSystemSetting.GSTRate/100;
            //    header.GSTAmt = gstamt;
            //} 

            if (Util.Member != null) header.UserID = Util.Member.MemberID;
            header.PONo = txtPoNo.Text;
            header.PODate = DateTime.Parse(txtDate.Text);
            header.Contact = txtName.Text;
            header.Tel = txtTel.Text;
            header.HP = txtHp.Text;
            header.Fax = txtFax.Text;
            header.Email = txtEmail.Text;
            header.Company = txtComp.Text;
            header.Dept = txtDept.Text;
            header.Address1 = txtAddress.Text.Replace("\n", "<br />");
            header.Remarks = txtRemarks.Text.Replace("\n", "<br />");

            header.DeliveryDate = txtDelDate.Text;
            header.EatingTime = txtEatTime.Text;
            header.CollectionTime = txtColTime.Text;
            header.Address2 = txtFuncVenue.Text.Replace("\n", "<br />");
            header.NoOfPax = txtNoOfPax.Text;
            header.MenuPrice = txtMenuPrice.Text;
            header.PaymentTerm = rblPaymentTerm.SelectedItem.Value;
            header.OrderBy = txtconfirmby.Text;
            header.Status = "PO";
            header.Charge1 = txtCharges1.Text;
            header.Charge2 = txtCharges2.Text;
            header.Charge3 = txtCharges3.Text;
            header.Charge4 = txtCharges4.Text;
            header.Charge5 = txtCharges5.Text;

			OrderProxy orderProxy = new OrderProxy();
			bool result = true;
			try 
			{
				result = orderProxy.CreateOrder(header,cart);
			} 
			finally 
			{
				orderProxy = null;
			}

			if (result)
			{	

				try
				{
					string ItemDetail="<Table width='80%' cellpadding='4' cellspacing='1' style='border:1px solid grey;'>";
					ItemDetail += "<tr><td bgcolor='#aaaaaa'><font face='arial' size='-1'><b>Product</b></font></td>";
					ItemDetail += "<td bgcolor='#aaaaaa'><font face='arial' size='-1'><b>Quantity</b></font></td>";
					if (Util.DefaultSystemSetting.Flag_UOM ) ItemDetail += "<td bgcolor='#aaaaaa'><font face='arial' size='-1'><b>UOM</b></font></td>";
					ItemDetail += "<td bgcolor='#aaaaaa'><font face='arial' size='-1'><b>Price</b></font></td></tr>";
								
					UOMProxy up = Util.UOMProxy;
				
					for(int i=0;i < dgCart.Items.Count; i++)
					{													
						ItemDetail += "<tr><td bgcolor='#eeeeee'><font face='arial' size='-1'>"+ dgCart.Items[i].Cells[0].Text +"</font></td>\n";
						ItemDetail += "<td bgcolor='#eeeeee'><font face='arial' size='-1'>"+ dgCart.Items[i].Cells[1].Text +"</font></td>\n";
						if (Util.DefaultSystemSetting.Flag_UOM)
						{
							UOM uom = (UOM)up.FindByID(Convert.ToInt32(dgCart.Items[i].Cells[2].Text));
							ItemDetail += "<td bgcolor='#eeeeee' width=5% align=center><font face='arial' size='-1'>"+uom.Unit+"</font></td>\n";
						}
						ItemDetail += "<td bgcolor='#eeeeee'><font face='arial' size='-1'>"+ dgCart.Items[i].Cells[3].Text +"</font></td></tr>\n";
					}
					ItemDetail += "<td bgcolor='#aaaacc' colspan='4' align=right><font face='arial' size='-1'><b>Total Amount: "+ lbTotal.Text +"</b></font></td></tr>\n";
					ItemDetail += "</Table>";

					Hashtable prop = new Hashtable();
                    prop.Add("Date", DateTime.Today.ToString("dd/MM/yyyy"));
                    prop.Add("Name", txtName.Text);
                    prop.Add("Tel", txtTel.Text);
                    prop.Add("Hp", txtHp.Text);
                    prop.Add("Fax", txtFax.Text);
                    prop.Add("Email", txtEmail.Text);
                    prop.Add("Comp", txtComp.Text);
                    prop.Add("Dept", txtDept.Text);
                    prop.Add("Address", txtAddress.Text.Replace("\n", "<br />"));
                    prop.Add("Remarks", txtRemarks.Text.Replace("\n", "<br />"));

                    prop.Add("DelDate", txtDelDate.Text);
                    prop.Add("EatTime", txtEatTime.Text);
                    prop.Add("ColTime", txtColTime.Text);
                    prop.Add("FuncVenue", txtFuncVenue.Text.Replace("\n", "<br />"));
                    prop.Add("NoOfPax", txtNoOfPax.Text);
                    prop.Add("MenuPrice", txtMenuPrice.Text);
                    prop.Add("PayTerm", rblPaymentTerm.SelectedItem.Value);
                    prop.Add("confirmby", txtconfirmby.Text);

                    prop.Add("Charges1", txtCharges1.Text);
                    prop.Add("Charges2", txtCharges2.Text);
                    prop.Add("Charges3", txtCharges3.Text);
                    prop.Add("Charges4", txtCharges4.Text);
                    prop.Add("Charges5", txtCharges5.Text);  

					prop.Add("OrderDetail",ItemDetail);
					
					prop.Add("URL","<a href=http://" + Util.DefaultSystemSetting.Domain + " >http://" + Util.DefaultSystemSetting.Domain + "</a>");
					EmailObject emailObj = Util.EmailObject;
					emailObj.SendNotification("NewPO",txtEmail.Text,Util.DefaultSystemSetting.Email,"","Send PO",prop,MailFormat.Html);
					Util.TmpString = "Your PO has been sent to us. We will reply to you asap. Thank you.";
				} 
				catch (Exception ex)
				{
					Util.TmpString = ex.Message;
				}
				finally
				{
					if (Request.QueryString["RFQID"]==null || Request.QueryString["RFQID"]=="")
					{
						ShoppingCartProxy scp = Util.ShoppingCartProxy;
						scp.DelCart(Util.GetShoppingCartId);
					}
				}
				Response.Redirect("~/general/status.aspx");
			}
			else
			{
				lbStatus.Text = "Error with your email address:<br />" + CommonV2.SmtpCheck.result;
			}
		}
	}

	protected void Button1_Click(object sender, System.EventArgs e)
	{
		Response.Redirect("~/cart/pocart.aspx");
	}
}