예제 #1
0
        protected void btnUpdteRec_Click(object sender, EventArgs e)
        {
            DataSet ds = new DataSet();

            for (int i = 0; i < gvSearch.Rows.Count; i++)
            {
                string Id = ((Label)gvSearch.Rows[i].FindControl("grdlbluniqid")).Text.Trim();
                string TeamId = HdnTeamId.Value;
                string AuditDate = HdnServerDate.Value;
                string PassAdhoc = ((TextBox)gvSearch.Rows[i].FindControl("grdPassAdhoc")).Text.Trim();
                string DmlType = "P";
                string userid = HndUserId.Value;
                string dateformat = "dd/mm/yyyy";
                string extra1 = "", extra2 = "", extra3 = "", extra4 = "", extra5 = "";

                string   procedureName       = "SpGetAdhocForApproved";
                string[] ParameterValueArray = new string[] { Id, TeamId, AuditDate, PassAdhoc, DmlType, userid, dateformat, extra1, extra2, extra3, extra4, extra5 };

                if (ConfigurationManager.AppSettings["ConnectionType"].ToString() == "orcl")
                {
                    ADSTesting.Classes.Oracle.CommonClass obj = new ADSTesting.Classes.Oracle.CommonClass();
                    ds = obj.DynamicBindProcedure(procedureName, ParameterValueArray);
                }
                else
                {
                    ADSTesting.Classes.Sql.CommonClass obj = new ADSTesting.Classes.Sql.CommonClass();
                    ds = obj.DynamicBindProcedure(procedureName, ParameterValueArray);
                }
            }
            Response.Write("<script>alert('" + ds.Tables[0].Rows[0]["MSG"].ToString() + "');</script>");
            BindGridView(0);
        }
        public static string GetUserPref(string[] ParameterValueArray)
        {
            DataSet ds            = new DataSet();
            string  procedureName = "Get_User_Pref";

            if (ConfigurationManager.AppSettings["ConnectionType"].ToString() == "Orcl")
            {
                ADSTesting.Classes.Oracle.CommonClass obj = new ADSTesting.Classes.Oracle.CommonClass();
                ds = obj.DynamicBindProcedure(procedureName, ParameterValueArray);
            }
            else
            {
                ADSTesting.Classes.Sql.CommonClass obj = new ADSTesting.Classes.Sql.CommonClass();
                ds = obj.DynamicBindProcedure(procedureName, ParameterValueArray);
            }

            DataTable dt = new DataTable();

            dt = ds.Tables[0];
            List <Dictionary <string, object> > rows = new List <Dictionary <string, object> >();

            System.Collections.Generic.Dictionary <string, object> row = null;
            foreach (DataRow dr in dt.Rows)
            {
                row = new Dictionary <string, object>();
                foreach (DataColumn col in dt.Columns)
                {
                    row.Add(col.ColumnName.Trim(), dr[col]);
                }
                rows.Add(row);
            }
            System.Web.Script.Serialization.JavaScriptSerializer serializer = new System.Web.Script.Serialization.JavaScriptSerializer();
            return(serializer.Serialize(rows));
        }
예제 #3
0
        private void BindGridView(Int32 currentPage)
        {
            string Id = "";
            string TeamId = HdnTeamId.Value;
            string AuditDate = HdnServerDate.Value;
            string PassAdhoc = "";
            string DmlType = "S";
            string userid = HndUserId.Value;
            string dateformat = "dd/mm/yyyy";
            string extra1 = "", extra2 = "", extra3 = "", extra4 = "", extra5 = "";

            DataSet ds            = new DataSet();
            string  procedureName = "SpGetAdhocForApproved";

            string[] ParameterValueArray = new string[] { Id, TeamId, AuditDate, PassAdhoc, DmlType, userid, dateformat, extra1, extra2, extra3, extra4, extra5 };

            if (ConfigurationManager.AppSettings["ConnectionType"].ToString() == "orcl")
            {
                ADSTesting.Classes.Oracle.CommonClass obj = new ADSTesting.Classes.Oracle.CommonClass();
                ds = obj.DynamicBindProcedure(procedureName, ParameterValueArray);
            }
            else
            {
                ADSTesting.Classes.Sql.CommonClass obj = new ADSTesting.Classes.Sql.CommonClass();
                ds = obj.DynamicBindProcedure(procedureName, ParameterValueArray);
            }
            gvSearch.DataSource = ds;
            gvSearch.DataBind();
        }
        public static DataTable SearchTeam(String name, String nick, Int32 startRowIndex, Int32 maximumRows, string sortExpression)
        {
            DataSet ds            = new DataSet();
            string  procedureName = "SpSearchTeam";

            string[] ParameterValueArray = new string[] { nick, name, startRowIndex.ToString(), maximumRows.ToString(), sortExpression };

            if (ConfigurationManager.AppSettings["ConnectionType"].ToString() == "orcl")
            {
                ADSTesting.Classes.Oracle.CommonClass obj = new ADSTesting.Classes.Oracle.CommonClass();
                ds = obj.DynamicBindProcedure(procedureName, ParameterValueArray);
            }
            else
            {
                ADSTesting.Classes.Sql.CommonClass obj = new ADSTesting.Classes.Sql.CommonClass();
                ds = obj.DynamicBindProcedure(procedureName, ParameterValueArray);
            }

            if (ds != null && ds.Tables.Count > 1)
            {
                _recordCount = Convert.ToInt16(ds.Tables[1].Rows[0][0]);
                return(ds.Tables[0]);
            }

            return(new DataTable());
        }
        private void EmployeeDashboard()
        {
            string ProcedureName = "GetEmployeeDashboardData";

            string TesterEmailID = drpEmployeeName.SelectedValue;
            string AuditDate = txtdate.Text;
            string userid = drpEmployeeName.SelectedValue;
            string dateformat = "dd/mm/yyyy";
            string extra1 = "", extra2 = "", extra3 = "", extra4 = "", extra5 = "";
            string extra6 = "", extra7 = "", extra8 = "", extra9 = "", extra10 = "";

            string[] ParameterValueArray = new string[] { };
            ParameterValueArray = new string[] { TesterEmailID, AuditDate, userid, dateformat, extra1, extra2, extra3, extra4, extra5, extra6, extra7, extra8, extra9, extra10 };
            if (ConfigurationManager.AppSettings["ConnectionType"].ToString() == "Orcl")
            {
                ADSTesting.Classes.Oracle.CommonClass obj = new ADSTesting.Classes.Oracle.CommonClass();
                dsmain = obj.DynamicBindProcedure(ProcedureName, ParameterValueArray);
            }
            else
            {
                ADSTesting.Classes.Sql.CommonClass obj = new ADSTesting.Classes.Sql.CommonClass();
                dsmain = obj.DynamicBindProcedure(ProcedureName, ParameterValueArray);
            }
            if (dsmain.Tables[0].Rows.Count == 0)
            {
                HdnIndividualProductivity.Value = "0" + "%";
                divIndividual.InnerHtml         = "0" + "%";
            }
            else
            {
                HdnIndividualProductivity.Value = dsmain.Tables[0].Rows[0]["IndividualProductivity"].ToString() + "%";
                divIndividual.InnerHtml         = dsmain.Tables[0].Rows[0]["IndividualProductivity"].ToString() + "%";
            }
            if (dsmain.Tables[1].Rows.Count == 0)
            {
                HdnTeamProductivity.Value = "0" + "%";
                divTeam.InnerHtml         = "0" + "%";
            }
            else
            {
                HdnTeamProductivity.Value = dsmain.Tables[1].Rows[0]["TeamProductivity"].ToString() + "%";
                divTeam.InnerHtml         = dsmain.Tables[1].Rows[0]["TeamProductivity"].ToString() + "%";
            }
            if (dsmain.Tables[2].Rows.Count == 0)
            {
                divPendingAdhoc.InnerHtml = "0";
            }
            else
            {
                divPendingAdhoc.InnerHtml = dsmain.Tables[2].Rows[0]["PendingforPassing"].ToString();
            }
        }
        private void BindTeamName()
        {
            drpregisterteamname.Items.Clear();
            drpregisterteamname.Items.Add(new System.Web.UI.WebControls.ListItem("-- Select Team Name --", ""));
            string ProcedureName = "SpGetTeamName";

            string[] ParameterValueArray = new string[] { };
            ParameterValueArray = new string[] { "", "", "", "", "", "" };
            if (ConfigurationManager.AppSettings["ConnectionType"].ToString() == "Orcl")
            {
                ADSTesting.Classes.Oracle.CommonClass obj = new ADSTesting.Classes.Oracle.CommonClass();
                drpregisterteamname.DataSource = obj.DynamicBindProcedure(ProcedureName, ParameterValueArray);
                drpregisterteamname.DataBind();
            }
            else
            {
                ADSTesting.Classes.Sql.CommonClass obj = new ADSTesting.Classes.Sql.CommonClass();
                drpregisterteamname.DataSource = obj.DynamicBindProcedure(ProcedureName, ParameterValueArray);
                drpregisterteamname.DataBind();
            }
        }
        private void BindEmployeeName()
        {
            drpEmployeeName.Items.Clear();
            drpEmployeeName.Items.Add(new System.Web.UI.WebControls.ListItem("-- Select Employee Name --", ""));
            string ProcedureName = "SpGetEmployeeName";

            string[] ParameterValueArray = new string[] { };
            ParameterValueArray = new string[] { Convert.ToString(HttpContext.Current.Session["UserId"]), "", "", "", "", "" };
            if (ConfigurationManager.AppSettings["ConnectionType"].ToString() == "Orcl")
            {
                ADSTesting.Classes.Oracle.CommonClass obj = new ADSTesting.Classes.Oracle.CommonClass();
                drpEmployeeName.DataSource = obj.DynamicBindProcedure(ProcedureName, ParameterValueArray);
                drpEmployeeName.DataBind();
            }
            else
            {
                ADSTesting.Classes.Sql.CommonClass obj = new ADSTesting.Classes.Sql.CommonClass();
                drpEmployeeName.DataSource = obj.DynamicBindProcedure(ProcedureName, ParameterValueArray);
                drpEmployeeName.DataBind();
            }
        }