public HttpResponseMessage SaveUploadDocl(UploadDoc obj)
{
OracleConnection connection = new OracleConnection(ConnectionString);
OracleCommand command;
try
{
connection.Open();
command = new OracleCommand("HCI_SP_UPLOAD_INSERT");
command.CommandType = CommandType.StoredProcedure;
command.Connection = connection;
command.Parameters.Add("V_ID", OracleDbType.Double).Value = obj.Id;
command.Parameters.Add("V_AGT_CODE", OracleDbType.NVarchar2).Value = obj.AgtCode;
command.Parameters.Add("V_DOC_TYPE_ID", OracleDbType.Double).Value = obj.DocTypeId;
command.Parameters.Add("V_DOC_URL", OracleDbType.NVarchar2).Value = obj.DocUrl;
command.Parameters.Add("V_CREATED_BY", OracleDbType.NVarchar2).Value = obj.CreatedBy;
command.Parameters.Add("V_DOC_DESCRIPTION", OracleDbType.NVarchar2).Value = obj.DocDescription;
//command.Parameters.Add("V_CREATED_DATE", OracleType.DateTime).Value = "";// obj.CreatedDate;
//command.Parameters.Add("V_EFFECTIVE_END_DATE", OracleType.DateTime).Value = "";// obj.EffectiveEndDate;
command.ExecuteNonQuery();
connection.Close();
return(Request.CreateResponse(HttpStatusCode.OK));
}
catch (Exception exception)
{
connection.Close();
return(Request.CreateResponse(HttpStatusCode.ExpectationFailed));
}
}
public IActionResult GetUploadedLoanDoc(int userId)
{
List <UploadDoc> lstUploadedDocVM = new List <UploadDoc>();
var t = _context.CustomerLoan.Where(q => q.CustomerId == userId).Select(q => q.CustomerLoanId).ToList();
List <CustomerLoanDocumentDtl> lstUploadedDoc = _context.CustomerLoanDocumentDtl.Where(q => t.Contains(q.CustomerLoanId)).ToList();
string folderName = "CustomerDoc";
string webRootPath = _hostingEnvironment.WebRootPath;
string uploadFilesPath = Path.Combine(webRootPath, folderName);
//var filepath = Path.Combine(uploadFilesPath, filename);
var result = lstUploadedDoc.GroupBy(q => new { q.FileName, q.DocumentTypeId }).Select(a => a.FirstOrDefault());
foreach (var item in result)
{
var doc = new UploadDoc
{
filedata = null,
Filename = item.FileName,
DocType = item.DocumentTypeId,
DownloadPath = string.Format("{0}/CustomerDoc/{1}", _configuration["DevImageDomain"], item.FileName),
isChecked = true
};
lstUploadedDocVM.Add(doc);
}
return(Ok(lstUploadedDocVM));
}
public ActionResult UploadDocEdit(TManager.Models.ViewModels.AttachedFileVM uploadhelper, int ProjectID)
{
if (ModelState.IsValid)
{
if (uploadhelper.AttachedFile != null && uploadhelper.AttachedFile.ContentLength > 0)
{
var realFileName = System.IO.Path.GetFileName(uploadhelper.AttachedFile.FileName);
var filePath = Server.MapPath("~/App_Data/UploadedDoc");
var fileName = DateTime.Now.Ticks + System.IO.Path.GetExtension(uploadhelper.AttachedFile.FileName);
string savedFileName = System.IO.Path.Combine(filePath, fileName);
uploadhelper.AttachedFile.SaveAs(savedFileName);
// init object here
var evd = new UploadDoc();
evd.FileName = realFileName;
evd.FileSystemName = fileName;
evd.ContentType = uploadhelper.AttachedFile.ContentType;
evd.FileExtension = Path.GetExtension(fileName);
evd.ProjectID = ProjectID;
// for now
evd.Description = uploadhelper.FDescription;
unitOfWork.Repository <UploadDoc>().Insert(evd);
unitOfWork.Save();
// we shall send back the id for this file
return(Json(new { ID = evd.FileID, R = true, FileName = evd.FileName, FileSystemName = evd.FileSystemName, Description = evd.Description, DLink = Url.Action("Download", "Home", new { id = evd.FileID }) }));
}
}
return(Json(new { R = false }));
}
public ActionResult DeleteDoc(string id)
{
if (!(string.IsNullOrEmpty(id)))
{
int delID = int.Parse(id);
UploadDoc doc = unitOfWork.Repository <UploadDoc>().GetByID(delID);
string fullPath = Request.MapPath("~/App_Data/UploadedDoc/" + doc.FileName);
if (System.IO.File.Exists(fullPath))
{
System.IO.File.Delete(fullPath);
}
unitOfWork.Repository <UploadDoc>().Delete(doc);
unitOfWork.Save();
return(Json(new { msg = "Document Remove successfully", D = true }));
}
return(Json(new { msg = "error in removing doc", D = false }));
}
//protected void DdlReceivedFrom_SelectedIndexChanged(object sender, EventArgs e)
//{
// GetAccReceiptInVoicesByReceiptID(1);
//}
protected void UploadFile()
{
string folderPath = Server.MapPath("~/Files/Receipts/");
//Check whether Directory (Folder) exists.
if (!Directory.Exists(folderPath))
{
//If Directory (Folder) does not exists. Create it.
Directory.CreateDirectory(folderPath);
}
//Save the File to the Directory (Folder).
UploadDoc.SaveAs(folderPath + Path.GetFileName(UploadDoc.FileName));
////Display the success message.
//lblMessage.Text = Path.GetFileName(FileUpload1.FileName) + " has been uploaded.";
}
public void UpdateUploadDoc(UploadDoc upload)
{
throw new NotImplementedException();
}
public void AddUploadDoc(UploadDoc upload)
{
_db.UploadDocs.Add(upload);
}
public UploadDoc getLeader_HProfilePicByAgentID(string vAGT_CODE)
{
UploadDoc UploadDocObj1 = new UploadDoc();
OracleDataReader dataReader1 = null;
OracleConnection connection1 = new OracleConnection(ConnectionString);
OracleCommand command1;
string sql = "";
sql = "SELECT " +
"CASE WHEN t.ID IS NULL THEN 0 ELSE t.ID END, " +
"t.AGT_CODE || ' - ' || A.AGT_FULL_NAME, " +
"CASE WHEN t.DOC_TYPE_ID IS NULL THEN 0 ELSE t.DOC_TYPE_ID END, " +
"CASE WHEN t.DOC_URL IS NULL THEN '' ELSE t.DOC_URL END, " +
"CASE WHEN t.CREATED_BY IS NULL THEN '' ELSE t.CREATED_BY END, " +
"CASE WHEN t.CREATED_DATE IS NULL THEN to_date('01/01/1900', 'DD/MM/RRRR') ELSE t.CREATED_DATE END, " +
"CASE WHEN t.EFFECTIVE_END_DATE IS NULL THEN to_date('01/01/1900', 'DD/MM/RRRR') ELSE to_date(t.EFFECTIVE_END_DATE, 'DD/MM/RRRR') END, DT.DOC_TYPE_NAME, t.doc_description " +
"FROM HCI_TBL_UPLOADED_DOC t, Hci_Tbl_Uploaded_Doc_Type DT, HCI_TBL_AGENT A " +
"WHERE A.AGT_CODE=:vAGT_CODE AND DT.doc_type_id = T.doc_type_id AND t.EFFECTIVE_END_DATE is null AND t.DOC_TYPE_ID = 1 AND A.AGT_CODE = T.AGT_CODE AND A.AGT_EFFECTIVE_END_DATE IS NULL";
command1 = new OracleCommand(sql, connection1);
command1.Parameters.Add(new OracleParameter("vAGT_CODE", vAGT_CODE));
connection1.Open();
try
{
dataReader1 = command1.ExecuteReader();
if (dataReader1.HasRows)
{
dataReader1.Read();
UploadDocObj1.Id = Convert.ToInt32(dataReader1[0]);
UploadDocObj1.AgtCode = dataReader1[1].ToString();
UploadDocObj1.DocTypeId = Convert.ToInt32(dataReader1[2].ToString());
UploadDocObj1.DocUrl = dataReader1[3].ToString();
UploadDocObj1.CreatedBy = dataReader1[4].ToString();
UploadDocObj1.CreatedDate = dataReader1[5].ToString();
UploadDocObj1.EffectiveEndDate = dataReader1[6].ToString();
UploadDocObj1.DocTypeDesc = dataReader1[7].ToString();
UploadDocObj1.DocDescription = dataReader1[8].ToString();
dataReader1.Close();
connection1.Close();
}
else
{
return(null);
}
}
catch (Exception exception)
{
if (dataReader1 != null || connection1.State == ConnectionState.Open)
{
dataReader1.Close();
connection1.Close();
}
}
finally
{
connection1.Close();
}
return(UploadDocObj1);
}
public async Task <FileUploadResult> UploadExcel(string vAGT_CODE)
{
try
{
var uploadPath = CommissionSystemREST.Properties.Settings.Default.Commission_Docs;
string year = DateTime.Now.Year.ToString();
var dbSavePath = "/" + year + "/" + vAGT_CODE;
uploadPath = uploadPath + "/" + year + "/" + vAGT_CODE;
if (!Directory.Exists(uploadPath))
{
System.IO.Directory.CreateDirectory(uploadPath);
}
var multipartFormDataStreamProvider = new UploadMultipartFormProvider(uploadPath);
// Read the MIME multipart asynchronously
await Request.Content.ReadAsMultipartAsync(multipartFormDataStreamProvider);
string AgentCode = multipartFormDataStreamProvider.FormData["AgentCode"];
string DocTypeID = multipartFormDataStreamProvider.FormData["DocTypeID"];
string UserID = multipartFormDataStreamProvider.FormData["UserID"];
string DocDescription = multipartFormDataStreamProvider.FormData["DocDescription"];
string _localFileName = multipartFormDataStreamProvider
.FileData.Select(multiPartData => multiPartData.LocalFileName).FirstOrDefault();
dbSavePath = dbSavePath + "/" + multipartFormDataStreamProvider
.FileData.Select(multiPartData => multiPartData.Headers.ContentDisposition.FileName).FirstOrDefault().Replace("\"", "");
DataTable Dt = ConvertExceltoDatatable(_localFileName, vAGT_CODE, UserID); // DPTSManualUpload / ReceiptManualUpload
if (vAGT_CODE == "DPTSManualUpload")
{
BulkCopyDPTS(Dt, UserID);
}
else if (vAGT_CODE == "ReceiptManualUpload")
{
BulkCopyRECEIPT(Dt);
}
UploadDoc uploadedDoc = new UploadDoc();
uploadedDoc.Id = 0;
uploadedDoc.AgtCode = AgentCode;
uploadedDoc.DocTypeId = Convert.ToInt32(DocTypeID);
uploadedDoc.DocUrl = dbSavePath;
uploadedDoc.CreatedBy = UserID;
uploadedDoc.CreatedDate = null;
uploadedDoc.EffectiveEndDate = null;
uploadedDoc.DocDescription = vAGT_CODE; // DPTSManualUpload / ReceiptManualUpload
SaveUploadDocl(uploadedDoc);
// Create response
return(new FileUploadResult
{
LocalFilePath = _localFileName,
FileName = Path.GetFileName(_localFileName),
FileLength = new FileInfo(_localFileName).Length
});
}
catch (Exception ex)
{
throw;
}
}
public string GenerateInvoiceAndTask(int POId)
{
try
{
string strDefCulZone = Global.DefCulZone();
DataAccess dba = new DataAccess();
using (SqlConnection conn = dba.dxConnection)
{
conn.Open();
SqlTransaction trans = conn.BeginTransaction();
SqlCommand command = conn.CreateCommand();
command.Transaction = trans;
string message = string.Empty;
int claimId = 0;
claimId = dba.dxGetIntData("select projid from schedule where schid=" + schId);
SubProcessId = dba.dxGetIntData("select subprocessid from schedule where schid=" + schId);
////string claimNo = this.ddlProject.SelectedItem.Text.Trim();
SmartFlowLite.APInvoice inv = null;
// Task variables
int nextActionID = 22854; //task no this goes to
int assignedAccountId = 0; //branch id
int assignedUserId = 0; //user id
if ((this.SubProcessId == 1) || (this.SubProcessId == 2))
{
assignedUserId = WorkFlow.BLL.Invoice.APInvoice.GetPMforClaims(this.WfId, this.SubProcessId);
assignedAccountId = Claim.GetBranchID(this.WfId, SubProcessId);
}
Doxess.Web.WorkFlow.Process.Process dxProcess = new Doxess.Web.WorkFlow.Process.Process();
dba.dxAddParameter("@POId", POId);
int VendorId = dba.dxGetIntData("Select VendorId from PurchaseOrders where POId = @POId");
int CostCodeId = dba.dxGetIntData("Select defcostcode from vendors where vendorid =" + VendorId);
// Add new invoice record
inv = new SmartFlowLite.APInvoice();
inv.InvoiceDate = DateTime.Parse(this.txtInvoiceDate.Text);
inv.Amount = Math.Round(Convert.ToDecimal(this.txtAmount.Text), 2);
inv.GSTAmount = Math.Round(Convert.ToDecimal(this.txtHST.Text), 2);
//inv.setProvincialTaxField(ref inv, SelectedVendor, SelectedBranch, Math.Round(Convert.ToDecimal(this.txtPSTAmt.Text), 2));
inv.TotalAmount = Math.Round((inv.Amount + inv.GSTAmount + inv.PSTAmount + inv.QSTAmount), 2);
inv.ClaimId = claimId;
inv.InvoiceNo = this.txtInvoiceNumber.Text.Trim();
inv.PONo = POId;
inv.VendorId = VendorId;
inv.VendorName = WorkFlow.Objects.BLL.Vendors.GetVendorName(VendorId);
inv.SubProcess = this.SubProcessId;
inv.FileId = this.FileId;
inv.CostCodeId = CostCodeId;
inv.History = false;
inv.BatchId = WorkFlow.BLL.Invoice.APInvoice.GetBatchId();
inv.AdminOrClaims = 1;
inv.ProcessId = 22;
int invoiceId = inv.AddNewWithProcessId(ref message, command, userID);
InvoiceId = invoiceId;
if (!message.Equals(string.Empty))
{
//delete the uplaoded file
WorkFlow.BLL.Claim.UploadDoc doc = new UploadDoc(this.FileId);
doc.DeleteFile(ref message);
//delete attached PO
WorkFlow.BLL.JobCost.PoData.DeletePO(POId);
//this.lblMessage.Text = message;
trans.Rollback();
return(message);
}
string TaskDesc = "Approve Vendor Cost - " + inv.VendorName + " No. " + inv.InvoiceNo;
int DetId = dxProcess.wfTaskCreate(ref message, command, this.WfId, nextActionID, -1, assignedAccountId, assignedUserId, TaskDesc, "", "", InvoiceId, this.FileId, this.SubProcessId);
if (!message.Equals(string.Empty) || DetId < 0)
{
WorkFlow.BLL.JobCost.PoData.DeletePO(POId);
WorkFlow.BLL.Invoice.APInvoice.DeleteIncomingInvoice(command, InvoiceId, this.WfId, this.SubProcessId);
WorkFlow.BLL.Claim.UploadDoc doc = new UploadDoc(this.FileId);
doc.DeleteFile(ref message);
//this.lblMessage.Text = message;
trans.Rollback();
return(message);
}
else
{
if (cat == "20")
{
this.userName = dba.dxGetTextData("select resname from schresources where resindexid=(select accountid from wfusers where userid=" + this.userID.ToString() + ") and rescatid=20");
}
else
{
this.userName = TimebookCom.WeeklyTimebook.GetUserNameById(userID);
}
Notes.AddNewNote(this.WfId, "A", 0, DateTime.Now.ToString(), userID, "Invoice " + InvoiceId + " created by " + userName, this.SubProcessId);
}
dba.dxAddParameter("@UserId", assignedUserId);
int assignedToRoleId = 0;// = 211;
DataTable dtRoles = dba.dxGetTable("Select RoleId from wfUsersRoles where UserId = @UserId order by RoleId");
if (dtRoles.Rows.Count > 0)
{
for (int count = 0; count < dtRoles.Rows.Count; count++)
{
if (Convert.ToInt32(dtRoles.Rows[count]["RoleId"].ToString()) == 210)
{
assignedToRoleId = 210;
break;
}
else if (Convert.ToInt32(dtRoles.Rows[count]["RoleId"].ToString()) == 211)
{
assignedToRoleId = 211;
break;
}
}
}
if (!message.Equals(string.Empty) || DetId < 0)
{
WorkFlow.BLL.JobCost.PoData.DeletePO(POId);
WorkFlow.BLL.Invoice.APInvoice.DeleteIncomingInvoice(command, InvoiceId, this.WfId, this.SubProcessId);
WorkFlow.BLL.Claim.UploadDoc doc = new UploadDoc(this.FileId);
doc.DeleteFile(ref message);
//this.lblMessage.Text = message;
trans.Rollback();
return(message);
}
else
{
message = dba.dxUpdate(command, "wfDet", "AssignedToRoleId", "DetId", assignedToRoleId, DetId);
message = dba.dxUpdate(command, "wfDetR2G", "AssignedToRoleId", "DetId", assignedToRoleId, DetId);
dba.dxUpdate(command, "PurchaseOrders", "POStatusId", "POId", 2, inv.PONo); //update purchase order status
}
trans.Commit();
SetExpiryDate(DetId);
return("");
}
}
catch (Exception ex)
{
string message = ex.Message;
WorkFlow.BLL.Claim.UploadDoc doc = new UploadDoc(this.FileId);
doc.DeleteFile(ref message);
return(message);
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
try
{
lbl_Massage.Visible = true;
//System.Threading.Thread.Sleep(15000);
if (drpDownType.Text == "--Select--" || drpDownType.SelectedValue.ToString() == "--Select--" || drpDownType.Text == "" || drpDownType.Text == "--Seleccionar--" || drpDownType.SelectedValue.ToString() == "--Seleccionar--")
{
btnSave.Enabled = true;
string alertmsg;
if (CultureInfo.CurrentCulture.Name == "es-ES")
{
alertmsg = "alert('Por favor seleccione tipo');";
}
else
{
alertmsg = "alert('Please Select Type');";
}
ScriptManager.RegisterStartupScript(this, this.GetType(), "alertscript", alertmsg, true);
return;
}
if (drpDownApplication.Text == "Select" || drpDownApplication.SelectedValue.ToString() == "Select" || drpDownApplication.Text == "" || drpDownApplication.Text == "--Seleccionar--" || drpDownApplication.SelectedValue.ToString() == "--Seleccionar--")
{
btnSave.Enabled = true;
string alertmsg;
if (CultureInfo.CurrentCulture.Name == "es-ES")
{
alertmsg = "alert('Por favor seleccione la aplicación');";
}
else
{
alertmsg = "alert('Please Select Application');";
}
ScriptManager.RegisterStartupScript(this, this.GetType(), "alertscript", alertmsg, true);
return;
}
if (DrpPriority.Text == "--Select Priority--" || DrpPriority.Text == "Select" || DrpPriority.Text == "" || DrpPriority.Text == "Seleccionar" || DrpPriority.Text == "--Seleccionar prioridad--")
{
btnSave.Enabled = true;
string alertmsg;
if (CultureInfo.CurrentCulture.Name == "es-ES")
{
alertmsg = "alert('Seleccione Prioridad');";
}
else
{
alertmsg = "alert('Please Select Priority');";
}
ScriptManager.RegisterStartupScript(this, this.GetType(), "alertscript", alertmsg, true);
return;
}
if (fnCheckEmail(drpDownType.SelectedValue) == false)
{
string alertmsg;
if (CultureInfo.CurrentCulture.Name == "es-ES")
{
alertmsg = "alert('Por favor contacte al administrador');";
}
else
{
alertmsg = "alert('Please contact Administrator');";
}
ScriptManager.RegisterStartupScript(this, this.GetType(), "alertscript", alertmsg, true);
return;
}
string Ticket_Id = Fn_Get_Ticket_NO();
string query = "insert into tbl_Ticket_Master(Ticket_Id,Type_Id,Application_Id,Issue_Id,Issue_Details,Priority,Created_By,Created_Time,Status) values('" + Ticket_Id + "', " + drpDownType.SelectedValue + "," + drpDownApplication.SelectedValue + "," + DrpIssueType.SelectedValue + ",'" + IssueDetail.Text.Replace("'", "''").ToString() + "','" + DrpPriority.SelectedItem + "','" + UserId + "','" + DateTime.Now.ToString() + "','0')";
int executeStatus = DBUtils.ExecuteSQLCommand(new SqlCommand(query));
if (executeStatus != -1)
{
typeName = DBNulls.StringValue(drpDownType.SelectedItem.Text);
applicationName = DBNulls.StringValue(drpDownApplication.SelectedItem.Text);
issueName = DBNulls.StringValue(DrpIssueType.Text);
issueDetails = DBNulls.StringValue(IssueDetail.Text);
priority = DBNulls.StringValue(DrpPriority.Text);
createdBy = UserId;
createdAt = PublicMethods.fnGetDateTimeNow();
typeId = DBNulls.StringValue(drpDownType.SelectedValue);
applictionsId = DBNulls.StringValue(drpDownApplication.SelectedValue);
if (UploadDoc.HasFile)
{
try
{
string filename = Path.GetFileName(UploadDoc.FileName);
string folderPath = Server.MapPath("Files/" + Ticket_Id.ToString() + "/");
if (!Directory.Exists(folderPath))
{
Directory.CreateDirectory(folderPath);
}
UploadDoc.SaveAs(Server.MapPath("Files/" + Ticket_Id.ToString() + "/") + filename);
string queryFile = "Insert into tbl_Attachment_Master(Ticket_Id,File_Path,File_Name) values(" + Ticket_Id + ",'" + folderPath + "','" + filename + "')";
DBUtils.ExecuteSQLCommand(new SqlCommand(queryFile));
fileName = "files/" + Ticket_Id + "/" + filename;
//ClientScript.RegisterStartupScript(this.GetType(), "alert", "alert('Ticket creation is successfull')", true);
string alertmsg;
if (CultureInfo.CurrentCulture.Name == "es-ES")
{
alertmsg = "alert(''La creación de entradas es exitosa');";
}
else
{
alertmsg = "alert(''Ticket creation is successful');";
}
ScriptManager.RegisterStartupScript(this, this.GetType(), "alertscript", alertmsg, true);
}
catch (Exception ex)
{
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alertMessage", "alert(" + ex.Message + ")", true);
}
}
//Send Email
fnSendMailXML(Ticket_Id);
btnSave.Enabled = false;
string alertmsg1;
if (CultureInfo.CurrentCulture.Name == "es-ES")
{
alertmsg1 = "alert('Ticket creado con éxito');";
}
else
{
alertmsg1 = "alert('Ticket created successfully');";
}
ScriptManager.RegisterStartupScript(this, this.GetType(), "alertscript", alertmsg1, true);
Response.Redirect("UserDash.aspx", true);
}
else
{
string alertmsg;
if (CultureInfo.CurrentCulture.Name == "es-ES")
{
alertmsg = "alert(''Error de inserción');";
}
else
{
alertmsg = "alert(''Insertion Error');";
}
ScriptManager.RegisterStartupScript(this, this.GetType(), "alertscript", alertmsg, true);
btnSave.Enabled = true;
return;
}
}
catch (Exception ex)
{
Response.Redirect("UserDash.aspx", true);
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alertMessage", "alert(" + ex.Message + ")", true);
}
}
public ActionResult AddProject(ProjectReg preg)
{
var insertProject = new ProjectReg();
List <string> arr = new List <string>();
string tid = null;
int CompID = 0;
var additionalFile = false;
try
{
insertProject.ProjectName = preg.ProjectName;
insertProject.Priority = preg.Priority;
insertProject.ProjectManager = preg.ProjectManager;
insertProject.DeptResponsible = preg.DeptResponsible;
insertProject.LeadDeveloper = preg.LeadDeveloper;
var otherDev = preg.multiSelectLob.Split(','); //string.Join(",", preg.multiSelectLob.ToArray()).Split(',');
foreach (var o in otherDev.ToList())
{
var od = unitOfWork.Repository <Team>().Get(f => f.Fullname == o);
if (od.Count() > 0) //.FirstOrDefault().TeamID;
{
tid = od.FirstOrDefault().TeamID.ToString();
arr.Add(tid);
od = null;
}
}
CompID = int.Parse(preg.CompanyID);
var com = unitOfWork.Repository <Company>().GetByID(CompID);
insertProject.OtherDeveloper = string.Join(",", arr.ToArray());
insertProject.NumberOfUsers = preg.NumberOfUsers;
insertProject.oDeveloper = preg.oDeveloper;
insertProject.oProjectManager = preg.oProjectManager;
insertProject.CompanyID = preg.CompanyID;
insertProject.CompanyName = com.CompanyName;
insertProject.BusinessNeed = preg.BusinessNeed;
insertProject.BizContact = com.ContactPerson;
insertProject.DateRecieved = DateTime.Now;
// insertProject.RegisteredBy
insertProject.ProjectRemark = preg.ProjectRemark;
insertProject.ProjectStatus = preg.ProjectStatus;
insertProject.ProjectTaskType = preg.ProjectTaskType;
insertProject.ProjectObjective = preg.ProjectObjective;
insertProject.ProjectStatus = TManager.Models.Consts.ApprovalConsts.PENDING;
bool hasv = unitOfWork.Repository <ProjectReg>().Get().Any(a => a.ProjectName == insertProject.ProjectName);
if (hasv == false)
{
unitOfWork.Repository <ProjectReg>().Insert(insertProject);
unitOfWork.Save();
var docs = unitOfWork.Repository <TempDoc>().Get().Where(d => d.Description == insertProject.ProjectName && d.FileStatus == 1);
UploadDoc doc = new UploadDoc();
if (docs != null && docs.ToList().Count != 0)
{
foreach (var f in docs)
{
doc.FileName = f.FileName;
doc.FileSystemName = f.FileSystemName;
doc.Description = f.Description;
doc.ProjectID = insertProject.ProjectRegisterID;
doc.ContentType = f.ContentType;
unitOfWork.Repository <UploadDoc>().Insert(doc);
unitOfWork.Save();
}
// we have to set the file status to 2 to differentiate the ones taken from tempDoc to vendorDoc tables
foreach (var t in docs)
{
TempDoc td = unitOfWork.Repository <TempDoc>().GetByID(t.TempID);
td.FileStatus = 2;
td.ProjectID = insertProject.ProjectRegisterID;
unitOfWork.Repository <TempDoc>().Update(td);
}
unitOfWork.Save();
}
}
return(RedirectToAction("Projects"));
}
catch (DbEntityValidationException e)
{
ViewBag.Error = e.StackTrace;
foreach (var eve in e.EntityValidationErrors)
{
ViewBag.Error += eve.Entry.Entity.GetType().Name + ", " + eve.Entry.State;
Console.WriteLine("Entity of type \"{0}\" in state \"{1}\" has the following validation errors:",
eve.Entry.Entity.GetType().Name, eve.Entry.State);
foreach (var ve in eve.ValidationErrors)
{
ViewBag.Error += ve.PropertyName + " :: " + ve.ErrorMessage;
Console.WriteLine("- Property: \"{0}\", Error: \"{1}\"",
ve.PropertyName, ve.ErrorMessage);
}
}
}
// set notification for approval
// string TargetMsg = PCMS_v1.Models.Consts.Message.RequesterLp1VendorMsg(insertVendor.VendorName, newaction.ActionID, BasePath());
// string subject = "#" + insertVendor.VendorID + " / " + insertVendor.VendorType + "/" + insertVendor.VendorName + " Registration Approval";
// var lp1Data = unitOfWork.Repository<ConsolStaffData>().Get(e => e.POSITION_NBR == RequesterData.ReportsTo).FirstOrDefault();
// // initiator's message
// string initiatorMsg = PCMS_v1.Models.Consts.Message.initiatorMsg(insertVendor);
// //insertVendor.RequesterLp1Data.FullName = lp1Data.FULL_NAME;
// insertVendor.RequesterData = DataHelper.GetRequesterInfo(unitOfWork, insertVendor.VendorRequester);
// insertVendor.RequesterData.FullName = RequesterData.LastName + " " + RequesterData.OtherNames;
// insertVendor.RequesterData.EmailAddress = RequesterData.EmailAddress;
// string TargetMail = lp1Data.EMAIL_ADDR;
// // we can fire mail to both requester and initiator
// SendEmail(TargetMsg, TargetMail, subject, newaction.ActionID, newaction, PCMS_v1.Models.Consts.ProcessAndFlowName.VENDOR_PROCESS);
// SendEmail(initiatorMsg, RequesterData.EmailAddress, subject, newaction.ActionID, newaction, PCMS_v1.Models.Consts.ProcessAndFlowName.VENDOR_PROCESS);
// // NotifyNextActor(insertVendor, insertVendor.RequesterLp1, insertVendor.RequesterLp1, PCMS_v1.Models.Consts.ActorRole.REQUESTER_LP1, "ReviewVendor", PCMS_v1.Models.Consts.ActorRole.VENDOR_PROCESS, sequenceNumber, insertVendor.VendorID, targetMsg, initiatorMsg, insertVendor.RequesterLp1Data.EmailAddress, insertVendor.RequesterData.EmailAddress);
//TempData["CssClass"] = "success";
//TempData["Notify"] = "Vendor" + insertVendor.VendorName + " created successfully !";
var company = unitOfWork.Repository <Company>().Get().OrderBy(o => o.CompanyName);
var LeadDev = unitOfWork.Repository <Team>().Get();
var projectMgr = unitOfWork.Repository <Team>().Get(e => e.Role == TManager.Models.Consts.ActorRole.PROJECT_MANAGER);
ViewBag.LeadDeveloper = new SelectList(LeadDev, "TeamID", "Fullname");
ViewBag.ProjectManager = new SelectList(projectMgr, "TeamID", "Fullname");
ViewBag.CompanyID = new SelectList(company, "CompanyID", "CompanyName");
return(View());
}
public async Task <IActionResult> AddUpload(UploadViewModel model)
{
if (ModelState.IsValid)
{
string unique = Guid.NewGuid().ToString();
string UniqueTransId = "Upload-" + unique;
var upload = new UploadDoc
{
Name = model.Name,
Email = model.Email,
TransNumber = UniqueTransId
};
_upload.AddUploadDoc(upload);
string webrootPath = _hostEnvironment.WebRootPath;
var files = model.FormFiles;
var uploads = Path.Combine(webrootPath, "images");
for (int i = 0; i < files.Count; i++)
{
string fileName = files[i].FileName;
//var extension = Path.GetExtension(files[i].FileName);
using (var fileStreams = new FileStream(Path.Combine(uploads, fileName), FileMode.Create))
{
files[i].CopyTo(fileStreams);
}
var uploadFile = new UploadImage
{
UploadId = upload.Id,
ImagePath = @"\images\" + fileName
};
_upload.AddUploadFile(uploadFile);
}
#region Mail
MailMessage msg = new MailMessage // instance Mail sender service
{
From = new MailAddress("#########################################"), // Server Email Address
};
msg.To.Add(model.Email); // receiver Email
msg.Subject = "SDSD Developer Test";
msg.Body = "Hello " + model.Name + ", these are your attachments"; // Message Body
foreach (var filepath in files)
{
string fileName = Path.GetFileName(filepath.FileName);
msg.Attachments.Add(new Attachment(filepath.OpenReadStream(), fileName));
}
SmtpClient client = new SmtpClient
{
Host = "smtp.gmail.com"
};
NetworkCredential credential = new NetworkCredential
{ // Server Email credentisal
UserName = "******",
Password = "******"
};
client.Credentials = credential;
client.EnableSsl = true;
client.Port = 587;
client.Send(msg);
ViewBag.Success = $"Email has been sent successfully to {model.Email}";
_logger.LogInformation("User created ");
#endregion
if (await _upload.SaveChangesAsync())
{
return(RedirectToAction(nameof(Index)));
}
return(View(model));
}
return(View(model));
}
