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