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);
}
