public bool UpdateShadowSessionAcceptReject(AcceptRejShadow SAR) { try { using (SqlConnection con = new SqlConnection(connectionString)) { bool Res_CDF; if (SAR.ShadowCDFResponse == "Y") { Res_CDF = true; } else { Res_CDF = false; } string strCommand = "update tbl_Session set Shadow_CDF_Acceptance=@ShadowCDF_Acceptance where Shadow_CDFId=@ShadowCDF_Id and Student_Id=@Student_Id"; SqlCommand cmd = new SqlCommand(strCommand, con); cmd.Parameters.AddWithValue("@ShadowCDF_Acceptance", Res_CDF); cmd.Parameters.AddWithValue("@ShadowCDF_Id", SAR.ShadowCDFId); cmd.Parameters.AddWithValue("@Student_Id", SAR.StudentId); con.Open(); int i = cmd.ExecuteNonQuery(); if (i > 0) { return(true); } else { return(false); } } } catch (Exception ex) { Log.Error(ex); return(false); } }
public bool UpdateShadowSession([FromBody] AcceptRejShadow SAR) { return(SR.UpdateShadowSessionAcceptReject(SAR)); }