//****************************************************************************************
// 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;
}
}