protected void Button_Save_Click(object sender, EventArgs e) { try { Error.Visible = false; GenDoc myDoc = new GenDoc(); ScriptManager.RegisterClientScriptBlock(Page, typeof(Page), "ClientScript", "alert('function disabled; Are you sure that you want to save ? ')", true); string _tableName = txtTableName.Text; List <string> myData = new List <string>(); string[] records = TextBox_Details.Text.Split('\r'); for (int i = 0; i < records.Length; i++) { myData.Add(records[i].ToString().Trim()); } DB_Operations con = new DB_Operations(); myDoc = new GenDoc(myData); //SqlCommand objcmd = new SqlCommand("Insert into Interview values ('" + myData + "')"); int retcode = con.InsertUpdateDeleteQry("Insert into Interview values ('" + myData + "')"); int retcode2 = con.InsertUpdateDeleteQry("Insert into Interview values ('" + myDoc + "')"); } catch (Exception ex) { Error.Visible = true; } }
protected void Button1_Click(object sender, EventArgs e) { int EMP_ID = Convert.ToInt32(HttpContext.Current.Session["user"]); string res = "select * from Timesheets where Emp_ID=" + EMP_ID + " and week_id=(select max(week_id) from timesheets where Emp_ID=" + EMP_ID + ")"; DataTable s = db.SelectQry(res); y = s.Rows[0]; List <Int32> hourslist = new List <int>(); hourslist.Add(Convert.ToInt32(TextBox1.Text)); hourslist.Add(Convert.ToInt32(TextBox2.Text)); hourslist.Add(Convert.ToInt32(TextBox3.Text)); hourslist.Add(Convert.ToInt32(TextBox4.Text)); hourslist.Add(Convert.ToInt32(TextBox5.Text)); Label9.Text = DateTime.Parse(s.Rows[0].ItemArray[6].ToString()).AddDays(7).ToString(); Label10.Text = DateTime.Parse(s.Rows[0].ItemArray[7].ToString()).AddDays(7).ToString(); Label11.Text = (Convert.ToInt32(s.Rows[0].ItemArray[4].ToString()) + 1).ToString(); //label12.Text = y[3]; List <String> hrs = new List <string>(); int totalHours = 0; int docnum = 412; string docNumLatest = "select max(docnum) from Timesheets"; DataTable doc = db.SelectQry(docNumLatest); DataRow docs = doc.Rows[0]; docnum = Convert.ToInt32(docs[0]); docnum = docnum + 1; for (int i = 0; i < hourslist.Count; i++) { totalHours = totalHours + hourslist[i]; string detailsQuery = "INSERT INTO timesheets_details (docnum, doctype, emp_id, day_of_week,hours_worked, numvalue1, numvalue2, comments )" + "Values (" + docnum + ", 41, " + Label8.Text + "," + (i + 1) + ", " + hourslist[i] + ", 0, 0, 'Timesheet details for week day " + (i + 1) + "')"; db.InsertUpdateDeleteQry(detailsQuery); } string start_time = DateTime.Parse(s.Rows[0].ItemArray[6].ToString()).AddDays(7).ToString(); string end_time = DateTime.Parse(s.Rows[0].ItemArray[7].ToString()).AddDays(7).ToString(); string cmdString = "insert into Timesheets (DocNum,DocType, EMp_id, Max_Hours, Week_Id, Total_Hours_Worked, Start_date, End_date, Numvalue1,Numvalue2 ,Comments ) Values " + "(" + docnum + ", 41, " + Label8.Text + ", 40, " + Label11.Text + ", " + totalHours + " ,'" + DateTime.Parse(s.Rows[0].ItemArray[6].ToString()).AddDays(7).ToString() + "' ,'" + DateTime.Parse(s.Rows[0].ItemArray[7].ToString()).AddDays(7).ToString() + "', 0, 0 , 'Timesheet hours for week " + Label11.Text + "')"; db.InsertUpdateDeleteQry(cmdString); //string retMessage = Utilities.DataBaseUtility.Execute(cmdString, value); CalculateGrossPay(Label11.Text, totalHours, EMP_ID, start_time, end_time); Label20.Text = "Successfully updated in timesheet"; }
public static int Execute(IdentityObject ident, string _sqlCommand) { // int retcode = 0; //string _message = "no errors"; //OleDbConnection conn; //conn = GetConnectionObject(); DB_Operations db = new DB_Operations(); try { //if (ident.ActionLevel < 5) //{ // // _message = "command requires a higher permission level than " + ident.ActionLevel + " by user : "******"could not execute " + _sqlCommand; } else { return(0); // "no errors"; } } catch (Exception) { return(2); // (e.ToString()); } }
public static string Execute(string _sqlCommand, IdentityObject ident) { string _message = "no errors"; //OleDbConnection conn; //conn = GetConnectionObject(); //try //{ //if (ident.ActionLevel < 5) //{ // _message = "command requires a higher permission level than " + ident.ActionLevel + " by user : "******"could not execute " + _sqlCommand; return(_message); } else { return("no errors"); } //} //catch (Exception e) //{ // return (e.ToString()); //} //finally }
public static void DeleteEntity(IdentityObject ident, string _tablename, string docNumStr, string docTypeStr) { // OleDbConnection conn = GetConnectionObject(); //if (ident.ActionLevel < 5) //{ // _message = "command requires a higher permission level than " + ident.ActionLevel + " by user : "******"delete from {0} where DocNum = {1} ", _tablename, docNum); //, docType); //where DocNum = {1}",/* and //OleDbCommand cmd = new OleDbCommand(cmdStr, conn); //conn.Open(); //cmd.ExecuteNonQuery(); db.InsertUpdateDeleteQry(cmdStr); } catch (Exception e) { //MessageBox.Show("Error Report: " + e.Message); } //finally //{ // conn.Close(); //} try { int docNum = Int32.Parse(docNumStr); int docType = Int32.Parse(docTypeStr); string cmdStr2 = String.Format("delete from {0}_Details where DocNum = {1} ", _tablename, docNum); //, docType); //where DocNum = {1}",/* and //OleDbCommand cmd2 = new OleDbCommand(cmdStr2, conn); //conn.Open(); //cmd2.ExecuteNonQuery(); db.InsertUpdateDeleteQry(cmdStr2); } catch (Exception) { // MessageBox.Show("Error Report: " + e.Message); } //finally //{ // conn.Close(); //} }