//**************************************************************************************** // Person Sigup public int CreateAccount(Person per) { DataAccessLayer da = new DataAccessLayer(); SqlParameter[] parameter = { new SqlParameter("@Per_Name", per.PName), new SqlParameter("@User_Name", per.UName), new SqlParameter("@Per_Password", per.PPassword), new SqlParameter("@Per_Gender", per.PGender), new SqlParameter("@Per_Age", per.PAge) }; int validity = da.ExecuteNonQuery("SPRegisterUser", CommandType.StoredProcedure, parameter); return(validity); }
//**************************************************************************************** // Person Sigup public void DeleteAcc(Person per) { SqlParameter[] parameter = { new SqlParameter("@PersonID", per.PID) }; DataAccessLayer DA = new DataAccessLayer(); int validity = DA.ExecuteNonQuery("SP_DELETE_PERSON_ACC", CommandType.StoredProcedure, parameter); if (validity == 1) { throw new Exception("Failed to delete a Record"); } }
public bool AyakkabiEkle(Ayakkabi ayk) { try { if (ayk == null) { throw new NullReferenceException("Öğrenci referansı null geldi"); } SqlParameter[] p = { new SqlParameter("@Marka", ayk.Marka), new SqlParameter("@Model", ayk.Model), new SqlParameter("@Numara", ayk.Numara) }; dal = new DataAccessLayer(); return(dal.ExecuteNonQuery("Insert into tblAyakkabiStok values(@Marka,@Model,@Numara)", p) > 0); } catch (Exception) { throw; } }