public static bool? CheckForComplaintCode(IndComplaint ind)
{
SqlConnection conn = new SqlConnection(ConnectionStrings.mainConn);
string sql = "SELECT del FROM comcodes where comcode = @ComCode";
SqlCommand cmd = new SqlCommand(sql, conn);
cmd.Parameters.Add(new SqlParameter("@ComCode", ind.ComCode));
bool? count;
conn.Open();
count = (bool?)cmd.ExecuteScalar();
conn.Close();
return count;
}
public static bool? CheckForDepartmentCode(IndDepartment ind)
{
SqlConnection conn = new SqlConnection(ConnectionStrings.mainConn);
string sql = "SELECT del FROM deptcode where deptcode = @DeptCode";
SqlCommand cmd = new SqlCommand(sql, conn);
cmd.Parameters.Add(new SqlParameter("@DeptCode", ind.DeptCode));
bool? count;
conn.Open();
count = (bool?)cmd.ExecuteScalar();
conn.Close();
return count;
}//end def 'CheckForDepartmentCode'
The .NET Framework is not specific to any one programming language; rather, it includes a library of functions that allows developers to rapidly build applications. Several supported languages include C#, VB.NET, C++ or ASP.NET.
TRUSTED BY