protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
if (userAction != (int)Enums.UserAction.Add)
{
model = issueDocumentRepo.GetIssueDocumentByID(issueDocumentID);
if (model != null)
{
GetIssueDocumentProvider().SetIssueDocumentModel(model);
FillForm();
}
}
FillDefaultValues();
UserActionConfirmBtnUpdate(btnSaveChanges, userAction);
}
else
{
if (model == null && SessionHasValue(Enums.IssueDocumentSession.IssueDocumentModel))
{
model = GetIssueDocumentProvider().GetIssueDocumentModel();
}
}
}
protected void gvDocuments_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
//Populate dto from session
GetSessionValues();
if (IssueBF.IssueDto.Documents[e.RowIndex].IsOld)
{
//Mark for deletion from database
IssueBF.IssueDto.Documents[e.RowIndex].IsDeleted = true;
}
else
{
//Get the document
IssueDocument issueDoc = IssueBF.IssueDto.Documents[e.RowIndex];
try
{
File.Delete(issueDoc.FullFileName);
}
catch (IOException ioEx)
{
DisplayPopup("An error occured deleting the document.");
}
//Remove from documents list
IssueBF.IssueDto.Documents.RemoveAt(e.RowIndex);
}
//Update session
SetSessionValues();
//Reload the grid
LoadDocGrid();
}
public int SaveIssueDocument(IssueDocument model, int userID = 0)
{
try
{
model.tsUpdate = DateTime.Now;
model.tsUpdateUserID = userID;
if (model.IssueDocumentID == 0)
{
model.IssueNumber = GetNextIssueDocumentNumber();
model.tsInsert = DateTime.Now;
model.tsInsertUserID = userID;
}
model.Save();
return(model.IssueDocumentID);
}
catch (Exception ex)
{
string error = "";
CommonMethods.getError(ex, ref error);
throw new Exception(CommonMethods.ConcatenateErrorIN_DB(DB_Exception.res_38, error, CommonMethods.GetCurrentMethodName()));
}
}
public static Issue AdminGetIssue(Int32 VolumeIssueId)
{
Issue issue = new Issue();
try
{
DataSet issueSet = IssueQueryHelper.AdminGetIssue(VolumeIssueId);
if (issueSet.Tables.Count == 2)
{
//Get the issue details
if (issueSet.Tables[0].Rows.Count > 0)
{
DataRow issRow = issueSet.Tables[0].Rows[0];
issue.IssueId = (Int32)issRow["IssueId"];
issue.IssueName = (string)issRow["IssueName"];
issue.IsActive = (bool)issRow["Active"];
}
//Get the documents
if (issueSet.Tables[1].Rows.Count > 0)
{
IssueDocument issDoc;
issue.Documents = new List <IssueDocument>();
foreach (DataRow docRow in issueSet.Tables[1].Rows)
{
issDoc = new IssueDocument();
issDoc.DocId = (Int32)docRow["DocId"];
issDoc.FullFileName = (string)docRow["FileName"];
issDoc.IssueDocTypeDescription = (string)docRow["IssueDocTypeDescription"];
issDoc.IssueDocTypeId = (Int32)docRow["IssueDocTypeId"];
issDoc.IsActive = (bool)docRow["Active"];
issDoc.IsNew = false;
issue.Documents.Add(issDoc);
}
}
}
return(issue);
}
catch (SqlException sqlEx)
{
Console.WriteLine(sqlEx.ToString());
throw new DataException("An exception occured getting the issue details.", sqlEx);
}
}
public void InitCommand(Database db, Int32 volumeIssueId, IssueDocument issueDoc)
{
dbCommand = db.GetStoredProcCommand(sqlCommand);
db.AddInParameter(dbCommand, "VolumeIssueId", DbType.Int32, volumeIssueId);
db.AddInParameter(dbCommand, "IssueDocTypeId", DbType.Int32, issueDoc.IssueDocTypeId);
db.AddInParameter(dbCommand, "DocId", DbType.Int32, issueDoc.DocId);
}
public void InitCommand(Database db, Int32 volumeIssueId, IssueDocument issueDoc)
{
dbCommand = db.GetStoredProcCommand(sqlCommand);
db.AddInParameter(dbCommand, "VolumeIssueId", DbType.Int32, volumeIssueId);
db.AddInParameter(dbCommand, "IssueDocTypeId", DbType.Int32, issueDoc.IssueDocTypeId);
db.AddInParameter(dbCommand, "Data", DbType.Binary, issueDoc.Data);
db.AddInParameter(dbCommand, "FileName", DbType.String, issueDoc.FileName);
db.AddInParameter(dbCommand, "FileSizeKB", DbType.Int32, issueDoc.CalculateFileSizeInKB());
db.AddInParameter(dbCommand, "Comments", DbType.String, issueDoc.Comments);
db.AddInParameter(dbCommand, "Active", DbType.Int32, ConvBoolToInt32(issueDoc.IsActive));
db.AddInParameter(dbCommand, "CreationUserId", DbType.Int32, issueDoc.CreationUserId);
}
private IssueDocument GetDocValues()
{
IssueDocument issueDoc = new IssueDocument();
issueDoc.IssueDocTypeId = Convert.ToInt32(ddlIssueDocTypes.SelectedValue);
issueDoc.Comments = tbComments.Text.Trim();
issueDoc.CreationUserId = UserInfo.UserDto.UserId;
issueDoc.IsActive = Convert.ToBoolean(Convert.ToInt32(ddlDocStatus.SelectedValue));
return(issueDoc);
}
public bool DeleteIssueDocument(IssueDocument model)
{
try
{
model.Delete();
return(true);
}
catch (Exception ex)
{
string error = "";
CommonMethods.getError(ex, ref error);
throw new Exception(CommonMethods.ConcatenateErrorIN_DB(DB_Exception.res_39, error, CommonMethods.GetCurrentMethodName()));
}
}
public static IssueDto AsDto(this IssueDocument document)
=> new IssueDto
{
Id = document.Id,
Type = document.Type,
Status = document.Status,
Title = document.Title,
Description = document.Description,
StoryPoints = document.StoryPoints,
ProjectId = document.ProjectId,
EpicId = document.EpicId,
SprintId = document.SprintId,
Assignees = document.Assignees ?? Enumerable.Empty <Guid>(),
LinkedIssues = document.LinkedIssues ?? Enumerable.Empty <Guid>(),
CreatedAt = document.CreatedAt
};
private bool AddOrEditEntityObject(bool add = false, bool completeIssueDocument = false)
{
if (add)
{
model = new IssueDocument(session);
model.IssueDocumentID = 0;
model.IssueStatus = issueDocumentRepo.GetIssueDocumentStatusByCode(Enums.IssueDocumentStatus.DELOVNA, model.Session);
}
else if (!add && model == null)
{
model = GetIssueDocumentProvider().GetIssueDocumentModel();
}
model.IssueNumber = txtIssueDocumentNumber.Text;
model.Name = txtName.Text;
model.IssueDate = DateEditIssueDocumentDate.Date;
int buyerID = CommonMethods.ParseInt(GetGridLookupValue(GridLookupBuyer));
if (model.BuyerID != null)
{
model.BuyerID = clientRepo.GetClientByID(buyerID, model.BuyerID.Session);
}
else
{
model.BuyerID = clientRepo.GetClientByID(buyerID);
}
model.InternalDocument = txtInternalDocument.Text;
model.InvoiceNumber = txtInvoiceNumber.Text;
model.Notes = MemoNotes.Text;
model.PermissionDoc = txtPermissonDoc.Text;
if (completeIssueDocument)
{
model.IssueStatus = issueDocumentRepo.GetIssueDocumentStatusByCode(Enums.IssueDocumentStatus.ZAKLJUCENO, model.Session);
utilityRepo.ClearStockByIssueDocumentID(model.IssueDocumentPositions.ToList());
}
issueDocumentID = issueDocumentRepo.SaveIssueDocument(model, PrincipalHelper.GetUserID());
return(true);
}
protected void gvDocuments_RowDataBound(object sender, GridViewRowEventArgs e)
{
if (e.Row.RowType.Equals(DataControlRowType.DataRow))
{
if (IssueBF.IssueDto.Documents[e.Row.RowIndex].IsDeleted)
{
e.Row.Visible = false;
}
Label lblDocType = (Label)e.Row.FindControl("lblDocType");
IssueDocument issueDoc = (IssueDocument)e.Row.DataItem;
if (!(lblDocType == null || issueDoc == null))
{
ListItem liItem = ddlIssueDocTypes.Items.FindByValue(issueDoc.IssueDocTypeId.ToString());
if (liItem != null)
{
lblDocType.Text = liItem.Text;
}
}
}
}
protected void btnAddDoc_Click(object sender, EventArgs e)
{
if (Page.IsValid)
{
//Get session values
GetSessionValues();
try
{
if (tbUploadDocument.HasFile && tbUploadDocument.PostedFile != null)
{
string fileName = SaveDocToTemp(tbUploadDocument);
IssueDocument issueDoc = GetDocValues();
issueDoc.FullFileName = fileName;
IssueBF.IssueDto.Documents.Add(issueDoc);
SetSessionValues();
LoadDocGrid();
ResetDocumentFormValues();
}
else
{
DisplayPopup("The document cannot be empty. Please choose a document with content.");
}
}
catch (IOException ioEx)
{
throw;
}
}
}
public void SetIssueDocumentModel(IssueDocument model)
{
AddValueToSession(Enums.IssueDocumentSession.IssueDocumentModel, model);
}
public static Issue AsEntity(this IssueDocument document) => new Issue(document.Id, document.ProjectId, document.SprintId);
public static Issue AsEntity(this IssueDocument document) => new Issue(document.Id, document.Type, document.Status, document.Title, document.Description, document.StoryPoints, document.ProjectId, document.EpicId, document.SprintId, document.Assignees, document.LinkedIssues, document.CreatedAt);
public int CreateIssueDocumentFromMobileTransactions(List <int> mobileTransactionsID, int userID, int buyerID)
{
UnitOfWork uow = XpoHelper.GetNewUnitOfWork();
XPQuery <MobileTransaction> mobileTrans = uow.Query <MobileTransaction>();
XPQuery <InventoryDeliveries> invDeliveries = uow.Query <InventoryDeliveries>();
var mobileTransactions = mobileTrans.Where(mt => mobileTransactionsID.Any(mti => mti == mt.MobileTransactionID)).ToList();
if (mobileTransactions != null && mobileTransactions.Count > 0)
{
var buyer = clientRepo.GetClientByID(buyerID, session);
//from locationID we get buyer
IssueDocument document = new IssueDocument(session);
document.IssueDocumentID = 0;
document.IssueNumber = GetNextIssueDocumentNumber();
document.BuyerID = buyer;
document.IssueStatus = GetIssueDocumentStatusByCode(Enums.IssueDocumentStatus.DELOVNA);
document.IssueDate = DateTime.Now;
document.Name = $"Izdaja materiala za kupca: {buyer.Name}";
document.Notes = "Prenos iz mobilnih transkacij";
document.InternalDocument = "000000";
document.InvoiceNumber = DateTime.Now.Year.ToString() + "/000000";
document.tsInsert = DateTime.Now;
document.tsInsertUserID = userID;
document.tsUpdate = DateTime.Now;
document.tsUpdateUserID = userID;
document.Save();
var issueDocument = GetIssueDocumentByID(document.IssueDocumentID, uow);
IssueDocumentPosition pos = null;
foreach (var item in mobileTransactions)
{
pos = new IssueDocumentPosition(uow);
pos.IssueDocumentID = issueDocument;
pos.SupplierID = clientRepo.GetClientByID(item.SupplierID.ClientID, uow);
//Kosovna količina
pos.Quantity = item.Quantity <= 0 ? invDeliveries.Count(inv => inv.PackagesUIDs.Contains(item.UIDCode)) : item.Quantity;// če se še ni shranila količina na mobilnih transkacijah jo poiščemo v invnetoryDeliveries
pos.UID250 = item.UIDCode;
pos.Name = item.ProductID.Name;
pos.Notes = "Prenos iz mobilnih transakcij";
pos.tsInsert = DateTime.Now;
pos.tsInsertUserID = userID;
pos.tsUpdate = DateTime.Now;
pos.tsUpdateUserID = userID;
pos.ProductID = productRepo.GetProductByID(item.ProductID.ProductID, uow);
pos.MobileTransactionID = item;
}
uow.CommitChanges();
return(document.IssueDocumentID);
}
return(-1);
}