public UserrModel GetData(string id)
{
UserrModel result = null;
var sSql = @"
SELECT
aa.UserrName, aa.Password, aa.UserType
FROM
Userr aa
WHERE
aa.UserrID = @UserrID ";
using (var conn = new SqlConnection(_connString))
using (var cmd = new SqlCommand(sSql, conn))
{
cmd.AddParam("@UserrID", id);
conn.Open();
using (var dr = cmd.ExecuteReader())
{
if (dr.HasRows)
{
dr.Read();
result = new UserrModel
{
UserrID = id,
UserrName = dr["UserrName"].ToString(),
Password = dr["Password"].ToString(),
JenisAkses = dr["UserType"].ToString(),
};
}
}
}
return(result);
}
public IEnumerable <UserrModel> ListData()
{
List <UserrModel> result = null;
var sSql = @"
SELECT
aa.UserrID, aa.UserrName, aa.Password, aa.UserType
FROM
Userr aa ";
using (var conn = new SqlConnection(_connString))
using (var cmd = new SqlCommand(sSql, conn))
{
conn.Open();
using (var dr = cmd.ExecuteReader())
{
if (dr.HasRows)
{
result = new List <UserrModel>();
while (dr.Read())
{
var item = new UserrModel
{
UserrID = dr["UserrID"].ToString(),
UserrName = dr["UserrName"].ToString(),
Password = dr["Password"].ToString(),
JenisAkses = dr["UserType"].ToString()
};
result.Add(item);
}
}
}
}
return(result);
}
UserrModel UserrDataFactory2()
{
var result = new UserrModel
{
UserrID = "A2",
UserrName = "B2"
};
return(result);
}
UserrModel UserrDataFactory()
{
var result = new UserrModel
{
UserrID = "A1",
UserrName = "B1"
};
return(result);
}
UserrModel Userr2DataFactory()
{
var result = new UserrModel
{
UserrID = "A2",
UserrName = "B2",
Password = "******"
};
return(result);
}
public bool IsValidPassword(UserrModel userr, string pass)
{
var userr2 = _userrDal.GetData(userr.UserrID);
var hash1 = userr2.Password;
var hash2 = HashFunctions.GetHashString(pass);
if (hash1 == hash2)
{
return(true);
}
else
{
return(false);
}
}
public void Insert(UserrModel userr)
{
var sSql = @"
INSERT INTO
Userr (
UserrID, UserrName, Password, UserType)
VALUES (
@UserrID, @UserrName, @Password, @UserType) ";
using (var conn = new SqlConnection(_connString))
using (var cmd = new SqlCommand(sSql, conn))
{
cmd.AddParam("@UserrID", userr.UserrID);
cmd.AddParam("@UserrName", userr.UserrName);
cmd.AddParam("@Password", userr.Password);
cmd.AddParam("@UserType", userr.JenisAkses);
conn.Open();
cmd.ExecuteNonQuery();
}
}
public UserrModel TryValidate(UserrModel userr)
{
var result = userr;
if (userr == null)
{
throw new ArgumentNullException(nameof(userr));
}
if (userr.UserrID.Trim() == "")
{
throw new ArgumentException("UserrID empty");
}
if (userr.UserrName.Trim() == "")
{
throw new ArgumentException("UserrName empty");
}
userr.Password = HashFunctions.GetHashString(userr.Password);
return(result);
}
public UserrModel Save(UserrModel userr)
{
// validasi
var result = userr;
result = TryValidate(userr);
// save
var dummyUserr = _userrDal.GetData(userr.UserrID);
if (dummyUserr == null)
{
_userrDal.Insert(result);
}
else
{
_userrDal.Update(result);
}
return(result);
}
public void Update(UserrModel userr)
{
var sSql = @"
UPDATE
Userr
SET
UserrName = @UserrName,
Password = @Password,
UserType = @UserType
WHERE
UserrID = @UserrID ";
using (var conn = new SqlConnection(_connString))
using (var cmd = new SqlCommand(sSql, conn))
{
cmd.AddParam("@UserrID", userr.UserrID);
cmd.AddParam("@UserrName", userr.UserrName);
cmd.AddParam("@Password", userr.Password);
cmd.AddParam("@UserType", userr.JenisAkses);
conn.Open();
cmd.ExecuteNonQuery();
}
}
