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)); }
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(); }
private void InsertExcelRecords(string FilePath) { lblmessage.Text = ""; DataSet dsmain = new DataSet(); string fileUniqName = Server.MapPath("~/_EmployeeData/" + Guid.NewGuid().ToString() + ".xls"); if (Path.GetExtension(UploadXlsData.PostedFile.FileName) == ".xls") { UploadXlsData.SaveAs(fileUniqName); System.Data.OleDb.OleDbConnection MyConnection = default(System.Data.OleDb.OleDbConnection); System.Data.OleDb.OleDbDataAdapter MyCommand = default(System.Data.OleDb.OleDbDataAdapter); MyConnection = new System.Data.OleDb.OleDbConnection("provider=Microsoft.ACE.OLEDB.12.0; Data Source = " + fileUniqName + "; Extended Properties = Excel 8.0;"); MyCommand = new System.Data.OleDb.OleDbDataAdapter("select * from [Sheet1$]", MyConnection); MyCommand.TableMappings.Add("Table", "TestTable"); MyConnection.Open(); DtSet = new System.Data.DataSet(); MyCommand.Fill(DtSet); ADSTesting.Classes.Sql.CommonClass obj = new ADSTesting.Classes.Sql.CommonClass(); dsmain = obj.SaveEmployeeDailyWorkStatus(GetEmployeeDailyWorkStatusXML()); MyConnection.Close(); lblmessage.Text = dsmain.Tables[0].Rows[0]["MSG"].ToString(); Response.Write("<script>alert('" + dsmain.Tables[0].Rows[0]["MSG"].ToString() + "');</script>"); this.Controls.Add(new LiteralControl("<script type='text/javascript'>SaveDailyStatusOnJs();</script>")); } else { lblmessage.Text = "Please Upload Only Excel(.xls) File"; } }
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(); } }
public string GetJsonDaysMonthWiseData() { System.Data.DataSet dsmain; string Action = ""; if (TransType == "") { Action = "GraphMonthWise"; } else { Action = "GraphTeamMonthWise"; } string UserId = drpEmployeeName.SelectedValue; string Dataformat = "dd/mm/yyyy"; string Extra1 = "", Extra2 = "", Extra3 = "", Extra4 = "", Extra5 = ""; dsmain = null; string[] parameterValueArray = new string[] { Action, UserId, Dataformat, Extra1, Extra2, Extra3, Extra4, Extra5 }; string procedureName = "SpDashBoardGrap"; ADSTesting.Classes.Sql.CommonClass obj = new ADSTesting.Classes.Sql.CommonClass(); dsmain = obj.DynamicBindProcedure(procedureName, parameterValueArray); DataTableReader rd = dsmain.Tables[0].CreateDataReader(); StringBuilder JSON = new StringBuilder(); string prefix = ""; int c = 1; string DayTextString = ""; JSON.Append("["); while (rd.Read()) { DayTextString = rd[1].ToString(); JSON.Append(prefix); JSON.Append("\"" + DayTextString + "\""); prefix = " ,"; c++; } JSON.Append("]"); return(JSON.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(); } }