public string Update_Goal(Goal_Line GM, string Emp_Desc)
{
string res = "";
try
{
connection();
SqlCommand cmd = new SqlCommand("Prc_UpdateGoal", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@ID", GM.Id);
cmd.Parameters.AddWithValue("@SELF_RATING", GM.SelfRating);
cmd.Parameters.AddWithValue("@SELF_REMARK", GM.SelfRemark);
cmd.Parameters.AddWithValue("@EMP_DESC", Emp_Desc);
SqlParameter oblogin = new SqlParameter();
oblogin.ParameterName = "@MESSAGE";
oblogin.SqlDbType = SqlDbType.NVarChar;
oblogin.Size = 50;
oblogin.Direction = ParameterDirection.Output;
cmd.Parameters.Add(oblogin);
con.Open();
cmd.ExecuteNonQuery();
res = oblogin.Value.ToString();
con.Close();
return(res);
}
catch (Exception ex)
{
res = ex.Message;
}
return(res);
}
public string Apply_Goal(Goal_Line GM, string Emp_Desc, string Mgr_Desc, int Emp_Id, string QUARTER, int YEAR)
{
string res = "";
int ID = 0;
try
{
connection();
SqlCommand cmd = new SqlCommand("Prc_ApplyGoal", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@ID", ID);
cmd.Parameters.AddWithValue("@GOAL_ID", GM.GoalId);
cmd.Parameters.AddWithValue("@EMP_ID", Emp_Id);
cmd.Parameters.AddWithValue("@SELF_RATING", GM.SelfRating);
cmd.Parameters.AddWithValue("@SELF_REMARK", GM.SelfRemark);
cmd.Parameters.AddWithValue("@MANAGER_RATING", GM.ManagerRating);
cmd.Parameters.AddWithValue("@MANAGER_REMARK", GM.ManagerRemark);
cmd.Parameters.AddWithValue("@EMP_DESC", Emp_Desc);
cmd.Parameters.AddWithValue("@MGR_DESC", Mgr_Desc);
cmd.Parameters.AddWithValue("@QUARTER", QUARTER);
cmd.Parameters.AddWithValue("@YEAR", YEAR);
SqlParameter oblogin = new SqlParameter();
oblogin.ParameterName = "@MESSAGE";
oblogin.SqlDbType = SqlDbType.NVarChar;
oblogin.Size = 50;
oblogin.Direction = ParameterDirection.Output;
cmd.Parameters.Add(oblogin);
con.Open();
cmd.ExecuteNonQuery();
res = oblogin.Value.ToString();
con.Close();
return(res);
}
catch (Exception ex)
{
res = ex.Message;
}
return(res);
}
