public void Insert(PraCIF obj)
{
using (SqlConnection conn = new SqlConnection(GetConnString()))
{
string strSql = @"
INSERT INTO PraCIF(Id,Comp_ID,CIF_No,CIF_Name,CIF_Address,NoHP)
VALUES(@Id,@Comp_ID,@CIF_No,@CIF_Name,@CIF_Address,@NoHP)";
SqlCommand cmd = new SqlCommand(strSql, conn);
cmd.Parameters.AddWithValue("@Id", Guid.NewGuid().ToString());
cmd.Parameters.AddWithValue("@CIF_No", obj.CIF_No);
cmd.Parameters.AddWithValue("@Comp_ID", obj.Comp_ID);
cmd.Parameters.AddWithValue("@CIF_Name", obj.CIF_Name);
cmd.Parameters.AddWithValue("@CIF_Address", obj.CIF_Address);
cmd.Parameters.AddWithValue("@NoHP", obj.NoHP);
try
{
conn.Open();
cmd.ExecuteNonQuery();
}
catch (SqlException sqlEx)
{
throw new Exception($"Kesalahan: {sqlEx.Number} Message: {sqlEx.Message}");
}
finally
{
cmd.Dispose();
conn.Close();
}
}
}
public void Update(PraCIF obj)
{
using (SqlConnection conn = new SqlConnection(GetConnString()))
{
string strSql = @"update PraCIF set Comp_ID=@Comp_ID,CIF_No=@CIF_No,
CIF_Name=@CIF_Name,CIF_Address=@CIF_Address,NoHP=@NoHP
where ID=@ID";
SqlCommand cmd = new SqlCommand(strSql, conn);
cmd.Parameters.AddWithValue("@ID", obj.ID);
cmd.Parameters.AddWithValue("@CIF_No", obj.CIF_No);
cmd.Parameters.AddWithValue("@Comp_ID", obj.Comp_ID);
cmd.Parameters.AddWithValue("@CIF_Name", obj.CIF_Name);
cmd.Parameters.AddWithValue("@CIF_Address", obj.CIF_Address);
cmd.Parameters.AddWithValue("@NoHP", obj.NoHP);
try
{
conn.Open();
cmd.ExecuteNonQuery();
}
catch (SqlException sqlEx)
{
throw new Exception($"Kesalahan: {sqlEx.Number} - {sqlEx.Message}");
}
finally
{
cmd.Dispose();
conn.Close();
}
}
}
public void Insert(PraCIF obj)
{
using (SqlConnection conn = new SqlConnection(GetConnString()))
{
string strSql = @"
INSERT INTO PraCIF(Id,Comp_ID,CIF_No,CIF_Name,CIF_Address,NoHP)
VALUES(@Id,@Comp_ID,@CIF_No,@CIF_Name,@CIF_Address,@NoHP)";
var param = new PraCIF
{
ID = Guid.NewGuid().ToString(),
Comp_ID = obj.Comp_ID,
CIF_No = obj.CIF_No,
CIF_Name = obj.CIF_Name,
CIF_Address = obj.CIF_Address,
NoHP = obj.NoHP
};
try
{
conn.Execute(strSql);
}
catch (SqlException sqlEx)
{
throw new Exception($"Kesalahan: {sqlEx.Number} Message: {sqlEx.Message}");
}
}
}
public IActionResult Put([FromBody] PraCIF praCIF)
{
try
{
_praCIF.Update(praCIF);
return(Ok("Berhasil update data PraCIF"));
}
catch (Exception ex)
{
return(BadRequest(ex.Message));
}
}
public IActionResult Post([FromBody] PraCIF praCif)
{
try
{
_praCIF.Insert(praCif);
return(Ok("Berhasil Tambah Data PraCIF"));
}
catch (Exception ex)
{
return(BadRequest($"Kesalahan: {ex.Message}"));
}
}
public IEnumerable <PraCIF> GetByName(string name)
{
List <PraCIF> lstPraCIF = new List <PraCIF>();
using (SqlConnection conn = new SqlConnection(GetConnString()))
{
string strSql = @"
SELECT ID,Comp_ID,CIF_No,CIF_Name,CIF_Address,NoHP
FROM PraCIF
WHERE CIF_Name like @CIF_Name
ORDER BY CIF_Name asc";
SqlCommand cmd = new SqlCommand(strSql, conn);
cmd.Parameters.AddWithValue("@CIF_Name", $"%{name}%");
conn.Open();
SqlDataReader dr = cmd.ExecuteReader();
if (dr.HasRows)
{
while (dr.Read())
{
PraCIF objPraCIF = new PraCIF
{
ID = dr["ID"].ToString(),
Comp_ID = dr["Comp_ID"].ToString(),
CIF_No = dr["CIF_No"].ToString(),
CIF_Name = dr["CIF_Name"].ToString(),
CIF_Address = dr["CIF_Address"].ToString(),
NoHP = dr["NoHP"].ToString()
};
lstPraCIF.Add(objPraCIF);
}
}
dr.Close();
cmd.Dispose();
conn.Close();
return(lstPraCIF);
}
}
