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