public JsonNetResult SaveReceipt(ReceiptInfoModel receipt)
{
if (receipt == null)
{
throw new ArgumentNullException("The receipt is null.");
}
if (!this.ValidateReceipt(receipt))
{
return(JsonNet(new ResponseResult(false, "The receipt is invalid.", ErrorCodes.RequireField)));
}
var entity = new ReceiptInfoEntity
{
Id = receipt.Id,
Title = receipt.Title,
Tax = receipt.Tax,
HospitalId = receipt.HospitalId
};
new ReceiptInfoService().Save(entity);
receipt.Id = entity.Id;
return(JsonNet(new ResponseResult(true, receipt)));
}
public void Save(ReceiptInfoEntity entity)
{
if (string.IsNullOrEmpty(entity.Id))
{
entity.Id = Guid.NewGuid().ToString();
ReceiptInfoRepository.Add(entity);
}
else
{
ReceiptInfoRepository.Update(entity);
}
}
public static void Update(ReceiptInfoEntity receipt)
{
var sql = string.Format(@"UPDATE receipt_info
SET title = @p_title, tax = @p_tax, updated_id = @p_updated_id, updated_time = @p_updated_time
WHERE id=@p_id", COLUMN_SQL);
var db = DatabaseFactory.CreateDatabase();
var dc = db.GetSqlStringCommand(sql);
db.AddInParameter(dc, "p_id", DbType.String, receipt.Id);
db.AddInParameter(dc, "p_title", DbType.String, receipt.Title);
db.AddInParameter(dc, "p_tax", DbType.String, receipt.Tax);
db.AddInParameter(dc, "p_updated_id", DbType.String, receipt.UpdatedId);
db.AddInParameter(dc, "p_updated_time", DbType.DateTime, receipt.UpdatedTime);
db.ExecuteNonQuery(dc);
}
public static void Add(ReceiptInfoEntity receipt)
{
var sql = string.Format(@"INSERT INTO receipt_info({0})
VALUES(@p_id, @p_hospital_id, @p_title, @p_tax,
@p_created_id, @p_created_time, @p_updated_id, @p_updated_time)", COLUMN_SQL);
var db = DatabaseFactory.CreateDatabase();
var dc = db.GetSqlStringCommand(sql);
db.AddInParameter(dc, "p_id", DbType.String, receipt.Id);
db.AddInParameter(dc, "p_hospital_id", DbType.String, receipt.HospitalId);
db.AddInParameter(dc, "p_title", DbType.String, receipt.Title);
db.AddInParameter(dc, "p_tax", DbType.String, receipt.Tax);
db.AddInParameter(dc, "p_created_id", DbType.String, receipt.CreatedId);
db.AddInParameter(dc, "p_created_time", DbType.DateTime, receipt.CreatedTime);
db.AddInParameter(dc, "p_updated_id", DbType.String, receipt.UpdatedId);
db.AddInParameter(dc, "p_updated_time", DbType.DateTime, receipt.UpdatedTime);
db.ExecuteNonQuery(dc);
}
public static ReceiptInfoEntity Get(string id)
{
var sql = string.Format(@"SELECT {0} FROM receipt_info WHERE id = @p_id ", COLUMN_SQL);
var db = DatabaseFactory.CreateDatabase();
var dc = db.GetSqlStringCommand(sql);
db.AddInParameter(dc, "p_id", DbType.String, id);
var list = new List <ReceiptInfoEntity>();
using (var reader = db.ExecuteReader(dc))
{
while (reader.Read())
{
var entity = new ReceiptInfoEntity();
entity.Init(reader);
return(entity);
}
return(null);
}
}
public static IList <ReceiptInfoEntity> GetByHospital(string hospitalId)
{
var sql = string.Format(@"SELECT {0} FROM receipt_info WHERE hospital_id = @p_hospital_id ORDER BY TITLE", COLUMN_SQL);
var db = DatabaseFactory.CreateDatabase();
var dc = db.GetSqlStringCommand(sql);
db.AddInParameter(dc, "p_hospital_id", DbType.String, hospitalId);
var list = new List <ReceiptInfoEntity>();
using (var reader = db.ExecuteReader(dc))
{
while (reader.Read())
{
var entity = new ReceiptInfoEntity();
entity.Init(reader);
list.Add(entity);
}
}
return(list);
}
