public ActionResult DayWiseDetails()//total hours per day { List <GettingDetailsOfFile> list = new List <GettingDetailsOfFile>(); // SqlConnection Connection = new SqlConnection("Server=WIN-P2S8E7IH0S7\\SQLEXPRESS;Integrated Security=sspi;database=FileAnalysis"); SqlConnection Connection = new SqlConnection("Server=WIN-P2S8E7IH0S7\\SQLEXPRESS; Initial Catalog = FileAnalysis; User ID = sa; Password = Passw0rd@12;"); Connection.Open(); SqlCommand Command = new SqlCommand("ppmdaywisedetails", Connection); SqlDataReader DataReader = Command.ExecuteReader(); while (DataReader.Read()) { GettingDetailsOfFile Obj = new GettingDetailsOfFile() { ResourceNumber = Convert.ToString(DataReader[0]), ResourceName = Convert.ToString(DataReader[1]), DateMentioned = Convert.ToDateTime(DataReader[2]), HoursMentioned = Convert.ToDouble(DataReader[3]) }; list.Add(Obj); } Connection.Close(); return(View(list)); }
public ActionResult GettingAll() { List <GettingDetailsOfFile> list = new List <GettingDetailsOfFile>(); // SqlConnection Connection = new SqlConnection("Server=WIN-P2S8E7IH0S7\\SQLEXPRESS;Integrated Security=sspi;database=FileAnalysis"); SqlConnection Connection = new SqlConnection("Server=WIN-P2S8E7IH0S7\\SQLEXPRESS; Initial Catalog = FileAnalysis; User ID = sa; Password = Passw0rd@12;"); Connection.Open(); SqlCommand Command = new SqlCommand("GettingAll", Connection); SqlDataReader DataReader = Command.ExecuteReader(); while (DataReader.Read()) { GettingDetailsOfFile Obj = new GettingDetailsOfFile() { EmployeeId = Convert.ToString(DataReader[0]), EmployeeName = Convert.ToString(DataReader[1]), ActDate = Convert.ToDateTime(DataReader[2]), ExtProject = Convert.ToString(DataReader[3]), Esnumber = Convert.ToString(DataReader[4]), ExternalProject = Convert.ToString(DataReader[5]), Project = Convert.ToString(DataReader[6]), Wbs = Convert.ToString(DataReader[7]), Attribute = Convert.ToString(DataReader[8]), AAtype = Convert.ToString(DataReader[9]), ProjectType = Convert.ToString(DataReader[10]), HoursMentioned = Convert.ToDouble(DataReader[11]) }; list.Add(Obj); } Connection.Close(); return(View(list)); }
public ActionResult GettingAll() { List <GettingDetailsOfFile> list = new List <GettingDetailsOfFile>(); // SqlConnection Connection = new SqlConnection("Server=WIN-P2S8E7IH0S7\\SQLEXPRESS;Integrated Security=sspi;database=FileAnalysis"); SqlConnection Connection = new SqlConnection("Server=WIN-P2S8E7IH0S7\\SQLEXPRESS; Initial Catalog = FileAnalysis; User ID = sa; Password = Passw0rd@12;"); Connection.Open(); SqlCommand Command = new SqlCommand("PPMGettingAll", Connection); SqlDataReader DataReader = Command.ExecuteReader(); while (DataReader.Read()) { GettingDetailsOfFile Obj = new GettingDetailsOfFile() { ProjectNumber = Convert.ToString(DataReader[1]), ProjectName = Convert.ToString(DataReader[2]), ResourceNumber = Convert.ToString(DataReader[3]), ResourceName = Convert.ToString(DataReader[4]), TaskName = Convert.ToString(DataReader[5]), Summary = Convert.ToString(DataReader[6]), DateMentioned = Convert.ToDateTime(DataReader[7]), HoursMentioned = Convert.ToDouble(DataReader[8]), ResourceRole = Convert.ToString(DataReader[9]), ResourceType = Convert.ToString(DataReader[10]), BillingCode = Convert.ToString(DataReader[11]), ResourceHourlyRate = Convert.ToDouble(DataReader[12]), ProgrameeProjectManager = Convert.ToString(DataReader[13]), AfeDescrimination = Convert.ToString(DataReader[14]), ProgrameeGroup = Convert.ToString(DataReader[15]), Programee = Convert.ToString(DataReader[16]), ProgrameeManager = Convert.ToString(DataReader[17]), BussinessLead = Convert.ToString(DataReader[18]), UAVP = Convert.ToString(DataReader[19]), ITSABuildingCategory = Convert.ToString(DataReader[20]), FundingCategory = Convert.ToString(DataReader[21]), AFENumber = Convert.ToString(DataReader[22]), ServiceCategory = Convert.ToString(DataReader[23]), BillingRateOnShore = Convert.ToString(DataReader[24]), BillingRateOffShore = Convert.ToString(DataReader[25]) }; list.Add(Obj); } Connection.Close(); return(View(list)); }