//public List<ExamQuestSetupClass> GetExamQuestionSetup()
//{
// List<ExamQuestSetupClass> Instlist = new List<ExamQuestSetupClass>();
// DataTable ds = new DataTable();
// using (SqlConnection conn = ConnectionDB.OpenConnection())
// {
// SqlCommand sqlComm = new SqlCommand("Proc_GetInstitute", conn);
// sqlComm.Parameters.AddWithValue("@Instituteid", InstituteID);
// sqlComm.CommandType = CommandType.StoredProcedure;
// SqlDataAdapter da = new SqlDataAdapter();
// da.SelectCommand = sqlComm;
// da.Fill(ds);
// }
// foreach (DataRow dr in ds.Rows)
// {
// Instlist.Add(new InstituteClass
// {
// InstituteID = int.Parse(dr["Institueid"].ToString()),
// InstituteCode = dr["Instituecode"].ToString(),
// InstituteName = dr["Instituename"].ToString(),
// InstituteStreet = dr["InstitueStreet"].ToString(),
// InstituteCity = dr["InstitueCity"].ToString(),
// InstituteDistrict = dr["InstitueDistrict"].ToString(),
// InstituteState = dr["InstitueState"].ToString(),
// InstituteCountry = dr["InstitueCountry"].ToString(),
// InstitutePinCode = dr["InstituePinCode"].ToString()
// });
// }
// return Instlist;
//}
public clsMessage updateExamQuestionSetup(string action = "insert")
{
clsMessage rm = new clsMessage();
try
{
using (SqlConnection con = ConnectionDB.OpenConnection())
{
SqlCommand cmd = new SqlCommand("Proc_UpdateExamCourseQuestSetup", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@ECQSID", ECQSID);
cmd.Parameters.AddWithValue("@ExamCourseScheduleID", ExamCourseScheduleID);
cmd.Parameters.AddWithValue("@QuestNo", QuestNo);
cmd.Parameters.AddWithValue("@QuestMarks", QuestMarks);
cmd.Parameters.AddWithValue("@QuestCO", QuestCO);
// cmd.Parameters.AddWithValue("@QuestBTL",InstituteDistrict);
cmd.Parameters.AddWithValue("@action", action);
cmd.Parameters.Add("@rvalue", SqlDbType.Char, 500);
cmd.Parameters["@rvalue"].Direction = ParameterDirection.Output;
cmd.ExecuteNonQuery();
rm.SuccessMessage = (string)cmd.Parameters["@rvalue"].Value;
rm.StatusMessage = "success";
}
}
catch (Exception er)
{
rm.ErrorMessage = er.Message.ToString();
rm.StatusMessage = "failed";
}
return(rm);
}
protected void btnSend_Click(object sender, EventArgs e)
{
clsMessage msg = new clsMessage(Global.curEmployee.ID, txtMessage.Text.Replace("'", "''"));
clsDataSource.insertMessage(msg.toInsert());
txtMessage.Text = "";
}
public clsMessage updateCourseCategory(string action = "insert")
{
clsMessage rm = new clsMessage();
try
{
using (SqlConnection con = ConnectionDB.OpenConnection())
{
SqlCommand cmd = new SqlCommand("Proc_UpdateCourseCategory", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@CourseCategoryID", CourseCategoryID);
cmd.Parameters.AddWithValue("@ProgramID", ProgramID);
cmd.Parameters.AddWithValue("@CourseCategoryTitle", CourseCategoryTitle);
cmd.Parameters.AddWithValue("@CourseCategoryCredit", CourseCategoryCredit);
cmd.Parameters.AddWithValue("@ACYR", AcademicYear);
cmd.Parameters.Add("@rvalue", SqlDbType.Char, 500);
cmd.Parameters["@rvalue"].Direction = ParameterDirection.Output;
cmd.ExecuteNonQuery();
rm.StatusMessage = (string)cmd.Parameters["@rvalue"].Value.ToString().Trim();
//rm.StatusMessage = "success";
}
}
catch (Exception er)
{
rm.ErrorMessage = er.Message.ToString();
rm.StatusMessage = "failed";
}
return(rm);
}
public clsMessage updateStudentCourseRegistration(string action = "insert")
{
clsMessage rm = new clsMessage();
try
{
using (SqlConnection conn = ConnectionDB.OpenConnection())
{
SqlCommand cmd = new SqlCommand("Proc_UpdateStudentCourseRegistration", conn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@StudentCourseRegID", StudentCourseRegID);
cmd.Parameters.AddWithValue("@UID", UID);
cmd.Parameters.AddWithValue("@CourseID", CourseID);
cmd.Parameters.Add("@rvalue", SqlDbType.Char, 500);
cmd.Parameters["@rvalue"].Direction = ParameterDirection.Output;
cmd.ExecuteNonQuery();
rm.SuccessMessage = (string)cmd.Parameters["@rvalue"].Value;
rm.StatusMessage = "success";
}
}
catch (Exception er)
{
rm.ErrorMessage = er.Message.ToString();
rm.StatusMessage = "failed";
}
return(rm);
}
public clsMessage UpdateInstitute(clsInstitute Inst, string action = "Insert")
{
clsMessage rm = new clsMessage();
rm = Inst.updateInstitute(action);
return(rm);
}
public clsMessage UpdateDepartment(clsDepartment dept, string action = "Insert")
{
clsMessage rm = new clsMessage();
rm = dept.updateDepartment(action);
return(rm);
}
public clsMessage UpdateCourseScheme(clsCourseScheme objCourseScheme, string action = "Insert")
{
clsMessage rm = new clsMessage();
rm = objCourseScheme.updateCourseScheme(action);
return(rm);
}
public clsMessage UpdateCourseCategory(clsCourseCategory objCourseCategory, string action = "Insert")
{
clsMessage rm = new clsMessage();
rm = objCourseCategory.updateCourseCategory(action);
return(rm);
}
public clsMessage UpdateStudentCourseRegistrationBulk(clsStudentCourseRegistration studCourseReg, clsManageInstitute Inst, List <string> pCourseList, string action = "Insert")
{
clsMessage rm = new clsMessage();
rm = studCourseReg.updateStudentCourseRegistrationBulk(Inst, pCourseList, action);
return(rm);
}
public clsMessage UpdateExamSchedule(clsExamSchedule examSchedule, string action = "Insert")
{
clsMessage rm = new clsMessage();
rm = examSchedule.updateExamSchedule(action);
return(rm);
}
public clsMessage UpdateExamScheduleBulk(clsExamSchedule pExamSchedule, List <clsExamCourseSchedule> pExamCourseScheduleList, string action = "Insert")
{
clsMessage rm = new clsMessage();
rm = pExamSchedule.updateExamScheduleBulk(pExamCourseScheduleList, action);
return(rm);
}
public clsMessage UpdateExamFormBulk(clsExamForm pExamForm, List <clsCourseScheme> pCourseList, string action = "Insert")
{
clsMessage rm = new clsMessage();
rm = pExamForm.updateExamForm(pCourseList, action);
return(rm);
}
public clsMessage updatePersonalDetails(string action = "Insert")
{
clsMessage rm = new clsMessage();
try
{
using (SqlConnection con = ConnectionDB.OpenConnection())
{
SqlCommand cmd = new SqlCommand("Proc_UpdatepersonalDetails", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@uid", UID);
cmd.Parameters.AddWithValue("@AdhaarNo", AdhaarNo);
cmd.Parameters.AddWithValue("@Photo", Photo);
cmd.Parameters.AddWithValue("@FirstName", FirstName);
cmd.Parameters.AddWithValue("@MiddleName", MiddleName);
cmd.Parameters.AddWithValue("@LastName", LastName);
cmd.Parameters.AddWithValue("@FathersName", FathersName);
cmd.Parameters.AddWithValue("@MothersName", MothersName);
cmd.Parameters.AddWithValue("@MobileNo", MobileNo);
cmd.Parameters.AddWithValue("@EmailID", EmailID);
cmd.Parameters.AddWithValue("@DOB", DOB);
cmd.Parameters.AddWithValue("@CategoryCast", CategoryCast);
cmd.Parameters.AddWithValue("@Religion", Religion);
cmd.Parameters.AddWithValue("@Gender", Gender);
cmd.Parameters.AddWithValue("@Nationality", Nationality);
cmd.Parameters.AddWithValue("@HandicapedBlind", HandicapedBlind);
cmd.Parameters.AddWithValue("@PostalStreet", PostalStreet);
cmd.Parameters.AddWithValue("@PostalCityName", PostalCityName);
cmd.Parameters.AddWithValue("@PostalDistrictName", PostalDistrictName);
cmd.Parameters.AddWithValue("@PostalCountryName", PostalCountryName);
cmd.Parameters.AddWithValue("@PostalPinCode", PostalPinCode);
cmd.Parameters.AddWithValue("@PermanantStreet", PermanantStreet);
cmd.Parameters.AddWithValue("@PermanantCityName", PermanantCityName);
cmd.Parameters.AddWithValue("@PermanantDistrictName", PermanantDistrictName);
cmd.Parameters.AddWithValue("@PermanantCountryName", PermanantCountryName);
cmd.Parameters.AddWithValue("@PermanantPinCode", PermanantPinCode);
cmd.Parameters.AddWithValue("@action", action);
cmd.Parameters.Add("@rvalue", SqlDbType.Char, 500);
cmd.Parameters["@rvalue"].Direction = ParameterDirection.Output;
cmd.ExecuteNonQuery();
rm.SuccessMessage = (string)cmd.Parameters["@rvalue"].Value;
rm.StatusMessage = "success";
}
}
catch (Exception er)
{
rm.ErrorMessage = er.Message.ToString();
rm.StatusMessage = "failed";
}
return(rm);
}
void QADummy_EntsvcP2PAskQuestion(string uName, string Question, string Role)
{
clsMessage objMessage = new clsMessage();
objMessage.struName = uName;
objMessage.strQuestion = Question;
objMessage.strRole = Role;
lstMessage.Add(objMessage);
}
public clsMessage ChangePassword(string Uname, string OldPassword, string NewPassword)
{
clsMessage rm = new clsMessage();
clsLogin Login = new clsLogin();
rm = Login.changePassword(Uname, OldPassword, NewPassword);
return(rm);
}
void AudioDummy_EntsvcP2PSetUserList(string uname, string strConf)
{
clsMessage objMessage = new clsMessage();
objMessage.strUserName = uname;
objMessage.strConfNumber = strConf;
objMessage.msgType = "setuserlist";
lstMessage.Add(objMessage);
}
public clsMessage CheckLogin(string UserName, string Password)
{
clsMessage status = new clsMessage();
clsLogin Login = new clsLogin();
status = Login.checkLogin(UserName, Password);
return(status);
}
public clsMessage UpdateStudentCourseRegistration(string pUID, string pCourseID, string action = "Insert")
{
clsStudentCourseRegistration stregcourse = new clsStudentCourseRegistration();
clsMessage rm = new clsMessage();
stregcourse.UID = pUID;
stregcourse.CourseID = int.Parse(pCourseID);
rm = stregcourse.updateStudentCourseRegistration(action);
return(rm);
}
void QADummy_entsvcP2PReplyQuestion(string uName, string Question, string Answer, string Role, List <string> strBuddyList)
{
clsMessage objMessage = new clsMessage();
objMessage.struName = uName;
objMessage.strQuestion = Question;
objMessage.strAnswer = Answer;
objMessage.strRole = Role;
objMessage.strGuestList = strBuddyList;
lstMessage.Add(objMessage);
}
/// <summary>
/// Populate business objects from the data reader
/// </summary>
/// <param name="dataReader">data reader</param>
/// <returns>list of clsContacts</returns>
internal List <clsMessage> PopulateObjectsFromReader(IDataReader dataReader)
{
List <clsMessage> list = new List <clsMessage>();
while (dataReader.Read())
{
clsMessage businessObject = new clsMessage();
PopulateBusinessObjectFromReader(businessObject, dataReader);
list.Add(businessObject);
}
return(list);
}
// exam Creation in one click having exam details and exam Course Details.
public clsMessage updateExamScheduleBulk(List <clsExamCourseSchedule> pExamCourseList, string action = "insert")
{
clsMessage rm = new clsMessage();
DataTable tabExamCourseList = new DataTable();
tabExamCourseList.Columns.Add("ExamID"); tabExamCourseList.Columns.Add("CourseID");
tabExamCourseList.Columns.Add("ExamCourseStartDate"); tabExamCourseList.Columns.Add("ExamCourseEndDate");
tabExamCourseList.Columns.Add("ExamCourseFees");
foreach (var course in pExamCourseList)
{
tabExamCourseList.Rows.Add(ExamID, course.CourseID, course.ExamCourseStartDateTime, course.ExamCourseEndDateTime, course.ExamCourseFees);
}
try
{
using (SqlConnection con = ConnectionDB.OpenConnection())
{
SqlCommand cmd = new SqlCommand("Proc_UpdateExamSchedule", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@ExamID", ExamID);
cmd.Parameters.AddWithValue("@DepartmentID", DepartmentID);
cmd.Parameters.AddWithValue("@ProgramID", ProgramID);
cmd.Parameters.AddWithValue("@SemesterID", SemesterID);
cmd.Parameters.AddWithValue("@ExamYear", ExamYear);
cmd.Parameters.AddWithValue("@ExamSession", ExamSession);
cmd.Parameters.AddWithValue("@ExamType", ExamType);
cmd.Parameters.AddWithValue("@ExamName", ExamName);
cmd.Parameters.AddWithValue("@examstartdate", ExamStartDate);
cmd.Parameters.AddWithValue("@examenddate", ExamEndDate);
cmd.Parameters.AddWithValue("@TyExamCourseID", tabExamCourseList);
cmd.Parameters.Add("@rvalue", SqlDbType.Char, 500);
cmd.Parameters["@rvalue"].Direction = ParameterDirection.Output;
cmd.ExecuteNonQuery();
rm.SuccessMessage = (string)cmd.Parameters["@rvalue"].Value;
rm.StatusMessage = "success";
}
}
catch (Exception er)
{
rm.ErrorMessage = er.Message.ToString();
rm.StatusMessage = "failed";
}
return(rm);
}
void AudioDummy_EntsvcP2PStartConference(string uName, string strConfNumber, string[] GuestInfo)
{
try
{
clsMessage objMessage = new clsMessage();
objMessage.strConfNumber = strConfNumber;
lstMessage.Add(objMessage);
}
catch (Exception ex)
{
ex.Data.Add("My Key", "VMukti--:--VmuktiModules--:--VmuktiModules--:--Call Center--:--AutoProgressiveSoftPhone--:--AutoProgressivePhone.Presentation--:--AudioDummy.cs--:--AudioDummy_EntsvcP2PStartConference()--");
ClsException.LogError(ex);
ClsException.WriteToErrorLogFile(ex);
}
}
void DummyClient_EntsvcSendMessage(string msg, string from, List <string> to)
{
try
{
clsMessage objMessage = new clsMessage();
objMessage.strFrom = from;
objMessage.lstTo = to;
objMessage.strMessage = msg;
lstMessage.Add(objMessage);
}
catch (Exception ex)
{
VMuktiAPI.VMuktiHelper.ExceptionHandler(ex, "DummyClient_EntsvcSendMessage", "ChatDummy.cs");
}
}
void DummyClient_EntsvcSetUserList(string uName)
{
try
{
clsMessage objMessage = new clsMessage();
objMessage.strFrom = uName;
//objMessage.lstTo = to;
objMessage.strMessage = "SetUserList";
lstMessage.Add(objMessage);
}
catch (Exception ex)
{
VMuktiAPI.VMuktiHelper.ExceptionHandler(ex, "DummyClient_EntsvcSignOutChat", "ChatDummy.cs");
}
}
public static string ToState(this clsMessage message)
{
if (message.Status == enuMessageStatus.Displayed)
{
return("displayed");
}
else if (message.Status == enuMessageStatus.NotAcked)
{
return("displayed_not_acknowledged");
}
else
{
return("off");
}
}
void DummyClient_EntsvcShowStatus(string uname, List <string> to, string keydownstatus)
{
try
{
clsMessage objMessage = new clsMessage();
objMessage.strFrom = uname;
objMessage.lstTo = to;
objMessage.strMessage = "ShowTypeMessage";
objMessage.strShowMsg = keydownstatus;
lstMessage.Add(objMessage);
}
catch (Exception ex)
{
VMuktiAPI.VMuktiHelper.ExceptionHandler(ex, "DummyClient_EntsvcShowStatus", "ChatDummy.cs");
}
}
void FileSearchDummy_EntsvcSearchQuery(string strQuery, string uName, List <string> lstGuestList)
{
try
{
//Setting Data Members
clsMessage objMessage = new clsMessage();
objMessage.struName = uName;
objMessage.strSendQuery = strQuery;
objMessage.strGuestList = lstGuestList;
lstMessage.Add(objMessage);
}
catch (Exception ex)
{
VMuktiAPI.VMuktiHelper.ExceptionHandler(ex, "FileSearchDummy_EntsvcSearchQuery", "FileSearchDummy.cs");
}
}
public clsMessage updateStudentCourseRegistrationBulk(clsManageInstitute InstObject, List <string> CourseIDList, string action = "insert")
{
clsMessage rm = new clsMessage();
try
{
DataTable CourseTable = new DataTable();
CourseTable.Columns.Add("CourseID");
foreach (string course in CourseIDList)
{
CourseTable.Rows.Add(course);
}
using (SqlConnection conn = ConnectionDB.OpenConnection())
{
SqlCommand cmd = new SqlCommand("Proc_UpdateStudentCourseRegistration", conn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@StudentCourseRegID", StudentCourseRegID);
cmd.Parameters.AddWithValue("@UID", UID);
cmd.Parameters.AddWithValue("@ACYR", InstObject.AcademicYear);
cmd.Parameters.AddWithValue("@DepartmentID", InstObject.DepartmentID);
cmd.Parameters.AddWithValue("@SemesterID", InstObject.SemesterID);
cmd.Parameters.AddWithValue("@SectionID", InstObject.SectionID);
cmd.Parameters.AddWithValue("@RollNo", RollNo);
cmd.Parameters.AddWithValue("@ProfEMail", ProfEMailID);
cmd.Parameters.AddWithValue("@TyCourse", CourseTable);
cmd.Parameters.AddWithValue("@CurrentStatus", CurrentStatus);
cmd.Parameters.AddWithValue("@DepartmentID", RegistrationStatus);
cmd.Parameters.Add("@rvalue", SqlDbType.Char, 500);
cmd.Parameters["@rvalue"].Direction = ParameterDirection.Output;
cmd.ExecuteNonQuery();
rm.SuccessMessage = (string)cmd.Parameters["@rvalue"].Value;
rm.StatusMessage = "success";
}
}
catch (Exception er)
{
rm.ErrorMessage = er.Message.ToString();
rm.StatusMessage = "failed";
}
return(rm);
}
void FileSearchDummy_EntsvcSearchResult(string[] strResult, string uName)
{
if (strResult != null && strResult.Length > 0)
{
try
{
clsMessage objMessage = new clsMessage();
objMessage.struName = uName;
objMessage.strQueryReply = strResult;
lstMessage.Add(objMessage);
}
catch (Exception ex)
{
VMuktiAPI.VMuktiHelper.ExceptionHandler(ex, "FileSearchDummy_EntsvcSearchResult", "FileSearchDummy.cs");
}
}
}
void AudioDummy_EntsvcP2PUnJoin(string uName)
{
try
{
lstNodes.Remove(uName);
clsMessage objMessege = new clsMessage();
objMessege.strUserName = uName;
objMessege.msgType = "unjoin";
lstMessage.Add(objMessege);
//NetTcpAudioChannel.Close();
}
catch (Exception ex)
{
VMuktiAPI.VMuktiHelper.ExceptionHandler(ex, "AudioDummy_EntsvcP2PUnJoin()", "AudioDummy.cs");
}
}
private void DebugGLError(string Name)
{
if ( App.Debug_GL )
{
if ( Messages.Count < 8 )
{
if ( GL.GetError() != ErrorCode.NoError )
{
clsMessage NewMessage = new clsMessage();
NewMessage.Text = "OpenGL Error (" + Name + ")";
Messages.Add(NewMessage);
}
}
}
}
