protected void btnSaveWZD_Click(object sender, EventArgs e) { try { WorkZoneDetail wzd = new WorkZoneDetail(); wzd = WorkZoneDetail.GetWorkZoneDetail(int.Parse(HiddenWorkZoneId.Value), int.Parse(HiddenWorkZoneDetailId.Value)); wzd.Comment = txtCommetWZD.Text; wzd.ImageFile = string.Format(Constant.WORKNC_WZ_DETAIL_IMAGE_NAME, wzd.WorkZoneDetailId); wzd.Update(); if (ViewState["imgWZD"] == null) { return; } WorkZone wz = WorkZone.GetWorkZone(int.Parse(HiddenWorkZoneId.Value)); string path = "~/" + Common.GetFolderWorkZoneDetail(wz.CompanyId, wz.CompanyName, wz.FactoryId, wz.FactoryName, wz.WorkZoneId, wz.Name); SaveImage("imgWZD", path, wzd.ImageFile); ViewState.Remove("imgWZD"); panelMain.Visible = true; panelEidtDetail.Visible = false; } catch (Exception ex) { RegisterStartupScript("alert(\"" + GetJSMessage(GetResource("Title_Error"), ex.Message) + "\");"); logger.Error("Error in Save WorkZoneDetail:", ex); } }
private void ShowWorkZOneDetail() { WorkZoneDetail wzd = new WorkZoneDetail(); wzd = WorkZoneDetail.GetWorkZoneDetail(int.Parse(HiddenWorkZoneId.Value), int.Parse(HiddenWorkZoneDetailId.Value)); txtNo.Text = wzd.No; txtNCfileName.Text = wzd.NCFileName; txtPathType.Text = wzd.PathType; txtCommetWZD.Text = wzd.Comment; txtImgWZD.Text = wzd.ImageFile; WorkZone wz = WorkZone.GetWorkZone(int.Parse(HiddenWorkZoneId.Value)); string pathFileDetail = Server.MapPath("~/" + Common.GetFolderWorkZoneDetail(wz.CompanyId, wz.CompanyName, wz.FactoryId, wz.FactoryName, wz.WorkZoneId, wz.Name)) + "/" + wzd.ImageFile; if (File.Exists(pathFileDetail)) { imgWZD.ImageUrl = "~/" + Common.GetFolderWorkZoneDetail(wz.CompanyId, wz.CompanyName, wz.FactoryId, wz.FactoryName, wz.WorkZoneId, wz.Name) + "/" + txtImgWZD.Text + "?" + (new Random()).Next(int.MinValue, int.MaxValue) + ""; } else { imgWZD.ImageUrl = "~/Images/no-image.png"; } panelMain.Visible = false; panelEidtDetail.Visible = true; }
public void UpdateDetailStatus(WorkZoneDetail workZoneDetail)// int WorkZoneId, int WorkZoneDetailId, int Status, string CreateAccount) // { logger.DebugFormat("updateDetailStatus Begin, workZoneId= {0}, workZoneDetailId = {1}, updateStatus ={2}, userName = {3}", workZoneDetail.WorkZoneId, workZoneDetail.WorkZoneDetailId, workZoneDetail.Status, workZoneDetail.CreateAccount); WorkZoneDetail.UpdateDetailStatus(workZoneDetail.WorkZoneId, workZoneDetail.WorkZoneDetailId, workZoneDetail.Status, workZoneDetail.CreateAccount); if (workZoneDetail.Status == 2) { logger.Debug("Case Finish workZone - remove detail problem"); try { WorkZone wk = WorkZone.GetWorkZone(workZoneDetail.WorkZoneId); string pathFolderProblem = Path.Combine(System.Web.Hosting.HostingEnvironment.ApplicationPhysicalPath, Common.GetFolderWorkZoneProblem(wk.CompanyId, wk.CompanyName, wk.FactoryId, wk.FactoryName, wk.WorkZoneId, wk.Name)); List <DetailProblem> listProblem = DetailProblem.GetAllDetailProblem(workZoneDetail.WorkZoneId, workZoneDetail.WorkZoneDetailId); foreach (DetailProblem i in listProblem) { i.Delete(); string pathFile = Path.Combine(pathFolderProblem, i.ImageFile); if (File.Exists(pathFile)) { File.Delete(pathFile); } } } catch (Exception ex) { logger.Warn("Ignore case delete problem", ex); } } }
protected void btnDelete_Click(object sender, EventArgs e) { try { int countcheck = 0; string id = ""; string name = ""; CheckBox cb = new CheckBox(); foreach (GridViewRow r in grdWorkZoneList.Rows) { cb = (CheckBox)r.Cells[0].FindControl("cb"); if (cb.Checked) { countcheck++; if (countcheck == 2) { break; } else { id = r.Cells[12].Text; name = r.Cells[1].Text; } } } if (countcheck == 0) { RegisterStartupScript("alert(\"" + GetJSMessage(GetResource("Title_Error"), GetResource("MSG_NONE_SELECTED_ITEM")) + "\");"); return; } else if (countcheck == 2) { RegisterStartupScript("alert(\"" + GetJSMessage(GetResource("Title_Error"), GetResource("MSG_MORE_ONE_SELECTED")) + "\");"); return; } else { WorkZone wz = WorkZone.GetWorkZone(int.Parse(id)); WorkZone.DeleteWorkZone(int.Parse(id)); string directoryPath = Server.MapPath("~" + Common.GetFolderWorkZone(wz.CompanyId, wz.CompanyName, wz.FactoryId, wz.FactoryName, wz.WorkZoneId, wz.Name)); if (Directory.Exists(directoryPath)) { Directory.Delete(directoryPath, true); } Search(); } } catch (Exception ex) { RegisterStartupScript("alert(\"" + GetJSMessage(GetResource("Title_Error"), ex.Message) + "\");"); logger.Error("Error in Delete:", ex); } }
public List <DetailProblem> GetAllFileProblem(int workZoneId, int workZoneDetailId) { //string workZoneName = WorkZone.GetWorkZoneName(workZoneId); List <DetailProblem> listFile = DetailProblem.GetAllDetailProblem(workZoneId, workZoneDetailId); WorkZone wz = WorkZone.GetWorkZone(workZoneId); foreach (DetailProblem i in listFile) { string pathProblem = Common.GetFolderWorkZoneProblem(wz.CompanyId, wz.CompanyName, wz.FactoryId, wz.FactoryName, wz.WorkZoneId, wz.Name); pathProblem = pathProblem.Replace("Portal", ""); i.ImageFile = string.Format(@"{0}{1}/{2}", Common.AppSettingKey(Constant.PORTAL_CONFIG), pathProblem, i.ImageFile).Replace(" ", "%20"); } return(listFile); }
protected void btnSave_Click(object sender, EventArgs e) { try { if (Request.QueryString["Id"].ToString() == string.Empty) { return; } WorkZone wz = WorkZone.GetWorkZone(int.Parse(Request.QueryString["Id"].ToString())); int countWorKZoneName = WorkZone.GetCountWorkZoneName(int.Parse(cbxMachine.SelectedItem.Value), txtWorkZoneName.Text); if (wz == null) { if (countWorKZoneName > 0) { RegisterStartupScript("alert(\"" + GetJSMessage(GetResource("Title_Error"), string.Format(GetResource("CheckWZName"), txtWorkZoneName.Text)) + "\");"); return; } wz = new WorkZone(); wz.WorkZoneId = int.Parse(Request.QueryString["Id"].ToString()); wz.CreateAccount = this.User.Identity.Name; } else { if (countWorKZoneName > 0 && wz.Name != txtWorkZoneName.Text) { RegisterStartupScript("alert(\"" + GetJSMessage(GetResource("Title_Error"), string.Format(GetResource("CheckWZName"), txtWorkZoneName.Text)) + "\");"); return; } } wz.Name = txtWorkZoneName.Text; wz.CompanyId = int.Parse(GetCompany()); wz.CompanyName = Company.GetCompanyName(wz.CompanyId); wz.FactoryId = int.Parse(cbxFactory.SelectedItem.Value); wz.FactoryName = Factory.GetFactoryName(wz.FactoryId); wz.MachineId = int.Parse(cbxMachine.SelectedItem.Value); wz.WorkZonePath = txtWorkZonePath.Text; wz.ModelDataProgramer = txtModelDataProgramer.Text; wz.NCDataProgramer = txtNCDataProgramer.Text; wz.ProgramDate = Convert.ToDateTime(txtProgramDate.Text); wz.ModelName = txtModelName.Text; wz.Parts = txtParts.Text; wz.PartName = txtPartName.Text; wz.MachiningTimeTotal = txtMachiningTimeTotal.Text; wz.Comment = txtComment.Text; wz.Status = int.Parse(cbxStatus.SelectedItem.Value); wz.ImageFile = Constant.WORKNC_WZ_IMAGE_NAME; wz.ModifiedAccount = this.User.Identity.Name; wz.Update(); //if(previousName != wz.Name) // Directory.Move(Server.MapPath("~/Portal\\Images\\WorkZone\\" + previousName + ""), Server.MapPath("~/Portal\\Images\\WorkZone\\" + txtWorkZoneName.Text + "")); if (txtImgName.Text != string.Empty) { string path = "~/" + Common.GetFolderWorkZone(wz.CompanyId, wz.CompanyName, wz.FactoryId, wz.FactoryName, wz.WorkZoneId, wz.Name); SaveImage("imgWZ", path, wz.ImageFile); } ViewState.Remove("imgWZ"); RegisterStartupScript("alert(\"" + GetJSMessage("", GetResource("MSGUPLOAD")) + "\");"); } catch (Exception ex) { RegisterStartupScript("alert(\"" + GetJSMessage(GetResource("Title_Error"), ex.Message) + "\");"); logger.Error("Error in Save WorkZone:", ex); } }
public void UploadFile(DetailProblem problem) { logger.DebugFormat("Begin UploadFile , WorkZoneId = {0}, workZOneDetailId id = {1}", problem.WorkZoneId, problem.WorkZoneDetailId); WorkZone wk = WorkZone.GetWorkZone(problem.WorkZoneId); string pathFolderProblem = Path.Combine(System.Web.Hosting.HostingEnvironment.ApplicationPhysicalPath, Common.GetFolderWorkZoneProblem(wk.CompanyId, wk.CompanyName, wk.FactoryId, wk.FactoryName, wk.WorkZoneId, wk.Name)); logger.Debug("PhysicalPath pathFolder =" + pathFolderProblem); string uploadFilePath = ""; try { using (DBContext db = new DBContext()) { using (System.Data.Common.DbTransaction tran = db.UseTransaction()) { try { if (problem.FileId == 0) // case insert New { logger.Debug(" Case Insert new problem"); WorkZoneDetail d = WorkZoneDetail.GetWorkZoneDetail(problem.WorkZoneId, problem.WorkZoneDetailId); d.Status = 1; // Has Problem d.ModifiedAccount = problem.CreateAccount; d.Update(); problem.FileId = DetailProblem.GetNextFileID(d.WorkZoneId, d.WorkZoneDetailId); if (problem.Base64Data != null) { problem.ImageFile = string.Format("{0}_{1}.png", d.WorkZoneDetailId, problem.FileId); } problem.ModifiedAccount = problem.CreateAccount; problem.Insert(); logger.Debug(" Update problem and WorkZone Detail"); if (!Directory.Exists(pathFolderProblem)) { Directory.CreateDirectory(pathFolderProblem); } if (!string.IsNullOrEmpty(problem.Base64Data)) { uploadFilePath = Path.Combine(pathFolderProblem, problem.ImageFile); logger.Debug("Case Create file problem = " + uploadFilePath); Byte[] data = Convert.FromBase64String(problem.Base64Data); File.WriteAllBytes(uploadFilePath, data); problem.Base64Data = null; } } else if (problem.FileId != 0) // Update or Delete { DetailProblem p = DetailProblem.GetDetailProblem(problem.WorkZoneId, problem.WorkZoneDetailId, problem.FileId); if (string.IsNullOrEmpty(problem.ImageFile)) { //delete logger.Debug("Case Delete detail Problem"); p.Delete(); uploadFilePath = Path.Combine(pathFolderProblem, p.ImageFile); logger.Debug("Case Delete file uploadFilePath = " + uploadFilePath); if (File.Exists(uploadFilePath)) { File.Delete(uploadFilePath); } } else { logger.Debug("Case update detail Problem"); p.Comment = problem.Comment; p.ModifiedAccount = problem.CreateAccount; p.Update(); } } tran.Commit(); } catch (Exception ex) { tran.Rollback(); logger.Error("Error UploadFile", ex); throw ex; } } } logger.Debug("End UploadFile"); } catch (Exception ex) { logger.Error("Error UploadFile ", ex); throw ex; } }