/// <summary>
/// Saves a record to the Localtion table.
/// </summary>
private DynamicParameters Param(LocaltionEntity obj, string action = "add")
{
var p = new DynamicParameters();
p.Add("@AccountId", obj.AccountId);
p.Add("@ProvinceId", obj.ProvinceId);
p.Add("@DistrictId", obj.DistrictId);
p.Add("@CustomeType", obj.CustomeType);
p.Add("@Lag", obj.Lag);
p.Add("@Lng", obj.Lng);
p.Add("@Name", obj.Name);
p.Add("@Avatar", obj.Avatar);
p.Add("@Email", obj.Email);
p.Add("@Phone", obj.Phone);
p.Add("@Address", obj.Address);
p.Add("@Status", obj.Status);
p.Add("@Code", obj.Code);
p.Add("@RepresentActive", obj.RepresentActive);
p.Add("@MinCheckin", obj.MinCheckin);
p.Add("@StatusEdit", obj.StatusEdit);
if (action == "add")
{
p.Add("@Id", dbType: DbType.Int64, direction: ParameterDirection.Output);
}
else if (action == "edit")
{
p.Add("@Id", obj.Id);
}
return(p);
}
/// <summary>
/// Updates a record in the Localtion table.
/// </summary>
public bool Update(LocaltionEntity obj)
{
try
{
var p = Param(obj, "edit");
var res = unitOfWork.ProcedureExecute("Sp_Localtion_Update", p);
return(res);
}
catch (Exception ex)
{
Logging.PutError(ex.Message, ex);
throw;
}
}
public bool UpdateAvatar(LocaltionEntity obj)
{
try
{
var p = new DynamicParameters();
p.Add("@Id", obj.Id);
var res = unitOfWork.ProcedureExecute("Sp_Localtion_UpdateAvatar", p);
return(res);
}
catch (Exception ex)
{
Logging.PutError(ex.Message, ex);
return(false);
}
}
/// <summary>
/// Saves a record to the Localtion table.
/// </summary>
public long Insert(LocaltionEntity obj)
{
long res;
try
{
var p = Param(obj);
var flag = unitOfWork.ProcedureExecute("Sp_Localtion_Insert", p);
res = flag ? p.Get <long>("@Id") : 0;
}
catch (Exception ex)
{
Logging.PutError(ex.Message, ex);
throw;
}
return(res);
}
public bool CheckedLocaltion(LocaltionEntity loc)
{
try
{
var p = new DynamicParameters();
p.Add("@Id", loc.Id);
p.Add("@AccountId", loc.AccountId);
p.Add("@PlaceNumberWrong", loc.PlaceNumberWrong);
p.Add("@ImageCheckin", loc.ImageCheckin);
var res = unitOfWork.ProcedureExecute("Sp_Localtion_CheckedLocaltion", p);
return(res);
}
catch (Exception ex)
{
Logging.PutError(ex.Message, ex);
throw;
}
}
public bool EditLocaltion(LocaltionEntity obj)
{
try
{
var p = new DynamicParameters();
p.Add("@Id", obj.Id);
p.Add("@AccountId", obj.AccountId);
p.Add("@Lag", obj.Lag);
p.Add("@Lng", obj.Lng);
p.Add("@Name", obj.Name);
p.Add("@Avatar", obj.Avatar);
p.Add("@Phone", obj.Phone);
p.Add("@Address", obj.Address);
p.Add("@Code", obj.Code);
var res = unitOfWork.ProcedureExecute("Sp_Localtion_EditLocaltion", p);
return(res);
}
catch (Exception ex)
{
Logging.PutError(ex.Message, ex);
throw;
}
}