public bool UpdateDocumentMaster(QPMasterPool doc)
{
bool status = false;
try
{
var oldDoc = (from d in Context.QPMasterPools where d.QPDocId == doc.QPDocId select d).FirstOrDefault <QPMasterPool>();
oldDoc.Document = doc.Document;
oldDoc.Comments = doc.Comments;
oldDoc.DocumentName = doc.DocumentName;
oldDoc.UpdationLog = doc.UpdationLog;
oldDoc.Status = doc.Status;
Context.SaveChanges();
bool status2 = this.UpdateDocumentVersion(doc);
if (status2)
{
status = true;
}
else
{
status = false;
}
}
catch (Exception e)
{
status = false;
}
return(status);
}
//public byte[] DownloadDocument(string QPDocId)
//{
// byte[] doc = null;
// try
// {
// doc = (from d in Context.QPMasterPools where d.QPDocId == QPDocId select d.Document).FirstOrDefault();
// }
// catch (Exception)
// {
// doc = null;
// }
// return doc;
//}
public QPMasterPool DocumentDetails(string qpDocId)
{
QPMasterPool doc = null;
try
{
doc = (from d in Context.QPMasterPools where d.QPDocId == qpDocId select d).FirstOrDefault();
}
catch (Exception)
{
doc = null;
}
return(doc);
}
public bool AddDocument(QPMasterPool qpObj)
{
bool status = false;
try
{
Context.QPMasterPools.Add(qpObj);
Context.SaveChanges();
status = true;
}
catch (Exception e)
{
status = false;
}
return(status);
}
public bool QPAnchorSelectDoc(string qpDocId)
{
QPMasterPool doc = new QPMasterPool();
bool status;
try
{
doc = (from d in Context.QPMasterPools where d.QPDocId == qpDocId select d).FirstOrDefault();
Context.QPMasterPools.Remove(doc);
Context.SaveChanges();
status = true;
}
catch (Exception)
{
status = false;
}
return(status);
}
public bool QualityAnchorAccept(QPMasterPool qpObj)
{
bool status = false;
QPMasterPool doc = new QPMasterPool();
try
{
doc = (from d in Context.QPMasterPools where d.QPDocId == qpObj.QPDocId select d).FirstOrDefault();
doc.Status = qpObj.Status;
doc.UpdationLog = qpObj.UpdationLog;
Context.SaveChanges();
status = true;
}
catch (Exception)
{
status = false;
}
return(status);
}
public bool UpdateDocumentVersion(QPMasterPool doc)
{
QPVersion version = new QPVersion();
string versionId;
bool status = false;
try
{
var oldDoc = (from d in Context.QPMasterPools where d.QPDocId == doc.QPDocId select d).FirstOrDefault <QPMasterPool>();
var ver = (from v in Context.QPVersions where v.DocId == oldDoc.QPDocId select v.VersionId).ToList();
version.Comments = oldDoc.Comments;
version.CreationLog = oldDoc.CreationLog;
version.DocId = oldDoc.QPDocId;
version.Document = oldDoc.Document;
version.DocumentName = oldDoc.DocumentName;
version.UpdationLog = oldDoc.UpdationLog;
//-------------------------------------
if (ver.Count == 0)
{
versionId = Regex.Match(oldDoc.QPDocId, @"\d+").Value;
versionId += ".1";
version.VersionId = versionId;
}
else
{
int length = 0;
foreach (var item in ver)
{
if (item.Length > length)
{
length = item.Length;
}
else
{
continue;
}
}
ver.RemoveAll(x => x.Length < length);
string vers = ver.Max();
string[] parts = vers.Split('.');
int i1 = int.Parse(parts[0]);
int i2 = int.Parse(parts[1]);
i2 += 1;
vers = i1.ToString() + "." + i2.ToString();
versionId = vers;
version.VersionId = versionId;
}
//----------------------------------------
Context.QPVersions.Add(version);
Context.SaveChanges();
status = true;
}
catch (System.Data.Entity.Validation.DbEntityValidationException dbEx)
{
Exception raise = dbEx;
foreach (var validationErrors in dbEx.EntityValidationErrors)
{
foreach (var validationError in validationErrors.ValidationErrors)
{
string message = string.Format("{0}:{1}",
validationErrors.Entry.Entity.ToString(),
validationError.ErrorMessage);
// raise a new exception nesting
// the current instance as InnerException
raise = new InvalidOperationException(message, raise);
}
}
throw raise;
}
return(status);
}
