protected void GVAssignedOperator_RowCommand(object sender, GridViewCommandEventArgs e) { string ID = string.Empty; ID = Convert.ToString(e.CommandArgument); if (e.CommandName.Equals("EditOperator")) { hdID.Value = ID; MPAssignOperator.Show(); getOperatorDetails(ID); } if (e.CommandName.Equals("DeleteOperator")) { object res = null; SqlParameter[] Existsparam = new SqlParameter[] { new SqlParameter("@OPR", 3), new SqlParameter("@ID", ID) }; res = DBClass.ExecuteScalar_WithParam(Existsparam, "DM_SP_ADD_ASSIGNED_OPERATOR_DATA"); if (res.ToString() == "SUCCESS") { Response.Write("<script> alert('Operator details deleted successfully!'); </script>"); } BindAssignedOperator(); } }
protected void btnAssignOperator_Click(object sender, EventArgs e) { lblOperatorMessage.Text = string.Empty; BindStations(); BindOperators(); BindOperatorsGrd(); MPAssignOperator.Show(); }
protected void btnAddOperator_Click(object sender, EventArgs e) { lblOperatorMessage.Text = string.Empty; if (drpStation.SelectedValue == "") { lblOperatorMessage.Text = "Please select Station"; lblOperatorMessage.ForeColor = Color.Red; } else if (drpOperator.SelectedValue == "") { lblOperatorMessage.Text = "Please select Name"; lblOperatorMessage.ForeColor = Color.Red; } else if (drpType.SelectedValue == "") { lblOperatorMessage.Text = "Please select Type"; lblOperatorMessage.ForeColor = Color.Red; } else { object result; SqlParameter[] param = new SqlParameter[] { new SqlParameter("@OPR", 4), new SqlParameter("@PlantCode", lblplantcode.Text), new SqlParameter("@Line", lblline.Text), new SqlParameter("@Date", lbldate.Text), new SqlParameter("@ShiftCode", lblshift.Text), new SqlParameter("@StationCode", Convert.ToString(drpStation.SelectedValue)), new SqlParameter("@OperatorName", Convert.ToString(drpOperator.SelectedValue)), new SqlParameter("@Type", Convert.ToString(drpType.SelectedValue)), new SqlParameter("@CreatedBy", Convert.ToString(Session["username"])) }; result = DBClass.ExecuteScalar_WithParam(param, "DM_SP_DML_DATA"); if (Convert.ToInt64(result) > 0) { lblOperatorMessage.Text = "Operator added successfully."; lblOperatorMessage.ForeColor = Color.Green; ClearOperator(); BindOperatorsGrd(); } else if (Convert.ToInt64(result) == -1) { lblOperatorMessage.Text = "Station & Name already added."; lblOperatorMessage.ForeColor = Color.Red; } else { lblOperatorMessage.Text = "Error, Something went wrong!"; lblOperatorMessage.ForeColor = Color.Red; } } MPAssignOperator.Show(); }
protected void lnkDeleteAO_Click(object sender, EventArgs e) { try { ImageButton lnkDeleteAO = (ImageButton)sender; var deleteID = lnkDeleteAO.CommandArgument; SqlParameter[] param = new SqlParameter[] { new SqlParameter("@OPR", "8"), new SqlParameter("@DeleteID", deleteID) }; DataTable Dt = new DataTable(); DBClass.ExecuteNonQuery_WithParam(param, "DM_SP_DML_DATA"); BindOperatorsGrd(); lblOperatorMessage.Text = "Deleted Successfully."; lblOperatorMessage.ForeColor = Color.Green; } catch (Exception ex) { _logger.Error(string.Concat("lnkDeleteAO_Click::", ex.Message), ex); } MPAssignOperator.Show(); }