public async Task SaveAsync(InstitutionName entity)
{
try
{
if (entity == null)
{
return;
}
using (var timeLineContext = _contextFactory.GetTimeLineContext())
{
var entityModel = await timeLineContext
.InstitutionNames
.FirstOrDefaultAsync(item => item.Id.Equals(entity.Id));
if (entityModel == null)
{
entityModel = new DA.InstitutionName();
MapForUpdateentity(entity, entityModel);
await timeLineContext.InstitutionNames.AddAsync(entityModel);
}
else
{
MapForUpdateentity(entity, entityModel);
}
timeLineContext.SaveChanges();
}
}
catch (Exception ex)
{
throw ex;
}
}
public async Task <IActionResult> Put([FromBody] InstitutionName value)
{
try
{
var entity = _mapper.Map <BL.InstitutionName>(value);
var id = _service.SaveAsync(entity);
return(Ok(id));
}
catch (Exception)
{
return(BadRequest());
}
}
public bool Equals(UserProfile profile)
{
if (profile == null)
{
return(false);
}
var keysIntersect = Credentials.Keys.Intersect(profile.Credentials.Keys).ToList();
var valuesIntersect = Credentials.Values.Intersect(profile.Credentials.Values).ToList();
return(InstitutionName.Equals(profile.InstitutionName, StringComparison.InvariantCultureIgnoreCase) &&
keysIntersect.Count == profile.Credentials.Keys.Count &&
valuesIntersect.Count == profile.Credentials.Values.Count);
}
private void MapForUpdateentity(InstitutionName entity, DA.InstitutionName daEntity)
{
daEntity.Id = entity.Id;
}
private void MainForm_Load(object sender, EventArgs e)
{
string connection = "datasource=localhost;port=3306;username=root;password=;database=slims;";
MysqlConn = new MySqlConnection(connection);
MysqlConn.Open();
string query = "SELECT setting_value FROM setting WHERE setting_id=2 or setting_id=1;";
Command = new MySqlCommand(query, MysqlConn);
DbReader = Command.ExecuteReader();
while (DbReader.Read())
{
result.Add(DbReader.GetString(0));
}
DbReader.Close();
/*
* CEK NAMA SEKOLAH
* format dari database adalah s:1:"a";
* dimana angka 1 merupakan panjang kalimat (a)
* jika dihitung maka posisi dari angka 1, selalu tetap di index ke 2
* sedangkan angka 1 akan selalu berubah sesuai dengan panjang kalimat
* index awal kalimat merupakan banyaknya karakter sebelum kalimat + 1
*/
LibraryName = result.ElementAt(0);
LibrarySubName = result.ElementAt(1);
CheckSchoolName(LibraryName, out string LibName, out string LibLevel);
if (IsSchoolLevel(LibLevel) == true)
{
InstitutionName = LibName;
}
else
{
CheckSchoolName(LibrarySubName, out string LibSubName, out string LibSubLevel);
if (IsSchoolLevel(LibSubLevel) == true)
{
InstitutionName = LibSubName;
}
else
{
InstitutionName = LibName;
}
}
/*
* TO DO :
* Membuat institution_name center bersamaan dengan welcome_message
* serta place, semuanya didapatkan dari hasil bagi institution_name yang dibagi dua
* sama kalo bisa pada waktu form_onload kasih loading animation
*/
institution_name.Text = InstitutionName.ToUpper();
// get the system_date
var lang = new System.Globalization.CultureInfo("id-ID");
var day = lang.DateTimeFormat.GetDayName(DateTime.Today.DayOfWeek);
var month = lang.DateTimeFormat.GetMonthName(DateTime.Now.Month);
string today = DateTime.Now.Day.ToString();
string year = DateTime.Now.Year.ToString();
system_date.Text = day + ", " + today + " " + month + " " + year;
//set header panel
HeaderPanel.Width = Width - HeaderPanel.Left - 40;
HeaderPanel.Top = Img.Top;
// set the statistic panel position
StatisticTablePanel.Width = 400;
StatisticTablePanel.Top = HeaderPanel.Height + HeaderPanel.Top + 20;
StatisticTablePanel.Height = Height - StatisticTablePanel.Top - 200;
StatisticTablePanel.Left = Width - StatisticTablePanel.Width - 40;
// set the system_clock and date / input panel
InputPanel.Top = StatisticTablePanel.Top;
InputPanel.Width = StatisticTablePanel.Left - 52;
InputPanel.Height = StatisticTablePanel.Height;
system_clock.Font = system_date.Font = new Font("Calibri", 36);
ValidatePanel.Left = HeaderPanel.Left;
ValidatePanel.Top = system_date.Top + 2 * system_date.Height + 30;
ValidatePanel.Width = InputPanel.Width - 2 * ValidatePanel.Left;
ValidatePanel.Height = InputPanel.Height - ValidatePanel.Top - 20;
InputMessage.Font = new Font("Times New Roman", 24);
InputMessage.Height = 40;
InputIDTxt.Top = InputMessage.Top + InputMessage.Height + 20;
InputIDTxt.Left = 10;
InputIDTxt.Width = ValidatePanel.Width - 2 * InputIDTxt.Left;
InputIDTxt.MaxLength = 10;
InputNote.Font = InputNote1.Font = new Font("Arial", 8);
InputNote.Left = InputIDTxt.Left + ((InputIDTxt.Width - InputNote.Width) / 2);
InputNote1.Left = InputIDTxt.Left + ((InputIDTxt.Width - InputNote1.Width) / 2);
InputNote.Top = InputIDTxt.Top + InputIDTxt.Height + 5;
InputNote1.Top = InputNote.Top + 20;
// Copyright position
Copyright.Left = Img.Left;
Copyright.Top = Height - 70;
RepoLink.Top = Copyright.Top;
RepoLink.Left = Copyright.Left + Copyright.Width + 10;
// set footer panel position
FooterPanel.Width = HeaderPanel.Left + HeaderPanel.Width - 26;
FooterPanel.Left = Img.Left;
FooterPanel.Top = StatisticTablePanel.Top + StatisticTablePanel.Height + 10;
FooterPanel.Height = Height - FooterPanel.Top - (Height - Copyright.Top + 10);
// set counter font and position
Today.Font = Month.Font = Year.Font = Total.Font = Pnc1.Font = Pnc2.Font
= Pnc3.Font = Pnc4.Font = TodayTotal.Font = MonthTotal.Font
= YearTotal.Font = AllTotal.Font = new Font("Times new roman", 25);
Today.Left = Month.Left = Year.Left = Total.Left = 10;
Pnc1.Left = Pnc2.Left = Pnc3.Left = Pnc4.Left = Year.Width + 20;
TodayTotal.Left = MonthTotal.Left = YearTotal.Left =
AllTotal.Left = Pnc1.Left + 20;
Today.Top = Pnc1.Top = TodayTotal.Top = StatisticHeader.Height + 50;
Month.Top = Pnc2.Top = MonthTotal.Top = Today.Top + 50;
Year.Top = Pnc3.Top = YearTotal.Top = Month.Top + 50;
Total.Top = Pnc4.Top = AllTotal.Top = Year.Top + 50;
ViewTotal();
}
