/// <summary>
/// Saves a record to the Employee table.
/// </summary>
private DynamicParameters Param(DispatchOutEntity dispatchout, string action = "add")
{
var p = new DynamicParameters();
if (action == "add")
{
p.Add("@Id", dbType: DbType.Int32, direction: ParameterDirection.Output);
p.Add("@CreateBy", dispatchout.CreateBy);
p.Add("@CreatedDate", dispatchout.CreatedDate);
}
else
{
p.Add("@Id", dispatchout.Id);
p.Add("@ModifiedBy", dispatchout.ModifiedBy);
p.Add("@ModifiedDate", dispatchout.ModifiedDate);
}
p.Add("@DispatchNo", dispatchout.DispatchNo);
p.Add("@DispatchName", dispatchout.DispatchName);
p.Add("@DispatchType", dispatchout.DispatchType);
p.Add("@Priority", dispatchout.Priority);
p.Add("@DateWrite", dispatchout.DateWrite);
p.Add("@DispatchStatus", dispatchout.DispatchStatus);
p.Add("@WriterId", dispatchout.WriterId);
p.Add("@DepartmentId", dispatchout.DepartmentId);
p.Add("@ApproverId", dispatchout.ApproverId);
p.Add("@ChiefOfStaffId", dispatchout.ChiefOfStaffId);
p.Add("@Note", dispatchout.Note);
p.Add("@FileId", dispatchout.FileId);
p.Add("@Description", dispatchout.Description);
return(p);
}
public int Insert(DispatchOutEntity dispatchout)
{
int res = 0;
bool flag = false;
try
{
var p = Param(dispatchout);
flag = (bool)unitOfWork.ProcedureExecute("ptgroup_DispatchOut_Insert", p);
if (flag)
{
res = p.Get <int>("@Id");
}
else
{
res = 0;
}
}
catch (Exception ex)
{
Logging.PutError(ex.Message, ex);
throw;
}
return(res);
}
///Update
public bool Update(DispatchOutEntity dispatchout)
{
bool res = false;
try
{
var p = Param(dispatchout, "edit");
res = (bool)unitOfWork.ProcedureExecute("ptgroup_DispatchOut_Update", p);
return(res);
}
catch (Exception ex)
{
Logging.PutError(ex.Message, ex);
throw;
}
}
public bool UpdateFileId(DispatchOutEntity dispatchout)
{
bool res = false;
try
{
var p = new DynamicParameters();
p.Add("@Id", dispatchout.Id);
p.Add("@FileId", dispatchout.FileId);
res = (bool)unitOfWork.ProcedureExecute("ptgroup_DispatchOut_UpdateFileId", p);
return(res);
}
catch (Exception ex)
{
Logging.PutError(ex.Message, ex);
throw;
}
}