public static HttpResponseMessage AddProjectToLocation(ProjectLocationInfo ProjLoc) { try { int val = ProjectLocationDal.AddProjectAtLocation(ProjLoc); return new HttpResponseMessage(HttpStatusCode.OK); } catch (Exception ex) { Console.WriteLine("EXCEPTION: " + ex); return new HttpResponseMessage(HttpStatusCode.BadRequest); } }
public static int AddProjectAtLocation(ProjectLocationInfo ProjLoc) { int retValue = -1; return ProjManagementAdmin.AddProjectAtLocation(ProjLoc, out retValue); }
public static ProjectLocationInfo[] GetProjectsAtLocation(int LocationId) { ArrayList al = new ArrayList(); int retValue = -1; //Generated Code for query : dbo.GetAllVendors using (SqlDataReader dr = ProjManagementAdmin.GetProjectsAtLocation(LocationId,out retValue)) //Initialize and retrieve code for Datareader goes here { while (dr.Read()) { ProjectLocationInfo proj_loc = new ProjectLocationInfo(); proj_loc.ProjectLocationId = Convert.ToInt32(dr["project_location_id"]); proj_loc.ProjectId = Convert.ToInt32(dr["project_id"]); proj_loc.ProjectName = dr["project_name"].ToString(); proj_loc.ProjectCode = dr["project_code"].ToString(); proj_loc.ProjectLeadId = Convert.ToInt32(dr["project_lead_id"]); proj_loc.ProjectLeadName = dr["project_lead_name"].ToString(); proj_loc.LocationId = Convert.ToInt32(dr["location_id"]); proj_loc.LocationName = dr["location_name"].ToString(); proj_loc.IsActive = Convert.ToBoolean(dr["is_active"]); proj_loc.CreatedDate = Convert.ToDateTime(dr["created_date"]); proj_loc.ChangedDate = Convert.ToDateTime(dr["changed_date"]); proj_loc.ChangedByName = dr["changed_by"].ToString(); if (proj_loc.IsActive == true) { proj_loc.OpenClose = "Close"; } else { proj_loc.OpenClose = "Open"; } al.Add(proj_loc); } //dr.Close(); } ProjectLocationInfo[] allInfo = new ProjectLocationInfo[al.Count]; al.CopyTo(allInfo); return allInfo; }
private static SqlParameter[] GetAddProjectAtLocationParams(ProjectLocationInfo ProjLoc) { SqlParameter[] sqlParms = new SqlParameter[100]; sqlParms = SQLHelper.GetCachedParameters(PROC_ADDPROJECTATLOC); if (sqlParms == null) { sqlParms = new SqlParameter[] { new SqlParameter(PARAM_RETURN, SqlDbType.Int), new SqlParameter(PARAM_PROJECT_ID, SqlDbType.Int), new SqlParameter(PARAM_LOCATION_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 = ProjLoc.ProjectId; sqlParms[2].Value = ProjLoc.LocationId; sqlParms[3].Value = "vysali"; return sqlParms; }
public static int AddProjectAtLocation(ProjectLocationInfo ProjLoc, out int retValue) { retValue = -1; SqlParameter[] parms = GetAddProjectAtLocationParams(ProjLoc); return ExecuteNonQuery(PROC_ADDPROJECTATLOC, parms, out retValue); }
public HttpResponseMessage Post(ProjectLocationInfo ProjLoc) { return ProjectLocationBl.AddProjectToLocation(ProjLoc); }