public void save_rec_admin(clsregistrationprp p)
{
if (con.State == ConnectionState.Closed)
{
con.Open();
}
SqlCommand cmd = new SqlCommand("insreg", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@email", SqlDbType.VarChar, 50).Value = p.email;
cmd.Parameters.Add("@password", SqlDbType.VarChar, 50).Value = p.password;
cmd.Parameters.Add("@f_name", SqlDbType.VarChar, 50).Value = p.f_name;
cmd.Parameters.Add("@l_name", SqlDbType.VarChar, 50).Value = p.l_name;
cmd.Parameters.Add("@contact", SqlDbType.VarChar, 50).Value = p.contact;
cmd.Parameters.Add("@address", SqlDbType.VarChar, 50).Value = DBNull.Value;
cmd.Parameters.Add("@rollno", SqlDbType.VarChar, 50).Value = p.rollno;
cmd.Parameters.Add("@department", SqlDbType.VarChar, 50).Value = p.dept;
cmd.Parameters.Add("@semester", SqlDbType.VarChar, 50).Value = p.sem;
cmd.Parameters.Add("@dob", SqlDbType.VarChar, 50).Value = DBNull.Value;
cmd.Parameters.Add("@father", SqlDbType.VarChar, 50).Value = DBNull.Value;
cmd.Parameters.Add("@mother", SqlDbType.VarChar, 50).Value = DBNull.Value;
cmd.Parameters.Add("@hostel", SqlDbType.VarChar, 50).Value = DBNull.Value;
cmd.Parameters.Add("@bus", SqlDbType.VarChar, 50).Value = DBNull.Value;
cmd.Parameters.Add("@acc_type", SqlDbType.VarChar, 50).Value = p.acc_type;
cmd.Parameters.Add("@lastupd", SqlDbType.VarChar, 50).Value = p.lastupd;
cmd.ExecuteNonQuery();
cmd.Dispose();
con.Close();
}
public List<clsregistrationprp> find_parent(Int32 regid)
{
if (con.State == ConnectionState.Closed)
{
con.Open();
}
SqlCommand cmd = new SqlCommand("findparent", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@rollno", SqlDbType.Int).Value = regid;
SqlDataReader dr = cmd.ExecuteReader();
List<clsregistrationprp> obj = new List<clsregistrationprp>();
if (dr.HasRows)
{
dr.Read();
clsregistrationprp p = new clsregistrationprp();
p.parentemail = dr[2].ToString();
p.parentcontact = dr[3].ToString();
obj.Add(p);
}
dr.Close();
cmd.Dispose();
con.Close();
return obj;
}
public List<clsregistrationprp> find_rec_parent(Int32 regid)
{
if (con.State == ConnectionState.Closed)
{
con.Open();
}
SqlCommand cmd = new SqlCommand("findregparent", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@regid", SqlDbType.Int).Value = regid;
SqlDataReader dr = cmd.ExecuteReader();
List<clsregistrationprp> obj = new List<clsregistrationprp>();
if (dr.HasRows)
{
dr.Read();
clsregistrationprp k = new clsregistrationprp();
k.regid = Convert.ToInt32(dr[0]);
k.f_name = dr[1].ToString();
k.email = dr[2].ToString();
k.contact = dr[3].ToString();
k.address = dr[4].ToString();
k.password = dr[5].ToString();
k.lastupd = dr[7].ToString();
obj.Add(k);
}
dr.Close();
cmd.Dispose();
con.Close();
return obj;
}
public List<clsregistrationprp> disp_rec()
{
if (con.State == ConnectionState.Closed)
{
con.Open();
}
SqlCommand cmd = new SqlCommand("dispreg", con);
cmd.CommandType = CommandType.StoredProcedure;
SqlDataReader dr = cmd.ExecuteReader();
List<clsregistrationprp> obj = new List<clsregistrationprp>();
while (dr.Read())
{
clsregistrationprp k = new clsregistrationprp();
k.regid = Convert.ToInt32(dr[0]);
k.email = dr[1].ToString();
k.password = dr[2].ToString();
k.f_name = dr[3].ToString();
k.l_name = dr[4].ToString();
k.address = dr[5].ToString();
obj.Add(k);
}
dr.Close();
cmd.Dispose();
con.Close();
return obj;
}
public void delete_rec(clsregistrationprp p)
{
if (con.State == ConnectionState.Closed)
{
con.Open();
}
SqlCommand cmd = new SqlCommand("delreg", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@regid", SqlDbType.Int).Value = p.regid;
cmd.ExecuteNonQuery();
cmd.Dispose();
con.Close();
}
public void change_pass_parent(clsregistrationprp p)
{
if (con.State == ConnectionState.Closed)
{
con.Open();
}
SqlCommand cmd = new SqlCommand("passchangeparent", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@regid", SqlDbType.Int).Value = p.regid;
cmd.Parameters.Add("@password", SqlDbType.VarChar, 50).Value = p.password;
cmd.Parameters.Add("@lastupd", SqlDbType.VarChar, 50).Value = p.lastupd;
cmd.ExecuteNonQuery();
cmd.Dispose();
con.Close();
}
public Int32 findid(clsregistrationprp p)
{
if (con.State == ConnectionState.Closed)
{
con.Open();
}
SqlCommand cmd = new SqlCommand("getid", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@rollno", SqlDbType.VarChar, 50).Value = p.rollno;
cmd.Parameters.Add("@reg", SqlDbType.Int).Direction = ParameterDirection.Output;
cmd.ExecuteNonQuery();
Int32 a = Convert.ToInt32(cmd.Parameters["@reg"].Value);
cmd.Dispose();
con.Close();
return a;
}
//kanha//
public Int32 adminlogin(clsregistrationprp p)
{
if (con.State == ConnectionState.Closed)
{
con.Open();
}
SqlCommand cmd = new SqlCommand("adminlogin", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@email", SqlDbType.VarChar, 50).Value = p.email;
cmd.Parameters.Add("@password", SqlDbType.VarChar, 50).Value = p.password;
cmd.Parameters.Add("@pass", SqlDbType.Int).Direction = ParameterDirection.Output;
cmd.ExecuteNonQuery();
Int32 a = Convert.ToInt32(cmd.Parameters["@pass"].Value);
cmd.Dispose();
con.Close();
return a;
}
public void update_parent(clsregistrationprp p)
{
if (con.State == ConnectionState.Closed)
{
con.Open();
}
SqlCommand cmd = new SqlCommand("parentupd", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@email", SqlDbType.VarChar, 50).Value = p.parentemail;
cmd.Parameters.Add("@contact", SqlDbType.VarChar, 50).Value = p.parentcontact;
cmd.Parameters.Add("@address", SqlDbType.VarChar, 50).Value = p.address;
cmd.Parameters.Add("@rollno", SqlDbType.Int).Value = p.regid ;
cmd.Parameters.Add("@name", SqlDbType.VarChar, 50).Value = p.parent;
cmd.Parameters.Add("@lastupd", SqlDbType.VarChar, 50).Value = p.lastupd;
cmd.ExecuteNonQuery();
cmd.Dispose();
con.Close();
}
public Int32 logincheckrolla(clsregistrationprp p)
{
if (con.State == ConnectionState.Closed)
{
con.Open();
}
SqlCommand cmd = new SqlCommand("logincheckroll", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@rollno", SqlDbType.VarChar, 50).Value = p.rollno;
cmd.Parameters.Add("@password", SqlDbType.VarChar, 50).Value = p.password;
cmd.Parameters.Add("@cod", SqlDbType.Int).Direction = ParameterDirection.Output;
cmd.Parameters.Add("@acc_type", SqlDbType.VarChar, 50).Direction = ParameterDirection.Output;
cmd.ExecuteNonQuery();
Int32 a = Convert.ToInt32(cmd.Parameters["@cod"].Value);
// Int32 b = Convert.ToInt32(cmd.Parameters["@acc_type"].Value);
cmd.Dispose();
con.Close();
return a;
}
public void join_family(clsregistrationprp p)
{
if (con.State == ConnectionState.Closed)
{
con.Open();
}
SqlCommand cmd = new SqlCommand("joinfamily", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@email", SqlDbType.VarChar, 50).Value = p.parentemail;
cmd.Parameters.Add("@password", SqlDbType.VarChar, 50).Value = p.parentpassword;
cmd.Parameters.Add("@name", SqlDbType.VarChar, 50).Value = p.parent;
cmd.Parameters.Add("@contact", SqlDbType.VarChar, 50).Value = p.parentcontact;
cmd.Parameters.Add("@student", SqlDbType.Int).Value = p.studentid;
cmd.Parameters.Add("@address", SqlDbType.VarChar, 50).Value = DBNull.Value;
cmd.Parameters.Add("@lstupd", SqlDbType.VarChar, 50).Value = p.lastupd;
cmd.ExecuteNonQuery();
cmd.Dispose();
con.Close();
}
public void data_entry(clsregistrationprp p)
{
if (con.State == ConnectionState.Closed)
{
con.Open();
}
SqlCommand cmd = new SqlCommand("dataentry", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@rollno", SqlDbType.VarChar, 50).Value = p.rollno;
cmd.Parameters.Add("@acadmics", SqlDbType.Int).Value =Convert.ToInt32( p.acadmics);
cmd.Parameters.Add("@hostel", SqlDbType.Int).Value = Convert.ToInt32 (p.hostelfee1);
cmd.Parameters.Add("@extra", SqlDbType.Int).Value = Convert.ToInt32(p.extra);
cmd.Parameters.Add("@exam", SqlDbType.Int).Value = Convert.ToInt32( p.exam);
cmd.Parameters.Add("@fine", SqlDbType.Int).Value = Convert.ToInt32( p.fine);
cmd.Parameters.Add("@bus", SqlDbType.Int).Value = Convert.ToInt32 (p.busfee);
cmd.Parameters.Add("@pending", SqlDbType.Int).Value = Convert.ToInt32(p.pending);
cmd.Parameters.Add("@total", SqlDbType.Int).Value = Convert.ToInt32( p.total);
cmd.ExecuteNonQuery();
cmd.Dispose();
con.Close();
}
