public int Insert(Project_StatusEntity project_status) { int res = 0; bool flag = false; try { var p = Param(project_status); flag = (bool)unitOfWork.ProcedureExecute("ptgroup_Project_Status_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(Project_StatusEntity project_status) { bool res = false; try { var p = Param(project_status, "edit"); res = (bool)unitOfWork.ProcedureExecute("ptgroup_Project_Status_Update", p); return(res); } catch (Exception ex) { Logging.PutError(ex.Message, ex); throw; } }
/// <summary> /// Saves a record to the Employee table. /// </summary> private DynamicParameters Param(Project_StatusEntity project_status, string action = "add") { var p = new DynamicParameters(); if (action == "add") { p.Add("@Id", dbType: DbType.Int32, direction: ParameterDirection.Output); } else { p.Add("@Id", project_status.Id); } p.Add("@Name", project_status.Name); p.Add("@IsDel", project_status.IsDel); p.Add("@IsActive", project_status.IsActive); return(p); }