public string Activity_Schedule(ExamDM.ExamScheduleDM objDM) { NewDAL.DBManager objDB = new DBManager(); objDB.ConnectionString = System.Configuration.ConfigurationManager.ConnectionStrings["FeesManagementConn"].ConnectionString; objDB.DBManager(DataAccessLayer.DataProvider.SqlServer, objDB.ConnectionString); objDB.Open(); string retv = ""; string f = ""; objDB.CreateParameters(7); objDB.AddParameters(0, "semid", objDM.semid, DbType.Int32); objDB.AddParameters(1, "spclID", objDM.specid, DbType.Int32); objDB.AddParameters(2, "courseID", objDM.courseid, DbType.Int32); objDB.AddParameters(3, "session", objDM.sessionid, DbType.String); objDB.AddParameters(4, "date", objDM.SchDate, DbType.String); objDB.AddParameters(5, "From_Time", objDM.TimeFrom, DbType.String); objDB.AddParameters(6, "To_Time", objDM.TimeTo, DbType.String); IDataReader dr = (IDataReader)objDB.ExecuteReader(CommandType.StoredProcedure, "Activity_Schedule"); DataTable dt = new DataTable(); dt.Load(dr); if (dt.Rows.Count > 0) { retv = dt.Rows[0]["Column1"].ToString(); } objDB.Connection.Close(); objDB.Dispose(); return(retv); }
public string InsertTestSchedule1(ExamDM.ExamScheduleDM objDM, Admin.AdministratorData.AuditDM audit) { NewDAL.DBManager objDB = new DBManager(); objDB.ConnectionString = System.Configuration.ConfigurationManager.ConnectionStrings["FeesManagementConn"].ConnectionString; objDB.DBManager(DataAccessLayer.DataProvider.SqlServer, objDB.ConnectionString); objDB.Open(); objDB.BeginTransaction(); string retv = ""; string f = ""; try { objDB.CreateParameters(15); objDB.AddParameters(0, "testschId", objDM.testschid, DbType.Int32); objDB.AddParameters(1, "testId", objDM.testid, DbType.Int32); objDB.AddParameters(2, "subjectId", objDM.Subjectid, DbType.String); objDB.AddParameters(3, "testDate", objDM.testdate1, DbType.DateTime); objDB.AddParameters(4, "Unit_Name", objDM.Unit_Name, DbType.String); objDB.AddParameters(5, "Unit_Id", objDM.Unit_Id, DbType.String); objDB.AddParameters(6, "sessionId", objDM.sessionid, DbType.String); objDB.AddParameters(7, "courseId", objDM.courseid, DbType.Int32); objDB.AddParameters(8, "specid", objDM.specid, DbType.Int32); objDB.AddParameters(9, "semid", objDM.semid, DbType.Int32); objDB.AddParameters(10, "flag", objDM.Flag, DbType.String); objDB.AddParameters(11, "Remark", objDM.remark, DbType.String); objDB.AddParameters(12, "Status", objDM.Status, DbType.String); objDB.AddParameters(13, "TimeFrom", objDM.TimeFrom, DbType.String); objDB.AddParameters(14, "TimeTo", objDM.TimeTo, DbType.String); retv = objDM.Flag; objDB.ExecuteNonQuery(CommandType.StoredProcedure, "Insert_itestSchedule_new"); objDB.CreateParameters(9); objDB.AddParameters(0, "ID", 0, DbType.Int32); objDB.AddParameters(1, "Form_Name", audit.Form_Name, DbType.String); objDB.AddParameters(2, "Action", audit.Action, DbType.String); objDB.AddParameters(3, "User_ID", audit.User_ID, DbType.String); objDB.AddParameters(4, "Entry_Date", audit.Entry_Date, DbType.String); objDB.AddParameters(5, "Record_ID", audit.Record_ID, DbType.String); objDB.AddParameters(6, "Entry_Time", audit.Entry_Time, DbType.String); objDB.AddParameters(7, "InstituteID", audit.InstituteID, DbType.Int32); objDB.AddParameters(8, "SessionID", audit.SessionID, DbType.String); objDB.ExecuteNonQuery(CommandType.StoredProcedure, "Audit_Insert"); objDB.Transaction.Commit(); if (retv == "N") { retv = "Test Date Scheduled Successfully..!!"; } else if (retv == "U") { retv = "Test Date Updated Successfully..!!"; } else { retv = "Record deleted Successfully."; } } catch (Exception ex) { objDB.Transaction.Rollback(); retv = "Unable to save record :-" + ex.Message.ToString(); } finally { objDB.Connection.Close(); objDB.Dispose(); } return(retv); }