public int UpdateReviewDetailByTransID(ReviewDetail obj)
{
string sql = @"Update [BE_ReviewDetail] Set
[OrderID]=@OrderID
,[TransDate]=@TransDate
,[Amount]=@Amount
,[VoucherNo]=@VoucherNo
,[Payee]=@Payee
,[Created]=@Created
,[CreatedBy]=@CreatedBy
Where TransID=@TransID";
SqlCommand cmd = new SqlCommand(sql, this.conn, this.trans);
SqlParameter pTransID = new SqlParameter("TransID", Convert2DBnull(obj.TransID));
pTransID.SqlDbType = SqlDbType.UniqueIdentifier;
cmd.Parameters.Add(pTransID);
SqlParameter pOrderID = new SqlParameter("OrderID", Convert2DBnull(obj.OrderID));
pOrderID.SqlDbType = SqlDbType.UniqueIdentifier;
cmd.Parameters.Add(pOrderID);
SqlParameter pTransDate = new SqlParameter("TransDate", Convert2DBnull(obj.TransDate));
pTransDate.SqlDbType = SqlDbType.DateTime;
cmd.Parameters.Add(pTransDate);
SqlParameter pAmount = new SqlParameter("Amount", Convert2DBnull(obj.Amount));
pAmount.SqlDbType = SqlDbType.Decimal;
cmd.Parameters.Add(pAmount);
SqlParameter pVoucherNo = new SqlParameter("VoucherNo", Convert2DBnull(obj.VoucherNo));
pVoucherNo.SqlDbType = SqlDbType.NVarChar;
cmd.Parameters.Add(pVoucherNo);
SqlParameter pPayee = new SqlParameter("Payee", Convert2DBnull(obj.Payee));
pPayee.SqlDbType = SqlDbType.NVarChar;
cmd.Parameters.Add(pPayee);
SqlParameter pCreated = new SqlParameter("Created", Convert2DBnull(obj.Created));
pCreated.SqlDbType = SqlDbType.DateTime;
cmd.Parameters.Add(pCreated);
SqlParameter pCreatedBy = new SqlParameter("CreatedBy", Convert2DBnull(obj.CreatedBy));
pCreatedBy.SqlDbType = SqlDbType.NVarChar;
cmd.Parameters.Add(pCreatedBy);
return(cmd.ExecuteNonQuery());
}
public List <ReviewDetail> LoadReviewDetails()
{
string sql = @"Select
[TransID]
,[OrderID]
,[TransDate]
,[Amount]
,[VoucherNo]
,[Payee]
,[Created]
,[CreatedBy]
From [BE_ReviewDetail] With(NoLock)";
SqlCommand cmd = new SqlCommand(sql, this.conn, this.trans);
List <ReviewDetail> ret = new List <ReviewDetail>();
SqlDataReader dr = cmd.ExecuteReader();
try
{
while (dr.Read())
{
ReviewDetail iret = new ReviewDetail();
if (!Convert.IsDBNull(dr["TransID"]))
{
iret.TransID = (Guid)dr["TransID"];
}
if (!Convert.IsDBNull(dr["OrderID"]))
{
iret.OrderID = (Guid)dr["OrderID"];
}
if (!Convert.IsDBNull(dr["TransDate"]))
{
iret.TransDate = (DateTime)dr["TransDate"];
}
if (!Convert.IsDBNull(dr["Amount"]))
{
iret.Amount = (decimal)dr["Amount"];
}
if (!Convert.IsDBNull(dr["VoucherNo"]))
{
iret.VoucherNo = (string)dr["VoucherNo"];
}
if (!Convert.IsDBNull(dr["Payee"]))
{
iret.Payee = (string)dr["Payee"];
}
if (!Convert.IsDBNull(dr["Created"]))
{
iret.Created = (DateTime)dr["Created"];
}
if (!Convert.IsDBNull(dr["CreatedBy"]))
{
iret.CreatedBy = (string)dr["CreatedBy"];
}
ret.Add(iret);
}
}
finally
{
dr.Close();
}
return(ret);
}
public int LoadReviewDetail(ReviewDetail obj)
{
string sql = @"Select
[TransID]
,[OrderID]
,[TransDate]
,[Amount]
,[VoucherNo]
,[Payee]
,[Created]
,[CreatedBy]
From [BE_ReviewDetail] With(NoLock) Where TransID=@TransID";
SqlCommand cmd = new SqlCommand(sql, this.conn, this.trans);
SqlParameter pTransID = new SqlParameter("TransID", Convert2DBnull(obj.TransID));
pTransID.SqlDbType = SqlDbType.UniqueIdentifier;
cmd.Parameters.Add(pTransID);
int ret = 0;
SqlDataReader dr = cmd.ExecuteReader();
try
{
while (dr.Read())
{
if (!Convert.IsDBNull(dr["TransID"]))
{
obj.TransID = (Guid)dr["TransID"];
}
if (!Convert.IsDBNull(dr["OrderID"]))
{
obj.OrderID = (Guid)dr["OrderID"];
}
if (!Convert.IsDBNull(dr["TransDate"]))
{
obj.TransDate = (DateTime)dr["TransDate"];
}
if (!Convert.IsDBNull(dr["Amount"]))
{
obj.Amount = (decimal)dr["Amount"];
}
if (!Convert.IsDBNull(dr["VoucherNo"]))
{
obj.VoucherNo = (string)dr["VoucherNo"];
}
if (!Convert.IsDBNull(dr["Payee"]))
{
obj.Payee = (string)dr["Payee"];
}
if (!Convert.IsDBNull(dr["Created"]))
{
obj.Created = (DateTime)dr["Created"];
}
if (!Convert.IsDBNull(dr["CreatedBy"]))
{
obj.CreatedBy = (string)dr["CreatedBy"];
}
ret += 1;
}
}
finally
{
dr.Close();
}
return(ret);
}
public int InsertReviewDetail(ReviewDetail obj)
{
string sql = @"Insert Into [BE_ReviewDetail](
[TransID]
,[OrderID]
,[TransDate]
,[Amount]
,[VoucherNo]
,[Payee]
,[Created]
,[CreatedBy]
)Values (
@TransID
,@OrderID
,@TransDate
,@Amount
,@VoucherNo
,@Payee
,@Created
,@CreatedBy
)";
SqlCommand cmd = new SqlCommand(sql, this.conn, this.trans);
SqlParameter pTransID = new SqlParameter("TransID", Convert2DBnull(obj.TransID));
pTransID.SqlDbType = SqlDbType.UniqueIdentifier;
cmd.Parameters.Add(pTransID);
SqlParameter pOrderID = new SqlParameter("OrderID", Convert2DBnull(obj.OrderID));
pOrderID.SqlDbType = SqlDbType.UniqueIdentifier;
cmd.Parameters.Add(pOrderID);
SqlParameter pTransDate = new SqlParameter("TransDate", Convert2DBnull(obj.TransDate));
pTransDate.SqlDbType = SqlDbType.DateTime;
cmd.Parameters.Add(pTransDate);
SqlParameter pAmount = new SqlParameter("Amount", Convert2DBnull(obj.Amount));
pAmount.SqlDbType = SqlDbType.Decimal;
cmd.Parameters.Add(pAmount);
SqlParameter pVoucherNo = new SqlParameter("VoucherNo", Convert2DBnull(obj.VoucherNo));
pVoucherNo.SqlDbType = SqlDbType.NVarChar;
cmd.Parameters.Add(pVoucherNo);
SqlParameter pPayee = new SqlParameter("Payee", Convert2DBnull(obj.Payee));
pPayee.SqlDbType = SqlDbType.NVarChar;
cmd.Parameters.Add(pPayee);
SqlParameter pCreated = new SqlParameter("Created", Convert2DBnull(obj.Created));
pCreated.SqlDbType = SqlDbType.DateTime;
cmd.Parameters.Add(pCreated);
SqlParameter pCreatedBy = new SqlParameter("CreatedBy", Convert2DBnull(obj.CreatedBy));
pCreatedBy.SqlDbType = SqlDbType.NVarChar;
cmd.Parameters.Add(pCreatedBy);
return(cmd.ExecuteNonQuery());
}