public SMSNotification SMSNotification(string phone, string messages) { SMSNotification xs = null; if (client.BaseAddress == null) { GetBaseAddress(); } client.Timeout.Add(new TimeSpan(0, 0, 5)); client.DefaultRequestHeaders.Accept.Clear(); client.DefaultRequestHeaders.Authorization = new AuthenticationHeaderValue("Bearer", ConfigurationManager.AppSettings["bearerToken"].ToString()); client.DefaultRequestHeaders.Accept.Add(new MediaTypeWithQualityHeaderValue("application/json")); var jsonString = "{\"msisdn\":\"" + phoneNumberFormat(phone) + "\",\"content\":\"" + messages + "\"}"; var httpContent = new StringContent(jsonString, Encoding.UTF8, "application/json"); HttpResponseMessage response = client.PostAsync("smsnotification/1.0.0/messages", httpContent).Result; if (response.IsSuccessStatusCode) { //att = await response.Content.ReadAsAsync<AirportTransferTransaction>(); string resultJSON = response.Content.ReadAsStringAsync().Result; xs = JsonConvert.DeserializeObject <SMSNotification>(resultJSON); } return(xs); }
public void RelayMessage(double latitude, double longitude, string emailAddress) { User TempUser = db.Users.Where(x => x.Email == emailAddress).FirstOrDefault(); var TempAlert = db.AlertTypes.Where(x => x.UserId == TempUser.Id).FirstOrDefault(); GeoCoordinate PersonLocation = new GeoCoordinate(latitude, longitude); var locations = db.NoGoZones.Where(x => x.User.Id == TempUser.Id); if (CompareLocations.CompareLocations.Compare(PersonLocation, locations.AsEnumerable())) { var msgData = new MessageData { EMail = TempUser.Email, TelNr = TempUser.TelNr, MsgBody = "You got too close to a no go zone!", MsgHeader = "Alert" }; if (!string.IsNullOrEmpty(TempUser.TelNr) && TempAlert.Text) { INotifications notification = new SMSNotification(); notification.Send(msgData); } if (!string.IsNullOrEmpty(TempUser.Email) && TempAlert.EMail) { INotifications notification = new EMailNotification(); notification.Send(msgData); } if (!string.IsNullOrEmpty(TempUser.Push) && TempAlert.Push) { INotifications notification = new PushFirebase(); notification.Send(msgData); } } }
public IActionResult SMS([FromBody] Assignment model) { if (!User.HasClaim(x => x.Type == ClaimTypes.Role && (x.Value == "客服主管" || x.Value == "客服部" || x.Value == "经理办"))) { return(BadRequest("你没有权限执行该操作!")); } if (model == null) { return(BadRequest()); } using (var session = _documentStore.LightweightSession()) { DateTime dueTime = (DateTime)model.finishDue; TimeSpan ts = dueTime - DateTime.Now; string remainTime; if (ts.TotalHours >= 1) { remainTime = ts.Days + "天," + ts.Hours + "小时," + ts.Minutes + "分钟"; } else { remainTime = "不足一小时"; } FanyiNetwork.Models.User editor = session.Query <User>().FirstOrDefault(x => x.id == model.editor); if (editor != null) { SMSNotification.SendChangeOrderSMS(model.no, remainTime, editor.mobile); } return(Ok()); } }
static void Main(string[] args) { /* * var reader = new RobotChannelReader("http://bots.myrobots.com/channels/{0}/feed.xml?key={1}", "67", "B94DD85F4ED8430B"); * var channel = reader.ReadChannel(); * Console.WriteLine("Name: {0}", channel.Name); * Console.WriteLine("Created: {0}", channel.Description); * Console.WriteLine("Feeds:"); * * foreach (var feed in channel.Feeds) * { * Console.WriteLine("Created: {0}", feed.Created); * Console.WriteLine("Entry ID: {0}", feed.EntryId); * Console.WriteLine(); * Console.WriteLine("Values:"); * foreach (var field in feed.Values) * { * Console.WriteLine("{0} = {1}", field.Key, field.Value); * } * Console.WriteLine(); * }*/ var notification = new SMSNotification(); notification.PhoneNumber = Properties.Settings.Default.PhoneNumber; notification.GatewayEmail = Properties.Settings.Default.GatewayEmail; notification.Content = "Test"; notification.Send(); }
static void Main(string[] args) { /* var reader = new RobotChannelReader("http://bots.myrobots.com/channels/{0}/feed.xml?key={1}", "67", "B94DD85F4ED8430B"); var channel = reader.ReadChannel(); Console.WriteLine("Name: {0}", channel.Name); Console.WriteLine("Created: {0}", channel.Description); Console.WriteLine("Feeds:"); foreach (var feed in channel.Feeds) { Console.WriteLine("Created: {0}", feed.Created); Console.WriteLine("Entry ID: {0}", feed.EntryId); Console.WriteLine(); Console.WriteLine("Values:"); foreach (var field in feed.Values) { Console.WriteLine("{0} = {1}", field.Key, field.Value); } Console.WriteLine(); }*/ var notification = new SMSNotification(); notification.PhoneNumber = Properties.Settings.Default.PhoneNumber; notification.GatewayEmail = Properties.Settings.Default.GatewayEmail; notification.Content = "Test"; notification.Send(); }
public IActionResult Assign([FromBody] Assignment model) { if (!User.HasClaim(x => x.Type == ClaimTypes.Role && (x.Value == "主编" || x.Value == "客服主管" || x.Value == "经理办"))) { return(BadRequest("你没有权限执行该操作!")); } if (model == null) { return(BadRequest()); } using (var session = _documentStore.LightweightSession()) { model.status = "待交稿"; model.chiefeditor = int.Parse(User.FindFirst(ClaimTypes.Sid).Value); model.assignTime = DateTime.Now; model.isParttimeConfirm = false; session.Store <Assignment>(model); Notification notification = new Notification(); notification.userid = model.editor; notification.assignmentid = model.id; notification.message = "单号已分配至你,请按时提交稿件!"; notification.time = DateTime.Now; session.Store <Notification>(notification); Flow flow = new Flow(); flow.AssignmentID = model.id; flow.Operator = User.Identity.Name; flow.Operation = "成功分配,标记单号为待交稿."; flow.Time = DateTime.Now; session.Store <Flow>(flow); session.SaveChanges(); DateTime dueTime = (DateTime)model.finishDue; TimeSpan ts = dueTime - DateTime.Now; string remainTime; if (ts.TotalHours >= 1) { remainTime = ts.Days + "天," + ts.Hours + "小时," + ts.Minutes + "分钟"; } else { remainTime = "不足一小时"; } FanyiNetwork.Models.User editor = session.Query <User>().FirstOrDefault(x => x.id == model.editor); if (editor != null) { SMSNotification.SendAssignOrderSMS(model.no, remainTime, editor.mobile); } return(Ok()); } }
private bool CheckCapacity(T_RegisteredStudentSemester value) { using (SMSNotification nofity = new SMSNotification()) { var cap = nofity.GetRegisterStudent().Where(x => x.Day == value.Day && x.TImeEnd.ToShortTimeString() == value.TImeEnd.ToShortTimeString() && x.TimeStart.ToShortTimeString() == value.TimeStart.ToShortTimeString() && x.Semester == value.Semester && x.SemEndDate.ToShortDateString() == value.SemEndDate.ToShortDateString() && x.SemStartDate.ToShortDateString() == value.SemStartDate.ToShortDateString() && x.YearClass == value.YearClass && x.Active == true).ToList().Count; //lblSelected.Text = string.Format("Selected",cap); return(cap <= GetCapacity(value.RoomCode)?true:false); } }
void Delete(long ID) { if (SystemProperties.ShowMessage.MessageQuestion(SystemProperties.MessageNotification.YouWantToDelete, "Room record") == DialogResult.Yes) { using (SMSNotification notify = new SMSNotification()) { notify.Delete(ID, ref MsgReturned); SystemProperties.ShowMessage.MessageInformation(MsgReturned, "Room record"); LoadRoomRecord(); } } }
public void Setup() { _address = new IpsAddress(); _address.Address = new List <string> { "+987654321" }; _address.From = "+123456789031"; _message = new IpsMessage(); _message.Message = "testMessage"; _sender = new SMSNotification(); }
public async Task<string> CreateNotification(SMSNotification message) { string enableSMSGateway = ConfigurationManager.AppSettings["enableSMSGateway"]; if (enableSMSGateway == null) throw new ApplicationException("Unable to find SMS Gateway switch"); else if (!bool.Parse(enableSMSGateway)) throw new ApplicationException("SMS Gateway disabled"); string json = JsonUtil<SMSNotification>.ToJson(message); string result = await ClickatellAPIPost(json); return result; }
void LoadSMS() { int i = 1; dgSMS.Rows.Clear(); using (SMSNotification notify = new SMSNotification()) { notify.GetSMS().ForEach(x => { dgSMS.Rows.Add(x.ID, i, x.Code, x.MessageAlert, x.Active); i++; }); ObjEnable(false); } }
void Delete() { if (SystemProperties.ShowMessage.MessageQuestion(SystemProperties.MessageNotification.YouWantToDelete, "Message notification") == DialogResult.Yes && dgSMS.Rows.Count > 0) { using (SMSNotification notify = new SMSNotification()) { var value = SetRoomType(); value.ID = Convert.ToInt64(dgSMS.SelectedRows[0].Cells[0].Value); if (value != null) { notify.Delete(value, ref MsgReturned); SystemProperties.ShowMessage.MessageInformation(MsgReturned, "Message notification"); LoadSMS(); } } } }
void dgSMS_CellClick(object sender, DataGridViewCellEventArgs e) { if (dgSMS.Rows.Count > 0) { using (SMSNotification notify = new SMSNotification()) { var value = notify.GetSMS().Where(x => x.ID == Convert.ToInt64(dgSMS.SelectedRows[0].Cells[0].Value)).FirstOrDefault(); if (value != null) { txtCode.Text = value.Code; txtMessage.Text = value.MessageAlert; cbActive.Checked = value.Active.Value; btnDelete = SystemProperties.BtnProperties(btnDelete, true, Imagename.Delete.ToString(), Imagename._delete.ToString()); btnEdit = SystemProperties.BtnProperties(btnEdit, true, Imagename.Edit.ToString(), Imagename._edit.ToString()); } } } }
public override void SetContext(StepEditContext context, SMSNotification notification) { base.SetContext(context, notification); cbTextbeltPresets.DataSource = Enum.GetValues(typeof(TextbeltPresets)); if (notification.TextbeltAPIURL != null && notification.TextbeltAPIURL.ToLower() == "http://textbelt.com/text") { cbTextbeltPresets.SelectedItem = TextbeltPresets.Paid; } else { cbTextbeltPresets.SelectedItem = TextbeltPresets.Custom; } txtTextbeltAPIURL.Text = notification.TextbeltAPIURL; txtTextbeltAPIKey.Text = notification.TextbeltAPIKey; txtNumbers.Text = String.Join("; ", notification.Numbers); }
void Save() { if (SystemProperties.ShowMessage.MessageQuestion(SystemProperties.MessageNotification.YouWantToSave, "Message notification") == DialogResult.Yes) { if (CheckEmptyField()) { using (SMSNotification notify = new SMSNotification()) { notify.Save(SetRoomType(), ref MsgReturned); SystemProperties.ShowMessage.MessageInformation(MsgReturned, "Message notification"); SystemProperties.Cleared(this, false, true, true); LoadSMS(); } } else { SystemProperties.ShowMessage.MessageError(SystemProperties.MessageNotification.CheckInput + Environment.NewLine + Environment.NewLine + "Code" + Environment.NewLine + "Message", "Message notification"); } } }
void LoadRoomRecord() { int i = 1; dgRoomRecord.Rows.Clear(); using (SMSNotification notify = new SMSNotification()) { notify.GetRegisterStudent().OrderBy(o => o.TimeStart).ToList().ForEach(x => { using (Maintenance maintain = new Maintenance()) { using (Students stud = new Students()) { var studs = stud.GetStudentInfo().Where(s => s.StudentID == x.StudentID).FirstOrDefault(); var valueBldg = maintain.GetRoom().Where(xx => xx.RoomCode == x.RoomCode).FirstOrDefault(); dgRoomRecord.Rows.Add(x.ID, i, x.StudentID, studs.LastName + "," + studs.FirstName, x.Semester, valueBldg.BuildingCode, x.RoomCode, valueBldg.Description, x.TimeStart.ToShortTimeString() + " to " + x.TImeEnd.ToShortTimeString()); i++; } } }); } }
void GetAttendanceLogs() { dgAttendanceLogs.Rows.Clear(); int i = 1; using (SMSNotification notify = new SMSNotification()) { var value = notify.GetUserTime(); if (value.Count > 0) { value.ForEach(x => { using (Students stud = new Students()) { var valueStud = stud.GetStudentInfo().Where(xx => xx.StudentID == x.StudentID).FirstOrDefault(); dgAttendanceLogs.Rows.Add(x.ID, i, x.StudentID, valueStud != null?valueStud.LastName + ", " + valueStud.FirstName:"Student name are not found", x.SubjectCode, x.RoomCode, x.Day, x.TimeIN, x.TimeOUT); i++; } }); } } }
void GetRoomSubjectMessage() { cmbMessage.Items.Clear(); cmbRoomCode.Items.Clear(); cmbSubjectCode.Items.Clear(); using (Maintenance maintain = new Maintenance()) { maintain.GetRoom().Where(x => x.Active == true).OrderBy(o => o.RoomCode).ToList().ForEach(y => { cmbRoomCode.Items.Add(y.RoomCode); }); maintain.GetSubject().Where(x => x.Active == true).OrderBy(o => o.Code).ToList().ForEach(y => { cmbSubjectCode.Items.Add(y.Code); }); } using (SMSNotification smsNotify = new SMSNotification()) { smsNotify.GetSMS().Where(x => x.Active == true).ToList().ForEach(s => { cmbMessage.Items.Add(s.Code); }); } }
void LoadSelected(bool Date, bool Time, bool Day, bool SubCode, bool RoomCode) { int i = 1; dgAttendanceLogs.Rows.Clear(); using (SMSNotification notify = new SMSNotification()) { #region 1 //Start 1 if (Date && Time && Day && SubCode && RoomCode) { dgAttendanceLogs.Rows.Clear(); var value = notify.GetUserTime().Where(x => (ConvertDates(x.TimeIN.Value) >= ConvertDates(dtDateStart.Value) && (ConvertDates(x.TimeIN.Value)) <= ConvertDates(dtDateEnd.Value)) && (ConvertTimes(x.TimeIN.Value) >= ConvertTimes(dtTimeIN.Value) && ConvertTimes(x.TimeIN.Value) <= ConvertTimes(dtTimeOUT.Value)) && x.Day == cmbDays.Text && x.SubjectCode == cmbSubCode.Text && x.RoomCode == cmbRoomCode.Text).ToList(); if (value.Count > 0) { value.ForEach(x => { using (Students stud = new Students()) { var valueStud = stud.GetStudentInfo().Where(xx => xx.StudentID == x.StudentID).FirstOrDefault(); dgAttendanceLogs.Rows.Add(x.ID, i, x.StudentID, valueStud != null ? valueStud.LastName + ", " + valueStud.FirstName : "Student name are not found", x.SubjectCode, x.RoomCode, x.Day, x.TimeIN, x.TimeOUT); i++; } }); } } //End #endregion #region 2 //Start 1 if (Time && Day && SubCode && RoomCode) { dgAttendanceLogs.Rows.Clear(); var value = notify.GetUserTime().Where(x => (ConvertTimes(x.TimeIN.Value) >= ConvertTimes(dtTimeIN.Value) && ConvertTimes(x.TimeIN.Value) <= ConvertTimes(dtTimeOUT.Value)) && x.Day == cmbDays.Text && x.SubjectCode == cmbSubCode.Text && x.RoomCode == cmbRoomCode.Text).ToList(); if (value.Count > 0) { value.ForEach(x => { using (Students stud = new Students()) { var valueStud = stud.GetStudentInfo().Where(xx => xx.StudentID == x.StudentID).FirstOrDefault(); dgAttendanceLogs.Rows.Add(x.ID, i, x.StudentID, valueStud != null ? valueStud.LastName + ", " + valueStud.FirstName : "Student name are not found", x.SubjectCode, x.RoomCode, x.Day, x.TimeIN, x.TimeOUT); i++; } }); } } //End #endregion #region 3 //Start 1 if (Date && Day && SubCode && RoomCode) { dgAttendanceLogs.Rows.Clear(); var value = notify.GetUserTime().Where(x => (ConvertDates(x.TimeIN.Value) >= ConvertDates(dtDateStart.Value) && (ConvertDates(x.TimeIN.Value)) <= ConvertDates(dtDateEnd.Value)) && x.Day == cmbDays.Text && x.SubjectCode == cmbSubCode.Text && x.RoomCode == cmbRoomCode.Text).ToList(); if (value.Count > 0) { value.ForEach(x => { using (Students stud = new Students()) { var valueStud = stud.GetStudentInfo().Where(xx => xx.StudentID == x.StudentID).FirstOrDefault(); dgAttendanceLogs.Rows.Add(x.ID, i, x.StudentID, valueStud != null ? valueStud.LastName + ", " + valueStud.FirstName : "Student name are not found", x.SubjectCode, x.RoomCode, x.Day, x.TimeIN, x.TimeOUT); i++; } }); } } //End #endregion #region 4 //Start 1 if (Date && Time && SubCode && RoomCode) { dgAttendanceLogs.Rows.Clear(); var value = notify.GetUserTime().Where(x => (ConvertDates(x.TimeIN.Value) >= ConvertDates(dtDateStart.Value) && (ConvertDates(x.TimeIN.Value)) <= ConvertDates(dtDateEnd.Value)) && (ConvertTimes(x.TimeIN.Value) >= ConvertTimes(dtTimeIN.Value) && ConvertTimes(x.TimeIN.Value) <= ConvertTimes(dtTimeOUT.Value)) && x.SubjectCode == cmbSubCode.Text && x.RoomCode == cmbRoomCode.Text).ToList(); if (value.Count > 0) { value.ForEach(x => { using (Students stud = new Students()) { var valueStud = stud.GetStudentInfo().Where(xx => xx.StudentID == x.StudentID).FirstOrDefault(); dgAttendanceLogs.Rows.Add(x.ID, i, x.StudentID, valueStud != null ? valueStud.LastName + ", " + valueStud.FirstName : "Student name are not found", x.SubjectCode, x.RoomCode, x.Day, x.TimeIN, x.TimeOUT); i++; } }); } } //End #endregion #region 5 //Start 1 if (Date && Time && Day && SubCode && RoomCode) { dgAttendanceLogs.Rows.Clear(); var value = notify.GetUserTime().Where(x => (ConvertDates(x.TimeIN.Value) >= ConvertDates(dtDateStart.Value) && (ConvertDates(x.TimeIN.Value)) <= ConvertDates(dtDateEnd.Value)) && (ConvertTimes(x.TimeIN.Value) >= ConvertTimes(dtTimeIN.Value) && ConvertTimes(x.TimeIN.Value) <= ConvertTimes(dtTimeOUT.Value)) && x.Day == cmbDays.Text && x.SubjectCode == cmbSubCode.Text && x.RoomCode == cmbRoomCode.Text).ToList(); if (value.Count > 0) { value.ForEach(x => { using (Students stud = new Students()) { var valueStud = stud.GetStudentInfo().Where(xx => xx.StudentID == x.StudentID).FirstOrDefault(); dgAttendanceLogs.Rows.Add(x.ID, i, x.StudentID, valueStud != null ? valueStud.LastName + ", " + valueStud.FirstName : "Student name are not found", x.SubjectCode, x.RoomCode, x.Day, x.TimeIN, x.TimeOUT); i++; } }); } } //End #endregion #region 6 //Start 1 if (Date && Time && Day) { dgAttendanceLogs.Rows.Clear(); var value = notify.GetUserTime().Where(x => (ConvertDates(x.TimeIN.Value) >= ConvertDates(dtDateStart.Value) && (ConvertDates(x.TimeIN.Value)) <= ConvertDates(dtDateEnd.Value)) && (ConvertTimes(x.TimeIN.Value) >= ConvertTimes(dtTimeIN.Value) && ConvertTimes(x.TimeIN.Value) <= ConvertTimes(dtTimeOUT.Value))).ToList(); if (value.Count > 0) { value.ForEach(x => { using (Students stud = new Students()) { var valueStud = stud.GetStudentInfo().Where(xx => xx.StudentID == x.StudentID).FirstOrDefault(); dgAttendanceLogs.Rows.Add(x.ID, i, x.StudentID, valueStud != null ? valueStud.LastName + ", " + valueStud.FirstName : "Student name are not found", x.SubjectCode, x.RoomCode, x.Day, x.TimeIN, x.TimeOUT); i++; } }); } } //End #endregion #region 7 //Start 1 if (Time && Day && SubCode) { dgAttendanceLogs.Rows.Clear(); var value = notify.GetUserTime().Where(x => (ConvertTimes(x.TimeIN.Value) >= ConvertTimes(dtTimeIN.Value) && ConvertTimes(x.TimeIN.Value) <= ConvertTimes(dtTimeOUT.Value)) && x.Day == cmbDays.Text && x.SubjectCode == cmbSubCode.Text).ToList(); if (value.Count > 0) { value.ForEach(x => { using (Students stud = new Students()) { var valueStud = stud.GetStudentInfo().Where(xx => xx.StudentID == x.StudentID).FirstOrDefault(); dgAttendanceLogs.Rows.Add(x.ID, i, x.StudentID, valueStud != null ? valueStud.LastName + ", " + valueStud.FirstName : "Student name are not found", x.SubjectCode, x.RoomCode, x.Day, x.TimeIN, x.TimeOUT); i++; } }); } } //End #endregion #region 8 //Start 1 if (Day && SubCode && RoomCode) { dgAttendanceLogs.Rows.Clear(); var value = notify.GetUserTime().Where(x => x.Day == cmbDays.Text && x.SubjectCode == cmbSubCode.Text && x.RoomCode == cmbRoomCode.Text).ToList(); if (value.Count > 0) { value.ForEach(x => { using (Students stud = new Students()) { var valueStud = stud.GetStudentInfo().Where(xx => xx.StudentID == x.StudentID).FirstOrDefault(); dgAttendanceLogs.Rows.Add(x.ID, i, x.StudentID, valueStud != null ? valueStud.LastName + ", " + valueStud.FirstName : "Student name are not found", x.SubjectCode, x.RoomCode, x.Day, x.TimeIN, x.TimeOUT); i++; } }); } } //End #endregion #region 9 //Start 1 if (Date && SubCode && RoomCode) { dgAttendanceLogs.Rows.Clear(); var value = notify.GetUserTime().Where(x => (ConvertDates(x.TimeIN.Value) >= ConvertDates(dtDateStart.Value) && (ConvertDates(x.TimeIN.Value)) <= ConvertDates(dtDateEnd.Value)) && x.SubjectCode == cmbSubCode.Text && x.RoomCode == cmbRoomCode.Text).ToList(); if (value.Count > 0) { value.ForEach(x => { using (Students stud = new Students()) { var valueStud = stud.GetStudentInfo().Where(xx => xx.StudentID == x.StudentID).FirstOrDefault(); dgAttendanceLogs.Rows.Add(x.ID, i, x.StudentID, valueStud != null ? valueStud.LastName + ", " + valueStud.FirstName : "Student name are not found", x.SubjectCode, x.RoomCode, x.Day, x.TimeIN, x.TimeOUT); i++; } }); } } //End #endregion #region 10 //Start 1 if (Date && Time && RoomCode) { dgAttendanceLogs.Rows.Clear(); var value = notify.GetUserTime().Where(x => (ConvertDates(x.TimeIN.Value) >= ConvertDates(dtDateStart.Value) && (ConvertDates(x.TimeIN.Value)) <= ConvertDates(dtDateEnd.Value)) && (ConvertTimes(x.TimeIN.Value) >= ConvertTimes(dtTimeIN.Value) && ConvertTimes(x.TimeIN.Value) <= ConvertTimes(dtTimeOUT.Value)) && x.RoomCode == cmbRoomCode.Text).ToList(); if (value.Count > 0) { value.ForEach(x => { using (Students stud = new Students()) { var valueStud = stud.GetStudentInfo().Where(xx => xx.StudentID == x.StudentID).FirstOrDefault(); dgAttendanceLogs.Rows.Add(x.ID, i, x.StudentID, valueStud != null ? valueStud.LastName + ", " + valueStud.FirstName : "Student name are not found", x.SubjectCode, x.RoomCode, x.Day, x.TimeIN, x.TimeOUT); i++; } }); } } //End #endregion #region 11 //Start 1 if (Date && Time) { dgAttendanceLogs.Rows.Clear(); var value = notify.GetUserTime().Where(x => (ConvertDates(x.TimeIN.Value) >= ConvertDates(dtDateStart.Value) && (ConvertDates(x.TimeIN.Value)) <= ConvertDates(dtDateEnd.Value)) && (ConvertTimes(x.TimeIN.Value) >= ConvertTimes(dtTimeIN.Value) && ConvertTimes(x.TimeIN.Value) <= ConvertTimes(dtTimeOUT.Value))).ToList(); if (value.Count > 0) { value.ForEach(x => { using (Students stud = new Students()) { var valueStud = stud.GetStudentInfo().Where(xx => xx.StudentID == x.StudentID).FirstOrDefault(); dgAttendanceLogs.Rows.Add(x.ID, i, x.StudentID, valueStud != null ? valueStud.LastName + ", " + valueStud.FirstName : "Student name are not found", x.SubjectCode, x.RoomCode, x.Day, x.TimeIN, x.TimeOUT); i++; } }); } } //End #endregion #region 12 //Start 1 if (Time && Day) { dgAttendanceLogs.Rows.Clear(); var value = notify.GetUserTime().Where(x => (ConvertTimes(x.TimeIN.Value) >= ConvertTimes(dtTimeIN.Value) && ConvertTimes(x.TimeIN.Value) <= ConvertTimes(dtTimeOUT.Value)) && x.Day == cmbDays.Text).ToList(); if (value.Count > 0) { value.ForEach(x => { using (Students stud = new Students()) { var valueStud = stud.GetStudentInfo().Where(xx => xx.StudentID == x.StudentID).FirstOrDefault(); dgAttendanceLogs.Rows.Add(x.ID, i, x.StudentID, valueStud != null ? valueStud.LastName + ", " + valueStud.FirstName : "Student name are not found", x.SubjectCode, x.RoomCode, x.Day, x.TimeIN, x.TimeOUT); i++; } }); } } //End #endregion #region 13 //Start 1 if (SubCode && RoomCode) { dgAttendanceLogs.Rows.Clear(); var value = notify.GetUserTime().Where(x => x.SubjectCode == cmbSubCode.Text && x.RoomCode == cmbRoomCode.Text).ToList(); if (value.Count > 0) { value.ForEach(x => { using (Students stud = new Students()) { var valueStud = stud.GetStudentInfo().Where(xx => xx.StudentID == x.StudentID).FirstOrDefault(); dgAttendanceLogs.Rows.Add(x.ID, i, x.StudentID, valueStud != null ? valueStud.LastName + ", " + valueStud.FirstName : "Student name are not found", x.SubjectCode, x.RoomCode, x.Day, x.TimeIN, x.TimeOUT); i++; } }); } } //End #endregion #region 14 //Start 1 if (Date && RoomCode) { dgAttendanceLogs.Rows.Clear(); var value = notify.GetUserTime().Where(x => (ConvertDates(x.TimeIN.Value) >= ConvertDates(dtDateStart.Value) && (ConvertDates(x.TimeIN.Value)) <= ConvertDates(dtDateEnd.Value)) && x.RoomCode == cmbRoomCode.Text).ToList(); if (value.Count > 0) { value.ForEach(x => { using (Students stud = new Students()) { var valueStud = stud.GetStudentInfo().Where(xx => xx.StudentID == x.StudentID).FirstOrDefault(); dgAttendanceLogs.Rows.Add(x.ID, i, x.StudentID, valueStud != null ? valueStud.LastName + ", " + valueStud.FirstName : "Student name are not found", x.SubjectCode, x.RoomCode, x.Day, x.TimeIN, x.TimeOUT); i++; } }); } } //End #endregion #region 15 //Start 1 if (Date) { dgAttendanceLogs.Rows.Clear(); var value = notify.GetUserTime().Where(x => (ConvertDates(x.TimeIN.Value) >= ConvertDates(dtDateStart.Value) && (ConvertDates(x.TimeIN.Value)) <= ConvertDates(dtDateEnd.Value))).ToList(); if (value.Count > 0) { value.ForEach(x => { using (Students stud = new Students()) { var valueStud = stud.GetStudentInfo().Where(xx => xx.StudentID == x.StudentID).FirstOrDefault(); dgAttendanceLogs.Rows.Add(x.ID, i, x.StudentID, valueStud != null ? valueStud.LastName + ", " + valueStud.FirstName : "Student name are not found", x.SubjectCode, x.RoomCode, x.Day, x.TimeIN, x.TimeOUT); i++; } }); } } //End #endregion #region 16 //Start 1 if (Time) { dgAttendanceLogs.Rows.Clear(); var value = notify.GetUserTime().Where(x => (ConvertTimes(x.TimeIN.Value) >= ConvertTimes(dtTimeIN.Value) && ConvertTimes(x.TimeIN.Value) <= ConvertTimes(dtTimeOUT.Value))).ToList(); if (value.Count > 0) { value.ForEach(x => { using (Students stud = new Students()) { var valueStud = stud.GetStudentInfo().Where(xx => xx.StudentID == x.StudentID).FirstOrDefault(); dgAttendanceLogs.Rows.Add(x.ID, i, x.StudentID, valueStud != null ? valueStud.LastName + ", " + valueStud.FirstName : "Student name are not found", x.SubjectCode, x.RoomCode, x.Day, x.TimeIN, x.TimeOUT); i++; } }); } } //End #endregion #region 17 //Start 1 if (Day) { dgAttendanceLogs.Rows.Clear(); var value = notify.GetUserTime().Where(x => x.Day == cmbDays.Text).ToList(); if (value.Count > 0) { value.ForEach(x => { using (Students stud = new Students()) { var valueStud = stud.GetStudentInfo().Where(xx => xx.StudentID == x.StudentID).FirstOrDefault(); dgAttendanceLogs.Rows.Add(x.ID, i, x.StudentID, valueStud != null ? valueStud.LastName + ", " + valueStud.FirstName : "Student name are not found", x.SubjectCode, x.RoomCode, x.Day, x.TimeIN, x.TimeOUT); i++; } }); } } //End #endregion #region 18 //Start 1 if (SubCode) { dgAttendanceLogs.Rows.Clear(); var value = notify.GetUserTime().Where(x => x.SubjectCode == cmbSubCode.Text).ToList(); if (value.Count > 0) { value.ForEach(x => { using (Students stud = new Students()) { var valueStud = stud.GetStudentInfo().Where(xx => xx.StudentID == x.StudentID).FirstOrDefault(); dgAttendanceLogs.Rows.Add(x.ID, i, x.StudentID, valueStud != null ? valueStud.LastName + ", " + valueStud.FirstName : "Student name are not found", x.SubjectCode, x.RoomCode, x.Day, x.TimeIN, x.TimeOUT); i++; } }); } } //End #endregion #region 19 //Start 1 if (RoomCode) { dgAttendanceLogs.Rows.Clear(); var value = notify.GetUserTime().Where(x => x.RoomCode == cmbRoomCode.Text).ToList(); if (value.Count > 0) { value.ForEach(x => { using (Students stud = new Students()) { var valueStud = stud.GetStudentInfo().Where(xx => xx.StudentID == x.StudentID).FirstOrDefault(); dgAttendanceLogs.Rows.Add(x.ID, i, x.StudentID, valueStud != null ? valueStud.LastName + ", " + valueStud.FirstName : "Student name are not found", x.SubjectCode, x.RoomCode, x.Day, x.TimeIN, x.TimeOUT); i++; } }); } } //End #endregion } }
void Save() { T_RegisteredStudentSemester ret = new T_RegisteredStudentSemester(); var StudentSelected = dgStudentList.Rows.Cast <DataGridViewRow>().Where(x => Convert.ToBoolean(x.Cells[6].Value)).ToList(); var DaySelected = dgDay.Rows.Cast <DataGridViewRow>().Where(d => Convert.ToBoolean(d.Cells[1].Value)).ToList(); var TimeSelected = dgTime.Rows.Cast <DataGridViewRow>().Where(t => Convert.ToBoolean(t.Cells[2].Value)).ToList(); if (StudentSelected.Count > 0) { StudentSelected.ForEach(s => { ret.StudentID = s.Cells[2].Value.ToString(); using (Students std = new Students()) { var stud = std.GetStudentInfo().Where(x => x.StudentID == s.Cells[2].Value.ToString()).FirstOrDefault(); ret.Active = true; ret.RFID = stud.RFIDNo; ret.RoomCode = cmbRoomCode.Text; ret.MessageID = cmbMessage.Text; ret.SubjectCode = cmbSubjectCode.Text; ret.SubjectDescription = txtSubjectDesc.Text; ret.Semester = SystemProperties.SemesterActive.Semester; ret.SemStartDate = SystemProperties.SemesterActive.Start; ret.SemEndDate = SystemProperties.SemesterActive.End; ret.YearClass = SystemProperties.SemesterActive.YearSemester; using (Parents parent = new Parents()) { var part = parent.GetParentsInfo().Where(pp => pp.StudentID == stud.StudentID).FirstOrDefault(); ret.ParentsNo = !string.IsNullOrWhiteSpace(part.MomContactNo)?part.MomContactNo:part.DadContactNo; } if (DaySelected.Count > 0) { DaySelected.ForEach(dd => { ret.Day = dd.Cells[0].Value.ToString(); if (TimeSelected.Count > 0) { TimeSelected.ForEach(tt => { var _tt = tt.Cells[3].Value.ToString(); using (Maintenance maintain = new Maintenance()) { var TimeStartEnd = maintain.GetTime().Where(ttt => ttt.TimeCode == _tt).FirstOrDefault(); ret.TimeStart = TimeStartEnd.TimeStart.Value; ret.TImeEnd = TimeStartEnd.TimeEnd.Value; using (SMSNotification notify = new SMSNotification()) { string msgRet = ""; notify.Save(ret, ref msgRet); lblMessage.Text = msgRet; } } }); } else { SystemProperties.ShowMessage.MessageError("Select time first", "Time Error"); } }); } else { SystemProperties.ShowMessage.MessageError("Select day first", "Day Error"); } } }); } GetDayAndTime(); GetRoomSubjectMessage(); LoadStudent(); ObjEnable(false); SystemProperties.Cleared(this, false, true, true); dgDay.Enabled = dgTime.Enabled = dgStudentList.Enabled = false; txtRoomDesc.ReadOnly = true; txtSubjectDesc.ReadOnly = true; }
public Response<ProviderModel> ApproveRetailer(ProviderModel model) { string ReturnLink = string.Empty; var phone = string.Empty; Response<ProviderModel> returnModel = new Response<ProviderModel>(); try { using (SqlConnection DB = new SqlConnection(SiteKey.ConnectionString)) { DB.ExecuteSql(@"update provider set admin_approve = @admin_approve where id = @id ", new { id = model.id, admin_approve = model.admin_approve, }); phone = DB.QuerySql<string>(@"Select country_code + contact_no as phone, admin_approve from provider where id= @id", new { id = model.id }).FirstOrDefault(); } returnModel.status = (int)EnumClass.ResponseState.Success; returnModel.msg = Resource_Kharban.UpdateSuccessfully; returnModel.success = true; if(!string.IsNullOrEmpty(phone)) { if (model.admin_approve == 1) { sendSMS("Kharban", $"{model.country_code}{model.contact_no}", "Your account is approved, You can login now"); } else { sendSMS("Kharban", $"{model.country_code}{model.contact_no}", "Your account is rejected."); } } string DeviceId = string.Empty; using (SqlConnection DB = new SqlConnection(SiteKey.ConnectionString)) { DeviceId = DB.QuerySql<string>("select device_id from device_data where user_id = @UserId and user_active = 1", new { UserId = model.id }).FirstOrDefault(); if (model.admin_approve == 1) { var notification = "Congratulations! Your account has been approved by the admin, you can now access the complete features of Kharban."; SMSNotification.PushNotificationAsync(DeviceId, "Kharban", notification, "Home", 1); } else { var notification = "We are sorry, we can not approve your account at the moment, for any query please contact the admin."; SMSNotification.PushNotificationAsync(DeviceId, "Kharban", notification, "Home", 1); } } } catch (Exception ex) { returnModel.msg = ex.Message; returnModel.status = (int)EnumClass.ResponseState.ResposityError; LoggingRepository.SaveException(ex); } return returnModel; }
/// <summary> /// Send SMS Message /// </summary> /// <param name="message"></param> private void SendSMS(IPDMessage message) { SMSNotification.Notify(message.Sender, message.ReceiverUri, message.Subject, commParams.SMSUserName, commParams.SMSPasword, commParams.SMSKey); }
public HttpResponseMessage ResendOTPNumber(int nApplicationID, string sPhoneNumber, int nLanguageID) { ApiResponse oApiResponse = new ApiResponse(); string sResultMessage = string.Empty; try { int nOTPNumber = CommonHelper.nGenerateRandomInteger(1000, 9999); Response oResponse = this.oIAuthenticationService.oResendOTPNumber(nApplicationID, sPhoneNumber, nOTPNumber); if (oResponse.OperationResult == enumOperationResult.Success) { oApiResponse.OperationResult = 1; sResultMessage = nLanguageID == 2 ? "OTP has been successfully sent." : "تم إرسال رمز التفعيل بنجاح ."; oApiResponse.OperationResultMessage = sResultMessage; //TODO::integrate with sms service and update status to database oApiResponse.ResponseCode = nOTPNumber.ToString(); Languages enmUserLanuage = (Languages)Enum.Parse(typeof(Languages), nLanguageID.ToString()); //Send OTP via SMS and update in DB SMSNotification oSMSNotification = new SMSNotification(); SMSViewModel oSMSViewModel = new SMSViewModel(); //oSMSViewModel.Language = enmUserLanuage == Languages.English ? 0 : 64; oSMSViewModel.Language = 64; string sMessage = string.Empty; if (enmUserLanuage == Languages.English) { sMessage = string.Format("Thank you for registering with {0}, Your activation code is : {1}.", oResponse.ResponseCode, nOTPNumber); } else { string sMessagePart1 = "نشكرك على تسجيلك في تطبيق "; sMessagePart1 = sMessagePart1 + oResponse.ResponseCode + ", "; string sMessagePart2 = "رمز التفعيل الخاص بك هو : "; sMessagePart2 = sMessagePart2 + nOTPNumber; sMessage = sMessagePart1 + sMessagePart2; } oSMSViewModel.Message = sMessage; oSMSViewModel.Recipient = sPhoneNumber; oSMSViewModel.RecipientType = 1; bool bSentSMS = oSMSNotification.bSendOTPSMS(oSMSViewModel); Response oResponseOTPStatus = this.oIAuthenticationService.oUpdateOTPStatus(oApiResponse.ResponseID, bSentSMS); } else if (oResponse.OperationResult == enumOperationResult.RelatedRecordFaild) { oApiResponse.OperationResult = -2; sResultMessage = nLanguageID == 2 ? "You have exceeded the maximum number of attempt.Please contact app administrator." : "لقد تجاوزت الحد الأقصى لعدد المحاولات. يرجى الاتصال بمشرف التطبيق ."; oApiResponse.OperationResultMessage = sResultMessage; } else if (oResponse.OperationResult == enumOperationResult.AlreadyExistRecordFaild) { oApiResponse.OperationResult = -3; sResultMessage = nLanguageID == 2 ? "The user does not exist.Please contact app administrator" : "المستخدم غير مسجل . يرجى الاتصال بمشرف التطبيق"; oApiResponse.OperationResultMessage = sResultMessage; } else { oApiResponse.OperationResult = 0; sResultMessage = nLanguageID == 2 ? "An error Occured.Please contact app administrator." : "حدث خطأ الرجاء الاتصال بمشرف التطبيق."; oApiResponse.OperationResultMessage = sResultMessage; } return(Request.CreateResponse(HttpStatusCode.OK, oApiResponse)); } catch (Exception ex) { oApiResponse.OperationResult = 0; sResultMessage = nLanguageID == 2 ? "An error occurred during the operation. Please try again later." : "حدث خطأ يرجى المحاولة لاحقا مرة أخرى"; oApiResponse.OperationResultMessage = sResultMessage; return(Request.CreateResponse(HttpStatusCode.InternalServerError, oApiResponse)); Elmah.ErrorLog.GetDefault(HttpContext.Current).Log(new Elmah.Error(ex)); } }
public HttpResponseMessage RegisterUser(TakamulUser oTakamulUser, int nLanguageID) { ApiResponse oApiResponse = new ApiResponse(); string sResultMessage = string.Empty; if (ModelState.IsValid) { try { int nOTPNumber = CommonHelper.nGenerateRandomInteger(1000, 9999); UserInfoViewModel oUserInfoViewModel = new UserInfoViewModel() { APPLICATION_ID = oTakamulUser.ApplicationID, USER_TYPE_ID = 4, //Mobile user type FULL_NAME = oTakamulUser.FullName, PHONE_NUMBER = oTakamulUser.PhoneNumber, EMAIL = oTakamulUser.Email, ADDRESS = oTakamulUser.Addresss, AREA_ID = oTakamulUser.AreaID, WILAYAT_ID = oTakamulUser.WilayatID, VILLAGE_ID = oTakamulUser.VillageID, OTP_NUMBER = nOTPNumber, DEVICE_ID = oTakamulUser.DeviceID, PREFERED_LANGUAGE_ID = nLanguageID }; Response oResponse = this.oIAuthenticationService.oInsertMobileUser(oUserInfoViewModel); if (oResponse.OperationResult == enumOperationResult.Success) { oApiResponse.OperationResult = 1; sResultMessage = nLanguageID == 2 ? "User registered successfully." : "تم تسجيل المستخدم بنجاح."; oApiResponse.OperationResultMessage = sResultMessage; oApiResponse.ResponseID = Convert.ToInt32(oResponse.ResponseID); oApiResponse.ResponseCode = nOTPNumber.ToString(); Languages enmUserLanuage = (Languages)Enum.Parse(typeof(Languages), nLanguageID.ToString()); //Send OTP via SMS and update in DB SMSNotification oSMSNotification = new SMSNotification(); SMSViewModel oSMSViewModel = new SMSViewModel(); //oSMSViewModel.Language = enmUserLanuage == Languages.English ? 0 : 64; oSMSViewModel.Language = 64; string sMessage = string.Empty; if (enmUserLanuage == Languages.English) { sMessage = string.Format("Thank you for registering with {0}, Your activation code is : {1}.", oResponse.ResponseCode, oUserInfoViewModel.OTP_NUMBER); } else { string sMessagePart1 = "نشكرك على تسجيلك في تطبيق "; sMessagePart1 = sMessagePart1 + oResponse.ResponseCode + ", "; string sMessagePart2 = "رمز التفعيل الخاص بك هو : "; sMessagePart2 = sMessagePart2 + oUserInfoViewModel.OTP_NUMBER; sMessage = sMessagePart1 + sMessagePart2; } oSMSViewModel.Message = sMessage; oSMSViewModel.Recipient = oUserInfoViewModel.PHONE_NUMBER; oSMSViewModel.RecipientType = 1; bool bSentSMS = oSMSNotification.bSendOTPSMS(oSMSViewModel); Response oResponseOTPStatus = this.oIAuthenticationService.oUpdateOTPStatus(oApiResponse.ResponseID, bSentSMS); } else if (oResponse.OperationResult == enumOperationResult.AlreadyExistRecordFaild) { oApiResponse.OperationResult = -3; sResultMessage = nLanguageID == 2 ? "The user already exists.Please contact app administrator." : "المستخدم مسجل من قبل. الرجاء الاتصال بمشرف التطبيق."; oApiResponse.OperationResultMessage = sResultMessage; } else { oApiResponse.OperationResult = 0; sResultMessage = nLanguageID == 2 ? "Error Occured.Please contact app administrator." : "حدث خطأ الرجاء الاتصال بمشرف التطبيق."; oApiResponse.OperationResultMessage = sResultMessage; } return(Request.CreateResponse(HttpStatusCode.OK, oApiResponse)); } catch (Exception ex) { oApiResponse.OperationResult = 0; sResultMessage = nLanguageID == 2 ? "An error occurred during the operation. Please try again later." : "حدث خطأ يرجى المحاولة لاحقا مرة أخرى"; oApiResponse.OperationResultMessage = sResultMessage; return(Request.CreateResponse(HttpStatusCode.InternalServerError, oApiResponse)); Elmah.ErrorLog.GetDefault(HttpContext.Current).Log(new Elmah.Error(ex)); } } oApiResponse.OperationResult = 0; sResultMessage = nLanguageID == 2 ? "Validation failed." : "خطاء في التحقق."; oApiResponse.OperationResultMessage = sResultMessage; return(Request.CreateResponse(HttpStatusCode.BadRequest, oApiResponse)); }
public SMSNotificationEditor(StepEditContext context, SMSNotification notification) : this() { this.SetContext(context, notification); }
public SMSNotification GetSMSNotification(UserProfile user) { SMSNotification sms = new SMSNotification(); sms.Recipients = new List<string>(); sms.Recipients.Add(user.NotificationCellPhone); sms.Text = GetShortNotificationBody(); return sms; }
public async System.Threading.Tasks.Task <Response <PushNotificationModel> > SendPushNotifications(PushNotificationModel model) { int TotalRecords = 0; Response <PushNotificationModel> returnModel = new Response <PushNotificationModel>(); if (string.IsNullOrEmpty(model.customer_id) && string.IsNullOrEmpty(model.provider_id) && !model.receiver_all) { returnModel.msg = "Please select the receiver"; returnModel.status = (int)EnumClass.ResponseState.ResposityError; returnModel.success = false; return(returnModel); } if (string.IsNullOrEmpty(model.text)) { returnModel.msg = "Please enter the message"; returnModel.status = (int)EnumClass.ResponseState.ResposityError; returnModel.success = false; return(returnModel); } using (SqlConnection DB = new SqlConnection(SiteKey.ConnectionString)) { List <string> Receivers = new List <string>(); List <string> Receivers1 = new List <string>(); string DeviceId = string.Empty; if (model.receiver_all) { //send notification to customer Receivers = DB.QuerySql <string>(@"SELECT id FROM customer where is_deleted = 0 ").ToList(); if (Receivers != null) { foreach (var item in Receivers) { DeviceId = DB.QuerySql <string>("select device_id from device_data where user_id = @UserId and user_active = 1", new { UserId = item }).FirstOrDefault(); if (DeviceId != null) { await SMSNotification.PushNotificationAsync(DeviceId, "Kharban", model.subject + Environment.NewLine + model.text, "Home", 1); } } } //send notification to provider Receivers1 = DB.QuerySql <string>(@"SELECT id FROM provider where is_deleted = 0 and is_online = 1 ").ToList(); if (Receivers1 != null) { foreach (var item in Receivers1) { DeviceId = DB.QuerySql <string>("select device_id from device_data where user_id = @UserId and user_active = 1", new { UserId = item }).FirstOrDefault(); if (DeviceId != null) { await SMSNotification.PushNotificationAsync(DeviceId, "Kharban", model.subject + Environment.NewLine + model.text, "Home", 1); } } } } if (model.customer_id != string.Empty) { DeviceId = DB.QuerySql <string>("select device_id from device_data where user_id = @UserId and user_active = 1", new { UserId = model.customer_id }).FirstOrDefault(); if (DeviceId != null) { await SMSNotification.PushNotificationAsync(DeviceId, "Kharban", model.subject + Environment.NewLine + model.text, "Home", 1); } } if (model.provider_id != string.Empty) { DeviceId = DB.QuerySql <string>("select device_id from device_data where user_id = @UserId and user_active = 1", new { UserId = model.provider_id }).FirstOrDefault(); if (DeviceId != null) { await SMSNotification.PushNotificationAsync(DeviceId, "Kharban", model.subject + Environment.NewLine + model.text, "Home", 1); } } } returnModel.status = (int)EnumClass.ResponseState.Success; returnModel.success = true; return(returnModel); }
void LoadSearch(bool Year, bool Semester, bool Room, bool Subject) { dgRoomRecord.Rows.Clear(); int i = 1; using (SMSNotification notify = new SMSNotification()) { using (Maintenance maintain = new Maintenance()) { using (Students stud = new Students()) { if (!Year && !Semester && !Room && !Subject) { LoadRoomRecord(); } if (Year && Semester && Room && Subject)//four { dgRoomRecord.Rows.Clear(); var value = notify.GetRegisterStudent().Where(x => x.YearClass == cmbYearClass.Text && x.Semester == cmbSemester.Text && x.RoomCode == cmbRoomCode.Text && x.SubjectCode == cmbSubCode.Text).OrderBy(o => o.TimeStart).ToList(); if (value.Count > 0) { value.ForEach(x => { var studs = stud.GetStudentInfo().Where(s => s.StudentID == x.StudentID).FirstOrDefault(); var valueBldg = maintain.GetRoom().Where(xx => xx.RoomCode == x.RoomCode).FirstOrDefault(); dgRoomRecord.Rows.Add(x.ID, i, x.StudentID, studs.LastName + "," + studs.FirstName, x.Semester, valueBldg.BuildingCode, x.RoomCode, valueBldg.Description, x.TimeStart.ToShortTimeString() + " to " + x.TImeEnd.ToShortTimeString()); i++; }); } } if (Year) //four { dgRoomRecord.Rows.Clear(); var value = notify.GetRegisterStudent().Where(x => x.YearClass == cmbYearClass.Text).OrderBy(o => o.TimeStart).ToList(); if (value.Count > 0) { value.ForEach(x => { var studs = stud.GetStudentInfo().Where(s => s.StudentID == x.StudentID).FirstOrDefault(); var valueBldg = maintain.GetRoom().Where(xx => xx.RoomCode == x.RoomCode).FirstOrDefault(); dgRoomRecord.Rows.Add(x.ID, i, x.StudentID, studs.LastName + "," + studs.FirstName, x.Semester, valueBldg.BuildingCode, x.RoomCode, valueBldg.Description, x.TimeStart.ToShortTimeString() + " to " + x.TImeEnd.ToShortTimeString()); i++; }); } } if (Semester) //four { dgRoomRecord.Rows.Clear(); var value = notify.GetRegisterStudent().Where(x => x.Semester == cmbSemester.Text).OrderBy(o => o.TimeStart).ToList(); if (value.Count > 0) { value.ForEach(x => { var studs = stud.GetStudentInfo().Where(s => s.StudentID == x.StudentID).FirstOrDefault(); var valueBldg = maintain.GetRoom().Where(xx => xx.RoomCode == x.RoomCode).FirstOrDefault(); dgRoomRecord.Rows.Add(x.ID, i, x.StudentID, studs.LastName + "," + studs.FirstName, x.Semester, valueBldg.BuildingCode, x.RoomCode, valueBldg.Description, x.TimeStart.ToShortTimeString() + " to " + x.TImeEnd.ToShortTimeString()); i++; }); } } if (Room) //four { dgRoomRecord.Rows.Clear(); var value = notify.GetRegisterStudent().Where(x => x.RoomCode == cmbRoomCode.Text).OrderBy(o => o.TimeStart).ToList(); if (value.Count > 0) { value.ForEach(x => { var studs = stud.GetStudentInfo().Where(s => s.StudentID == x.StudentID).FirstOrDefault(); var valueBldg = maintain.GetRoom().Where(xx => xx.RoomCode == x.RoomCode).FirstOrDefault(); dgRoomRecord.Rows.Add(x.ID, i, x.StudentID, studs.LastName + "," + studs.FirstName, x.Semester, valueBldg.BuildingCode, x.RoomCode, valueBldg.Description, x.TimeStart.ToShortTimeString() + " to " + x.TImeEnd.ToShortTimeString()); i++; }); } } if (Subject)//four { dgRoomRecord.Rows.Clear(); var value = notify.GetRegisterStudent().Where(x => x.SubjectCode == cmbSubCode.Text).OrderBy(o => o.TimeStart).ToList(); if (value.Count > 0) { value.ForEach(x => { var studs = stud.GetStudentInfo().Where(s => s.StudentID == x.StudentID).FirstOrDefault(); var valueBldg = maintain.GetRoom().Where(xx => xx.RoomCode == x.RoomCode).FirstOrDefault(); dgRoomRecord.Rows.Add(x.ID, i, x.StudentID, studs.LastName + "," + studs.FirstName, x.Semester, valueBldg.BuildingCode, x.RoomCode, valueBldg.Description, x.TimeStart.ToShortTimeString() + " to " + x.TImeEnd.ToShortTimeString()); i++; }); } } if (Year && Semester && Room) { dgRoomRecord.Rows.Clear(); var value = notify.GetRegisterStudent().Where(x => x.YearClass == cmbYearClass.Text && x.Semester == cmbSemester.Text && x.RoomCode == cmbRoomCode.Text).OrderBy(o => o.TimeStart).ToList(); if (value.Count > 0) { value.ForEach(x => { var studs = stud.GetStudentInfo().Where(s => s.StudentID == x.StudentID).FirstOrDefault(); var valueBldg = maintain.GetRoom().Where(xx => xx.RoomCode == x.RoomCode).FirstOrDefault(); dgRoomRecord.Rows.Add(x.ID, i, x.StudentID, studs.LastName + "," + studs.FirstName, x.Semester, valueBldg.BuildingCode, x.RoomCode, valueBldg.Description, x.TimeStart.ToShortTimeString() + " to " + x.TImeEnd.ToShortTimeString()); i++; }); } } if (Year && Semester && Subject) { dgRoomRecord.Rows.Clear(); var value = notify.GetRegisterStudent().Where(x => x.YearClass == cmbYearClass.Text && x.Semester == cmbSemester.Text && x.SubjectCode == cmbSubCode.Text).OrderBy(o => o.TimeStart).ToList(); if (value.Count > 0) { value.ForEach(x => { var studs = stud.GetStudentInfo().Where(s => s.StudentID == x.StudentID).FirstOrDefault(); var valueBldg = maintain.GetRoom().Where(xx => xx.RoomCode == x.RoomCode).FirstOrDefault(); dgRoomRecord.Rows.Add(x.ID, i, x.StudentID, studs.LastName + "," + studs.FirstName, x.Semester, valueBldg.BuildingCode, x.RoomCode, valueBldg.Description, x.TimeStart.ToShortTimeString() + " to " + x.TImeEnd.ToShortTimeString()); i++; }); } } if (Semester && Room && Subject) { dgRoomRecord.Rows.Clear(); var value = notify.GetRegisterStudent().Where(x => x.Semester == cmbSemester.Text && x.RoomCode == cmbRoomCode.Text && x.SubjectCode == cmbSubCode.Text).OrderBy(o => o.TimeStart).ToList(); if (value.Count > 0) { value.ForEach(x => { var studs = stud.GetStudentInfo().Where(s => s.StudentID == x.StudentID).FirstOrDefault(); var valueBldg = maintain.GetRoom().Where(xx => xx.RoomCode == x.RoomCode).FirstOrDefault(); dgRoomRecord.Rows.Add(x.ID, i, x.StudentID, studs.LastName + "," + studs.FirstName, x.Semester, valueBldg.BuildingCode, x.RoomCode, valueBldg.Description, x.TimeStart.ToShortTimeString() + " to " + x.TImeEnd.ToShortTimeString()); i++; }); } } if (Year && Room && Subject) { dgRoomRecord.Rows.Clear(); var value = notify.GetRegisterStudent().Where(x => x.YearClass == cmbYearClass.Text && x.RoomCode == cmbRoomCode.Text && x.SubjectCode == cmbSubCode.Text).OrderBy(o => o.TimeStart).ToList(); if (value.Count > 0) { value.ForEach(x => { var studs = stud.GetStudentInfo().Where(s => s.StudentID == x.StudentID).FirstOrDefault(); var valueBldg = maintain.GetRoom().Where(xx => xx.RoomCode == x.RoomCode).FirstOrDefault(); dgRoomRecord.Rows.Add(x.ID, i, x.StudentID, studs.LastName + "," + studs.FirstName, x.Semester, valueBldg.BuildingCode, x.RoomCode, valueBldg.Description, x.TimeStart.ToShortTimeString() + " to " + x.TImeEnd.ToShortTimeString()); i++; }); } } if (Year && Semester) { dgRoomRecord.Rows.Clear(); var value = notify.GetRegisterStudent().Where(x => x.YearClass == cmbYearClass.Text && x.Semester == cmbSemester.Text).OrderBy(o => o.TimeStart).ToList(); if (value.Count > 0) { value.ForEach(x => { var studs = stud.GetStudentInfo().Where(s => s.StudentID == x.StudentID).FirstOrDefault(); var valueBldg = maintain.GetRoom().Where(xx => xx.RoomCode == x.RoomCode).FirstOrDefault(); dgRoomRecord.Rows.Add(x.ID, i, x.StudentID, studs.LastName + "," + studs.FirstName, x.Semester, valueBldg.BuildingCode, x.RoomCode, valueBldg.Description, x.TimeStart.ToShortTimeString() + " to " + x.TImeEnd.ToShortTimeString()); i++; }); } } if (Year && Room) { dgRoomRecord.Rows.Clear(); var value = notify.GetRegisterStudent().Where(x => x.YearClass == cmbYearClass.Text && x.RoomCode == cmbRoomCode.Text).OrderBy(o => o.TimeStart).ToList(); if (value.Count > 0) { value.ForEach(x => { var studs = stud.GetStudentInfo().Where(s => s.StudentID == x.StudentID).FirstOrDefault(); var valueBldg = maintain.GetRoom().Where(xx => xx.RoomCode == x.RoomCode).FirstOrDefault(); dgRoomRecord.Rows.Add(x.ID, i, x.StudentID, studs.LastName + "," + studs.FirstName, x.Semester, valueBldg.BuildingCode, x.RoomCode, valueBldg.Description, x.TimeStart.ToShortTimeString() + " to " + x.TImeEnd.ToShortTimeString()); i++; }); } } if (Year && Subject) { dgRoomRecord.Rows.Clear(); var value = notify.GetRegisterStudent().Where(x => x.YearClass == cmbYearClass.Text && x.SubjectCode == cmbSubCode.Text).OrderBy(o => o.TimeStart).ToList(); if (value.Count > 0) { value.ForEach(x => { var studs = stud.GetStudentInfo().Where(s => s.StudentID == x.StudentID).FirstOrDefault(); var valueBldg = maintain.GetRoom().Where(xx => xx.RoomCode == x.RoomCode).FirstOrDefault(); dgRoomRecord.Rows.Add(x.ID, i, x.StudentID, studs.LastName + "," + studs.FirstName, x.Semester, valueBldg.BuildingCode, x.RoomCode, valueBldg.Description, x.TimeStart.ToShortTimeString() + " to " + x.TImeEnd.ToShortTimeString()); i++; }); } } if (Semester && Room) { dgRoomRecord.Rows.Clear(); var value = notify.GetRegisterStudent().Where(x => x.Semester == cmbSemester.Text && x.RoomCode == cmbRoomCode.Text).OrderBy(o => o.TimeStart).ToList(); if (value.Count > 0) { value.ForEach(x => { var studs = stud.GetStudentInfo().Where(s => s.StudentID == x.StudentID).FirstOrDefault(); var valueBldg = maintain.GetRoom().Where(xx => xx.RoomCode == x.RoomCode).FirstOrDefault(); dgRoomRecord.Rows.Add(x.ID, i, x.StudentID, studs.LastName + "," + studs.FirstName, x.Semester, valueBldg.BuildingCode, x.RoomCode, valueBldg.Description, x.TimeStart.ToShortTimeString() + " to " + x.TImeEnd.ToShortTimeString()); i++; }); } } if (Semester && Subject) { dgRoomRecord.Rows.Clear(); var value = notify.GetRegisterStudent().Where(x => x.Semester == cmbSemester.Text && x.SubjectCode == cmbSubCode.Text).OrderBy(o => o.TimeStart).ToList(); if (value.Count > 0) { value.ForEach(x => { var studs = stud.GetStudentInfo().Where(s => s.StudentID == x.StudentID).FirstOrDefault(); var valueBldg = maintain.GetRoom().Where(xx => xx.RoomCode == x.RoomCode).FirstOrDefault(); dgRoomRecord.Rows.Add(x.ID, i, x.StudentID, studs.LastName + "," + studs.FirstName, x.Semester, valueBldg.BuildingCode, x.RoomCode, valueBldg.Description, x.TimeStart.ToShortTimeString() + " to " + x.TImeEnd.ToShortTimeString()); i++; }); } } if (Room && Subject) { dgRoomRecord.Rows.Clear(); var value = notify.GetRegisterStudent().Where(x => x.RoomCode == cmbRoomCode.Text && x.SubjectCode == cmbSubCode.Text).OrderBy(o => o.TimeStart).ToList(); if (value.Count > 0) { value.ForEach(x => { var studs = stud.GetStudentInfo().Where(s => s.StudentID == x.StudentID).FirstOrDefault(); var valueBldg = maintain.GetRoom().Where(xx => xx.RoomCode == x.RoomCode).FirstOrDefault(); dgRoomRecord.Rows.Add(x.ID, i, x.StudentID, studs.LastName + "," + studs.FirstName, x.Semester, valueBldg.BuildingCode, x.RoomCode, valueBldg.Description, x.TimeStart.ToShortTimeString() + " to " + x.TImeEnd.ToShortTimeString()); i++; }); } } } } } }