protected void CapexListview_ItemCommand(object sender, ListViewCommandEventArgs e) { if (e.CommandName == "Link") { itemcommand = capexstring; ListViewItem itemClicked = e.Item; // Find Controls/Retrieve values from the item here Label c = (Label)itemClicked.FindControl("CapexID"); PK_CAPEX = Convert.ToInt32(c.Text); string query = "SELECT [Remarks] FROM " + MRPClass.CapexTableLogs() + " WHERE MasterKey = '" + PK_CAPEX + "' AND UserKey = '" + Session["CreatorKey"].ToString() + "'"; SqlConnection conn = new SqlConnection(GlobalClass.SQLConnString()); conn.Open(); SqlCommand comm = new SqlCommand(query, conn); SqlDataReader reader = comm.ExecuteReader(); bool empty = true; while (reader.Read()) { LogsMemo.Text = reader[0].ToString(); LogsMemo.Focus(); empty = false; } if (empty) { LogsMemo.Enabled = true; LogsMemo.Text = ""; LogsMemo.Focus(); } conn.Close(); LogsPopup.HeaderText = "Comment"; LogsPopup.ShowOnPageLoad = true; } }
protected void LogsBtn_Click(object sender, EventArgs e) { string tablename = ""; int PK = 0; if (itemcommand == matstring) { tablename = MRPClass.MaterialsTableLogs(); PK = PK_MAT; } else if (itemcommand == opexstring) { tablename = MRPClass.OpexTableLogs(); PK = PK_OPEX; } else if (itemcommand == manstring) { tablename = MRPClass.ManpowerTableLogs(); PK = PK_MAN; } else if (itemcommand == capexstring) { tablename = MRPClass.CapexTableLogs(); PK = PK_CAPEX; } else if (itemcommand == revstring) { tablename = MRPClass.RevenueTableLogs(); PK = PK_REV; } if (PK == 0) { return; } //Query if log exist string query = "SELECT COUNT(*) FROM " + tablename + " WHERE MasterKey = '" + PK + "' AND UserKey = '" + Session["CreatorKey"].ToString() + "'"; SqlConnection conn = new SqlConnection(GlobalClass.SQLConnString()); conn.Open(); SqlCommand comm = new SqlCommand(query, conn); int count = Convert.ToInt32(comm.ExecuteScalar()); //MRPClass.PrintString(tablename + PK + count + LogsMemo.Text); if (count > 0)//edit { string update = "UPDATE " + tablename + " SET [Remarks] = @Remarks WHERE [MasterKey] = '" + PK + "' AND UserKey = '" + Session["CreatorKey"].ToString() + "'"; SqlCommand cmd = new SqlCommand(update, conn); cmd.Parameters.AddWithValue("@Remarks", LogsMemo.Text); cmd.CommandType = CommandType.Text; cmd.ExecuteNonQuery(); } else//add { string insert = "INSERT INTO " + tablename + " ([MasterKey], [UserKey], [Remarks]) VALUES (@MasterKey, @UserKey, @Remarks)"; SqlCommand cmd = new SqlCommand(insert, conn); cmd.Parameters.AddWithValue("@MasterKey", PK); cmd.Parameters.AddWithValue("@UserKey", Convert.ToInt32(Session["CreatorKey"])); cmd.Parameters.AddWithValue("@Remarks", LogsMemo.Text); cmd.CommandType = CommandType.Text; cmd.ExecuteNonQuery(); } conn.Close(); LogsPopup.ShowOnPageLoad = false; }