public static String insertNewSubject(Subject subject)
{
string msg = SubjectVal.getInsertSubjectValidation(subject);
if (msg.ToUpper().Equals("OK"))
{
if (subjectBLL.checkDuplicateSubject(subject))
{
msg = "0";
}
else
{
SqlParameter[] param =
{
new SqlParameter("@subname", subject.SubjectName.Trim()),
new SqlParameter("@classid", Convert.ToInt64(subject.ClassID)),
new SqlParameter("@sessid", Convert.ToInt32(subject.SessionID.ToString() ?? "0")),
new SqlParameter("@currentsession", subject.Current_Session)
};
DataSet dss = new DataSet();
if (GeneralBLL.SqlHelperConnection == 1)
{
dss = SqlHelper.ExecuteDataset(SqlHelper.Connect, CommandType.Text, "Insert into Subjects(SubjectName,ClassID,SessionID,Current_Session) Values(@subname,@classid,@sessid,@currentsession)", param);
msg = "1";
}
else
{
dss = SqlHelper.ExecuteDataset(SqlHelper.Connect2, CommandType.Text, "Insert into Subjects(SubjectName,ClassID,SessionID,Current_Session) Values(@subname,@classid,@sessid,@currentsession)", param);
msg = "1";
}
}
}
return(msg);
}
public static String updateSubject(Subject subject)
{
string msg = SubjectVal.getInsertSubjectValidation(subject);
if (msg.ToUpper().Equals("OK"))
{
SqlParameter[] param =
{
new SqlParameter("@subid", Convert.ToInt64(subject.SubjectID)),
new SqlParameter("@subname", subject.SubjectName.Trim()),
// new SqlParameter("@classid", Convert.ToInt64(subject.ClassID)),
// new SqlParameter("@currentsession",subject.Current_Session)
};
if (GeneralBLL.SqlHelperConnection == 1)
{
if ((int)SqlHelper.ExecuteNonQuery(SqlHelper.Connect, CommandType.Text, "Update Subjects set SubjectName=@subname where subjectid=@subid", param) > 0)
{
msg = "1";
}
else
{
msg = "0";
}
}
else
{
if ((int)SqlHelper.ExecuteNonQuery(SqlHelper.Connect2, CommandType.Text, "Update Subjects set SubjectName=@subname where subjectid=@subid", param) > 0)
{
msg = "1";
}
else
{
msg = "0";
}
}
}
return(msg);
}
