public JenisTrsKasirModel GetData(string id)
{
JenisTrsKasirModel result = null;
var sSql = @"
SELECT
aa.JenisTrsKasirName, aa.IsKasKeluar
FROM
JenisTrsKasir aa
WHERE
aa.JenisTrsKasirID = @JenisTrsKasirID ";
using (var conn = new SqlConnection(_connString))
using (var cmd = new SqlCommand(sSql, conn))
{
cmd.AddParam("@JenisTrsKasirID", id);
conn.Open();
using (var dr = cmd.ExecuteReader())
{
if (dr.HasRows)
{
dr.Read();
result = new JenisTrsKasirModel
{
JenisTrsKasirID = id,
JenisTrsKasirName = dr["JenisTrsKasirName"].ToString(),
IsKasKeluar = Convert.ToBoolean(dr["IsKasKeluar"])
};
}
}
}
return(result);
}
public IEnumerable <JenisTrsKasirModel> ListData()
{
List <JenisTrsKasirModel> result = null;
var sSql = @"
SELECT
aa.JenisTrsKasirID, aa.JenisTrsKasirName,
aa.IsKasKeluar
FROM
JenisTrsKasir 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 <JenisTrsKasirModel>();
while (dr.Read())
{
var item = new JenisTrsKasirModel
{
JenisTrsKasirID = dr["JenisTrsKasirID"].ToString(),
JenisTrsKasirName = dr["JenisTrsKasirName"].ToString(),
IsKasKeluar = Convert.ToBoolean(dr["IsKasKeluar"])
};
result.Add(item);
}
}
}
}
return(result);
}
JenisTrsKasirModel JenisTrsKasir2DataFactory()
{
var result = new JenisTrsKasirModel
{
JenisTrsKasirID = "A2",
JenisTrsKasirName = "B2"
};
return(result);
}
public void Insert(JenisTrsKasirModel jenisTrsKasir)
{
var sSql = @"
INSERT INTO
JenisTrsKasir (
JenisTrsKasirID, JenisTrsKasirName, IsKasKeluar)
VALUES (
@JenisTrsKasirID, @JenisTrsKasirName, @IsKasKeluar) ";
using (var conn = new SqlConnection(_connString))
using (var cmd = new SqlCommand(sSql, conn))
{
cmd.AddParam("@JenisTrsKasirID", jenisTrsKasir.JenisTrsKasirID);
cmd.AddParam("@JenisTrsKasirName", jenisTrsKasir.JenisTrsKasirName);
cmd.AddParam("@IsKasKeluar", jenisTrsKasir.IsKasKeluar);
conn.Open();
cmd.ExecuteNonQuery();
}
}
public void Update(JenisTrsKasirModel jenisTrsKasir)
{
var sSql = @"
UPDATE
JenisTrsKasir
SET
JenisTrsKasirName = @JenisTrsKasirName,
IsKasKeluar = @IsKasKeluar
WHERE
JenisTrsKasirID = @JenisTrsKasirID ";
using (var conn = new SqlConnection(_connString))
using (var cmd = new SqlCommand(sSql, conn))
{
cmd.AddParam("@JenisTrsKasirID", jenisTrsKasir.JenisTrsKasirID);
cmd.AddParam("@JenisTrsKasirName", jenisTrsKasir.JenisTrsKasirName);
cmd.AddParam("@IsKasKeluar", jenisTrsKasir.IsKasKeluar);
conn.Open();
cmd.ExecuteNonQuery();
}
}
