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); }