public bool DeactivateAllEmployees()
{
sQuery = "update RTM_Master_UserList set MUL_ActiveStatus =0";
bool result = objDB.DBExecuteNoNQuery(sQuery);
return(result);
}
public bool UpdateRecordLog(string _fileId, string _newValue, string _modifiedBy)
{
bool result;
string sQuery = " update EMSDB_Log set Log_NewValue='" + _newValue + "',Log_ModifiedBy='" + _modifiedBy + "',Log_ModifiedOn='" + DateTime.Now + "' where Log_FileId=" + _fileId + " and Log_NewValue='" + _newValue + "'";
result = objDB.DBExecuteNoNQuery(sQuery);
return(result);
}
private void PrintReport()
{
//DataRow dr;
// BuildTable();
ds = getRecords1();
if (ds.Tables["records"].Rows.Count > 0)
{
foreach (DataRow dr1 in ds.Tables["records"].Rows)
{
int count = 0;
ds = getCountOfOrders1(Convert.ToInt32(dr1["R_ID"]));
if (ds.Tables["count"].Rows.Count > 0)
{
if (ds.Tables["count"].Rows[0]["SKU_IdCount"].ToString().Length > 0)
{
count = Convert.ToInt32(ds.Tables["count"].Rows[0]["SKU_IdCount"]);
}
}
SqlParameter[] param = new SqlParameter[]
{
new SqlParameter("@client", dr1["CL_ClientName"].ToString()),
new SqlParameter("@task", dr1["TL_Task"].ToString()),
new SqlParameter("@subtask", dr1["STL_SubTask"].ToString()),
new SqlParameter("@count", count),
new SqlParameter("@user", dr1["R_User_Name"].ToString())
};
SQlQuery = "INSERT INTO RTM_HourlyTaskTemp (Client, Task, SubTask, CountOfOrders, username) values (@client, @task, @subtask, @count, @user)";
bool result1 = objDB.ExecuteNonQuery(SQlQuery, CommandType.Text, param);
//dr = dtResult.NewRow();
//dr["Client"] = dr1["CL_ClientName"];
//dr["Task"] = dr1["TL_Task"];
//dr["SubTask"] = dr1["STL_SubTask"];
//ds = getCountOfOrders(Convert.ToInt32(dr1["R_ID"]));
//if (ds.Tables["count"].Rows.Count > 0)
//{
// dr["CountOfOrders"] = ds.Tables["count"].Rows[0]["SKU_IdCount"].ToString();
//}
//else
//{
// dr["CountOfOrders"] = "0";
//}
//dr["Date"] = txtFrom.Text ;
//dr["StartTime"] = txtFromTime.Text ;
//dr["EndTime"] = txtToTime.Text ;
//dtResult.Rows.Add(dr);
}
dt = new DataTable();
dt = getHourlyTasks();
SQlQuery = "TRUNCATE TABLE RTM_HourlyTaskTemp";
result = objDB.DBExecuteNoNQuery(SQlQuery);
if (dt.Rows.Count > 0)
{
Response.Clear();
Response.Buffer = true;
Response.AddHeader("content-disposition", "attachment;filename=HourlyTaskReport-(" + Convert.ToDateTime(txtFrom.Text + " " + txtFromTime.Text) + " to " + Convert.ToDateTime(txtFrom.Text + " " + txtFromTime.Text).AddHours(Convert.ToDouble(ddlHours.SelectedItem.Text)) + ") .csv");
Response.Charset = "";
Response.ContentType = "application/text";
StringBuilder sb = new StringBuilder();
checked
{
for (int k = 0; k < dt.Columns.Count; k++)
{
//add separator
sb.Append(dt.Columns[k].ColumnName + ',');
}
}
sb.Append("\r\n");
checked
{
for (int i = 0; i < dt.Rows.Count; i++)
{
for (int k = 0; k < dt.Columns.Count; k++)
{
//add separator
sb.Append(dt.Rows[i][k].ToString().Replace(",", ";") + ',');
}
//append new line
sb.Append("\r\n");
}
}
Response.Output.Write(sb.ToString());
Response.Flush();
Response.End();
}
else
{
lblError.Text = "No data found";
lblError.ForeColor = System.Drawing.Color.Red;
}
//var query = (from r in dtResult.AsEnumerable()
// select new
// {
// Client = r.Field<string>("Client"),
// Task = r.Field<string>("Client"),
// SubTask = r.Field<string>("SubTask"),
// CountOfOrders = r.Field<int>("CountOfOrders")
// }).Distinct();
//string strScript;
//Session["rptSrc"] = dtResult;
//strScript = "<script language=javascript>window.open('OrderDeskHourlyTaskReportDisplay.aspx')</script>";
//ClientScript.RegisterClientScriptBlock(this.GetType(), "strScript", strScript);
}
}