public bool Delete(Institutes institute) { QuaintDatabaseManager db = new QuaintDatabaseManager(true); try { bool flag = false; db.AddParameters("InstituteId", institute.InstituteId); int affectedRows = db.ExecuteNonQuery("Delete_Institute", true); if (affectedRows > 0) { flag = true; } return(flag); } catch (Exception) { throw; } finally { db.Disconnect(); } }
protected void btnDelete_Command(object sender, CommandEventArgs e) { try { string id = Convert.ToString(e.CommandArgument); if (!string.IsNullOrEmpty(id)) { InstituteBLL instituteBLL = new InstituteBLL(); Institutes institute = new Institutes(); institute.InstituteId = Convert.ToInt32(QuaintSecurityManager.Decrypt(id)); if (institute.InstituteId > 0) { if (instituteBLL.Delete(institute)) { Alert(AlertType.Success, "Deleted successfully."); LoadList(); } else { Alert(AlertType.Error, "Failed to delete."); } } } } catch (Exception) { Alert(AlertType.Error, "Failed to delete."); } }
private bool IsNameExist(Institutes institute) { try { DataTable dtList = GetAll(); var rows = dtList.AsEnumerable().Where(x => ((string)x["Name"]).ToString() == institute.Name); DataTable dt = rows.Any() ? rows.CopyToDataTable() : dtList.Clone(); if (dt != null) { if (dt.Rows.Count > 0) { return(true); } else { return(false); } } else { return(false); } } catch (Exception) { throw; } }
public bool Delete(Institutes institute) { try { InstituteDAL instituteDAL = new InstituteDAL(); return(instituteDAL.Delete(institute)); } catch (Exception) { throw; } }
public bool Save(Institutes institute) { try { InstituteDAL instituteDAL = new InstituteDAL(); if (IsNameExist(institute)) { throw new Exception("Name already exist."); } else { return(instituteDAL.Save(institute)); } } catch (Exception) { throw; } }
public bool Update(Institutes institute) { QuaintDatabaseManager db = new QuaintDatabaseManager(true); try { bool flag = false; db.AddParameters("InstituteId", institute.InstituteId); db.AddParameters("InstituteCode", institute.InstituteCode); db.AddParameters("Name", institute.Name); db.AddParameters("Logo", institute.Logo); db.AddParameters("Url", institute.Url); db.AddParameters("Description", institute.Description); db.AddParameters("SerialNumber", institute.SerialNumber); db.AddParameters("Attachment", institute.Attachment); db.AddParameters("IsActive", institute.IsActive); db.AddParameters("CreatedDate", ((institute.CreatedDate == null) ? institute.CreatedDate : institute.CreatedDate.Value)); db.AddParameters("CreatedBy", institute.CreatedBy); db.AddParameters("CreatedFrom", institute.CreatedFrom); db.AddParameters("UpdatedDate", ((institute.UpdatedDate == null) ? institute.UpdatedDate : institute.UpdatedDate.Value)); db.AddParameters("UpdatedBy", institute.UpdatedBy); db.AddParameters("UpdatedFrom", institute.UpdatedFrom); db.AddParameters("CourseId", institute.CourseId); int affectedRows = db.ExecuteNonQuery("Update_Institute", true); if (affectedRows > 0) { flag = true; } return(flag); } catch (Exception) { throw; } finally { db.Disconnect(); } }
protected override void Parse(HtmlDocument doc) { var tables = doc.DocumentNode.Descendants().Where (x => x.Name == "div" && x.HasClass("accordion-group")); foreach (var t in tables) { var name = t.Descendants("a").First().InnerText; foreach (var td in t.Descendants("td")) { foreach (var a in td.Descendants("a").Where(x => x.GetAttributeValue("target", null) == null)) { var href = a.Attributes["href"].Value; string stryear = href.Substring(3, href.IndexOf('i', 4) - 3); int year = int.Parse(stryear); Institutes.Add(new Institute(a.InnerText, CoreParser.FromBase('/' + year.ToString() + href.Trim('.')), year).SetType(name)); } } } }
private void SaveAndUpdate() { try { if (string.IsNullOrEmpty(txtName.Text)) { Alert(AlertType.Warning, "Enter institute name."); txtName.Focus(); } else if (string.IsNullOrEmpty(txtSerialNumber.Text)) { Alert(AlertType.Warning, "Enter serial number"); txtSerialNumber.Focus(); } else if (ddlCourse.SelectedIndex < 1) { Alert(AlertType.Warning, "Select course."); ddlCourse.Focus(); } else { string name = Convert.ToString(txtName.Text); string url = Convert.ToString(txtUrl.Text); string description = Convert.ToString(txtDescription.Text); int serialNumber = Convert.ToInt32(txtSerialNumber.Text); int courseId = Convert.ToInt32(ddlCourse.SelectedValue); string logo = string.Empty; if (fuLogo.HasFile) { logo = UploadLogo(); } else { logo = this.ModelLogo; } InstituteBLL instituteBLL = new InstituteBLL(); if (this.ModelId > 0) { DataTable dt = instituteBLL.GetById(this.ModelId); Institutes institute = new Institutes(); institute.InstituteId = Convert.ToInt32(Convert.ToString(dt.Rows[0]["InstituteId"])); institute.InstituteCode = Convert.ToString(dt.Rows[0]["InstituteCode"]); institute.Name = Convert.ToString(dt.Rows[0]["Name"]); institute.Logo = Convert.ToString(dt.Rows[0]["Logo"]); institute.Url = Convert.ToString(dt.Rows[0]["Url"]); institute.Description = Convert.ToString(dt.Rows[0]["Description"]); institute.SerialNumber = Convert.ToInt32(dt.Rows[0]["SerialNumber"]); institute.Attachment = Convert.ToString(dt.Rows[0]["Attachment"]); institute.IsActive = Convert.ToBoolean(Convert.ToString(dt.Rows[0]["IsActive"])); institute.CreatedDate = (string.IsNullOrEmpty(Convert.ToString(dt.Rows[0]["CreatedDate"]))) ? (DateTime?)null : Convert.ToDateTime(Convert.ToString(dt.Rows[0]["CreatedDate"])); institute.CreatedBy = Convert.ToString(dt.Rows[0]["CreatedBy"]); institute.CreatedFrom = Convert.ToString(dt.Rows[0]["CreatedFrom"]); institute.CourseId = Convert.ToInt32(Convert.ToString(dt.Rows[0]["CourseId"])); institute.Name = name.Trim(); institute.Url = url; institute.SerialNumber = serialNumber; institute.CourseId = courseId; institute.Logo = logo; institute.UpdatedDate = DateTime.Now; institute.UpdatedBy = this.UserInfo; institute.UpdatedFrom = this.StationInfo; if (instituteBLL.Update(institute)) { this.MultiEntryDisallow = true; Alert(AlertType.Success, "Updated successfully."); ClearFields(); } else { Alert(AlertType.Error, "Failed to update."); } } else { Institutes institute = new Institutes(); institute.InstituteCode = this.ModelCode; institute.Name = name; institute.Logo = logo; institute.Url = url; institute.Description = description; institute.SerialNumber = serialNumber; institute.Attachment = string.Empty; institute.CourseId = courseId; institute.IsActive = true; institute.CreatedDate = DateTime.Now; institute.CreatedBy = this.UserInfo; institute.CreatedFrom = this.StationInfo; if (instituteBLL.Save(institute)) { Alert(AlertType.Success, "Saved successfully."); ClearFields(); GenerateCode(); } else { Alert(AlertType.Error, "Failed to save."); } } } } catch (Exception ex) { Alert(AlertType.Error, ex.Message.ToString()); } }
protected void btnActiveOrDeactive_Command(object sender, CommandEventArgs e) { try { string id = Convert.ToString(e.CommandArgument); if (!string.IsNullOrEmpty(id)) { InstituteBLL instituteBLL = new InstituteBLL(); DataTable dt = instituteBLL.GetById(Convert.ToInt32(QuaintSecurityManager.Decrypt(id))); if (dt != null) { if (dt.Rows.Count > 0) { string actionStatus = "Updated"; Institutes institute = new Institutes(); institute.InstituteId = Convert.ToInt32(Convert.ToString(dt.Rows[0]["InstituteId"])); institute.InstituteCode = Convert.ToString(dt.Rows[0]["InstituteCode"]); institute.Name = Convert.ToString(dt.Rows[0]["Name"]); institute.Logo = Convert.ToString(dt.Rows[0]["Logo"]); institute.Url = Convert.ToString(dt.Rows[0]["Url"]); institute.Description = Convert.ToString(dt.Rows[0]["Description"]); institute.SerialNumber = Convert.ToInt32(dt.Rows[0]["SerialNumber"]); institute.Attachment = Convert.ToString(dt.Rows[0]["Attachment"]); institute.IsActive = Convert.ToBoolean(Convert.ToString(dt.Rows[0]["IsActive"])); institute.CreatedDate = (string.IsNullOrEmpty(Convert.ToString(dt.Rows[0]["CreatedDate"]))) ? (DateTime?)null : Convert.ToDateTime(Convert.ToString(dt.Rows[0]["CreatedDate"])); institute.CreatedBy = Convert.ToString(dt.Rows[0]["CreatedBy"]); institute.CreatedFrom = Convert.ToString(dt.Rows[0]["CreatedFrom"]); institute.CourseId = Convert.ToInt32(Convert.ToString(dt.Rows[0]["CourseId"])); institute.UpdatedDate = DateTime.Now; institute.UpdatedBy = UserInfo; institute.UpdatedFrom = StationInfo; if (institute.IsActive) { institute.IsActive = false; actionStatus = "Deactivated"; } else { institute.IsActive = true; actionStatus = "Activated"; } if (instituteBLL.Update(institute)) { Alert(AlertType.Success, actionStatus + " successfully."); LoadList(); } else { Alert(AlertType.Error, "Failed to update."); } } } } } catch (Exception) { Alert(AlertType.Error, "Failed to process."); } }
static SeedGetter() { var fileName = "dataseed.json"; var path = Path.Combine(Environment.CurrentDirectory, fileName); var jsonString = File.ReadAllTextAsync(path).Result; var seed = JsonConvert.DeserializeObject <DataSeed>(jsonString); foreach (var user in seed.DeanEmployees) { var preparedUser = PrepareUser(user); Users.Add(preparedUser); DeanEmployees.Add(preparedUser); } foreach (var student in seed.Students) { var user = PrepareUser(student.ApplicationUser); Users.Add(user); student.ApplicationUser = null; student.UserId = user.Id; //if (student.Id == Guid.Empty) //{ // student.Id = Guid.NewGuid(); //} Students.Add(student); } foreach (var institute in seed.Institutes) { //if (institute.Id == Guid.Empty) //{ // institute.Id = Guid.NewGuid(); //} foreach (var promoter in institute.Promoters) { var user = PrepareUser(promoter.ApplicationUser); Users.Add(user); promoter.ApplicationUser = null; promoter.UserId = user.Id; promoter.InstituteId = institute.Id; //if (promoter.Id == Guid.Empty) //{ // promoter.Id = Guid.NewGuid(); //} Promoters.Add(promoter); } institute.Promoters = null; Institutes.Add(institute); } foreach (var faculty in seed.Faculties) { //if (faculty.Id == Guid.Empty) //{ // faculty.Id = Guid.NewGuid(); //} foreach (var course in faculty.Courses) { //if (course.Id == Guid.Empty) //{ // course.Id = Guid.NewGuid(); //} course.FacultyId = faculty.Id; foreach (var proposal in course.Proposals) { //if (proposal.Id == Guid.Empty) //{ // proposal.Id = Guid.NewGuid(); //} proposal.CourseId = course.Id; proposal.StartingDate = new DateTime(2019, 10, 1); Proposals.Add(proposal); } course.Proposals = null; Courses.Add(course); } faculty.Courses = null; Faculties.Add(faculty); } }
protected override void Seed(mContext context) { Institutes ikni = new Institutes { Name = "IKNI", Location = "5th building" }; Departments SAP = new Departments { Name = "SAP", Institute = ikni }; Groups kn305 = new Groups { Name = "KN-305", Number = 305 }; Lecturers lect1 = new Lecturers { Name = "test", Surname = "testSurname", FathersName = "testFathersName", Department = SAP }; Lecturers lect2 = new Lecturers { Name = "test2", Surname = "testSurname2", FathersName = "testFathersName", Department = SAP }; context.Institute.Add(ikni); context.Institute.Add(new Institutes { Name = "IKTA", Location = "5th building" }); context.Department.Add(SAP); context.Department.Add(new Departments { Name = "PZ", Institute = ikni }); context.Subject.Add(new Subjects { Name = "TEST1", Credits = 1 }); context.Subject.Add(new Subjects { Name = "TEST2", Credits = 2 }); context.Student.Add(new Students { Name = "Timofiy", Surname = "PIPIDASTR", Age = 19, Group = kn305 }); context.Student.Add(new Students { Name = "Timofiy2", Surname = "PIPIDASTR", Age = 19, Group = kn305 }); context.Group.Add(kn305); context.Group.Add(new Groups { Name = "KN-306", Number = 306 }); context.mUnion.Add(new Union { Group = kn305, Lecturer = lect1, Subject = new Subjects { Name = "Algorhytms", Credits = 3 } }); context.mUnion.Add(new Union { Group = kn305, Lecturer = lect2, Subject = new Subjects { Name = "Programming", Credits = 3 } }); context.Lecturer.Add(lect1); context.Lecturer.Add(lect2); base.Seed(context); }