protected void ManListview_ItemCommand(object sender, ListViewCommandEventArgs e)
{
if (e.CommandName == "Link")
{
itemcommand = manstring;
ListViewItem itemClicked = e.Item;
// Find Controls/Retrieve values from the item here
Label c = (Label)itemClicked.FindControl("ManID");
PK_MAN = Convert.ToInt32(c.Text);
string query = "SELECT [Remarks] FROM " + MRPClass.ManpowerTableLogs() + " WHERE MasterKey = '" + PK_MAN + "' 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.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;
}
