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