public ResponseBaseModel Insert(string connectString, Q_WorkDetail model) { var rs = new ResponseBaseModel(); using (db = new QMSSystemEntities(connectString)) { if (!CheckExists(model)) { if (model.Id == 0) { db.Q_WorkDetail.Add(model); } else { var obj = db.Q_WorkDetail.FirstOrDefault(x => !x.IsDeleted && x.Id == model.Id); if (obj != null) { obj.WorkId = model.WorkId; obj.WorkTypeId = model.WorkTypeId; obj.TimeProcess = model.TimeProcess; } else { rs.IsSuccess = false; rs.sms = "Chi tiết công việc đã bị xóa hoặc không tồn tại trong hệ thống. Vui lòng kiểm tra lại!."; } } db.SaveChanges(); rs.IsSuccess = true; } else { rs.IsSuccess = false; rs.sms = "Loại công việc đã tồn tại công việc này. Vui lòng chọn công việc khác!."; } } return(rs); }
public void taoCongViec(string path, string connectionString) { ExcelApp.Application excelApp = new ExcelApp.Application(); ExcelApp.Workbook excelBook = excelApp.Workbooks.Open(path); ExcelApp._Worksheet excelSheet = excelBook.Sheets[1]; ExcelApp.Range excelRange = excelSheet.UsedRange; using (var db = new QMSSystemEntities(connectionString)) { Q_Works work; Q_WorkDetail workDetail_So; Q_WorkDetail workDetail_Ga; for (int ii = 5; ii < 36; ii++) { string code = excelRange.Cells[ii, 1].Value2.ToString(); string name = excelRange.Cells[ii, 2].Value2.ToString(); string phutSo = excelRange.Cells[ii, 3].Value2.ToString(); string phutGa = excelRange.Cells[ii, 4].Value2.ToString(); work = new Q_Works() { Code = code, Name = name }; work.Q_WorkDetail = new List <Q_WorkDetail>(); workDetail_So = new Q_WorkDetail() { Q_Works = work, WorkTypeId = 1, TimeProcess = layGio(Convert.ToInt32(phutSo)) }; //so work.Q_WorkDetail.Add(workDetail_So); workDetail_Ga = new Q_WorkDetail() { Q_Works = work, WorkTypeId = 2, TimeProcess = layGio(Convert.ToInt32(phutGa)) }; //ga work.Q_WorkDetail.Add(workDetail_Ga); db.Q_Works.Add(work); } for (int ii = 38; ii < 68; ii++) { string code = excelRange.Cells[ii, 1].Value2.ToString(); string name = excelRange.Cells[ii, 2].Value2.ToString(); string phutSo = excelRange.Cells[ii, 3].Value2.ToString(); string phutGa = excelRange.Cells[ii, 4].Value2.ToString(); work = new Q_Works() { Code = code, Name = name }; work.Q_WorkDetail = new List <Q_WorkDetail>(); workDetail_So = new Q_WorkDetail() { Q_Works = work, WorkTypeId = 1, TimeProcess = layGio(Convert.ToInt32(phutSo)) }; //so work.Q_WorkDetail.Add(workDetail_So); workDetail_Ga = new Q_WorkDetail() { Q_Works = work, WorkTypeId = 2, TimeProcess = layGio(Convert.ToInt32(phutGa)) }; //ga work.Q_WorkDetail.Add(workDetail_Ga); db.Q_Works.Add(work); } for (int ii = 5; ii < 56; ii++) { string code = excelRange.Cells[ii, 8].Value2.ToString(); string name = excelRange.Cells[ii, 9].Value2.ToString(); string phutSo = excelRange.Cells[ii, 10].Value2.ToString(); string phutGa = excelRange.Cells[ii, 11].Value2.ToString(); work = new Q_Works() { Code = code, Name = name }; work.Q_WorkDetail = new List <Q_WorkDetail>(); workDetail_So = new Q_WorkDetail() { Q_Works = work, WorkTypeId = 1, TimeProcess = layGio(Convert.ToInt32(phutSo)) }; //so work.Q_WorkDetail.Add(workDetail_So); workDetail_Ga = new Q_WorkDetail() { Q_Works = work, WorkTypeId = 2, TimeProcess = layGio(Convert.ToInt32(phutGa)) }; //ga work.Q_WorkDetail.Add(workDetail_Ga); db.Q_Works.Add(work); } for (int ii = 57; ii < 69; ii++) { string code = excelRange.Cells[ii, 8].Value2.ToString(); string name = excelRange.Cells[ii, 9].Value2.ToString(); string phutSo = excelRange.Cells[ii, 10].Value2.ToString(); string phutGa = excelRange.Cells[ii, 11].Value2.ToString(); work = new Q_Works() { Code = code, Name = name }; work.Q_WorkDetail = new List <Q_WorkDetail>(); workDetail_So = new Q_WorkDetail() { Q_Works = work, WorkTypeId = 1, TimeProcess = layGio(Convert.ToInt32(phutSo)) }; //so work.Q_WorkDetail.Add(workDetail_So); workDetail_Ga = new Q_WorkDetail() { Q_Works = work, WorkTypeId = 2, TimeProcess = layGio(Convert.ToInt32(phutGa)) }; //ga work.Q_WorkDetail.Add(workDetail_Ga); db.Q_Works.Add(work); } db.SaveChanges(); } }
private bool CheckExists(Q_WorkDetail model) { var obj = db.Q_WorkDetail.FirstOrDefault(x => !x.IsDeleted && x.Id != model.Id && x.WorkId == model.WorkId && x.WorkTypeId == model.WorkTypeId); return(obj != null ? true : false); }