public void AddBillingCustomerDetails(tbl_CustomerBillingAddress objCustomerBillingAddress)
 {
     try
     {
         objSKSEntities = new SKSEntities();
         objSKSEntities.tbl_CustomerBillingAddress.Add(objCustomerBillingAddress);
         objSKSEntities.SaveChanges();
     }
     catch (Exception ex)
     {
         throw ex;
     }
     finally
     {
         objSKSEntities = null;
     }
 }
    protected void btnAddItemInInvoice_Click(object sender, EventArgs e)
    {
        try
        {
            if (Page.IsValid)
            {
                objBusinessFacadLayer = new BusinessFacadLayer();

                if (Convert.ToInt32(ddlSearchBillingCustomer.SelectedItem.Value.ToString()) == 0 && hdnIsNewBillingCustomer.Value == "Yes")
                {
                    objCustomerBillingAddress = new tbl_CustomerBillingAddress();
                    objCustomerBillingAddress.CustomerName          = txtCustomerName.Text.Trim();
                    objCustomerBillingAddress.BillingProprietorName = txtProprietorName.Text.Trim();
                    objCustomerBillingAddress.BillingAddress1       = txtAddressLine1.Text.Trim();
                    objCustomerBillingAddress.BillingAddress2       = txtAddressLine2.Text.Trim();
                    objCustomerBillingAddress.BillingCity           = txtCity.Text.Trim();
                    objCustomerBillingAddress.FK_StateID            = Convert.ToInt32(ddlState.SelectedItem.Value.ToString());
                    objCustomerBillingAddress.Billingpin            = txtPin.Text.Trim();
                    objCustomerBillingAddress.BillingPhone          = txtPhoneNo.Text.Trim();
                    objCustomerBillingAddress.BillingEmail          = txtEmail.Text.Trim();
                    objCustomerBillingAddress.BillingAadharNo       = txtAadharNo.Text.Trim();
                    objCustomerBillingAddress.BillingGSTINNo        = txtGSTINNo.Text.Trim();
                    objCustomerBillingAddress.GUID      = hdnGUID.Value.ToString();
                    objCustomerBillingAddress.IsActive  = true;
                    objCustomerBillingAddress.IsDeleted = false;
                    objCustomerBillingAddress.CreatedBy = "Admin";
                    objCustomerBillingAddress.CreatedOn = Convert.ToDateTime(DateTime.Now.ToString());

                    objBusinessFacadLayer.AddBillingCustomerDetails(objCustomerBillingAddress);
                    hdnIsNewBillingCustomer.Value = Convert.ToString(objCustomerBillingAddress.Id);
                }
                if (Convert.ToInt32(ddlSearchShippingCustomer.SelectedItem.Value.ToString()) == 0 && hdnIsNewShippingCustomer.Value == "Yes")
                {
                    objCustomerShippingAddress = new tbl_CustomerShippingAddress();
                    objCustomerShippingAddress.CustomerName           = txtShippingCustomerName.Text.Trim();
                    objCustomerShippingAddress.ShippingProprietorName = txtShippingProprietorName.Text.Trim();
                    objCustomerShippingAddress.ShippingAddress1       = txtShippingAddressLine1.Text.Trim();
                    objCustomerShippingAddress.ShippingAddress2       = txtShippingAddressLine2.Text.Trim();
                    objCustomerShippingAddress.ShippingCity           = txtShippingCity.Text.Trim();
                    objCustomerShippingAddress.FK_StateID             = Convert.ToInt32(ddlShippingState.SelectedItem.Value.ToString());
                    objCustomerShippingAddress.Shippingpin            = txtShippingPin.Text.Trim();
                    objCustomerShippingAddress.ShippingPhone          = txtShippingPhoneNo.Text.Trim();
                    objCustomerShippingAddress.ShippingEmail          = txtShippingEmail.Text.Trim();
                    objCustomerShippingAddress.ShippingAadharNo       = txtShippingAadharNo.Text.Trim();
                    objCustomerShippingAddress.ShippingGSTINNo        = txtShippingGSTINNo.Text.Trim();
                    objCustomerShippingAddress.GUID      = hdnGUID.Value.ToString();
                    objCustomerShippingAddress.IsActive  = true;
                    objCustomerShippingAddress.IsDeleted = false;
                    objCustomerShippingAddress.CreatedBy = "Admin";
                    objCustomerShippingAddress.CreatedOn = Convert.ToDateTime(DateTime.Now.ToString());

                    objBusinessFacadLayer.AddShippingCustomerDetails(objCustomerShippingAddress);
                    hdnIsNewShippingCustomer.Value = Convert.ToString(objCustomerShippingAddress.Id);
                }

                mvwTaxInvoiceBill.SetActiveView(vwTaxInvoiceBillGeneration);

                #region Setting Billing Address
                lblBillingNameGSTIN.Text    = txtCustomerName.Text + "  [ <b>GSTIN No - " + txtGSTINNo.Text + "</b> ]";
                lblBillingAddress.Text      = txtAddressLine1.Text + ", " + txtAddressLine2.Text;
                lblBillingCityStatePin.Text = txtCity.Text + ", " + ddlState.SelectedItem.Text.ToString() + ", " + txtPin.Text;
                lblBillingContact.Text      = txtPhoneNo.Text + ", " + txtEmail.Text;
                #endregion

                #region Setting Shipping Address
                lblShippingNameGSTIN.Text    = txtShippingCustomerName.Text + "  [ <b>GSTIN No - " + txtShippingGSTINNo.Text + "</b> ]";
                lblShippingAddress.Text      = txtShippingAddressLine1.Text + ", " + txtShippingAddressLine2.Text;
                lblShippingCityStatePin.Text = txtShippingCity.Text + ", " + ddlShippingState.SelectedItem.Text.ToString() + ", " + txtShippingPin.Text;
                lblShippingContact.Text      = txtShippingPhoneNo.Text + ", " + txtShippingEmail.Text;
                #endregion

                Fill_BillDetailsGrid(hdnGUID.Value.ToString());

                txtDatenTimeofSupply.Text     = Convert.ToString(DateTime.Now.ToString());
                txtDatenTimeofSupply.ReadOnly = true;
            }
        }
        catch (Exception ex)
        {
            throw ex;
        }
        finally
        {
            objCustomerBillingAddress  = null;
            objCustomerShippingAddress = null;
            objBusinessFacadLayer      = null;
        }
    }