ViewCompany.aspx.cs :  » CRM-ERP » Tustena-CRM » Digita » Tustena » C# / CSharp Open Source

/// <license>TUSTENA PUBLIC LICENSE v1.0</license>
/// <copyright>
/// Portions Copyright (c) 2003-2006 Digita S.r.l. All Rights Reserved.
///
/// Tustena CRM is a trademark of:
/// Digita S.r.l.
/// Viale Enrico Fermi 14/z
/// 31011 Asolo (Italy)
/// Tel. +39-0423-951251
/// Mail. info@digita.it
///
/// This file contains Original Code and/or Modifications of Original Code
/// as defined in and that are subject to the Tustena Public Source License
/// Version 1.0 (the 'License'). You may not use this file except in
/// compliance with the License. Please obtain a copy of the License at
/// http://www.tustena.com/TPL/ and read it before using this
// file.
///
/// The Original Code and all software distributed under the License are
/// distributed on an 'AS IS' basis, WITHOUT WARRANTY OF ANY KIND, EITHER
/// EXPRESS OR IMPLIED, AND DIGITA S.R.L. HEREBY DISCLAIMS ALL SUCH WARRANTIES,
/// INCLUDING WITHOUT LIMITATION, ANY WARRANTIES OF MERCHANTABILITY,
/// FITNESS FOR A PARTICULAR PURPOSE, QUIET ENJOYMENT OR NON-INFRINGEMENT.
/// Please see the License for the specific language governing rights and
/// limitations under the License.
///
/// YOU MAY NOT REMOVE OR ALTER THIS COPYRIGHT NOTICE!
/// </copyright>

using System;
using System.Data;
using System.Text.RegularExpressions;
using System.Web.UI;
using System.Web.UI.WebControls;
using Digita.Tustena.Database;

namespace Digita.Tustena{
  public partial class ViewCompany : G
  {

    protected void Page_Load(object sender, EventArgs e)
    {
      if (!Login())
      {
        ClientScript.RegisterStartupScript(this.GetType(), "", "<script>opener.location.href=opener.location.href;self.close();</script>");
      }
      else

      {
                if (!Page.IsPostBack)
                {
                    litID.Text = Request.Params["id"].ToString();
                    edittable.Visible = false;
                    FillRepeater();
                }
      }
    }

        private void FillRepeater()
        {
            Repeater1.DataSource = DatabaseConnection.SecureCreateDataset("SELECT * FROM BASE_COMPANIES WHERE ID=@ID AND (" + GroupsSecure() + ")", new DbSqlParameter("@ID", litID.Text));
            Repeater1.DataBind();
        }

    #region Codice generato da Progettazione Web Form

    protected override void OnInit(EventArgs e)
    {
      InitializeComponent();
      base.OnInit(e);
    }

    private void InitializeComponent()
    {
            this.modSave.Click += new EventHandler(modSave_Click);
      this.Repeater1.ItemDataBound += new RepeaterItemEventHandler(Repeater1_ItemDataBound);
            this.Repeater1.ItemCommand+=new RepeaterCommandEventHandler(Repeater1_ItemCommand);
    }

    #endregion

        public void Repeater1_ItemCommand(object source, RepeaterCommandEventArgs e)
        {
            modEdit();
        }

        private void modEdit()
        {
            DataRow dr = DatabaseConnection.SecureCreateDataset("SELECT COMPANYNAME, INVOICINGADDRESS, INVOICINGCITY, INVOICINGSTATEPROVINCE, INVOICINGZIPCODE, PHONE, FAX, EMAIL, WEBSITE FROM BASE_COMPANIES WHERE ID=@ID", new DbSqlParameter("@ID", litID.Text)).Tables[0].Rows[0];
            txtCompanyName.Text = dr[0].ToString();
            txtInvoicingAddress.Text = dr[1].ToString();
            txtInvoicingCity.Text = dr[2].ToString();
            txtInvoicingStateProvince.Text = dr[3].ToString();
            txtInvoicingZipCode.Text = dr[4].ToString();
            txtPhone.Text = dr[5].ToString();
            txtFAX.Text = dr[6].ToString();
            txtEmail.Text = dr[7].ToString();
            txtWebSite.Text = dr[8].ToString();
            Repeater1.Visible = false;
            edittable.Visible = true;
        }

        void modSave_Click(object sender, EventArgs e)
        {
            using (DigiDapter dg = new DigiDapter())
            {
                dg.Add("COMPANYNAME",txtCompanyName.Text);
                dg.Add("INVOICINGADDRESS",txtInvoicingAddress.Text);
                dg.Add("INVOICINGCITY",txtInvoicingCity.Text);
                dg.Add("INVOICINGSTATEPROVINCE",txtInvoicingStateProvince.Text);
                dg.Add("INVOICINGZIPCODE",txtInvoicingZipCode.Text);
                dg.Add("PHONE",txtPhone.Text);
                dg.Add("FAX",txtFAX.Text);
                dg.Add("EMAIL",txtEmail.Text);
                dg.Add("WEBSITE",txtWebSite.Text);
                dg.Execute("BASE_COMPANIES","ID="+litID.Text);
            }

            FillRepeater();
            Repeater1.Visible = true;
            edittable.Visible = false;
        }

    private void Repeater1_ItemDataBound(object sender, RepeaterItemEventArgs e)
    {
      switch (e.Item.ItemType)
      {
        case ListItemType.Item:
        case ListItemType.AlternatingItem:
          Literal VoipCall = (Literal) e.Item.FindControl("VoipCall");
          if ((DataBinder.Eval((DataRowView) e.Item.DataItem, "Phone")).ToString().Length > 0)
          {
            string ph = Regex.Replace((string) DataBinder.Eval((DataRowView) e.Item.DataItem, "Phone"), @"[^0-9]", "");
            VoipCall.Text = MakeVoipString(ph);
          }
          break;
      }
    }
  }
}