Пример #1
0
        /*Reports related*/
        public WMRPTErrViewModel GetErrorsReport()
        {
            WMRPTErrViewModel objErr = new WMRPTErrViewModel(FinTrackRes.WM_REPORT_LOAD_ERR, false);

            try
            {
                using (con = new SqlConnection(conStr))
                {
                    con.Open();
                    SqlCommand cmd = new SqlCommand(StaticData.UPDATE_REVIEWER_WORKMAINTENANCE, con);
                    cmd.CommandType = System.Data.CommandType.StoredProcedure;
                    //cmd.Parameters.AddWithValue("@workitemid", data.WorkItemId);
                    //cmd.Parameters.AddWithValue("@userid", Common.GetUser.UserId);
                    //cmd.Parameters.AddWithValue("@revcomments", data.ReviewerComments);
                    //cmd.Parameters.AddWithValue("@starteddate", DateTime.Now);
                    //cmd.Parameters.AddWithValue("@itemstatus", data.Status);
                    //cmd.Parameters.AddWithValue("@usertype", "Reviewer"); //Hard coding this because this will be used only by the reviewer.
                    //cmd.Parameters.AddWithValue("@iserrorfound", data.ErrFound);
                    SqlDataReader rdr = cmd.ExecuteReader();
                }
            }
            catch (Exception ex)
            {
                Logger.Log(Logger.LogType.Error, ex.ToString());
            }
            return(null);
        }
Пример #2
0
 public ActionResult generateFile(WMReportInputs input)
 {
     try
     {
         Response.Cookies.Remove("fileDownload");
         repository        objRep = new repository();
         WMRPTErrViewModel rep    = objRep.GetHistory(input);
         XLExport          objExp = new XLExport(rep);
         string            flName = objExp.ExcelExport();
         return(Json(new { success = true, fileName = flName }, JsonRequestBehavior.AllowGet));
     }
     catch (Exception ex)
     {
         throw ex;
     }
 }
Пример #3
0
        public WMRPTErrViewModel GetHistory(WMReportInputs input)
        {
            WMRPTErrViewModel objErr = new WMRPTErrViewModel(FinTrackRes.WM_REPORT_LOAD_ERR, false);

            try
            {
                using (con = new SqlConnection(conStr))
                {
                    con.Open();
                    SqlCommand cmd = new SqlCommand(StaticData.GET_REPORT_BY_DATE_AR, con);
                    //based on the team we can generate the report, same properties can be used for all the teams.
                    if (input.TeamName == "ap")
                    {
                        cmd.CommandText = StaticData.GET_REPORT_BY_DATE_AP;
                    }

                    cmd.CommandType    = System.Data.CommandType.StoredProcedure;
                    cmd.CommandTimeout = 0;
                    cmd.Parameters.AddWithValue("@startdt", input.RptDate);
                    //if end date is there then pass that also
                    cmd.Parameters.Add(new SqlParameter("@enddate", input.EndDate));
                    SqlDataReader rdr = cmd.ExecuteReader();
                    //initialize all the lists.
                    objErr.lst      = new List <WMHistory>();
                    objErr.plst     = new List <WMReportTimeTaken>();
                    objErr.rlst     = new List <WMReportReviewerTime>();
                    objErr.psummary = new List <WMReportProcessorSummary>();
                    objErr.rDlst    = new List <WMReportReviewerData>();
                    while (rdr.Read())
                    {
                        objErr.lst.Add(new WMHistory()
                        {
                            WorkItemId       = Convert.ToInt32(rdr["Work Item Id"]),
                            ActivityName     = Convert.ToString(rdr["Description"]),
                            InvoiceNumber    = Convert.ToString(rdr["Invoice#"]),
                            RequestNumber    = Convert.ToString(rdr["Request#"]),
                            Comments         = Convert.ToString(rdr["Comments"]),
                            CreatedBy        = Convert.ToString(rdr["Created By"]),
                            ReviewedBy       = Convert.ToString(rdr["Reviewer"]),
                            ReviewerComments = Convert.ToString(rdr["Review Comments"]),
                            ErrFound         = Convert.ToBoolean(rdr["Error Found"]),
                            StartedDate      = Convert.ToDateTime(rdr["Stamp"]),
                            PresentStatus    = Convert.ToString(rdr["status"])
                        });
                    }
                    rdr.NextResult();
                    while (rdr.Read())
                    {
                        objErr.plst.Add(new WMReportTimeTaken()
                        {
                            WorkItemId    = Convert.ToInt32(rdr["Work Item Id"]),
                            ActivityName  = Convert.ToString(rdr["Description"]),
                            InvoiceNumber = Convert.ToString(rdr["Invoice#"]),
                            RequestNumber = Convert.ToString(rdr["Request#"]),
                            UserId        = Convert.ToString(rdr["Created By"]),
                            TimeTaken_Sec = Convert.ToInt32(rdr["timetaken"])
                        });
                    }
                    //new result set which is bringing the Totals of groups.
                    rdr.NextResult();
                    while (rdr.Read())
                    {
                        objErr.psummary.Add(new WMReportProcessorSummary()
                        {
                            ProcessorName  = Convert.ToString(rdr["created By"]),
                            Description    = Convert.ToString(rdr["Description"]),
                            TotalTimeTaken = Convert.ToDecimal(rdr["Total Timespent"])
                        });
                    }

                    rdr.NextResult();
                    while (rdr.Read())
                    {
                        objErr.rlst.Add(new WMReportReviewerTime()
                        {
                            ReviewerName  = Convert.ToString(rdr["Reviewer"]),
                            TimeTaken_Sec = Convert.ToInt32(rdr["timetaken"])
                        });
                    }

                    rdr.NextResult();
                    while (rdr.Read())
                    {
                        objErr.rDlst.Add(new WMReportReviewerData()
                        {
                            UserId        = Convert.ToString(rdr["UserId"]),
                            WorkItemId    = Convert.ToInt32(rdr["workitemid"]),
                            ActivityName  = Convert.ToString(rdr["ActivityName"]),
                            InvoiceNumber = Convert.ToString(rdr["InvoiceNumber"]),
                            RequestNumber = Convert.ToString(rdr["RequestNumber"]),
                            ReviewerName  = Convert.ToString(rdr["Reviewer"]),
                            TimeTaken_Sec = Convert.ToInt32(rdr["TimeTaken_Sec"]),
                            Comments      = Convert.ToString(rdr["comments"]),
                            StartTime     = Convert.ToDateTime(rdr["StartTime"]),
                            EndTime       = Convert.ToDateTime(rdr["EndTime"]),
                            ErrorFound    = Convert.ToBoolean(rdr["iserrorfound"])
                        });
                    }

                    objErr._success = true;
                    CloseReader(rdr);
                }
            }
            catch (Exception ex)
            {
                Logger.Log(Logger.LogType.Error, ex.ToString());
                throw ex;
            }
            return(objErr);
        }
Пример #4
0
 /// <summary>
 /// On Screen Report constructor
 /// </summary>
 /// <param name="data"></param>
 public XLExport(WMRPTErrViewModel data)
 {
     _dataToExport = data;
 }