public string PutSessionReportDTL([FromBody] SessionReportModel obj)
{
return(SR.PutSessionReportDTL(obj));
}
public string PutSessionReportDTL(SessionReportModel obj)
{
try
{
string Msg = "";
using (SqlConnection con = new SqlConnection(connectionString))
{
if (obj.ReportStatus == "Draft" || obj.ReportStatus == "Approved")
{
SqlCommand cmd = new SqlCommand("SP_Insert_Udate_Delete_SessionReport", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Type", "UPDATE");
cmd.Parameters.AddWithValue("@CDF_ID", obj.CDF_ID);
cmd.Parameters.AddWithValue("@Session_ID", obj.Session_ID);
// cmd.Parameters.AddWithValue("@ReportVersion", obj.ReportVersion);
cmd.Parameters.AddWithValue("@ReportStatus", obj.ReportStatus);
// cmd.Parameters.AddWithValue("@ReportPreparedBy", obj.CDF_ID);
// cmd.Parameters.AddWithValue("@Stud_Strengths", obj.Stud_Strengths);
string Strengths = "";
for (int a = 0; a < obj.Stud_Strengths.Count(); a++)
{
Strengths = Strengths + "," + obj.Stud_Strengths[a];
// cmd.Parameters.AddWithValue("@Stud_Strengths", ans);
}
cmd.Parameters.AddWithValue("@Stud_Strengths", Strengths);
// cmd.Parameters.AddWithValue("@Stud_Personality_Traits", obj.Stud_Personality_Traits);
string Traits = "";
for (int b = 0; b < obj.Stud_Personality_Traits.Count(); b++)
{
Traits = Traits + "," + obj.Stud_Personality_Traits[b];
}
cmd.Parameters.AddWithValue("@Stud_Personality_Traits", Traits);
cmd.Parameters.AddWithValue("@AreaAdvantage", obj.AreaAdvantage);
cmd.Parameters.AddWithValue("@Motivators", obj.Motivators);
cmd.Parameters.AddWithValue("@GeneralAbilities", obj.GeneralAbilities);
cmd.Parameters.AddWithValue("@LeadershipType", obj.LeadershipType);
cmd.Parameters.AddWithValue("@WaySetGoals", obj.WaySetGoals);
cmd.Parameters.AddWithValue("@WayStudy", obj.WayStudy);
cmd.Parameters.AddWithValue("@WayCommunicate", obj.WayCommunicate);
cmd.Parameters.AddWithValue("@MentalAbilities", obj.MentalAbilities);
cmd.Parameters.AddWithValue("@Creativities", obj.Creativities);
cmd.Parameters.AddWithValue("@PhysicalAbilities", obj.PhysicalAbilities);
cmd.Parameters.AddWithValue("@Skills", obj.Skills);
cmd.Parameters.AddWithValue("@CareerCategory", obj.CareerCategory);
cmd.Parameters.AddWithValue("@OccupationalCategory", obj.OccupationalCategory);
cmd.Parameters.AddWithValue("@Career", obj.Career);
cmd.Parameters.AddWithValue("@ReviewComment", obj.ReviewComment);
// cmd.Parameters.AddWithValue("@Recommendations", obj.Recommendations);
con.Open();
int i = cmd.ExecuteNonQuery();
if (i > 0)
{
Msg = "Success";
}
else
{
Msg = "Fail";
}
return(Msg);
}
if (obj.ReportStatus == "Rejected")
{
SqlCommand cmd = new SqlCommand("SP_Insert_Udate_Delete_SessionReport", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Type", "REJECTED");
cmd.Parameters.AddWithValue("@CDF_ID", obj.CDF_ID);
cmd.Parameters.AddWithValue("@Session_ID", obj.Session_ID);
// cmd.Parameters.AddWithValue("@ReportVersion", obj.ReportVersion);
cmd.Parameters.AddWithValue("@ReportStatus", obj.ReportStatus);
// cmd.Parameters.AddWithValue("@ReportPreparedBy", obj.CDF_ID);
cmd.Parameters.AddWithValue("@Stud_Strengths", obj.Stud_Strengths);
cmd.Parameters.AddWithValue("@Stud_Personality_Traits", obj.Stud_Personality_Traits);
cmd.Parameters.AddWithValue("@AreaAdvantage", obj.AreaAdvantage);
cmd.Parameters.AddWithValue("@Motivators", obj.Motivators);
cmd.Parameters.AddWithValue("@GeneralAbilities", obj.GeneralAbilities);
cmd.Parameters.AddWithValue("@LeadershipType", obj.LeadershipType);
cmd.Parameters.AddWithValue("@WaySetGoals", obj.WaySetGoals);
cmd.Parameters.AddWithValue("@WayStudy", obj.WayStudy);
cmd.Parameters.AddWithValue("@WayCommunicate", obj.WayCommunicate);
cmd.Parameters.AddWithValue("@MentalAbilities", obj.MentalAbilities);
cmd.Parameters.AddWithValue("@Creativities", obj.Creativities);
cmd.Parameters.AddWithValue("@PhysicalAbilities", obj.PhysicalAbilities);
cmd.Parameters.AddWithValue("@Skills", obj.Skills);
cmd.Parameters.AddWithValue("@CareerCategory", obj.CareerCategory);
cmd.Parameters.AddWithValue("@OccupationalCategory", obj.OccupationalCategory);
cmd.Parameters.AddWithValue("@Career", obj.Career);
cmd.Parameters.AddWithValue("@ReviewComment", obj.ReviewComment);
// cmd.Parameters.AddWithValue("@Recommendations", obj.Recommendations);
con.Open();
int i = cmd.ExecuteNonQuery();
if (i > 0)
{
Msg = "Success";
}
else
{
Msg = "Fail";
}
}
return(Msg);
}
}
catch (Exception ex)
{
Log.Error(ex);
return("Fail");
}
}
