private bool ReadExcel(string job_id)
{
FileInfo excel = new FileInfo(Server.MapPath("~/EXCEL/" + job_id + ".xlsx"));
using (var package = new ExcelPackage(excel))
{
var workbook = package.Workbook;
//*** Sheet 1
var worksheet = workbook.Worksheets["Sheet1"];
//*** Result
MODEL.Criteria.job job = new MODEL.Criteria.job();
job.job_name = worksheet.Cells["A3"].Text;
string tmpD;
tmpD = worksheet.Cells["B1"].Text;
// RET M/dd/yyyy 1/27/2018
job.job_date = retDate(tmpD);
job.job_id = job_id;
job.place_type = worksheet.Cells["K5"].Text.Trim();
// jobDetail
List <MODEL.Criteria.jobDetail> lstJobDetail = new List <MODEL.Criteria.jobDetail>();
int i = 5;
do
{
MODEL.jobDetail jobDetail = new MODEL.jobDetail();
jobDetail.place_get_job = worksheet.Cells[i, 1].Text;
jobDetail.container_type = worksheet.Cells[i, 2].Text;
jobDetail.container_dim = worksheet.Cells[i, 3].Text;
jobDetail.cust_dest = worksheet.Cells[i, 4].Text;
jobDetail.code_name = worksheet.Cells[i, 5].Text;
jobDetail.appointed_time = worksheet.Cells[i, 6].Text;
jobDetail.doc_no = worksheet.Cells[i, 7].Text;
jobDetail.place_send_job = worksheet.Cells[i, 8].Text;
jobDetail.send_company = worksheet.Cells[i, 9].Text;
jobDetail.remark = worksheet.Cells[i, 10].Text;
jobDetail.place_type = worksheet.Cells[i, 11].Text;
lstJobDetail.Add(jobDetail);
i++;
} while (worksheet.Cells[i, 1].Text != "");
job.createby = Session["NAME"].ToString();
InsertJob(job, lstJobDetail);
}
return(true);
}
private bool InsertJob(MODEL.Criteria.job job, List <MODEL.Criteria.jobDetail> lstJobDetail)
{
BLL.job _BLL = new BLL.job();
int ret;
ret = _BLL.Insert_Job(job);
if (ret == 1)
{
int k;
k = lstJobDetail.Count();
for (int i = 0; i < k; i++)
{
MODEL.Criteria.jobDetail jdt = new MODEL.Criteria.jobDetail();
jdt = (MODEL.Criteria.jobDetail)lstJobDetail[i];
jdt.job_id = job.job_id;
jdt.job_name = job.job_name;
_BLL.Insert_JobDetail(jdt);
}
}
return(true);
}
public int Insert_Job(MODEL.Criteria.job criteria)
{
try
{
criteria.createdate = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
Class.clsDB db = new Class.clsDB();
string sql;
sql = "Insert into job_trailer ( ";
sql += "job_id,";
sql += "job_name,";
sql += "job_date,";
sql += "place_type,";
sql += "create_by ,";
sql += "create_date) VALUES(";
sql += "'" + criteria.job_id + "',";
sql += "'" + criteria.job_name + "',";
sql += "'" + criteria.job_date + "',";
sql += "'" + criteria.place_type + "',";
sql += "'" + criteria.createby + "',";
sql += "'" + criteria.createdate + "')";
int ret;
ret = db.ExecuteNonQuery(sql);
db.Close();
return(ret);
}
catch (Exception ex)
{
return(0);
}
}
public int Insert_Job(MODEL.Criteria.job criteria)
{
return(_DAL.Insert_Job(criteria));
}
