private bool CheckExists(Q_Works model, bool checkCode)
{
Q_Works obj = null;
if (checkCode)
{
obj = db.Q_Works.FirstOrDefault(x => !x.IsDeleted && x.Id != model.Id && x.Code.Trim().ToUpper().Equals(model.Code.Trim().ToUpper()));
}
else
{
obj = db.Q_Works.FirstOrDefault(x => !x.IsDeleted && x.Id != model.Id && x.Name.Trim().ToUpper().Equals(model.Name.Trim().ToUpper()));
}
return(obj != null ? true : false);
}
public ResponseBaseModel Insert(string connectString, Q_Works model)
{
var rs = new ResponseBaseModel();
using (db = new QMSSystemEntities(connectString))
{
if (!CheckExists(model, true))
{
if (!CheckExists(model, false))
{
if (model.Id == 0)
{
db.Q_Works.Add(model);
}
else
{
var obj = db.Q_Works.FirstOrDefault(x => !x.IsDeleted && x.Id == model.Id);
if (obj != null)
{
obj.Code = model.Code;
obj.Name = model.Name;
}
else
{
rs.IsSuccess = false;
rs.sms = "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 = "Tên công việc đã tồn tại. Vui lòng nhập tên khác!.";
}
}
else
{
rs.IsSuccess = false;
rs.sms = "Mã công việc đã tồn tại. Vui lòng nhập mã 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();
}
}
