public ActionResult SaveFileProcessAction()
{
//foreach (HttpPostedFileBase f in Request.Files)
//{
//}
HttpFileCollectionBase PhotoFile = Request.Files;
var fMain = Request.Form["fMain"];
var obj1 = JObject.Parse(fMain);
var fileBelongstoUser = _fileMainService.All().Where(x => x.FileNo == (string)obj1["fMain"]["FileID"]).Select(x => x.UserID).FirstOrDefault();
try
{
using (var transaction = new TransactionScope())
{
var fileNoCheck = _fileMainService.All().Where(x => x.FileNo == (string)obj1["fMain"]["FileID"]).FirstOrDefault();
//FileMain FileMainInfo = new FileMain();
if (fileNoCheck != null)
{
var VersionNo = EncryptionDecryption.DH_PEncode(_actionListService.All().Where(x => x.ActID == (int)obj1["fMain"]["Action"]).Select(x => x.ActDesc).LastOrDefault());
var UpdUserID = (int)obj1["fMain"]["MarkTo"];
if (UpdUserID == 0)
{
fileNoCheck.UpdUserID = EncryptionDecryption.DH_PEncodeInt(fileBelongstoUser); //Convert.ToInt32(Session["UserID"]);
}
else
{
fileNoCheck.UpdUserID = EncryptionDecryption.DH_PEncodeInt((int)obj1["fMain"]["MarkTo"]);
}
fileNoCheck.VersionNo = EncryptionDecryption.DH_PEncode(VersionNo);
_fileMainService.Update(fileNoCheck);
_fileMainService.Save();
}
var user = Convert.ToInt32(Session["UserID"]);
FileTransMain FileTransMainInfo = new FileTransMain();
FileTransMainInfo.MainID = EncryptionDecryption.DH_PEncodeInt(_fileMainService.All().Where(x => x.FileNo == (string)obj1["fMain"]["FileID"]).Select(x => x.MainID).FirstOrDefault());
FileTransMainInfo.ActionNum = EncryptionDecryption.DH_PEncode(_actionListService.All().Where(x => x.ActID == (int)obj1["fMain"]["Action"]).Select(x => x.ActDesc).LastOrDefault());
//FileTransMainInfo.EntryDate = (DateTime)obj1["fMain"]["Date"];
FileTransMainInfo.MarkToID = EncryptionDecryption.DH_PEncodeInt((int)obj1["fMain"]["MarkTo"]);
//FileTransMainInfo.MarkToID = _newStaffService.All().Where(x => x.StaffId ==user).Select(x => x.ReportingId).FirstOrDefault();
if (FileTransMainInfo.MarkToID == 0)
{
FileTransMainInfo.MarkToID = fileBelongstoUser;
}
FileTransMainInfo.EntryDate = DateTime.Now;
FileTransMainInfo.ActionID = EncryptionDecryption.DH_PEncodeInt((int)obj1["fMain"]["Action"]);
FileTransMainInfo.AttachNum = EncryptionDecryption.DH_PEncode(Convert.ToString(PhotoFile.Count));
// var action = _fileTransMainService.All().Where(x => x.MainID ==(int)obj1["fMain"]["FileID"]).Select(x => x.ActionNum).LastOrDefault();
var FileTransNum = Convert.ToInt16(_fileTransMainService.All().Where(x => x.MainID == FileTransMainInfo.MainID).Select(x => x.FileTransNum).LastOrDefault());
FileTransMainInfo.FileTransNum = EncryptionDecryption.DH_PEncode((FileTransNum + 1).ToString());
// FileTransMainInfo.FileTransID = 1;
FileTransMainInfo.ActionByID = EncryptionDecryption.DH_PEncodeInt(Convert.ToInt32(Session["UserID"].ToString()));
FileTransMainInfo.SignDate = DateTime.Now;
FileTransMainInfo.TransDate = DateTime.Now;
FileTransMainInfo.Note = EncryptionDecryption.DH_PEncode((string)obj1["fMain"]["Note"]);
_fileTransMainService.Add(FileTransMainInfo);
_fileTransMainService.Save();
transaction.Complete();
}
}
catch (Exception ex)
{
return(Json("0", JsonRequestBehavior.AllowGet));
}
var MainIdCheck = _fileMainService.All().Where(x => x.FileNo == (string)obj1["fMain"]["FileID"]).Select(x => x.MainID).LastOrDefault();
string fileName = "";
string NewPhotoID = "";
//string ImgPrefix = "";
string ext = "";
string PhotoPath = "";
string PhysicalPhPath = "";
string DBPhotoPath = "";
try
{
if (PhotoFile != null)
{
for (int i = 0; i < PhotoFile.Count; i++)
{
string fileId = Guid.NewGuid().ToString().Replace("-", "");
HttpPostedFileBase file = PhotoFile[i];
fileName = Path.GetFileName(file.FileName);
//ImgPrefix = file.ContentType; //"Photo";//file.ContentType;//
int fSize = file.ContentLength;
//var path = Path.Combine(Server.MapPath("~/Uploads/Photo/"), MemberCode, fileId);
ext = System.IO.Path.GetExtension(fileName);
if (ext.ToLower().Contains("txt") || ext.ToLower().Contains("gif") || ext.ToLower().Contains("jpg") || ext.ToLower().Contains("jpeg") ||
ext.ToLower().Contains("png") || ext.ToLower().Contains(".xls") || ext.ToLower().Contains(".docx") ||
ext.ToLower().Contains(".xlsx") || ext.ToLower().Contains(".pdf"))
{
NewPhotoID = fileId + ext;
PhotoPath = ConfigurationManager.AppSettings["PhotoPath"];
PhysicalPhPath = Path.Combine(Server.MapPath(PhotoPath), NewPhotoID);
//var path = Path.Combine(Server.MapPath("~/Images/Photo"), fileName);
file.SaveAs(PhysicalPhPath);
DBPhotoPath = PhotoPath + "\\" + NewPhotoID;
}
var FileTransMain = new FileTransDetail
{
AttachFileName = fileName,
FileType = ext,
Size = fSize,
FileSourcePath = PhysicalPhPath,
FileTransID = _fileTransMainService.All().Where(x => x.MainID == MainIdCheck).Select(x => x.FileTransID).LastOrDefault(),
};
_fileTransDetailService.Add(FileTransMain);
_fileTransDetailService.Save();
}
}
return(Json("1", JsonRequestBehavior.AllowGet));
}
catch (Exception)
{
return(Json("0", JsonRequestBehavior.AllowGet));
}
}
public ActionResult ClosetoArchive(string FileNo)
{
//RBACUser rUser = new RBACUser(Session["UserName"].ToString());
//if (!rUser.HasPermission("NewFile_Delete"))
//{
// return Json("D", JsonRequestBehavior.AllowGet);
//}
using (var transaction = new TransactionScope())
{
try
{
var FileMainNo = _fileMainService.All().Where(x => x.FileNo == FileNo).FirstOrDefault();
if (FileMainNo != null)
{
//For filemain and afilemain by Anna
var aFileMain = new AFileMain();
aFileMain.FileNo = FileMainNo.FileNo;
aFileMain.FileRef = FileMainNo.FileRef;
aFileMain.FileSub = FileMainNo.FileSub;
aFileMain.FileText = FileMainNo.FileText;
aFileMain.LastUpdDate = FileMainNo.LastUpdDate;
aFileMain.UpdUserID = Convert.ToInt32(FileMainNo.UpdUserID);
aFileMain.UserID = FileMainNo.UserID;
aFileMain.VersionNo = FileMainNo.VersionNo;
aFileMain.CreateDate = FileMainNo.CreateDate;
aFileMain.AttachNum = FileMainNo.AttachNum;
_afileMainService.Add(aFileMain);
_afileMainService.Save();
_fileMainService.Delete(FileMainNo);
_fileMainService.Save();
}
//var FileDetailNo = _fileDetailService.All().Where(x => x.MainID == FileNo).FirstOrDefault();
//if (FileDetailNo != null)
//{
// var aFileDetail = new AFileDetail();
// aFileDetail.AttachFileName = FileDetailNo.AttachFileName;
// aFileDetail.FileNo = FileDetailNo.MainID;
// aFileDetail.FileSourcePath = FileDetailNo.FileSourcePath;
// aFileDetail.FileType = FileDetailNo.FileType;
// aFileDetail.Size = FileDetailNo.Size;
// _afileDetailService.Add(aFileDetail);
// _afileDetailService.Save();
// _fileDetailService.Delete(FileDetailNo);
// _fileDetailService.Save();
// transaction.Complete();
//}
//else
//{
// return Json("2", JsonRequestBehavior.AllowGet);
//}
return(Json("1", JsonRequestBehavior.AllowGet));
}
catch (Exception)
{
return(Json("0", JsonRequestBehavior.AllowGet));
}
}
}
public ActionResult SaveNewFile()
{
HttpFileCollectionBase PhotoFile = Request.Files;
var fMain = Request.Form["fMain"];
var obj1 = JObject.Parse(fMain);
var FileNo = (string)obj1["fMain"]["FileID"];
try
{
var fileNoCheck = _fileMainService.All().Where(x => x.FileNo.ToString() == FileNo).Select(x => x.FileNo).FirstOrDefault();
if (fileNoCheck == null)
{
FileMain FileMainInfo = new FileMain();
FileMainInfo.FileNo = (string)obj1["fMain"]["FileID"];
FileMainInfo.FileSub = (string)obj1["fMain"]["FileSub"];
FileMainInfo.FileRef = (string)obj1["fMain"]["FileRef"];
FileMainInfo.FileText = (string)obj1["fMain"]["FileText"];
FileMainInfo.AttachNum = Convert.ToByte(PhotoFile.Count);
//FileMainInfo.FileID = 1;
FileMainInfo.UserID = Convert.ToInt32(Session["UserID"].ToString());
//FileMainInfo.VersionNo = _actionListService.All().Select(x=>x.ActDesc).FirstOrDefault();
FileMainInfo.VersionNo = "New";
FileMainInfo.UpdUserID = Convert.ToInt32(Session["UserID"].ToString());
FileMainInfo.CreateDate = DateTime.Now;
FileMainInfo.LastUpdDate = DateTime.Now;
_fileMainService.Add(FileMainInfo);
_fileMainService.Save();
}
}
catch (Exception ex)
{
return(Json("0", JsonRequestBehavior.AllowGet));
}
//else
//{
// return Json("2", JsonRequestBehavior.AllowGet);
//}
string fileName = "";
string NewPhotoID = "";
string ImgPrefix = "";
string ext = "";
string PhotoPath = "";
string PhysicalPhPath = "";
string DBPhotoPath = "";
try
{
if (PhotoFile != null)
{
for (int i = 0; i < PhotoFile.Count; i++)
{
string fileId = Guid.NewGuid().ToString().Replace("-", "");
HttpPostedFileBase file = PhotoFile[i];
fileName = Path.GetFileName(file.FileName);
ext = System.IO.Path.GetExtension(fileName);
ImgPrefix = FileNo; //"Photo";//file.ContentType;//
int fSize = file.ContentLength;
//var path = Path.Combine(Server.MapPath("~/Uploads/Photo/"), MemberCode, fileId);
if (ext.ToLower().Contains("txt") || ext.ToLower().Contains("gif") || ext.ToLower().Contains("jpg") || ext.ToLower().Contains("jpeg") ||
ext.ToLower().Contains("png") || ext.ToLower().Contains(".xls") || ext.ToLower().Contains(".docx") ||
ext.ToLower().Contains(".xlsx") || ext.ToLower().Contains(".pdf"))
{
NewPhotoID = ImgPrefix + fileId + ext;
PhotoPath = ConfigurationManager.AppSettings["PhotoPath"];
PhysicalPhPath = Path.Combine(Server.MapPath(PhotoPath), NewPhotoID);
//var path = Path.Combine(Server.MapPath("~/Images/Photo"), fileName);
file.SaveAs(PhysicalPhPath);
DBPhotoPath = PhotoPath + "\\" + NewPhotoID;
}
var NewFile = new FileDetail
{
AttachFileName = fileName,
FileType = ext,
Size = fSize,
FileSourcePath = PhysicalPhPath,
//MainID = (int)obj1["fMain"]["MainID"],
MainID = _fileMainService.All().Where(x => x.FileNo == (string)obj1["fMain"]["FileID"]).Select(x => x.MainID).FirstOrDefault(),
};
_fileDetailService.Add(NewFile);
_fileDetailService.Save();
}
}
return(Json("1", JsonRequestBehavior.AllowGet));
}
catch (Exception)
{
return(Json("0", JsonRequestBehavior.AllowGet));
}
}