protected void btnDelete_Click(object sender, DirectEventArgs e)
{
using (TodoDBEntities context = new TodoDBEntities())
{
int idPos = int.Parse(this.cmbListTodo.SelectedValue);
todo miTodo = context.todos.Single(u => u.idTodo == idPos);
context.todos.DeleteObject(miTodo);
try
{
context.SaveChanges();
}
catch (Exception error)
{
X.Msg.Show(new MessageBoxConfig
{
Title = "Error...",
Message = error.Message,
Buttons = MessageBox.Button.OK,
Icon = MessageBox.Icon.ERROR
});
return;
}
X.Msg.Show(new MessageBoxConfig
{
Title = "TO-DO Updated!",
Message = "Your TO-DO has been deleted",
Buttons = MessageBox.Button.OK,
Icon = MessageBox.Icon.INFO
});
}
Response.Redirect(Request.RawUrl);
}
protected void btnSubmitRegister_Click(object sender, DirectEventArgs e)
{
if (!this.txtRegisterPassword.Value.Equals(this.txtRegisterRepeat.Value))
{
X.Msg.Show(new MessageBoxConfig
{
Title = "Invalid Information",
Message = "Password doesn't match",
Buttons = MessageBox.Button.OK,
Icon = MessageBox.Icon.ERROR
});
}
else
{
using (TodoDBEntities context = new TodoDBEntities())
{
usuario newUsuario = new usuario
{
email = txtRegisterEmail.Value.ToString(),
password = FormsAuthentication.HashPasswordForStoringInConfigFile(txtRegisterPassword.Value.ToString(), "SHA1"),
};
context.usuarios.AddObject(newUsuario);
try
{
context.SaveChanges();
}catch(Exception error){
X.Msg.Show(new MessageBoxConfig
{
Title = "Duplicated Email!",
Message = "The Email already exist!",
Buttons = MessageBox.Button.OK,
Icon = MessageBox.Icon.ERROR
});
return;
}
}
X.Msg.Show(new MessageBoxConfig
{
Title = "Welcome!",
Message = "You have been registed successfully",
Buttons = MessageBox.Button.OK,
Icon = MessageBox.Icon.INFO
});
windowRegister.Hidden = true;
}
}
protected void cmbListTodo_SelectedIndexChanged(object sender, EventArgs e)
{
System.Diagnostics.Debug.WriteLine("Si entro cabrones");
using (TodoDBEntities context = new TodoDBEntities())
{
int idPos = int.Parse(this.cmbListTodo.SelectedValue);
var miusuario = (from u in context.todos
where u.userOwner == User.Identity.Name && u.idTodo == idPos
select u);
todo temp = miusuario.First();
this.txtName.SetValue(temp.nombre);
this.txtDescription.SetValue(temp.descripcion);
string fechaIn = temp.fechaI.ToShortDateString();
string[] fechaIns = fechaIn.Split('/');
string fechaEn = temp.fechaF.ToShortDateString();
string[] fechaEns = fechaEn.Split('/');
this.txtFechaInicio.Text = fechaIns[1] + "/" + fechaIns[0] + "/" + fechaIns[2];
this.txtFechaFinal.Text = fechaEns[1] + "/" + fechaEns[0] + "/" + fechaEns[2];
string c = temp.status;
this.cmbStatusReal.SelectedIndex = (c.Equals("O") ? 0 : c.Equals("C") ? 1 : 2);
}
}
private bool ValidateUser(string userName, string passWord)
{
using (TodoDBEntities context = new TodoDBEntities())
{
string codusuario = this.txtUserName.Value.ToString();
/*var query=from w in context.wifispots
where w.owner==codusuario
select w;
*/
//otra forma
//bool band=context.usuarios.Any(u=>u.usuario1==userName && u.clave==password);
var miusuario = (from u in context.usuarios
where u.email == codusuario
select u);
string pass = FormsAuthentication.HashPasswordForStoringInConfigFile(this.txtPassword.Value.ToString(),"SHA1");
if (miusuario.Count() == 0)
return false;
if (pass.Equals(miusuario.First().password))
{
return true;
}
else
{
return false;
}
}
/*if (userName == "pedro" && passWord == "nolose")
{
return true;
}
else
{
return false;
}*/
}
protected void Page_Load(object sender, EventArgs e)
{
this.txtFechaFinal.Enabled = false;
this.txtFechaInicio.Enabled = false;
this.txtName.Disabled = true;
this.txtDescription.Disabled = true;
this.cmbStatusReal.Enabled = false;
if(!IsPostBack){
this.lblEmail.Text = User.Identity.Name;
using (TodoDBEntities context = new TodoDBEntities())
{
var miusuario = (from u in context.todos
where u.userOwner == User.Identity.Name
select u);
if (miusuario.Count() == 0)
{
this.cmbListTodo.Visible = false;
this.lblSelectTitle.Text = "You don't have any To-Do.";
this.btnRefresh.Disabled = true;
}
else
{
if (Session["range"] != null)
{
if ((bool)Session["range"] == true)
{
this.chFilter.Checked = true;
this.txtStart.Text = Session["fechaI"].ToString();
this.txtFinish.Text = Session["fechaF"].ToString();
}
}
foreach (todo u in miusuario)
{
if (Session["range"] == null || (bool)Session["range"]==false)
{
System.Web.UI.WebControls.ListItem item = new System.Web.UI.WebControls.ListItem(u.nombre,
u.idTodo.ToString());
this.cmbListTodo.Items.Add(item);
}
else
{
if(validateFechas(u.fechaF)){
System.Web.UI.WebControls.ListItem item = new System.Web.UI.WebControls.ListItem(u.nombre,
u.idTodo.ToString());
this.cmbListTodo.Items.Add(item);
}
}
}
if (cmbListTodo.Items.Count == 0)
{
this.lblSelectTitle.Text = "There isn't any To-Do in that Date Range";
this.cmbListTodo.Visible = false;
}
else
{
this.cmbListTodo.SelectedIndex = 0;
this.cmbListTodo_SelectedIndexChanged(this, null);
}
}
}
}
}
protected void btnAddTodo_Click(object sender, DirectEventArgs e)
{
if (this.txtFechaInicio.Text.Equals("") ||
this.txtFechaFinal.Text.Equals(""))
{
X.Msg.Show(new MessageBoxConfig
{
Title = "Information Required",
Message = "You have to complete Date Fields",
Buttons = MessageBox.Button.OK,
Icon = MessageBox.Icon.ERROR
});
}
else
{
using (TodoDBEntities context = new TodoDBEntities())
{
int idPos = int.Parse(this.cmbListTodo.SelectedValue);
todo miTodo = context.todos.Single(u => u.idTodo==idPos);
string fechaIn=txtFechaInicio.Text;
string fechaEn=txtFechaFinal.Text;
string []fechaIns=fechaIn.Split('/');
string []fechaEns=fechaEn.Split('/');
int index=this.cmbStatusReal.SelectedIndex;
string val=(index==0?"O":index==1?"C":"D");
miTodo.nombre = txtName.Value.ToString();
miTodo.descripcion = txtDescription.Value.ToString();
miTodo.fechaI=new DateTime(int.Parse(fechaIns[2]),
int.Parse(fechaIns[0]),
int.Parse(fechaIns[1]));
miTodo.fechaF=new DateTime(int.Parse(fechaEns[2]),
int.Parse(fechaEns[0]),
int.Parse(fechaEns[1]));
miTodo.status=val;
try
{
context.SaveChanges();
}
catch (Exception error)
{
X.Msg.Show(new MessageBoxConfig
{
Title = "Error...",
Message = error.Message,
Buttons = MessageBox.Button.OK,
Icon = MessageBox.Icon.ERROR
});
return;
}
}
X.Msg.Show(new MessageBoxConfig
{
Title = "TO-DO Updated!",
Message = "Your TO-DO has been updated",
Buttons = MessageBox.Button.OK,
Icon = MessageBox.Icon.INFO
});
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
System.Diagnostics.Debug.WriteLine("SI ENTRO PUES");
this.lblEmail.Text = User.Identity.Name;
using (TodoDBEntities context = new TodoDBEntities())
{
var miusuario = (from u in context.todos
where u.userOwner == User.Identity.Name
select u);
if (miusuario.Count() == 0)
{
this.btnAddTodo.Disabled=true;
this.btnDelete.Disabled = true;
this.cmbListTodo.Visible = false;
this.lblSelectTitle.Text = "You don't have any To-Do.";
}
else
{
foreach (todo u in miusuario)
{
System.Web.UI.WebControls.ListItem item = new System.Web.UI.WebControls.ListItem(u.nombre,
u.idTodo.ToString());
this.cmbListTodo.Items.Add(item);
}
this.cmbListTodo.SelectedIndex = 0;
this.cmbListTodo_SelectedIndexChanged(this, null);
}
}
}
}
protected void btnAddTodo_Click(object sender, DirectEventArgs e)
{
if (this.txtFechaInicio.Text.Equals("") ||
this.txtFechaFinal.Text.Equals(""))
{
X.Msg.Show(new MessageBoxConfig
{
Title = "Information Required",
Message = "You have to complete Date Fields",
Buttons = MessageBox.Button.OK,
Icon = MessageBox.Icon.ERROR
});
}
else
{
using (TodoDBEntities context = new TodoDBEntities())
{
string fechaIn=txtFechaInicio.Text;
string fechaEn=txtFechaFinal.Text;
string []fechaIns=fechaIn.Split('/');
string []fechaEns=fechaEn.Split('/');
int index=this.cmbStatusReal.SelectedIndex;
string val=(index==0?"O":index==1?"C":"D");
todo newTodo=new todo{
nombre=txtName.Value.ToString(),
descripcion=txtDescription.Value.ToString(),
fechaI=new DateTime(int.Parse(fechaIns[2]),
int.Parse(fechaIns[0]),
int.Parse(fechaIns[1])),
fechaF=new DateTime(int.Parse(fechaEns[2]),
int.Parse(fechaEns[0]),
int.Parse(fechaEns[1])),
status=val,
userOwner=User.Identity.Name
};
context.todos.AddObject(newTodo);
try
{
context.SaveChanges();
}
catch (Exception error)
{
X.Msg.Show(new MessageBoxConfig
{
Title = "Error...",
Message = error.Message,
Buttons = MessageBox.Button.OK,
Icon = MessageBox.Icon.ERROR
});
return;
}
}
X.Msg.Show(new MessageBoxConfig
{
Title = "TO-DO Added!",
Message = "Your new TO-DO has been added",
Buttons = MessageBox.Button.OK,
Icon = MessageBox.Icon.INFO
});
resetInformation();
}
}