public static ProjectInfo GetProjectById(int projectId) { int retValue = -1; ProjectInfo project = new ProjectInfo(); //Generated Code for query : dbo.GetAllVendors using (SqlDataReader dr = ProjManagementAdmin.GetProjectById(projectId, out retValue)) //Initialize and retrieve code for Datareader goes here { while (dr.Read()) { project.ProjectId = Convert.ToInt32(dr["project_id"]); project.ProjectName = dr["project_name"].ToString(); project.ProjectCode = dr["project_code"].ToString(); project.ProjectLeadId = Convert.ToInt32(dr["project_lead_id"]); project.ProjectLeadName = dr["project_lead_name"].ToString(); project.IsActive = Convert.ToBoolean(dr["is_active"]); project.CreatedDate = Convert.ToDateTime(dr["created_date"]); project.ChangedDate = Convert.ToDateTime(dr["changed_date"]); project.ChangedByName = dr["changed_by"].ToString(); } //dr.Close(); } return project; }
public static int AddNewProject(ProjectInfo project) { if (project == null) throw new ArgumentNullException("project"); int retValue = -1; return ProjManagementAdmin.AddNewProject(project, out retValue); }
public static HttpResponseMessage UpdateProject(ProjectInfo project) { try { int val = ProjectDal.UpdateProject(project); return new HttpResponseMessage(HttpStatusCode.OK); } catch (Exception ex) { Console.WriteLine("EXCEPTION: " + ex); return new HttpResponseMessage(HttpStatusCode.BadRequest); } }
public HttpResponseMessage Post(ProjectInfo project) { try { ProjectBl.AddNewProject(project); return new HttpResponseMessage(HttpStatusCode.OK); } catch (Exception ex) { return new HttpResponseMessage(HttpStatusCode.BadRequest); } }
public static ProjectInfo[] GetAllProjects() { ArrayList al = new ArrayList(); int retValue = -1; //Generated Code for query : dbo.GetAllVendors using (SqlDataReader dr = ProjManagementAdmin.GetAllProjects(out retValue)) //Initialize and retrieve code for Datareader goes here { while (dr.Read()) { ProjectInfo project = new ProjectInfo(); project.ProjectId = Convert.ToInt32(dr["project_id"]); project.ProjectName = dr["project_name"].ToString(); project.ProjectCode = dr["project_code"].ToString(); project.ProjectLeadId = Convert.ToInt32(dr["project_lead_id"]); project.ProjectLeadName = dr["project_lead_name"].ToString(); project.IsActive = Convert.ToBoolean(dr["is_active"]); project.CreatedDate = Convert.ToDateTime(dr["created_date"]); project.ChangedDate = Convert.ToDateTime(dr["changed_date"]); project.ChangedByName = dr["changed_by"].ToString(); if(project.IsActive == true) { project.OpenClose = "Close"; } else { project.OpenClose = "Open"; } al.Add(project); } //dr.Close(); } ProjectInfo[] allInfo = new ProjectInfo[al.Count]; al.CopyTo(allInfo); return allInfo; }
public static int UpdateProject(ProjectInfo project) { int retValue = -1; return ProjManagementAdmin.UpdateProject(project, out retValue); }
public HttpResponseMessage Post(ProjectInfo project) { return ProjectBl.UpdateProject(project); }
public ProjectInfo Get(int id) { ProjectInfo project = new ProjectInfo(); project = ProjectBl.GetProjectById(id); return project; }
private static SqlParameter[] GetAddProjectParams(ProjectInfo project) { SqlParameter[] sqlParms = new SqlParameter[100]; sqlParms = SQLHelper.GetCachedParameters(PROC_ADDNEWPROJECT); if (sqlParms == null) { sqlParms = new SqlParameter[] { new SqlParameter(PARAM_RETURN, SqlDbType.Int), new SqlParameter(PARAM_PROJECT_NAME, SqlDbType.NVarChar, 100), new SqlParameter(PARAM_PROJECT_CODE, SqlDbType.NVarChar, 100), new SqlParameter(PARAM_PROJECT_LEAD_ID, SqlDbType.Int), new SqlParameter(PARAM_CHANGEDBY, SqlDbType.NVarChar, 50) }; sqlParms[0].Direction = ParameterDirection.ReturnValue; SQLHelper.CacheParameters(PROC_ADDNEWPROJECT, sqlParms); } //Assigning values to parameter sqlParms[0].Value = -1; sqlParms[1].Value = project.ProjectName; sqlParms[2].Value = project.ProjectCode; sqlParms[3].Value = project.ProjectLeadId; sqlParms[4].Value = "vysali"; return sqlParms; }
public static int UpdateProject(ProjectInfo project, out int retValue) { retValue = -1; SqlParameter[] parms = GetUpdateProjectParams(project); return ExecuteNonQuery(PROC_UPDATEPROJECT, parms, out retValue); }
public static int AddNewProject(ProjectInfo project, out int retValue) { retValue = -1; SqlParameter[] parms = GetAddProjectParams(project); return ExecuteNonQuery(PROC_ADDNEWPROJECT, parms, out retValue); }
public static int AddNewProject(ProjectInfo project) { return ProjectDal.AddNewProject(project); }