public FirstLoginClienteForm(DataRow row, MainForm m, int userId, int perd)
{
InitializeComponent();
this.main = m;
this.pd = perd;
if (row == null)
{
DataTable dt = new DataTable();
dt.Columns.Add();
dt.Columns.Add();
dt.Columns.Add();
dt.Columns.Add();
dt.Columns.Add();
dt.Columns.Add();
dt.Columns.Add();
dt.Columns.Add();
row = dt.NewRow();
insertar = true;
}
else
{
this.Dni = Int32.Parse(row["Dni"].ToString());
} this.model = new AbmCliente.ModifClienteApp(row);
List <string> citys = this.model.getCitys();
List <string> checkedCitys = this.model.getCheckedCitys(this.Dni);
this.userId = userId;
//Bindeos...
this.txtName.Text = this.model.Nombre;
this.txtSurname.Text = this.model.Apellido;
this.txtDni.Text = this.model.Dni;
this.txtEmail.Text = this.model.Mail;
this.txtPhone.Text = this.model.Phone;
this.txtAddress.Text = this.model.Address;
this.txtPostalCode.Text = this.model.PostalCode;
if (this.model.FechaNac != null && this.model.FechaNac != "")
{
this.dtpBirhtday.Value = DateTime.Parse(this.model.FechaNac);
}
this.prevDni = this.txtDni.Text;
this.prevPhone = this.txtPhone.Text;
for (int i = 0; i < citys.Count; i++)
{
int index = this.chkBoxListPreferences.Items.Add(citys[i]);
if (checkedCitys.Any(city => city == citys[i]))
{
this.chkBoxListPreferences.SetItemChecked(index, true);
}
}
//StringBuilder sentece = new StringBuilder();
//sentece.AppendFormat("SELECT C.UserId FROM TRANSA_SQL.Customer C WHERE C.PhoneNumber={0}", this.txtPhone.Text);
//this.userId = (int)Conexion.Instance.ejecutarQuery(sentece.ToString()).Rows[0][0];
//StringBuilder sentece2 = new StringBuilder();
//sentece2.AppendFormat("SELECT CU.Enabled, CU.Deleted FROM TRANSA_SQL.CuponeteUser CU WHERE CU.UserId={0}", this.userId);
//DataRow rowUser = Conexion.Instance.ejecutarQuery(sentece2.ToString()).Rows[0];
}
public FirstLoginClienteForm(DataRow row,MainForm m,int userId)
{
InitializeComponent();
this.main = m;
this.Dni = Int32.Parse(row["Dni"].ToString());
this.model = new AbmCliente.ModifClienteApp(row);
List<string> citys = this.model.getCitys();
List<string> checkedCitys = this.model.getCheckedCitys(this.Dni);
this.userId = userId;
//Bindeos...
this.txtName.Text = this.model.Nombre;
this.txtSurname.Text = this.model.Apellido;
this.txtDni.Text = this.model.Dni;
this.txtEmail.Text = this.model.Mail;
this.txtPhone.Text = this.model.Phone;
this.txtAddress.Text = this.model.Address;
this.txtPostalCode.Text = this.model.PostalCode;
this.dtpBirhtday.Value = DateTime.Parse(this.model.FechaNac);
this.prevDni = this.txtDni.Text;
this.prevPhone = this.txtPhone.Text;
for (int i = 0; i < citys.Count; i++)
{
int index = this.chkBoxListPreferences.Items.Add(citys[i]);
if (checkedCitys.Any(city => city == citys[i]))
{
this.chkBoxListPreferences.SetItemChecked(index, true);
}
}
//StringBuilder sentece = new StringBuilder();
//sentece.AppendFormat("SELECT C.UserId FROM TRANSA_SQL.Customer C WHERE C.PhoneNumber={0}", this.txtPhone.Text);
//this.userId = (int)Conexion.Instance.ejecutarQuery(sentece.ToString()).Rows[0][0];
//StringBuilder sentece2 = new StringBuilder();
//sentece2.AppendFormat("SELECT CU.Enabled, CU.Deleted FROM TRANSA_SQL.CuponeteUser CU WHERE CU.UserId={0}", this.userId);
//DataRow rowUser = Conexion.Instance.ejecutarQuery(sentece2.ToString()).Rows[0];
}
