private void lsTimeSheet_SelectionChanged(object sender, SelectionChangedEventArgs e)
{
if (rbTMAll.IsChecked == false && rbTMRecent.IsChecked == false)
{
if (lsTimeSheet.SelectedItems.Count > 0)
{
CS_TimeSheetPROD timesheet = lsTimeSheet.SelectedItem as CS_TimeSheetPROD;
if (timesheet != null)
{
dpEndDate.IsEnabled = true;
dpStartDate.IsEnabled = false;
txtOdp.Text = timesheet.MONo;
txtPhase.Text = timesheet.Phase;
dpStartDate.SelectedTime = timesheet.StartDate;
tm.Id = timesheet.Id;
tm.Line = timesheet.Line;
tm.MOId = timesheet.MOId;
tm.MONo = timesheet.MONo;
tm.Phase = timesheet.Phase;
tm.RtgStep = timesheet.RtgStep;
tm.StartDate = timesheet.StartDate;
tm.StatusODP = timesheet.StatusODP;
tm.UserIdOP = Menu.usermanager.Id;
dpEndDate.IsEnabled = true;
}
}
}
else
{
dpEndDate.IsEnabled = false;
dpStartDate.IsEnabled = true;
}
}
public List <CS_TimeSheetPROD> getTimeSheetRecent(int userid)
{
try
{
List <CS_TimeSheetPROD> list = new List <CS_TimeSheetPROD>();
string sql = @"SELECT
*
FROM
CS_TimeSheetPROD
WHERE
StartDate >= DATEADD(day,-7, GETDATE())
AND UserIdOP = " + userid;
conn.Open();
SqlCommand cmd = new SqlCommand(sql, conn);
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
CS_TimeSheetPROD tsp = new CS_TimeSheetPROD();
tsp.Id = (int)reader["Id"];
tsp.Line = (int)reader["Line"];
tsp.MOId = (int)reader["MOId"];
tsp.Phase = reader["Phase"].ToString();
tsp.RtgStep = (int)reader["RtgStep"];
if (!string.IsNullOrEmpty(reader["StartDate"].ToString()))
{
tsp.StartDate = Convert.ToDateTime(reader["StartDate"]);
}
if (!string.IsNullOrEmpty(reader["EndDate"].ToString()))
{
tsp.EndDate = Convert.ToDateTime(reader["EndDate"]);
}
tsp.IsFinalized = reader["IsFinalized"].ToString();
tsp.StatusODP = (int)reader["StatusODP"];
tsp.UserIdOP = (int)reader["UserIdOP"];
list.Add(tsp);
}
conn.Close();
reader.Close();
if (list.Count > 0)
{
foreach (var item in list)
{
item.MONo = getMONo((short)item.MOId);
}
}
return(list);
}
catch (Exception ex)
{
conn.Close();
throw ex;
}
}
public void Insert(CS_TimeSheetPROD obj)
{
try
{
string sql = @"INSERT INTO CS_TimeSheetPROD
(Id
,Line
,MOId
,Phase
,StartDate
,StatusODP
,RtgStep
,UserIdOP
,TBCreated
,TBModified
,TBCreatedID
,TBModifiedID
,TBGuid) VALUES (" +
$"{ obj.Id }," +
$"{ obj.Line }," +
$"{ obj.MOId }," +
$"'{ obj.Phase }'," +
$"'{ obj.StartDate }'," +
$"{ obj.StatusODP }," +
$"{ obj.RtgStep }," +
$"{ obj.UserIdOP }," +
$"'{ DateTime.Now }'," +
$"'{ DateTime.Now }'," +
$"{ 1 }," +
$"{ 1 }," +
$"'{ Guid.NewGuid() }')";
conn.Open();
SqlCommand cmd = new SqlCommand(sql, conn);
cmd.ExecuteNonQuery();
conn.Close();
}
catch (Exception ex)
{
conn.Close();
throw ex;
}
}
public List <CS_TimeSheetPROD> getTimeSheetOpen(int userid)
{
try
{
List <CS_TimeSheetPROD> list = new List <CS_TimeSheetPROD>();
string sql = @"SELECT
*
FROM
CS_TimeSheetPROD
WHERE
IsFinalized = '0'
AND StartDate IS NOT NULL
AND UserIdOP = " + userid;
conn.Open();
SqlCommand cmd = new SqlCommand(sql, conn);
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
CS_TimeSheetPROD tsp = new CS_TimeSheetPROD();
tsp.Id = (int)reader["Id"];
tsp.Line = (int)reader["Line"];
tsp.MOId = (int)reader["MOId"];
tsp.Phase = reader["Phase"].ToString();
tsp.RtgStep = (int)reader["RtgStep"];
if (!string.IsNullOrEmpty(reader["StartDate"].ToString()))
{
tsp.StartDate = Convert.ToDateTime(reader["StartDate"]);
}
if (!string.IsNullOrEmpty(reader["EndDate"].ToString()))
{
tsp.EndDate = Convert.ToDateTime(reader["EndDate"]);
}
tsp.IsFinalized = reader["IsFinalized"].ToString();
tsp.StatusODP = (int)reader["StatusODP"];
tsp.UserIdOP = (int)reader["UserIdOP"];
if (Convert.ToDateTime(reader["EndDate"]).ToShortDateString() == "31/12/1799")
{
tsp.EndDate = Convert.ToDateTime("01/01/0001");
}
tsp.Status = (tsp.StatusODP == 20578305) ? "Em processamento" : "Terminada";
list.Add(tsp);
}
conn.Close();
reader.Close();
if (list.Count > 0)
{
foreach (var item in list)
{
item.MONo = getMONo((short)item.MOId);
}
}
return(list);
}
catch (Exception ex)
{
conn.Close();
throw ex;
}
}
