protected void AddBranch(object sender, EventArgs e)
{
Page.ClientScript.RegisterStartupScript(GetType(), "id", "toggle_forms('foo')", true);
if (Page.IsValid)
{
DBHandler.DBHandler db = new DBHandler.DBHandler(con);
Entities.Campus c1 = new Entities.Campus()
{
campusName = CampusName.Value,
address = address.Value,
zipCode = Convert.ToInt32(ZipCode.Value.ToString()),
phone1 = Phone1.Value,
phone2 = Phone2.Value,
phone3 = Phone3.Value,
principal = PrincipalName.Value,
email = CEmail.Value,
isActive = CCheck.Checked,
};
Entities.ZipCodes z1 = new Entities.ZipCodes()
{
zipCode = Convert.ToInt32(ZipCode.Value.ToString()),
cityName = CityName.Value,
};
db.InsertBranch(c1, z1);
Clabel.Text = "Campus Added Successfully";
}
}
protected void AddBranch(object sender, EventArgs e)
{
Page.ClientScript.RegisterStartupScript(GetType(), "id", "toggle_forms('foo')", true);
if (Page.IsValid)
{
DBHandler.DBHandler db = new DBHandler.DBHandler(con);
Entities.Campus c1 = new Entities.Campus()
{
campusName = CampusName.Value,
address = address.Value,
zipCode = Convert.ToInt32(ZipCode.Value.ToString()),
phone1 = Phone1.Value,
phone2 = Phone2.Value,
phone3 = Phone3.Value,
principal = PrincipalName.Value,
email = CEmail.Value,
isActive = CCheck.Checked,
};
Entities.ZipCodes z1 = new Entities.ZipCodes()
{
zipCode = Convert.ToInt32(ZipCode.Value.ToString()),
cityName = CityName.Value,
};
db.InsertBranch(c1, z1);
Clabel.Text = "Campus Added Successfully";
}
}
public static string GetEntityForEdition(string id)
{
System.Web.Script.Serialization.JavaScriptSerializer js = new System.Web.Script.Serialization.JavaScriptSerializer();
Business.Campus bo = new Business.Campus();
Entities.Campus entity = new Entities.Campus();
entity.ID = Utils.IsNull(id, 0);
entity.SetFromDataSource(true);
bo.PrepareEntityForEdition(entity);
return(js.Serialize(entity));
}
public DataSet CheckUserType(Entities.tblSchoolId p1, Entities.Campus c1)
{
DataSet ds;
using (WSqlCommand dbCom = new WSqlCommand(dbconstring, "[dbo].[spSelectUserType]"))
{
dbCom.AddParameter("@ID", System.Data.SqlDbType.NVarChar, p1.schoolId);
dbCom.AddParameter("@campus", System.Data.SqlDbType.NVarChar, c1.campusName);
ds = new DataSet();
ds = dbCom.Execute();
}
return(ds);
}
public override int Delete(Entity entity, DataTransaction tran)
{
Entities.Campus item = entity as Entities.Campus;
DataEntities.SpCampusDel sp = new DataEntities.SpCampusDel();
sp.ClaCampus = item.ID;
if (tran != null)
{
return(sp.ExecuteNonQuery(tran));
}
else
{
return(sp.ExecuteNonQuery(this.ConnectionString));
}
}
public override void PrepareEntityForEdition(Entity entity)
{
Entities.Campus item = entity as Entities.Campus;
if (item != null && item.FromDataSource)
{
DataEntities.SpCampusSel sp = new DataEntities.SpCampusSel();
sp.ClaCiudad = item.ID;
DataTable dt = sp.GetDataTable(this.ConnectionString);
if (dt != null && dt.Rows.Count == 1)
{
item.ID = Utils.GetDataRowValue(dt.Rows[0], "ClaCampus", 0);
item.Nombre = Utils.GetDataRowValue(dt.Rows[0], "NomCampus", "");
}
}
}
public void InsertBranch(Entities.Campus c1, Entities.ZipCodes z1)
{
using (WSqlCommand s1 = new WSqlCommand(dbconstring, "[dbo].[spInsertBranch]"))
{
s1.AddParameter("@campusName", System.Data.SqlDbType.NVarChar, c1.campusName);
s1.AddParameter("@address", System.Data.SqlDbType.NVarChar, c1.address);
s1.AddParameter("@zipCode", System.Data.SqlDbType.Int, c1.zipCode);
s1.AddParameter("@phone1", System.Data.SqlDbType.NVarChar, c1.phone1);
s1.AddParameter("@phone2", System.Data.SqlDbType.NVarChar, c1.phone2);
s1.AddParameter("@phone3", System.Data.SqlDbType.NVarChar, c1.phone3);
s1.AddParameter("@principal", System.Data.SqlDbType.NVarChar, c1.principal);
s1.AddParameter("@cityName", System.Data.SqlDbType.NVarChar, z1.cityName);
s1.AddParameter("@email", System.Data.SqlDbType.NVarChar, c1.email);
s1.AddParameter("@isActive", System.Data.SqlDbType.Bit, c1.isActive);
s1.Execute();
}
}
public override int Update(Entity entity)
{
Entities.Campus item = entity as Entities.Campus;
DataEntities.SpCampusUpd sp = new DataEntities.SpCampusUpd();
sp.ClaCampus = item.ID;
sp.NomCampus = item.Nombre;
sp.Calle = item.Calle;
sp.Colonia = item.Colonia;
sp.CodigoPostal = item.CodigoPostal;
sp.ClaPais = item.Pais.ID;
sp.ClaEstado = item.Estado.ID;
sp.ClaCiudad = item.Ciudad.ID;
sp.Telefono = item.Telefono;
sp.DirectorGeneral = item.DirectorGeneral;
sp.DirectorAdministrativo = item.DirectorAdministrativo;
return(sp.ExecuteNonQuery(this.ConnectionString));
}
public static string PruebaCombo()
{
List <Entities.Campus> list = new List <Entities.Campus>();
for (int i = 1; i <= 10; i++)
{
Entities.Campus item = new Entities.Campus();
item.ID = i;
item.Nombre = string.Format("Campus {0}", 0);
item.Calle = string.Format("Calle {0}", 0);
item.Colonia = string.Format("Colonia {0}", 0);
item.Telefono = string.Format("Telefono {0}", 0);
list.Add(item);
}
System.Web.Script.Serialization.JavaScriptSerializer js = new System.Web.Script.Serialization.JavaScriptSerializer();
return(js.Serialize(list));
}
public static void Guardar(string action, string id, string nombre, string calle, string colonia, string telefono)
{
Entities.Campus item;
if (action.ToLower() == "add")
{
item = new Entities.Campus();
}
else
{
item = new Entities.Campus(true);
}
item.ID = Utils.IsNull(id, 0);
item.Nombre = nombre;
item.Calle = calle;
item.Colonia = colonia;
item.Telefono = telefono;
Business.Campus bo = new Business.Campus();
bo.Save(item);
}
public List <Entities.Campus> Combo()
{
List <Entities.Campus> list = new List <Entities.Campus>();
DataEntities.SpCiudadesSel sp = new DataEntities.SpCiudadesSel();
sp.ClaPais = -1;
sp.ClaEstado = -1;
sp.ClaCiudad = -1;
DataTable dt = sp.GetDataTable(this.ConnectionString);
foreach (DataRow dr in dt.Rows)
{
Entities.Campus item = new Entities.Campus(true);
item.ID = Utils.GetDataRowValue(dr, "ClaCampus", 0);
item.Nombre = Utils.GetDataRowValue(dr, "NomCampus", "");
this.SetWebEntityGridValues(item, dr);
list.Add(item);
}
return(list);
}
public List <Entities.Campus> ListarCampus(InglesIndividual.Entities.JQXGridSettings settings, string nomCampus, string calle, string colonia, string telefono, int claPais, int claEstado, int claCiudad)
{
List <Entities.Campus> list = new List <Entities.Campus>();
DataEntities.SpCampusGrd sp = new DataEntities.SpCampusGrd();
sp.NomCampus = nomCampus;
sp.Calle = calle;
sp.Colonia = colonia;
sp.Telefono = telefono;
sp.ClaCiudad = claCiudad;
sp.ClaEstado = claEstado;
sp.ClaPais = claPais;
this.ConfigurePagedStoredProcedure(sp, settings);
DataTable dt = sp.GetDataTable(this.ConnectionString);
foreach (DataRow dr in dt.Rows)
{
Entities.Campus item = new Entities.Campus(true);
item.ID = Utils.GetDataRowValue(dr, "ClaCampus", 0);
item.Nombre = Utils.GetDataRowValue(dr, "NomCampus", "");
item.Calle = Utils.GetDataRowValue(dr, "Calle", "");
item.Colonia = Utils.GetDataRowValue(dr, "Colonia", "");
item.Telefono = Utils.GetDataRowValue(dr, "Telefono", "");
item.Pais = new Entities.Pais();
item.Pais.ID = Utils.GetDataRowValue(dr, "ClaPais", 0);
item.Estado = new Entities.Estado();
item.ID = Utils.GetDataRowValue(dr, "ClaEstado", 0);
item.Ciudad = new Entities.Ciudad();
item.ID = Utils.GetDataRowValue(dr, "ClaCiudad", 0);
this.SetWebEntityGridValues(item, dr);
list.Add(item);
}
return(list);
}
public List <Exception> Eliminar(string[] ids)
{
List <Exception> list = new List <Exception>();
if (ids != null && ids.Length > 0)
{
foreach (string id in ids)
{
Entities.Campus item = new Entities.Campus(true);
item.ID = Utils.IsNull(id, 0);
try
{
this.Data.Delete(item);
}
catch (Exception ex)
{
list.Add(ex);
}
}
}
return(list);
}
protected void Loginc(object sender, EventArgs e)
{
user = username.Value;
data = user.Split('@')[0];
data2 = user.Split('@')[1];
DBHandler.DBHandler db = new DBHandler.DBHandler(con);
Entities.tblSchoolId t1 = new Entities.tblSchoolId()
{
schoolId = data,
};
Entities.Campus c1 = new Entities.Campus()
{
campusName = data2,
};
DataSet ds = new DataSet();
ds = db.CheckUserType(t1, c1);
if (ds != null &&
ds.Tables.Count > 0 &&
ds.Tables[0].Rows.Count > 0)
{
usertype = ds.Tables[0].Rows[0]["userType"].ToString();
passcode = ds.Tables[0].Rows[0]["passCode"].ToString();
session = ds.Tables[0].Rows[0]["pKId"].ToString();
}
else
{
Label1.Text = "Invalid Username or Password";
}
if (usertype == "admin" || usertype == "Admin")
{
if (password.Value == passcode)
{
Session["School"] = session;
Response.Redirect("Admin.aspx");
}
else
{
Label1.Text = "Invalid Username or Password";
}
}
else if (usertype == "teacher" || usertype == "Teacher")
{
if (password.Value == passcode)
{
Session["School"] = session;
Response.Redirect("Teacher.aspx");
}
else
{
Label1.Text = "Invalid Username or Password";
}
}
else if (usertype == "student" || usertype == "Student")
{
if (password.Value == passcode)
{
Session["School"] = session;
Response.Redirect("Students.aspx");
}
else
{
Label1.Text = "Invalid Username or Password";
}
}
}
protected void Loginc(object sender, EventArgs e)
{
user = username.Value;
data = user.Split('@')[0];
data2 = user.Split('@')[1];
DBHandler.DBHandler db = new DBHandler.DBHandler(con);
Entities.tblSchoolId t1 = new Entities.tblSchoolId()
{
schoolId = data,
};
Entities.Campus c1 = new Entities.Campus()
{
campusName = data2,
};
DataSet ds = new DataSet();
ds = db.CheckUserType(t1,c1);
if (ds != null
&& ds.Tables.Count > 0
&& ds.Tables[0].Rows.Count > 0)
{
usertype = ds.Tables[0].Rows[0]["userType"].ToString();
passcode = ds.Tables[0].Rows[0]["passCode"].ToString();
session = ds.Tables[0].Rows[0]["pKId"].ToString();
}
else
{
Label1.Text = "Invalid Username or Password";
}
if (usertype == "admin" || usertype=="Admin")
{
if (password.Value == passcode)
{
Session["School"] = session;
Response.Redirect("Admin.aspx");
}
else
{
Label1.Text = "Invalid Username or Password";
}
}
else if (usertype == "teacher" || usertype=="Teacher")
{
if (password.Value == passcode)
{
Session["School"] = session;
Response.Redirect("Teacher.aspx");
}
else
{
Label1.Text = "Invalid Username or Password";
}
}
else if (usertype == "student" || usertype == "Student")
{
if (password.Value == passcode)
{
Session["School"] = session;
Response.Redirect("Students.aspx");
}
else
{
Label1.Text = "Invalid Username or Password";
}
}
}
