public void Update(ReturJualModel returJual) { var sSql = @" UPDATE ReturJual SET Tgl = @Tgl, Jam = @Jam, PenjualanID = @PenjualanID, BuyerName = @BuyerName, Keterangan = @Keterangan, TotalRetur = @TotalRetur WHERE ReturJualID = @ReturJualID "; using (var conn = new SqlConnection(_connString)) using (var cmd = new SqlCommand(sSql, conn)) { cmd.AddParam("@ReturJualID", returJual.ReturJualID); cmd.AddParam("@Tgl", returJual.Tgl.ToTglYMD()); cmd.AddParam("@Jam", returJual.Jam); cmd.AddParam("@PenjualanID", returJual.PenjualanID); cmd.AddParam("@BuyerName", returJual.BuyerName); cmd.AddParam("@Keterangan", returJual.Keterangan); cmd.AddParam("@TotalRetur", returJual.TotalRetur); conn.Open(); cmd.ExecuteNonQuery(); } }
public void Insert(ReturJualModel returJual) { var sSql = @" INSERT INTO ReturJual( ReturJualID, Tgl, Jam, PenjualanID, BuyerName, Keterangan, TotalRetur ) VALUES ( @ReturJualID, @Tgl, @Jam, @PenjualanID, @BuyerName, @Keterangan, @TotalRetur ) "; using (var conn = new SqlConnection(_connString)) using (var cmd = new SqlCommand(sSql, conn)) { cmd.AddParam("@ReturJualID", returJual.ReturJualID); cmd.AddParam("@Tgl", returJual.Tgl.ToTglYMD()); cmd.AddParam("@Jam", returJual.Jam); cmd.AddParam("@PenjualanID", returJual.PenjualanID); cmd.AddParam("@BuyerName", returJual.BuyerName); cmd.AddParam("@Keterangan", returJual.Keterangan); cmd.AddParam("@TotalRetur", returJual.TotalRetur); conn.Open(); cmd.ExecuteNonQuery(); } }
private ReturJualModel ReturJualDataFactory() { var result = new ReturJualModel { ReturJualID = "A1", Tgl = "23-02-2019", Jam = "08:00:21", PenjualanID = "B1", BuyerName = "C1", Keterangan = "D1", TotalRetur = 400, }; return(result); }
public IEnumerable <ReturJualModel> ListData(string tgl1, string tgl2) { List <ReturJualModel> result = null; var sSql = @" SELECT ReturJualID, Tgl, Jam, PenjualanID, BuyerName, Keterangan, TotalRetur FROM ReturJual WHERE Tgl BETWEEN @Tgl1 AND @Tgl2 "; using (var conn = new SqlConnection(_connString)) using (var cmd = new SqlCommand(sSql, conn)) { cmd.AddParam("@Tgl1", tgl1.ToTglYMD()); cmd.AddParam("@Tgl2", tgl2.ToTglYMD()); conn.Open(); using (var dr = cmd.ExecuteReader()) { if (dr.HasRows) { result = new List <ReturJualModel>(); while (dr.Read()) { var item = new ReturJualModel { ReturJualID = dr["ReturJualID"].ToString(), Tgl = dr["Tgl"].ToString().ToTglDMY(), Jam = dr["Jam"].ToString(), PenjualanID = dr["PenjualanID"].ToString(), BuyerName = dr["BuyerName"].ToString(), Keterangan = dr["Keterangan"].ToString(), TotalRetur = Convert.ToDecimal(dr["TotalRetur"]), }; result.Add(item); } } } } return(result); }
public ReturJualModel GetData(string returJualID) { ReturJualModel result = null; var sSql = @" SELECT ReturJualID, Tgl, Jam, PenjualanID, BuyerName, Keterangan, TotalRetur FROM ReturJual WHERE ReturJualID = @ReturJualID "; using (var conn = new SqlConnection(_connString)) using (var cmd = new SqlCommand(sSql, conn)) { cmd.AddParam("@ReturJualID", returJualID); conn.Open(); using (var dr = cmd.ExecuteReader()) { if (dr.HasRows) { dr.Read(); result = new ReturJualModel { ReturJualID = dr["ReturJualID"].ToString(), Tgl = dr["Tgl"].ToString().ToTglDMY(), Jam = dr["Jam"].ToString(), PenjualanID = dr["PenjualanID"].ToString(), BuyerName = dr["BuyerName"].ToString(), Keterangan = dr["Keterangan"].ToString(), TotalRetur = Convert.ToDecimal(dr["TotalRetur"]), }; } } } return(result); }