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
}
