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