/// <summary>
/// 스케줄 데이터 Insert
/// </summary>
/// <param name="phone">핸드폰번호</param>
/// <param name="wageData">입력할 데이터 구조체</param>
/// <returns>영양받은 행수</returns>
public int Insert(string phone, WageData wageData)
{
int result = -1;
string sql = "values(\"" + wageData.Date + "\", \"" + wageData.OnTime + "\", \"" + wageData.OffTime + "\", \"" + wageData.Time + "\", \"" + wageData.RestTime + "\", \""
+ wageData.ExtensionTime + "\", \"" + wageData.NightTime + "\", \"" + wageData.TotalTime + "\", \"" + wageData.Wage + "\", \"" + wageData.RestWage +
"\", \"" + wageData.ExtensionWage + "\", \"" + wageData.NightWage + "\", \"" + wageData.TotalWage + "\")";
string year = SplitString(wageData.Date, '-')[0];
sqlliteManager.DBOpen();
sqlliteManager.Insert(phone + year, sql);
sqlliteManager.DBClose();
sql = "values(\"" + phone + "\", \"" + wageData.Date + "\", \"" + wageData.OnTime + "\", \"" + wageData.OffTime + "\", \"" + wageData.Time + "\", \"" + wageData.RestTime + "\", \""
+ wageData.ExtensionTime + "\", \"" + wageData.NightTime + "\", \"" + wageData.TotalTime + "\", \"" + wageData.Wage + "\", \"" + wageData.RestWage +
"\", \"" + wageData.ExtensionWage + "\", \"" + wageData.NightWage + "\", \"" + wageData.TotalWage + "\")";
Thread thread = new Thread(() => MainWindow.runThread(4, MySQLData.TableWage, sql));
thread.Start();
return(result);
}
/// <summary>
/// 사용자 추가
/// </summary>
/// <param name="loinData">추가할 사용자 정보</param>
/// <returns>영양받은 행수</returns>
public int Insert(LoginData loinData)
{
int result = -1;
string sql = "values(\"" + loinData.Phone + "\",\"" + encryptionManager.EncryptionPassword(loinData) + "\",\"" + loinData.Name + "\",\"" + loinData.Wage + "\", " + loinData.Authority + ", " + loinData.Task + ")";
sqliteManager.DBOpen();
result = sqliteManager.Insert(SQLiteData.TableMember, sql);
sqliteManager.DBClose();
sql = "values(\"" + loinData.Phone + "\",\"" + loinData.Password + "\",\"" + loinData.Name + "\",\"" + loinData.Wage + "\", " + loinData.Authority + ", " + loinData.Task + ")";
Thread thread = new Thread(() => MainWindow.runThread(4, MySQLData.TableMember, sql));
thread.Start();
return(result);
}
/// <summary>
/// 데이터 베이스에 데이터 입력
/// </summary>
/// <param name="tableName">테이블명</param>
/// <param name="scheduleData">스케줄데이터</param>
/// <returns>영향받은 행수</returns>
public int Insert(string tableName, ScheduleData scheduleData)
{
int result = -1;
string sql = "values(\"" + scheduleData.Date + "\",\"" + scheduleData.Phone + "\",\"" + scheduleData.OnTime + "\",\"" + scheduleData.OffTime + "\")";
sqliteManager.DBOpen();
result = sqliteManager.Insert(tableName, sql);
Thread thread = new Thread(() => MainWindow.runThread(4, MySQLData.TableSchedule, sql));
thread.Start();
sqliteManager.DBClose();
return(result);
}
