Example #1
0
        public void AddStudent(AdminInformation admin, int schoolid, string query, bool isStoreProcedure)
        {
            try{
                con.Open();
                com = new SqlCommand(query, con);
                com.Parameters.Add("@schoolid", SqlDbType.NVarChar).Value = schoolid;
                com.Parameters.Add("@password", SqlDbType.NVarChar).Value = admin.StudentPassword;

                com.Parameters.Add("@studentname", SqlDbType.NVarChar).Value = admin.StudenName;

                if (isStoreProcedure)
                {
                    com.CommandType = CommandType.StoredProcedure;
                }
                else
                {
                    com.CommandType = CommandType.Text;
                }
                com.ExecuteNonQuery();
            }
            catch (Exception ex)
            {
                System.Diagnostics.Debug.WriteLine("Error inside SqlHelper class in NonQuery as {0}", ex.Message);
            }
            finally
            {
                con.Close();
                //com.Parameters.Clear();
                // parameters.Clear();
            }
        }
 public ActionResult Index(AdminInformation reg)
 {
     if (ModelState.IsValid)
     {
         using (TaxSystemEntities1 db = new TaxSystemEntities1())
         {
             var obj = db.AdminInformations.Where(a => a.UserName.Equals(reg.UserName) && a.Password.Equals(reg.Password)).FirstOrDefault();
             if (obj != null)
             {
                 Session["Admin"] = obj.UserName.ToString();
                 return(RedirectToAction("Index", "Home"));
             }
         }
     }
     ViewBag.Message = "Invalid User Name or Password";
     // Response.Write("<script>alert(' Invalid PanNumber or Password')</script>");
     return(View(reg));
 }
 public void AddStudent(AdminInformation admin, int schoolid)
 {
     sqhelp.AddStudent(admin, schoolid, "spAddStudent", true);
 }
 public void UpdateAdminPassword(AdminInformation admin, string name, int schoolid)
 {
     sqhelp.UpdateAdminPasssword(admin, name, schoolid, "spUpdateAdminPasssword", true);
 }
Example #5
0
 public void AddStudent(AdminInformation admin, int schoolid)
 {
     adminformdl.AddStudent(admin, schoolid);
 }
Example #6
0
 public void UpdateAdminPassword(AdminInformation admin, string name, int schoolid)
 {
     adminformdl.UpdateAdminPassword(admin, name, schoolid);
 }