public static string UpdateLogIdleClose(Model.mdlLogIdleParam lLogIdleParam) { List <SqlParameter> sp = new List <SqlParameter>() { new SqlParameter() { ParameterName = "@EmployeeID", SqlDbType = SqlDbType.NVarChar, Value = lLogIdleParam.EmployeeID }, new SqlParameter() { ParameterName = "@BranchID", SqlDbType = SqlDbType.NVarChar, Value = lLogIdleParam.BranchID }, new SqlParameter() { ParameterName = "@StartIdle", SqlDbType = SqlDbType.DateTime, Value = lLogIdleParam.StartIdle }, new SqlParameter() { ParameterName = "@Latitude", SqlDbType = SqlDbType.NVarChar, Value = lLogIdleParam.Latitude }, new SqlParameter() { ParameterName = "@Longitude", SqlDbType = SqlDbType.NVarChar, Value = lLogIdleParam.Longitude }, new SqlParameter() { ParameterName = "@Duration", SqlDbType = SqlDbType.NVarChar, Value = lLogIdleParam.Duration }, //new SqlParameter() {ParameterName = "@Location", SqlDbType = SqlDbType.NVarChar, Value = lLogIdleParam.Location }, //new SqlParameter() {ParameterName = "@EndIdle", SqlDbType = SqlDbType.NVarChar, Value = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") }, new SqlParameter() { ParameterName = "@EndIdle", SqlDbType = SqlDbType.NVarChar, Value = lLogIdleParam.Now }, //new SqlParameter() {ParameterName = "@Status", SqlDbType = SqlDbType.Bit, Value = lLogIdleParam.Status } }; // string result = DataFacade.DTSQLVoidCommand(@"UPDATE Log_Idle SET Latitude = @Latitude, Longitude=@Longitude, // Location=@Location, Status=1, EndIdle=@EndIdle // WHERE EmployeeID = @EmployeeID AND BranchID = @BranchID // AND Status=0", sp); string result = DataFacade.DTSQLVoidCommand(@"UPDATE Log_Idle SET Latitude = @Latitude, Longitude=@Longitude, Status=1, EndIdle=@EndIdle, Duration=@Duration WHERE EmployeeID = @EmployeeID AND BranchID = @BranchID AND Status=0", sp); return(result); //jika false tidak ada data, jika true ada data }
public static string InsertLogIdle(Model.mdlLogIdleParam lLogIdleParam) { List <SqlParameter> sp = new List <SqlParameter>() { new SqlParameter() { ParameterName = "@EmployeeID", SqlDbType = SqlDbType.NVarChar, Value = lLogIdleParam.EmployeeID }, new SqlParameter() { ParameterName = "@BranchID", SqlDbType = SqlDbType.NVarChar, Value = lLogIdleParam.BranchID }, new SqlParameter() { ParameterName = "@StartIdle", SqlDbType = SqlDbType.DateTime, Value = lLogIdleParam.StartIdle }, new SqlParameter() { ParameterName = "@Latitude", SqlDbType = SqlDbType.NVarChar, Value = lLogIdleParam.Latitude }, new SqlParameter() { ParameterName = "@Longitude", SqlDbType = SqlDbType.NVarChar, Value = lLogIdleParam.Longitude }, new SqlParameter() { ParameterName = "@Duration", SqlDbType = SqlDbType.NVarChar, Value = lLogIdleParam.Duration }, new SqlParameter() { ParameterName = "@Location", SqlDbType = SqlDbType.NVarChar, Value = lLogIdleParam.Location }, new SqlParameter() { ParameterName = "@Status", SqlDbType = SqlDbType.Bit, Value = lLogIdleParam.Status } }; string result = DataFacade.DTSQLVoidCommand("INSERT INTO Log_Idle (EmployeeID,BranchID,StartIdle,Latitude,Longitude,Duration,Location,Status) VALUES (@EmployeeID,@BranchID,@StartIdle,@Latitude,@Longitude,@Duration,@Location,@Status)", sp); return(result); //jika false tidak ada data, jika true ada data }
public static Model.mdlLogIdle GetLogIdle(Model.mdlLogIdleParam lLogIdleParam) { List <SqlParameter> sp = new List <SqlParameter>() { new SqlParameter() { ParameterName = "@EmployeeID", SqlDbType = SqlDbType.NVarChar, Value = lLogIdleParam.EmployeeID }, new SqlParameter() { ParameterName = "@BranchID", SqlDbType = SqlDbType.NVarChar, Value = lLogIdleParam.BranchID }, new SqlParameter() { ParameterName = "@StartIdle", SqlDbType = SqlDbType.DateTime, Value = lLogIdleParam.StartIdle } }; DataTable dtLogIdle = Manager.DataFacade.DTSQLCommand(@"SELECT EmployeeID ,BranchID ,StartIdle, Latitude, Longitude, Duration, Location ,Status FROM Log_Idle WHERE EmployeeID = @EmployeeID AND BranchID = @BranchID AND Status=0", sp); var lmdlLogIdle = new Model.mdlLogIdle(); foreach (DataRow row in dtLogIdle.Rows) { lmdlLogIdle.BranchID = row["BranchID"].ToString(); lmdlLogIdle.EmployeeID = row["EmployeeID"].ToString(); lmdlLogIdle.StartIdle = row["StartIdle"].ToString(); lmdlLogIdle.Latitude = row["Latitude"].ToString(); lmdlLogIdle.Longitude = row["Longitude"].ToString(); lmdlLogIdle.Location = row["Location"].ToString(); lmdlLogIdle.Duration = row["Duration"].ToString(); lmdlLogIdle.Status = row["Status"].ToString(); } return(lmdlLogIdle); }