public void Delete(int id)
{
using (TimeTrackerEntities db = new TimeTrackerEntities())
{
try
{
T_JobTracker t_jobtracker = new T_JobTracker();
t_jobtracker = db.T_JobTracker.FirstOrDefault(j => j.Id == id);
db.T_JobTracker.Remove(t_jobtracker);
db.SaveChanges();
}
catch (Exception ex)
{
string msg = ex.Message;
}
}
}
private void ParseJobTracker(T_JobTracker data,JobTracker jobtracker)
{
data.Id = jobtracker.Id;
data.JobIdNumber = jobtracker.JobIdNumber;
data.JobTypeId = jobtracker.JobTypeId;
data.Remarks = jobtracker.Remarks;
data.Description = jobtracker.Description;
data.StartTime = jobtracker.StartTime;
data.EndTime = jobtracker.EndTime;
data.ApprovedBy = jobtracker.ApprovedBy;
data.CreatedBy = jobtracker.CreatedBy;
data.LastUpdateDate = jobtracker.LastUpdateDate;
data.LastUpdatedBy = jobtracker.LastUpdatedBy;
data.CreateDate = jobtracker.CreateDate;
data.Status = jobtracker.Status;
data.SupervisorRemarks = jobtracker.SupervisorRemarks;
data.UserId = jobtracker.UserId;
data.ScheduleDate = jobtracker.ScheduleDate;
data.ActionRequest = jobtracker.ActionRequest;
data.HWNo = jobtracker.HWNo;
data.SWNo = jobtracker.SWNo;
data.JobStatus = jobtracker.JobStatus;
data.Customer = jobtracker.Customer;
data.EvalNo = jobtracker.EvalNo;
}
private void UpdateParse(T_JobTracker t_jobtracker, JobTracker jobtracker)
{
t_jobtracker.JobIdNumber = jobtracker.JobIdNumber;
t_jobtracker.JobTypeId = jobtracker.JobTypeId;
t_jobtracker.Remarks = jobtracker.Remarks;
t_jobtracker.Description = jobtracker.Description;
t_jobtracker.StartTime = jobtracker.StartTime;
t_jobtracker.EndTime = jobtracker.EndTime;
t_jobtracker.ApprovedBy = jobtracker.ApprovedBy;
t_jobtracker.LastUpdateDate = jobtracker.LastUpdateDate;
t_jobtracker.LastUpdatedBy = jobtracker.LastUpdatedBy;
t_jobtracker.Status = jobtracker.Status;
t_jobtracker.SupervisorRemarks = jobtracker.SupervisorRemarks;
t_jobtracker.UserId = jobtracker.UserId;
t_jobtracker.ScheduleDate = jobtracker.ScheduleDate;
t_jobtracker.ActionRequest = jobtracker.ActionRequest;
t_jobtracker.HWNo = jobtracker.HWNo;
t_jobtracker.SWNo = jobtracker.SWNo;
t_jobtracker.JobStatus = jobtracker.JobStatus;
t_jobtracker.Customer = jobtracker.Customer;
t_jobtracker.EvalNo = jobtracker.EvalNo;
}
//private JobTracker GetCustomer(string jobid)
//{
// JobTracker jobTracker = new JobTracker();
// using (SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["CAPHWConnection"].ToString()))
// {
// SqlCommand cmd = new SqlCommand("Select CO_Name,SO.SO_PCBdesc from Company CO, Sales_Order SO where SO.CO_ID = CO.CO_ID and SO.SO_Num = '" + jobid.Trim() + "'", con);
// con.Open();
// SqlDataReader reader = cmd.ExecuteReader();
// while (reader.Read())
// {
// jobTracker.Customer = reader["CO_Name"].ToString();
// jobTracker.Description = reader["SO_PCBdesc"].ToString();
// }
// }
// if (jobTracker.Customer == null || jobTracker.Customer == "")
// {
// using (SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["CAPSWConnection"].ToString()))
// {
// SqlCommand cmd = new SqlCommand("Select CO_Name,SO.SO_PCBdesc from Company CO, Sales_Order SO where SO.CO_ID = CO.CO_ID and SO.SO_Num = '" + jobid.Trim() + "'", con);
// con.Open();
// SqlDataReader reader = cmd.ExecuteReader();
// while (reader.Read())
// {
// jobTracker.Customer = reader["CO_Name"].ToString();
// jobTracker.Description = reader["SO_PCBdesc"].ToString();
// }
// }
// }
// return jobTracker;
//}
//private void GetCustomer(JobTracker jobtracker)
//{
// if (jobtracker.HWNo != null && jobtracker.HWNo.Trim() != "")
// {
// using (SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["CAPHWConnection"].ToString()))
// {
// SqlCommand cmd = new SqlCommand("Select CO_Name,SO.SO_PCBdesc from Company CO, Sales_Order SO where SO.CO_ID = CO.CO_ID and SO.SO_Num = '" + jobtracker.HWNo.Trim() + "'", con);
// con.Open();
// SqlDataReader reader = cmd.ExecuteReader();
// while (reader.Read())
// {
// jobtracker.Customer = reader["CO_Name"].ToString();
// jobtracker.Description = reader["SO_PCBdesc"].ToString();
// }
// }
// }
// else if ((jobtracker.SWNo != null && jobtracker.SWNo.Trim() != "") && (jobtracker.Customer == null || jobtracker.Customer.Trim() == ""))
// {
// using (SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["CAPSWConnection"].ToString()))
// {
// SqlCommand cmd = new SqlCommand("Select CO_Name,SO.SO_PCBdesc from Company CO, Sales_Order SO where SO.CO_ID = CO.CO_ID and SO.SO_Num = '" + jobtracker.SWNo.Trim() + "'", con);
// con.Open();
// SqlDataReader reader = cmd.ExecuteReader();
// while (reader.Read())
// {
// jobtracker.Customer = reader["CO_Name"].ToString();
// jobtracker.Description = reader["SO_PCBdesc"].ToString();
// }
// }
// }
//}
public void Insert(JobTracker jobtracker)
{
T_JobTracker j = new T_JobTracker();
ParseJobTracker(j, jobtracker);
using (TimeTrackerEntities db = new TimeTrackerEntities())
{
try
{
db.T_JobTracker.Add(j);
db.SaveChanges();
}
catch (Exception ex)
{
string msg = ex.Message;
}
}
}
