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