private void btnsave_Click(object sender, EventArgs e)
{
enTimeTable enTimeTable = new enTimeTable();
comTimeTable comTimeTable=new comTimeTable();
int rowcount = gridtimetable.Rows.Count;
int i = 1;
if (rowcount != 0)
{
foreach (DataGridViewRow row in gridtimetable.Rows)
{
Double tick = (100.0/rowcount)*i;
progressBarX1.Value =Convert.ToInt32(Math.Ceiling(tick));
enTimeTable.personalCard=row.Cells["_personalIDCard"].Value.ToString();
enTimeTable.timetable = row.Cells["_timetable"].Value.ToString();
enTimeTable.onduty = row.Cells["_onduty"].Value.ToString();
enTimeTable.offduty = row.Cells["_offduty"].Value.ToString();
enTimeTable.clockIn = row.Cells["_clockIn"].Value.ToString();
enTimeTable.clockOut = row.Cells["_clockOut"].Value.ToString();
comTimeTable.insertTimeTable(enTimeTable);
i++;
}
if (progressBarX1.Value >= 100)
{
MessageBox.Show("บันทึกข้อมูลเรียบร้อยแล้ว");
gridtimetable.Rows.Clear();
progressBarX1.Value = 0;
txttextfile.Text = string.Empty;
}
}
else
{
MessageBox.Show("ไม่พบข้อมูลที่ต้องการบันทึก");
}
}
public Boolean insertTimeTable(enTimeTable enTimeTable)
{
try
{
str = "INSERT INTO timetable (personalCard,timetable,onduty,offduty,clockIn,clockOut)VALUES(@personalCard,@timetable,@onduty,@offduty,@clockIn,@clockOut);";
Dbcmd = db.GetSqlStringCommand(str);
db.AddInParameter(Dbcmd, "@personalCard", DbType.String, enTimeTable.personalCard);
db.AddInParameter(Dbcmd, "@timetable", DbType.String, enTimeTable.timetable);
db.AddInParameter(Dbcmd, "@onduty", DbType.String, enTimeTable.onduty);
db.AddInParameter(Dbcmd, "@offduty", DbType.String, enTimeTable.offduty);
db.AddInParameter(Dbcmd, "@clockIn", DbType.String, enTimeTable.clockIn);
db.AddInParameter(Dbcmd, "@clockOut", DbType.String, enTimeTable.clockOut);
db.ExecuteNonQuery(Dbcmd);
return true;
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
