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