public int SaveReportInfo(Models.ReportInfo aReportInfo) { int rowAffected = 0; string query = "INSERT INTO ReportInfo(Name,DonorId,Msg,CreatedAt)VALUES('" + aReportInfo.Name + "','" + aReportInfo.DonorId + "','" + aReportInfo.Msg + "', GETDATE() )"; Connection.Open(); Command = new SqlCommand(query, Connection); rowAffected = Command.ExecuteNonQuery(); Connection.Close(); return(rowAffected); }
public string SaveReportInfo(Models.ReportInfo aReportInfo) { int rowAffected = _reportInfoGateway.SaveReportInfo(aReportInfo); if (rowAffected > 0) { return("success"); } else { return("failed"); } }