public int Insert(Perdorues perdorues)
{
int id = 0;
try
{
using (SqlConnection con = new SqlConnection(Connection.String()))
{
using (SqlCommand cmd = new SqlCommand("InsertPerdorues", con))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@userName", SqlDbType.VarChar).Value = perdorues.UserName;
cmd.Parameters.Add("@perdouresId", SqlDbType.Int).Direction = ParameterDirection.Output;
con.Open();
cmd.ExecuteNonQuery();
id = Convert.ToInt32(cmd.Parameters["@perdoruesId"].Value);
con.Close();
}
}
}
catch (Exception ex)
{
id = 0;
}
return(id);
}
public async Task <Perdorues> Regjistro(Perdorues perdorues, string fjalekalim)
{
byte[] fjalekalimHash, fjalekalimKryp;
KrijoFjalekalimHash(fjalekalim, out fjalekalimHash, out fjalekalimKryp);
perdorues.FjalekalimHash = fjalekalimHash;
perdorues.FjalekalimKryp = fjalekalimKryp;
await _context.Perdoruesit.AddAsync(perdorues);
await _context.SaveChangesAsync();
return(perdorues);
}
