/// <summary>
/// Updates a record in the Province table.
/// </summary>
public bool Update(ProvinceEntity obj)
{
try
{
var p = Param(obj, "edit");
var res = unitOfWork.ProcedureExecute("Sp_Province_Update", p);
return(res);
}
catch (Exception ex)
{
Logging.PutError(ex.Message, ex);
throw;
}
}
/// <summary>
/// Saves a record to the Province table.
/// </summary>
public long Insert(ProvinceEntity obj)
{
long res;
try
{
var p = Param(obj);
var flag = unitOfWork.ProcedureExecute("Sp_Province_Insert", p);
res = flag ? p.Get <long>("@Id") : 0;
}
catch (Exception ex)
{
Logging.PutError(ex.Message, ex);
throw;
}
return(res);
}
/// <summary>
/// Saves a record to the Province table.
/// </summary>
private DynamicParameters Param(ProvinceEntity obj, string action = "add")
{
var p = new DynamicParameters();
p.Add("@ProvinceId", obj.ProvinceId);
p.Add("@Type", obj.Type);
p.Add("@Name", obj.Name);
p.Add("@Location", obj.Location);
if (action == "add")
{
p.Add("@Id", dbType: DbType.Int64, direction: ParameterDirection.Output);
}
else if (action == "edit")
{
p.Add("@Id", obj.Id);
}
return(p);
}
