public ActivityList getActivities(Int32 IsActive) { SqlCommand cmd = null; ActivityList activities = new ActivityList(); try { using (con = new SqlConnection(conStr)) { con.Open(); using (cmd = new SqlCommand(StaticData.GET_ACTIVITIES, con)) { cmd.CommandType = System.Data.CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@status", Convert.ToBoolean(IsActive)); cmd.Parameters.AddWithValue("@userid", Common.GetUser.UserId); SqlDataReader rdr = cmd.ExecuteReader(); activities.lst = new List <Activities>(); while (rdr.Read()) { Activities act = new Activities(); act.activityid = Convert.ToInt32(rdr["activityid"]); act.description = Convert.ToString(rdr["description"]); act.isActive = Convert.ToBoolean(rdr["isactive"]); activities.lst.Add(act); } CloseReader(rdr); } } return(activities); } catch (Exception ex) { throw ex; } }
public WMViewModel getList() { WMViewModel workms = new WMViewModel("", false); workms.Activities = new ActivityList(); List <WorkMaint> wm = new List <WorkMaint>(); List <Activities> act = new List <Activities>(); String sqlCmd = String.Empty; SqlCommand cmd = null; try { using (con = new SqlConnection(conStr)) { con.Open(); //Check the reviewer is logged in or the user is logged in. based on this we need to generate the list //if (Common.GetUser.IsNormalUser) sqlCmd = StaticData.GET_WORKMAINT_PENDING_SUBMIT; //else sqlCmd = StaticData.GET_WORKMAINT_PENDING_REVIEW; using (cmd = new SqlCommand(sqlCmd, con)) { cmd.CommandType = System.Data.CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@CreatedBy", Common.GetUser.UserId); cmd.Parameters.AddWithValue("@Team", String.IsNullOrEmpty(Team)? Common.GetUser.AssignedTeam : Team); SqlDataReader rdr = cmd.ExecuteReader(); while (rdr.Read()) { WorkMaint e = new WorkMaint(); e.WorkItemId = Convert.ToInt32(rdr["workitemid"]); e.ActivityId = Convert.ToInt32(rdr["activityid"]); e.InvoiceNumber = Convert.ToString(rdr["invoice_number"]); e.ActivityName = Convert.ToString(rdr["activityname"]); e.RequestNumber = Convert.ToString(rdr["request_number"]); e.Comments = Convert.ToString(rdr["comments"]); e.UserId = Convert.ToString(rdr["userid"]); e.StartedDate = Convert.ToDateTime(rdr["starteddate"]); e.Status = Convert.ToString(rdr["itemstatus"]); wm.Add(e); } workms.WorkMaintList = wm; rdr.NextResult(); while (rdr.Read()) { Activities a = new Activities(); a.activityid = Convert.ToInt32(rdr["activityid"]); a.description = Convert.ToString(rdr["description"]); act.Add(a); } workms.Activities.lst = act; CloseReader(rdr); workms._success = true; } } } catch (Exception ex) { workms._message = FinTrackRes.WM_RETRIEVE_ERR; Logger.Log(Logger.LogType.Error, ex.ToString()); } return(workms); }