public int Insert(Entities.OrderHistory obj)
{
string storeName = "admin_order_histories_insert";
try
{
using (var db = new PostgresSQL(ConnectionEntity.DBPosition.Master))
{
using (var command = db.CreateCommand(storeName, true))
{
command.Parameters.Add(NpgsqlParameter("@_order_id", obj.order_id));
command.Parameters.Add(NpgsqlParameter("@_created_by", obj.created_by));
command.Parameters.Add(NpgsqlParameter("@_change_log", obj.change_log));
command.Parameters.Add(NpgsqlParameter("@_status", obj.status));
command.Parameters.Add(NpgsqlParameter("@_delivery_status", obj.delivery_status));
command.Parameters.Add(NpgsqlParameter("@_request_type", obj.request_type));
return((int)command.ExecuteScalar());
}
}
}
catch (Exception ex)
{
throw new Exception(string.Format("{0} => {1}", storeName, ex.ToString()));
}
}
public ErrorCodes Insert(Entities.OrderHistory obj)
{
ErrorCodes errorCodes = ErrorCodes.Success;
try
{
obj.created_date = DateTime.Now;
var result = _orderHistoryDal.Insert(obj);
if (result <= 0)
{
errorCodes = ErrorCodes.BusinessError;
}
}
catch (Exception ex)
{
Logger.WriteLog(Logger.LogType.Error, ex.ToString());
errorCodes = ErrorCodes.Exception;
}
return(errorCodes);
}
