ViewLead.aspx.cs :  » CRM-ERP » Tustena-CRM » Digita » Tustena » Common » 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.Common{
  public partial class ViewLead : 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
      {
                litID.Text = Request.Params["id"].ToString();
                edittable.Visible = false;
                FillRepeater();
      }
    }

        private void FillRepeater()
        {
            Repeater1.DataSource = DatabaseConnection.SecureCreateDataset("SELECT * FROM CRM_LEADS WHERE ID=@ID AND (" + GroupsSecure("GROUPS") + " OR OWNERID=" + UC.UserId + ")", 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.Load += new EventHandler(this.Page_Load);
      this.Repeater1.ItemDataBound += new RepeaterItemEventHandler(Repeater1_ItemDataBound);
            this.Repeater1.ItemCommand += new RepeaterCommandEventHandler(Repeater1_ItemCommand);
            this.modSave.Click += new EventHandler(modSave_Click);
    }



    #endregion

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

        private void modEdit()
        {
            DataRow dr = DatabaseConnection.SecureCreateDataset("SELECT NAME,SURNAME,COMPANYNAME,ADDRESS,CITY,PROVINCE,ZIPCODE,PHONE,MOBILEPHONE,FAX,EMAIL FROM CRM_LEADS WHERE ID=@ID", new DbSqlParameter("@ID", litID.Text)).Tables[0].Rows[0];

            txtName.Text = dr[0].ToString();
            txtSurname.Text = dr[1].ToString();
            txtCompanyName.Text = dr[2].ToString();
            txtAddress.Text = dr[3].ToString();
            txtCity.Text = dr[4].ToString();
            txtProvince.Text = dr[5].ToString();
            txtZipCode.Text = dr[6].ToString();
            txtPHONE.Text = dr[7].ToString();
            txtMobilePhone.Text = dr[8].ToString();
            txtFax.Text = dr[9].ToString();
            txtEmail.Text = dr[10].ToString();

            Repeater1.Visible = false;
            edittable.Visible = true;
        }


        void modSave_Click(object sender, EventArgs e)
        {
            using (DigiDapter dg = new DigiDapter())
            {
                dg.Add("NAME", txtName.Text);
                dg.Add("SURNAME", txtSurname.Text);
                dg.Add("COMPANYNAME", txtCompanyName.Text);
                dg.Add("ADDRESS", txtAddress.Text);
                dg.Add("CITY", txtCity.Text);
                dg.Add("PROVINCE", txtProvince.Text);
                dg.Add("ZIPCODE", txtZipCode.Text);
                dg.Add("PHONE", txtPHONE.Text);
                dg.Add("MOBILEPHONE", txtMobilePhone.Text);
                dg.Add("FAX", txtFax.Text);
                dg.Add("EMAIL", txtEmail.Text);


                dg.Execute("CRM_LEADS", "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 VoipCallPhone = (Literal) e.Item.FindControl("VoipCallPhone");
          Literal VoipCallMobilePhone = (Literal) e.Item.FindControl("VoipCallMobilePhone");

          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]", "");
            VoipCallPhone.Text = MakeVoipString(ph);
          }

          if ((DataBinder.Eval((DataRowView) e.Item.DataItem, "MobilePhone")).ToString().Length > 0)
          {
            string ph = Regex.Replace((string) DataBinder.Eval((DataRowView) e.Item.DataItem, "MobilePhone"), @"[^0-9]", "");
            VoipCallMobilePhone.Text = MakeVoipString(ph);
          }
          break;
      }
    }
  }
}