public static void EditSelected(LIVEX.UserControls.AsistenciaMaestros am)
{
string uid = am.cmbUID.Text;
livexEntities context = new livexEntities();
asistencia_maestros teacherAtt = context.asistencia_maestros.FirstOrDefault(x => x.UID == uid);
string hour = am.cmbHour.Text;
var time = hour.Split(':');
teacherAtt.Name = am.cmbName.Text;
teacherAtt.hour = Int32.Parse(time[0]);
teacherAtt.min = Int32.Parse(time[1]);
if (time.Count() > 2)
{
teacherAtt.sec = Int32.Parse(time[2]);
}
else
{
teacherAtt.sec = 0;
}
teacherAtt.date = Convert.ToDateTime(am.dpDate.Text);
int result = context.SaveChanges();
if (result >= 0)
{
MessageBox.Show("El registro se guardó exitosamente");
}
else
{
MessageBox.Show("El registro NO se guardó");
}
}
public static void refreshCombos(LIVEX.UserControls.AsistenciaMaestros am)
{
livexEntities context = new livexEntities();
asistencia_maestros a = new asistencia_maestros();
teacher t = new teacher();
if (am.cmbUID.SelectedItem != null || am.cmbUID.Text != "")
{
string uid = am.cmbUID.SelectedItem.ToString();
a = context.asistencia_maestros.FirstOrDefault(x => x.UID == uid);
if (a != null)
{
am.cmbName.Text = a.Name;
am.cmbName.SelectedValue = a.Name;
//teacher teacherFound = context.teacher.FirstOrDefault(x => x.uid == a.UID);
//if (teacherFound != null)
//{
// am.cmbTeacherNames.Text = teacherFound.teacher_names + " " + teacherFound.teacher_lastname;
// am.cmbTeacherNames.SelectedValue = teacherFound.teacher_names + " " + teacherFound.teacher_lastname;
//}
}
}
}
public static int uploadTimerFile(string path, string filename)
{
try
{
livexEntities context = new livexEntities();
int result = 0;
using (var reader = new StreamReader(path))//(@"C:\Users\Tania\Documents\NewCo\Proyectos\LIVEX\Docs\LogData\HisGLog_0001_20171201.csv"))
{
int isduplicated = context.asistencia_maestros.Count(x => x.filename == filename);
if (isduplicated > 0)
{
MessageBox.Show("El archivo ya ha sido cargado");
return(0);
}
int i = 0;
while (!reader.EndOfStream)
{
asistencia_maestros am = new asistencia_maestros();
var line = reader.ReadLine();
var values = line.Split('\t');
if (i > 0)
{
am.No = Int32.Parse(values[0]);
am.DN = Int32.Parse(values[1]);
am.UID = values[2];
am.Name = values[3];
am.Status = values[4];
am.Action = Int32.Parse(values[5]);
am.APB = Int32.Parse(values[6]);
am.JobCode = Int32.Parse(values[7]);
am.date = Convert.ToDateTime(Convert.ToDateTime(values[8]).ToShortDateString());
am.hour = Convert.ToDateTime(values[8]).Hour;
am.min = Convert.ToDateTime(values[8]).Minute;
am.sec = Convert.ToDateTime(values[8]).Second;
am.filename = filename;
context.asistencia_maestros.Add(am);
}
i++;
}
result = context.SaveChanges();
}
if (result > 0)
{
MessageBox.Show("Archivo cargado exitosamente");
return(1);
}
return(0);
}
catch (Exception e)
{
MessageBox.Show(e.Message);
return(0);
}
}
public static void DeleteRow(LIVEX.UserControls.AsistenciaMaestros am, object attRow)
{
TeacherAttendanceView row = (TeacherAttendanceView)attRow;
livexEntities context = new livexEntities();
asistencia_maestros teacherDelete = context.asistencia_maestros.FirstOrDefault(x => x.asistencia_maestrosID == row.id);
if (teacherDelete != null)
{
context.asistencia_maestros.Remove(teacherDelete);
int result = context.SaveChanges();
if (result > 0)
{
MessageBox.Show("El registro se borró exitosamente");
}
else
{
MessageBox.Show("Error al borrar el registro");
}
}
}
public static void AddAttendaceRow(LIVEX.UserControls.AsistenciaMaestros am)
{
livexEntities context = new livexEntities();
asistencia_maestros newAtt = new asistencia_maestros();
DateTime date = Convert.ToDateTime(am.dpDate.Text);
string hour = am.cmbHour.Text;
var time = hour.Split(':');
newAtt.DN = 1;
newAtt.UID = am.cmbUID.Text;
newAtt.Name = am.cmbName.Text;
newAtt.Status = "0";
newAtt.Action = 3;
newAtt.APB = 0;
newAtt.JobCode = 0;
newAtt.date = Convert.ToDateTime(date.ToShortDateString());
newAtt.No = 0;
newAtt.filename = "LIVEX_Sys";
newAtt.hour = Int32.Parse(time[0]);
newAtt.min = Int32.Parse(time[1]);
if (time.Count() > 2)
{
newAtt.sec = Int32.Parse(time[2]);
}
else
{
newAtt.sec = 0;
}
context.asistencia_maestros.Add(newAtt);
int result = context.SaveChanges();
if (result > 0)
{
MessageBox.Show("El registro se guardó exitosamente");
}
else
{
MessageBox.Show("El registro NO se guardó");
}
}