Exemple #1
0
    public int GetCostingStyleInfoByUser(int userId)
    {
        DataTable     dt       = null;
        StringBuilder tableRow = new StringBuilder();

        int GetCostingStyleInfoByUserCount = 0;

        try
        {
            using (ProfileGateway profileGateway = new ProfileGateway())
            {
                int count = 0;
                dt = profileGateway.GetCostingStyleInfoByUser(userId);
                GetCostingStyleInfoByUserCount = dt.Rows.Count;
                if (dt.Rows.Count > 0)
                {
                    tableRow.Append("<table class='table table-bordered'><thead><tr class='success'>" +
                                    "<th>Serial No</th>" +
                                    "<th>Style Number</th>" +
                                    "<th>Revision</th>" +
                                    "</tr></thead >");
                    for (int i = 0; i < dt.Rows.Count; i++)
                    {
                        count++;

                        tableRow.Append("<tbody><tr>");

                        int Revision = Convert.ToInt32(dt.Rows[i]["TotalCountOfSampleStage"]) - 1;

                        tableRow.Append("<td>" + count + "</td>");
                        tableRow.Append("<td>" + dt.Rows[i]["StyleNumber"] + "</td>");
                        tableRow.Append("<td>" + Revision + "</td>");

                        tableRow.Append("</tr></tbody>");
                    }
                    tableRow.Append("</table>");
                }
                else
                {
                    tableRow.Append("No Data Found");
                }
            }
        }
        catch (Exception ex)
        {
        }
        //return tableRow.ToString();
        return(GetCostingStyleInfoByUserCount);
    }
Exemple #2
0
    public DataTable GetUsersPerformance(int userId)
    {
        DataTable dt = null;

        try
        {
            using (ProfileGateway profileGateway = new ProfileGateway())
            {
                dt = profileGateway.GetUsersPerformance(userId);
            }
        }
        catch (Exception ex)
        {
        }
        return(dt);
    }
Exemple #3
0
    public int GetBulkSampleInfoByUser(int userId)
    {
        int           GetBulkSampleInfoByUserCount = 0;
        DataTable     dt       = null;
        StringBuilder tableRow = new StringBuilder();

        try
        {
            using (ProfileGateway profileGateway = new ProfileGateway())
            {
                int count = 0;
                dt = profileGateway.GetBulkSampleInfoByUser(userId);
                GetBulkSampleInfoByUserCount = Convert.ToInt32(dt.Rows[0]["RevisedBulk"]);
                //if (dt.Rows.Count > 0)
                //{
                //    tableRow.Append("<table class='table table-bordered'><thead><tr class='success'>" +
                //                    "<th>Serial No</th>" +
                //                    "<th>Style Number</th>" +
                //                    "<th>Revision name</th>" +
                //                    "<th>Posted Date</th>" +
                //                    "</tr></thead >");
                //    for (int i = 0; i < dt.Rows.Count; i++)
                //    {
                //        count++;

                //        tableRow.Append("<tbody><tr>");

                //        tableRow.Append("<td>" + count + "</td>");
                //        tableRow.Append("<td>" + dt.Rows[i]["StyleNumber"] + "</td>");
                //        tableRow.Append("<td>" + dt.Rows[i]["SampleStageName"] + "</td>");
                //        tableRow.Append("<td>" + dt.Rows[i]["PostedOn"] + "</td>");
                //        tableRow.Append("</tr></tbody>");
                //    }
                //    tableRow.Append("</table>");
                //}
                //else
                //{
                //    tableRow.Append("No Data Found");
                //}
            }
        }
        catch (Exception ex)
        {
        }
        return(GetBulkSampleInfoByUserCount);
    }
 public ProfileManager()
 {
     profileGateway = new ProfileGateway();
 }