public static ClientModel Build(int ClientId, DASEntities db) { //ClientModel model = new ClientModel(); ClientModel model = db.Clients.Where(a => a.ClientId == ClientId).Select(a => new ClientModel() { ClientName = a.Name, Description = a.Description, Address = a.Address, ClientId = a.ClientId }).FirstOrDefault(); model.Certificates = new List <CertModel>(); IList <Certificate> certs = db.Certificates.Where(j => j.ClientId == ClientId).ToList(); CertModel temp; foreach (var item in certs) { temp = new CertModel() { CertId = item.CertificateId, CertName = item.CertificateName, Standard = item.Standard }; temp.Status = GetStatusName(db, item.StatusId); temp.Statuses = BuildStatuses(db); temp.StatusID = item.StatusId; model.Certificates.Add(temp); } return(model); }
public JsonResult AddCertificate(int clientId, string certName, string standard, int statusId) { /*ModelState.Clear();*/ Certificate cert; cert = new Certificate(); cert.CertificateId = Db.Certificates.Select(j => j.CertificateId).Max() + 1; cert.CertificateName = certName; cert.ClientId = clientId; cert.Standard = standard; cert.StatusId = statusId; Db.Certificates.Add(cert); Db.SaveChanges(); IList <CertModel> model = new List <CertModel>(); IList <Certificate> certs = Db.Certificates.Where(j => j.ClientId == cert.ClientId).ToList(); CertModel temp; foreach (var item in certs) { temp = new CertModel() { CertId = item.CertificateId, CertName = item.CertificateName, Standard = item.Standard }; temp.Status = ClientDetailsBuilder.GetStatusName(Db, item.StatusId); temp.StatusID = item.StatusId; model.Add(temp); } return(Json(ResponseStatus.Success, new { html = RenderPartialViewToString("Certificate", model) })); }
public JsonResult SaveCerftificate(int certId, string certName, string standard, int statusId) { Certificate c = Db.Certificates.Where(j => j.CertificateId == certId).FirstOrDefault(); IList <CertModel> model = new List <CertModel>(); c.CertificateName = certName; c.Standard = standard; c.StatusId = statusId; Db.SaveChanges(); IList <Certificate> certs = Db.Certificates.Where(j => j.ClientId == c.ClientId).ToList(); CertModel temp; foreach (var item in certs) { temp = new CertModel() { CertId = item.CertificateId, CertName = item.CertificateName, Standard = item.Standard }; temp.Status = ClientDetailsBuilder.GetStatusName(Db, item.StatusId); temp.StatusID = item.StatusId; model.Add(temp); } return(Json(ResponseStatus.Success, new { html = RenderPartialViewToString("Certificate", model) })); }
public ActionResult AddCertificateEditor() { CertModel model = new CertModel(); model.Statuses = ClientDetailsBuilder.BuildStatuses(Db); return(Json(ResponseStatus.Success, RenderPartialViewToString("AddCertificate", model), JsonRequestBehavior.AllowGet)); }
private void CertDataGridView_CellContentClick(object sender, DataGridViewCellEventArgs e) { if (e.ColumnIndex == CertDataGridView.Columns["ViewStudentImage"].Index && e.RowIndex >= 0) { int certId = int.Parse(CertDataGridView.Rows[e.RowIndex].Cells["Id"].Value.ToString()); CertModel certModel = managingCertService.GetSingleCertById(certId); string imageName = managingStudentService.GetStudentImage(certModel.StudentId); if (string.IsNullOrEmpty(imageName)) { //MessageBox.Show("Không tìm thấy ảnh", "Lỗi", MessageBoxButtons.OK, MessageBoxIcon.Error); NotificationForm notificationForm = new NotificationForm("Không tìm thấy ảnh", "Cảnh báo", MessageBoxIcon.Warning); notificationForm.ShowDialog(); return; } string path = Directory.GetParent(Directory.GetCurrentDirectory()).Parent.FullName; ShowingImageForm showingImageForm = new ShowingImageForm(Path.Combine(@"C:\JbCert_Resource\StudentImages\", imageName)); showingImageForm.ShowDialog(); } else if (e.ColumnIndex == CertDataGridView.Columns["ViewBlankCertImage"].Index && e.RowIndex >= 0) { int certId = int.Parse(CertDataGridView.Rows[e.RowIndex].Cells["Id"].Value.ToString()); CertModel certModel = managingCertService.GetSingleCertById(certId); string imageName = managingBlankCertService.GetBlankCertImage(certModel.BlankCertId); if (string.IsNullOrEmpty(imageName)) { //MessageBox.Show("Không tìm thấy ảnh", "Lỗi", MessageBoxButtons.OK, MessageBoxIcon.Error); NotificationForm notificationForm = new NotificationForm("Không tìm thấy ảnh", "Cảnh báo", MessageBoxIcon.Warning); notificationForm.ShowDialog(); return; } string path = Directory.GetParent(Directory.GetCurrentDirectory()).Parent.FullName; ShowingImageForm showingImageForm = new ShowingImageForm(Path.Combine(@"C:\JbCert_Resource\Images\", imageName)); showingImageForm.ShowDialog(); } }
public JsonResult EditCertificate(int certId) { Certificate c = Db.Certificates.Where(j => j.CertificateId == certId).FirstOrDefault(); CertModel model = new CertModel() { CertId = c.CertificateId, CertName = c.CertificateName, Standard = c.Standard, StatusID = c.StatusId }; model.Statuses = ClientDetailsBuilder.BuildStatuses(Db); return(Json(ResponseStatus.Success, new { html = RenderPartialViewToString("EditCertificate", model) })); }
/// <summary> /// 初始化请求 /// </summary> /// <param name="request"></param> private void InitRequest(HttpWebRequest request) { //设置安全请求模式 if (request.RequestUri.ToString().ToLower().StartsWith("https:")) { ServicePointManager.SecurityProtocol = SecurityProtocolType.Ssl3; ServicePointManager.ServerCertificateValidationCallback = (sender, certificate, chain, errors) => true; } //添加cookie CookieModel.SetCookies(request); //添加证书 CertModel?.SetCert(request); //超时时间 request.Timeout = Timeout; }
private void LoadCertList() { CertDataGridView.Rows.Clear(); foreach (var certId in _certIds) { CertModel certModel = managingCertService.GetSingleCertById(certId); int i = 1; CertDataGridView.Rows.Add ( certModel.IsPrinted, certModel.Id, i++, certModel.StudentName, certModel.SchoolName, certModel.Serial, certModel.ReferenceNumber ); } }
private void Pd_PrintPage(object sender, PrintPageEventArgs e) { int certId = int.Parse(((PrintDocument)sender).DocumentName); CertModel certModel = managingCertService.GetSingleCertById(certId); StudentModel studentModel = managingStudentService.GetSingleStudentById(certModel.StudentId); BlankCertConfigModel blankCertConfigModel = managingBlankCertConfigService.GetSingleByBlankCertType(blankCertTypeId); //Get the Graphics object Graphics g = e.Graphics; //Create a font Arial with size 16 Font font = new Font("Arial", 16); //Create a solid brush with black color SolidBrush brush = new SolidBrush(Color.Black); if (blankCertTypeId == (int)Common.BlankCertType.HightSchool) { //g.DrawString("Hanhsama " + certId, // font, brush, // new Rectangle(20, 70, 200, 100)); //g.DrawString(studentModel.GraduatingYear.ToString(), // font, brush, // new Rectangle(blankCertConfigModel., 200, 100)); // thieu graduating year trong blankcertconfig } else if (blankCertTypeId == (int)Common.BlankCertType.JuniorHighSchool) { } else if (blankCertTypeId == (int)Common.BlankCertType.University) { } else if (blankCertTypeId == (int)Common.BlankCertType.Master) { } }
private void EditCertForm_Load(object sender, EventArgs e) { try { // load school SchoolComboBox.DataSource = managingSchoolService.GetAllSchool(); SchoolComboBox.DisplayMember = "SchoolName"; SchoolComboBox.ValueMember = "Id"; // load ethnic EthnicComboBox.DataSource = managingStudentService.GetAllEthnic(); EthnicComboBox.DisplayMember = "EthnicName"; EthnicComboBox.ValueMember = "Id"; // load ranking RankingComboBox.DataSource = managingStudentService.GetAllRanking(); RankingComboBox.DisplayMember = "RankingName"; RankingComboBox.ValueMember = "Id"; // load gender GenderComboBox.Items.Add("Nam"); GenderComboBox.Items.Add("Nữ"); // load major List <MajorModel> majorModels = managingStudentService.GetAllMajor(); majorModels.Add(new MajorModel() { Id = -1, MajorName = "Không có chuyên ngành" }); MajorComboBox.DataSource = majorModels; MajorComboBox.DisplayMember = "MajorName"; MajorComboBox.ValueMember = "Id"; // load learning Mode LearningModeComboBox.DataSource = managingStudentService.GetAllLearningMode(); LearningModeComboBox.DisplayMember = "LearningModeName"; LearningModeComboBox.ValueMember = "Id"; certModel = managingCertService.GetSingleCertById(_certId); studentModel = managingStudentService.GetSingleStudentById(certModel.StudentId); FullnameTextBox.Text = studentModel.FullName; SchoolComboBox.SelectedValue = studentModel.SchoolId; BornedAddressTextBox.Text = studentModel.BornedAddress; AddressTextBox.Text = studentModel.Address; DobTextBox.Text = studentModel.Dob.ToString("dd/MM/yyyy"); HouseHoldTextBox.Text = studentModel.HouseHold; ScoreTextBox.Text = studentModel.Score.ToString(); GraduatingYearTextBox.Text = studentModel.GraduatingYear.ToString(); RankingComboBox.SelectedValue = studentModel.RankingId; MajorComboBox.SelectedValue = studentModel.MajorId; LearningModeComboBox.SelectedValue = studentModel.LearningModeId; EthnicComboBox.SelectedValue = studentModel.EthnicId; GenderComboBox.SelectedItem = studentModel.Gender; SerialTextBox.Text = certModel.Serial; ReferenceNumberTextBox.Text = certModel.ReferenceNumber; // load student image string imageName = managingStudentService.GetStudentImage(certModel.StudentId); if (string.IsNullOrEmpty(imageName)) { //MessageBox.Show("Không tìm thấy ảnh", "Lỗi", MessageBoxButtons.OK, MessageBoxIcon.Error); NotificationForm notificationForm = new NotificationForm("Không tìm thấy ảnh", "Lỗi", MessageBoxIcon.Error); notificationForm.ShowDialog(); return; } string path = Directory.GetParent(Directory.GetCurrentDirectory()).Parent.FullName; using (FileStream fs = new FileStream(Path.Combine(@"C:\JbCert_Resource\StudentImages\", imageName), FileMode.Open)) { StudentImagePictureBox.Image = Image.FromStream(fs); } // load blankcert image imageName = managingBlankCertService.GetBlankCertImage(certModel.BlankCertId); if (string.IsNullOrEmpty(imageName)) { //MessageBox.Show("Không tìm thấy ảnh", "Lỗi", MessageBoxButtons.OK, MessageBoxIcon.Error); NotificationForm notificationForm = new NotificationForm("Không tìm thấy ảnh", "Lỗi", MessageBoxIcon.Error); notificationForm.ShowDialog(); return; } path = Directory.GetParent(Directory.GetCurrentDirectory()).Parent.FullName; using (FileStream fs = new FileStream(Path.Combine(@"C:\JbCert_Resource\Images\", imageName), FileMode.Open)) { BlankCertImagePictureBox.Image = Image.FromStream(fs); } } catch (FileNotFoundException FileNotFoundEx) { NotificationForm notificationForm = new NotificationForm("Không tìm thấy ảnh, vui lòng cập nhật lại ảnh", "Cảnh báo", MessageBoxIcon.Warning); notificationForm.ShowDialog(); } catch (Exception ex) { //MessageBox.Show(ex.Message, "Lỗi", MessageBoxButtons.OK, MessageBoxIcon.Error); NotificationForm notificationForm = new NotificationForm(Common.Common.COMMON_ERORR, "Lỗi", MessageBoxIcon.Error); notificationForm.ShowDialog(); } }
public static ClientList FilterClients(DASEntities db, GridDescriptor desc, FilterModel filters) { ClientList model = new ClientList() { Descriptor = desc, ListOfClients = new List <ClientModel>() }; IQueryable <Client> clients = db.Clients.AsQueryable(); IQueryable <vw_ClientsBackoffice> clientsF = db.vw_ClientsBackoffice.AsQueryable(); string filStandard = ""; if (filters == null) { filters = new FilterModel(); } if (!string.IsNullOrWhiteSpace(filters.Name)) { filStandard = filters.Name.Replace(":", "").Replace("/", "").Replace("-", "").Replace("–", "").Replace("\"", "").Replace(".", ""); clientsF = clientsF.Where(m => m.Name.Contains(filStandard)); } if (filters.SelectedStatusId != 0) { if (!string.IsNullOrWhiteSpace(filters.Standard)) { clientsF = clientsF.Where(b => b.StatusId == filters.SelectedStatusId && b.Standard.Contains(filters.Standard)); } else { clientsF = clientsF.Where(m => m.StatusId == filters.SelectedStatusId); } } else if (!string.IsNullOrWhiteSpace(filters.Standard)) { clientsF = clientsF.Where(m => m.Standard.Contains(filters.Standard)); } IList <int> clientIds = clientsF.Select(k => k.ClientId).Distinct().ToList(); IList <Client> listC = clients.Where(h => clientIds.Contains(h.ClientId)).Slice(desc).ToList(); ClientModel clientM; CertModel certM; foreach (var item in listC) { clientM = new ClientModel() { ClientId = item.ClientId, Address = item.Address, ClientName = item.Name, Description = item.Description, Certificates = new List <CertModel>() }; foreach (var itemC in item.Certificates) { if ((string.IsNullOrWhiteSpace(filters.Standard) || itemC.Standard.Contains(filters.Standard.ToUpper())) && (filters.SelectedStatusId == 0 || filters.SelectedStatusId == itemC.StatusId)) { certM = new CertModel() { CertId = itemC.CertificateId, CertName = itemC.CertificateName, Standard = itemC.Standard }; certM.Status = GetStatusName(db, itemC.StatusId); clientM.Certificates.Add(certM); } } model.ListOfClients.Add(clientM); } return(model); }
public static ClientsModel BuildClients(DASEntities db) { ClientsModel model = new ClientsModel(); int languageId = (int)HttpContext.Current.Session["lngId"]; model.Filters = new FilterModel(); model.Filters.Statuses = BuildStatuses(db); /*todo; dodati labelu Svi u labels*/ string stat = "..."; stat = db.Labels.Where(s => s.ViewId == "Clients" && s.ElementId == "lblSearchStat" && s.LanguageId == languageId).Select(ps => ps.Text).FirstOrDefault(); model.Filters.Statuses.Add(new StatusModel() { StatusId = 0, StatusName = stat }); /*in backoffice selected status is All*/ model.Filters.SelectedStatusId = 0; model.Filters.Statuses = model.Filters.Statuses.OrderBy(m => m.StatusId).ToList(); GridDescriptor desc = new GridDescriptor(new SortDescriptor() { PropertyName = "DateChange", Order = SortOrder.Descending }) { Pager = new PagerDescriptor(1, 20, db.Labels.Where(l => l.ViewId == "Clients" && l.ElementId == "lblPageSize" && l.LanguageId == languageId).Select(l => l.Text).FirstOrDefault(), 5) }; IQueryable <Client> clients = db.Clients.AsQueryable(); /*initial filter will be only with active status*/ //clients = clients.Where(m => m.Certificates.Any(l => l.StatusId == 1)); IList <Client> listC = clients.Slice(desc).ToList(); model.Clients = new ClientList() { Descriptor = desc, ListOfClients = new List <ClientModel>() }; ClientModel clientM; CertModel certM; foreach (var item in listC) { clientM = new ClientModel() { ClientId = item.ClientId, Address = item.Address, ClientName = item.Name, Description = item.Description, Certificates = new List <CertModel>() }; foreach (var itemC in item.Certificates) { //if (itemC.StatusId==1) //{ certM = new CertModel() { CertId = itemC.CertificateId, CertName = itemC.CertificateName, Standard = itemC.Standard }; certM.Status = GetStatusName(db, itemC.StatusId); clientM.Certificates.Add(certM); //} } model.Clients.ListOfClients.Add(clientM); } return(model); }
public List <CertModel> GetAll() { List <CertModel> certModels = new List <CertModel>(); using (conn = JBCertConnection.Instance) { string queryString = @"SELECT a.*, b.Ten as 'Hovaten', b.TruongId , f.Tentruong ,c.Tenxeploai, d.Serial as 'Sohieu', d.LoaiId, e.Name as 'Tenloai' FROM [dbo].[tblBang] as a left join [dbo].[tblHocsinh] as b on a.HocsinhId = b.Id Left join [dbo].[tblXeploai] as c on a.XeploaiId = c.Id left join [dbo].[tblPhoi] as d on a.PhoiId = d.Id left join [dbo].[tblLoai] as e on d.LoaiId = e.Id left join [dbo].[tblTruong] as f on b.TruongId = f.Id where a.isdeleted = 0"; conn.Open(); SqlCommand sqlCommand = new SqlCommand(queryString, conn); sqlCommand.CommandType = CommandType.Text; SqlDataReader sqlDataReader = sqlCommand.ExecuteReader(); try { while (sqlDataReader.Read()) { CertModel certModel = new CertModel(); certModel.Id = int.Parse(sqlDataReader["Id"].ToString()); certModel.StudentId = int.Parse(sqlDataReader["HocsinhId"].ToString()); certModel.StudentName = sqlDataReader["Hovaten"].ToString(); certModel.RankingId = int.Parse(sqlDataReader["XeploaiId"].ToString()); certModel.RankingName = sqlDataReader["Tenxeploai"].ToString(); certModel.CertName = sqlDataReader["Tenbang"].ToString(); certModel.BlankCertId = int.Parse(sqlDataReader["PhoiId"].ToString()); certModel.Serial = sqlDataReader["Sohieu"].ToString(); certModel.SchoolId = int.Parse(sqlDataReader["TruongId"].ToString()); certModel.SchoolName = sqlDataReader["Tentruong"].ToString(); certModel.ReferenceNumber = sqlDataReader["Sovaoso"].ToString(); certModel.ProviderName = sqlDataReader["Tennguoicap"].ToString(); certModel.Position = sqlDataReader["Chucvu"].ToString(); certModel.GrantedDate = DateTime.Parse(sqlDataReader["Ngaycap"].ToString()); certModel.ManagementAddress = sqlDataReader["Noiquanly"].ToString(); certModel.ReceiverName = sqlDataReader["Nguoinhan"].ToString(); certModel.ReceiverIdentityNumber = sqlDataReader["CMTnguoinhan"].ToString(); certModel.Note = sqlDataReader["Ghichu"].ToString(); certModel.IsGranted = bool.Parse(sqlDataReader["IsGranted"].ToString()); certModel.IsPrinted = bool.Parse(sqlDataReader["IsPrinted"].ToString()); certModel.IsDeleted = false; certModels.Add(certModel); } } catch (Exception ex) { throw ex; } finally { sqlDataReader.Close(); conn.Close(); } } return(certModels); }