public ActionResult Print(int id)
{
ProductUidHeader header = _ProductUidHeaderService.Find(id);
String GenHeaderId = header.GenDocTypeId.ToString() + '-' + header.GenDocNo;
return(Redirect((string)System.Configuration.ConfigurationManager.AppSettings["JobsDomain"] + "/Report_BarcodePrint/PrintBarCode/?GenHeaderId=" + GenHeaderId));
}
public ActionResult HeaderPost(ProductUidHeaderIndexViewModel svm)
{
string GodownName = "";
string ProcessName = "";
ViewBag.Mode = "Add";
if (svm.Qty == 0)
{
ModelState.AddModelError("", "Please enter qty.");
PrepareViewBag(svm);
return(View("Create", svm));
}
if (svm.GenPersonId == 0 || svm.GenPersonId == null)
{
ModelState.AddModelError("", "Please enter Person.");
PrepareViewBag(svm);
return(View("Create", svm));
}
if (svm.ProductId == 0 || svm.ProductId == null)
{
ModelState.AddModelError("", "Please enter Product.");
PrepareViewBag(svm);
return(View("Create", svm));
}
if (ModelState.IsValid)
{
if (svm.ProductUidHeaderId == 0)
{
if (svm.GodownId != null && svm.GodownId != 0)
{
GodownName = new GodownService(_unitOfWork).Find((int)svm.GodownId).GodownName;
}
if (svm.ProcessId != null && svm.ProcessId != 0)
{
ProcessName = new ProcessService(_unitOfWork).Find((int)svm.ProcessId).ProcessName;
}
ProductUidHeader ProdUidHeader = new ProductUidHeader();
//ProdUidHeader.GenDocNo = svm.GenDocNo;
ProdUidHeader.ProductId = svm.ProductId;
ProdUidHeader.GenDocTypeId = svm.GenDocTypeId;
ProdUidHeader.GenDocDate = svm.GenDocDate;
ProdUidHeader.GenPersonId = svm.GenPersonId;
ProdUidHeader.GenDocNo = new ProductUidHeaderService(_unitOfWork).FGetNewDocNo("GenDocNo", ConfigurationManager.AppSettings["DataBaseSchema"] + ".ProductUidHeaders", svm.GenDocTypeId, svm.GenDocDate);
ProdUidHeader.CreatedDate = DateTime.Now;
ProdUidHeader.ModifiedDate = DateTime.Now;
ProdUidHeader.CreatedBy = User.Identity.Name;
ProdUidHeader.ModifiedBy = User.Identity.Name;
ProdUidHeader.GenRemark = "Godown : " + GodownName + ", Process : " + ProcessName;
ProdUidHeader.ObjectState = Model.ObjectState.Added;
context.ProductUidHeader.Add(ProdUidHeader);
List <string> uids = new List <string>();
using (SqlConnection sqlConnection = new SqlConnection((string)System.Web.HttpContext.Current.Session["DefaultConnectionString"]))
{
sqlConnection.Open();
int TypeId = (int)svm.GenDocTypeId;
SqlCommand Totalf = new SqlCommand("SELECT * FROM Web.FGenerateBarcodeList ( " + TypeId + ", " + svm.Qty + ")", sqlConnection);
SqlDataReader Reader = (Totalf.ExecuteReader());
while (Reader.Read())
{
uids.Add((string)Reader.GetValue(0));
}
}
foreach (string UidItem in uids)
{
ProductUid ProdUid = new ProductUid();
ProdUid.ProductUidHeaderId = ProdUidHeader.ProductUidHeaderId;
ProdUid.ProductUidName = UidItem;
ProdUid.ProductId = ProdUidHeader.ProductId;
ProdUid.IsActive = true;
ProdUid.CreatedBy = User.Identity.Name;
ProdUid.CreatedDate = DateTime.Now;
ProdUid.ModifiedBy = User.Identity.Name;
ProdUid.ModifiedDate = DateTime.Now;
//ProdUid.GenLineId = item.JobOrderLineId;
//ProdUid.GenDocId = pd.JobOrderHeaderId;
ProdUid.GenDocNo = ProdUidHeader.GenDocNo;
ProdUid.GenDocTypeId = ProdUidHeader.GenDocTypeId;
ProdUid.GenDocDate = ProdUidHeader.GenDocDate;
ProdUid.GenPersonId = ProdUidHeader.GenPersonId;
ProdUid.CurrenctProcessId = svm.ProcessId;
ProdUid.CurrenctGodownId = svm.GodownId;
ProdUid.Status = ProductUidStatusConstants.Generated;
ProdUid.LastTransactionDocNo = ProdUidHeader.GenDocNo;
ProdUid.LastTransactionDocTypeId = ProdUidHeader.GenDocTypeId;
ProdUid.LastTransactionDocDate = ProdUidHeader.GenDocDate;
ProdUid.LastTransactionPersonId = ProdUidHeader.GenPersonId;
//ProdUid.LastTransactionLineId = item.JobOrderLineId;
//ProdUid.ProductUIDId = count;
ProdUid.ObjectState = Model.ObjectState.Added;
//new ProductUidService(_unitOfWork).Create(ProdUid);
context.ProductUid.Add(ProdUid);
}
try
{
context.SaveChanges();
}
catch (Exception ex)
{
string message = _exception.HandleException(ex);
ModelState.AddModelError("", message);
return(View("Create", svm));
}
LogActivity.LogActivityDetail(LogVm.Map(new ActiivtyLogViewModel
{
DocTypeId = new DocumentTypeService(_unitOfWork).FindByName(MasterDocTypeConstants.ProductUid).DocumentTypeId,
DocId = ProdUidHeader.ProductUidHeaderId,
ActivityType = (int)ActivityTypeContants.Added,
}));
ReAssignSessionVariables(ProdUidHeader.ProductUidHeaderId);
//return RedirectToAction("Edit", new { id = ProdUidHeader.ProductUidHeaderId }).Success("Data saved Successfully");
return(RedirectToAction("Create").Success("Data saved Successfully"));
}
}
PrepareViewBag(svm);
return(View("Create", svm));
}
public void Delete(ProductUidHeader p)
{
_unitOfWork.Repository <ProductUidHeader>().Delete(p);
}
public void Update(ProductUidHeader p)
{
p.ObjectState = ObjectState.Modified;
_unitOfWork.Repository <ProductUidHeader>().Update(p);
}
public ProductUidHeader Add(ProductUidHeader p)
{
_unitOfWork.Repository <ProductUidHeader>().Add(p);
return(p);
}
public ProductUidHeader Create(ProductUidHeader p)
{
p.ObjectState = ObjectState.Added;
_unitOfWork.Repository <ProductUidHeader>().Insert(p);
return(p);
}
public void Update(ProductUidHeader p)
{
p.ObjectState = ObjectState.Modified;
_productUidHeaderRepository.Update(p);
}
public void Delete(ProductUidHeader p)
{
_productUidHeaderRepository.Delete(p);
}
public ProductUidHeader Create(ProductUidHeader p)
{
p.ObjectState = ObjectState.Added;
_productUidHeaderRepository.Insert(p);
return(p);
}
public ProductUidHeader Add(ProductUidHeader p)
{
_productUidHeaderRepository.Add(p);
return(p);
}
public ActionResult Post(JobReceiveHeaderViewModel svm)
{
bool TimePlanValidation = true;
string ExceptionMsg = "";
bool Continue = true;
JobReceiveHeader s = Mapper.Map <JobReceiveHeaderViewModel, JobReceiveHeader>(svm);
List <WeavingReceiveWizardViewModel> JobOrdersAndQtys = (List <WeavingReceiveWizardViewModel>)System.Web.HttpContext.Current.Session["BarCodesWeavingWizardJobOrder"];
if (JobOrdersAndQtys.Count() <= 0)
{
ModelState.AddModelError("", "No Records Selected");
}
int JobWorkerCnt = (from l in JobOrdersAndQtys
group l by l.JobWorkerId into g
select new
{
JobWorkerId = g.Key,
}).Distinct().Count();
if (JobWorkerCnt > 1)
{
ModelState.AddModelError("", "Select any one Job Worker Orders.");
}
s.JobWorkerId = JobOrdersAndQtys.FirstOrDefault().JobWorkerId;
svm.JobWorkerId = JobOrdersAndQtys.FirstOrDefault().JobWorkerId;
#region DocTypeTimeLineValidation
try
{
if (svm.JobReceiveHeaderId <= 0)
{
TimePlanValidation = DocumentValidation.ValidateDocument(Mapper.Map <DocumentUniqueId>(svm), DocumentTimePlanTypeConstants.Create, User.Identity.Name, out ExceptionMsg, out Continue);
}
else
{
TimePlanValidation = DocumentValidation.ValidateDocument(Mapper.Map <DocumentUniqueId>(svm), DocumentTimePlanTypeConstants.Modify, User.Identity.Name, out ExceptionMsg, out Continue);
}
}
catch (Exception ex)
{
string message = _exception.HandleException(ex);
TempData["CSEXC"] += message;
TimePlanValidation = false;
}
if (!TimePlanValidation)
{
TempData["CSEXC"] += ExceptionMsg;
}
#endregion
if (ModelState.IsValid && (TimePlanValidation || Continue))
{
if (svm.JobReceiveHeaderId <= 0)
{
if (JobOrdersAndQtys.Count() > 0)
{
s.CreatedDate = DateTime.Now;
s.ModifiedDate = DateTime.Now;
s.CreatedBy = User.Identity.Name;
s.ModifiedBy = User.Identity.Name;
s.Status = (int)StatusConstants.Drafted;
_JobReceiveHeaderService.Create(s);
int Cnt = 0;
int Sr = 0;
JobReceiveSettings Settings = new JobReceiveSettingsService(_unitOfWork).GetJobReceiveSettingsForDocument(s.DocTypeId, s.DivisionId, s.SiteId);
int ProductUidCountForJobOrderLine = 0;
int pk = 0;
var JobOrderLineIds = JobOrdersAndQtys.Select(m => m.JobOrderLineId).ToArray();
var BalQtyandUnits = (from p in db.ViewJobOrderBalance
join t in db.Product on p.ProductId equals t.ProductId
where JobOrderLineIds.Contains(p.JobOrderLineId)
select new
{
BalQty = p.BalanceQty,
JobOrderLineId = p.JobOrderLineId,
UnitId = t.UnitId,
}).ToList();
if (ModelState.IsValid)
{
foreach (var SelectedJobOrderLine in JobOrdersAndQtys)
{
if (SelectedJobOrderLine.JobOrderLineId > 0)
{
if (SelectedJobOrderLine.ToProductUidName != "" && SelectedJobOrderLine.ToProductUidName != null && SelectedJobOrderLine.FromProductUidName != "" && SelectedJobOrderLine.FromProductUidName != null)
{
if (SelectedJobOrderLine.Qty != (Convert.ToInt32(SelectedJobOrderLine.ToProductUidName) - Convert.ToInt32(SelectedJobOrderLine.FromProductUidName) + 1))
{
string Msg = "";
Msg = "Qty and Barcode series does not match.";
ModelState.AddModelError("", Msg);
PrepareViewBag();
ViewBag.Mode = "Add";
return(View("Create", svm));
}
}
ProductUidCountForJobOrderLine = 0;
var JobOrderLine = new JobOrderLineService(_unitOfWork).Find((SelectedJobOrderLine.JobOrderLineId));
var Product = new ProductService(_unitOfWork).Find(JobOrderLine.ProductId);
var bal = BalQtyandUnits.Where(m => m.JobOrderLineId == SelectedJobOrderLine.JobOrderLineId).FirstOrDefault();
if (SelectedJobOrderLine.Qty <= bal.BalQty)
{
for (int i = 0; i <= SelectedJobOrderLine.Qty - 1; i++)
{
int?ProductUidHeaderId = null;
int?ProductUidId = null;
var SisterSite = (from S in db.Site where S.PersonId == s.JobWorkerId select S).FirstOrDefault();
//if (!string.IsNullOrEmpty(Settings.SqlProcGenProductUID))
if (SisterSite == null)
{
ProductUidHeader ProdUidHeader = new ProductUidHeader();
ProdUidHeader.ProductUidHeaderId = Cnt;
ProdUidHeader.ProductId = JobOrderLine.ProductId;
ProdUidHeader.Dimension1Id = JobOrderLine.Dimension1Id;
ProdUidHeader.Dimension2Id = JobOrderLine.Dimension2Id;
ProdUidHeader.GenDocId = s.JobReceiveHeaderId;
ProdUidHeader.GenDocNo = s.DocNo;
ProdUidHeader.GenDocTypeId = s.DocTypeId;
ProdUidHeader.GenDocDate = s.DocDate;
ProdUidHeader.GenPersonId = s.JobWorkerId;
ProdUidHeader.CreatedBy = User.Identity.Name;
ProdUidHeader.CreatedDate = DateTime.Now;
ProdUidHeader.ModifiedBy = User.Identity.Name;
ProdUidHeader.ModifiedDate = DateTime.Now;
ProdUidHeader.ObjectState = Model.ObjectState.Added;
new ProductUidHeaderService(_unitOfWork).Create(ProdUidHeader);
ProductUidHeaderId = ProdUidHeader.ProductUidHeaderId;
string ProductUidName = (Convert.ToInt32(SelectedJobOrderLine.FromProductUidName) + ProductUidCountForJobOrderLine).ToString();
ProductUid ProdUid = new ProductUid();
ProdUid.ProductUidHeaderId = ProdUidHeader.ProductUidHeaderId;
ProdUid.ProductUidName = ProductUidName;
ProdUid.ProductId = JobOrderLine.ProductId;
ProdUid.IsActive = true;
ProdUid.CreatedBy = User.Identity.Name;
ProdUid.CreatedDate = DateTime.Now;
ProdUid.ModifiedBy = User.Identity.Name;
ProdUid.ModifiedDate = DateTime.Now;
ProdUid.GenLineId = null;
ProdUid.GenDocId = s.JobReceiveHeaderId;
ProdUid.GenDocNo = s.DocNo;
ProdUid.GenDocTypeId = s.DocTypeId;
ProdUid.GenDocDate = s.DocDate;
ProdUid.GenPersonId = s.JobWorkerId;
ProdUid.Dimension1Id = JobOrderLine.Dimension1Id;
ProdUid.Dimension2Id = JobOrderLine.Dimension2Id;
ProdUid.CurrenctProcessId = s.ProcessId;
ProdUid.CurrenctGodownId = s.GodownId;
ProdUid.Status = "Receive";
ProdUid.LastTransactionDocId = s.JobReceiveHeaderId;
ProdUid.LastTransactionDocNo = s.DocNo;
ProdUid.LastTransactionDocTypeId = s.DocTypeId;
ProdUid.LastTransactionDocDate = s.DocDate;
ProdUid.LastTransactionPersonId = s.JobWorkerId;
ProdUid.LastTransactionLineId = null;
ProdUid.ProductUIDId = pk;
new ProductUidService(_unitOfWork).Create(ProdUid);
ProductUidId = ProdUid.ProductUIDId;
}
if (ProductUidId == null)
{
string ProductUidName = (Convert.ToInt32(SelectedJobOrderLine.FromProductUidName) + ProductUidCountForJobOrderLine).ToString();
var temp = new ProductUidService(_unitOfWork).Find(ProductUidName);
if (temp != null)
{
ProductUidId = temp.ProductUIDId;
}
else
{
string Msg = ProductUidName + " is not a valid barcode.";
ModelState.AddModelError("", Msg);
PrepareViewBag();
ViewBag.Mode = "Add";
return(View("Create", svm));
}
if (temp.CurrenctGodownId != null)
{
string Msg = ProductUidName + " is already in Stock at Godown " + new GodownService(_unitOfWork).Find(temp.CurrenctGodownId ?? 0).GodownName;
ModelState.AddModelError("", Msg);
PrepareViewBag();
ViewBag.Mode = "Add";
return(View("Create", svm));
}
if (temp.LastTransactionPersonId != s.JobWorkerId)
{
string Msg = ProductUidName + ProductUidName + " does not belong to this Job Worker";
ModelState.AddModelError("", Msg);
PrepareViewBag();
ViewBag.Mode = "Add";
return(View("Create", svm));
}
}
StockViewModel StockViewModel = new StockViewModel();
if (Cnt == 0)
{
StockViewModel.StockHeaderId = s.StockHeaderId ?? 0;
}
else
{
if (s.StockHeaderId != null && s.StockHeaderId != 0)
{
StockViewModel.StockHeaderId = (int)s.StockHeaderId;
}
else
{
StockViewModel.StockHeaderId = -1;
}
}
StockViewModel.StockId = -Cnt;
StockViewModel.DocHeaderId = s.JobReceiveHeaderId;
StockViewModel.DocLineId = null;
StockViewModel.DocTypeId = s.DocTypeId;
StockViewModel.StockHeaderDocDate = s.DocDate;
StockViewModel.StockDocDate = s.DocDate;
StockViewModel.DocNo = s.DocNo;
StockViewModel.DivisionId = s.DivisionId;
StockViewModel.SiteId = s.SiteId;
StockViewModel.CurrencyId = null;
StockViewModel.PersonId = s.JobWorkerId;
StockViewModel.ProductId = JobOrderLine.ProductId;
//StockViewModel.ProductUidId = ProdUid.ProductUIDId;
StockViewModel.ProductUidId = ProductUidId;
StockViewModel.HeaderFromGodownId = null;
StockViewModel.HeaderGodownId = s.GodownId;
StockViewModel.HeaderProcessId = s.ProcessId;
StockViewModel.GodownId = (int)s.GodownId;
StockViewModel.Remark = s.Remark;
StockViewModel.Status = s.Status;
StockViewModel.ProcessId = s.ProcessId;
StockViewModel.LotNo = null;
StockViewModel.CostCenterId = SelectedJobOrderLine.CostCenterId;
StockViewModel.Qty_Iss = 0;
StockViewModel.Qty_Rec = 1;
StockViewModel.Rate = SelectedJobOrderLine.Rate;
StockViewModel.ExpiryDate = null;
StockViewModel.Specification = JobOrderLine.Specification;
StockViewModel.Dimension1Id = JobOrderLine.Dimension1Id;
StockViewModel.Dimension2Id = JobOrderLine.Dimension2Id;
StockViewModel.CreatedBy = User.Identity.Name;
StockViewModel.CreatedDate = DateTime.Now;
StockViewModel.ModifiedBy = User.Identity.Name;
StockViewModel.ModifiedDate = DateTime.Now;
string StockPostingError = "";
StockPostingError = new StockService(_unitOfWork).StockPost(ref StockViewModel);
if (StockPostingError != "")
{
string message = StockPostingError;
ModelState.AddModelError("", message);
return(View("Create", svm));
}
if (Cnt == 0)
{
s.StockHeaderId = StockViewModel.StockHeaderId;
}
JobReceiveLine line = new JobReceiveLine();
line.StockId = StockViewModel.StockId;
//line.ProductUidHeaderId = ProdUidHeader.ProductUidHeaderId;
line.ProductUidHeaderId = ProductUidHeaderId;
//line.ProductUidId = ProdUid.ProductUIDId;
line.ProductUidId = ProductUidId;
line.JobReceiveHeaderId = s.JobReceiveHeaderId;
line.JobOrderLineId = JobOrderLine.JobOrderLineId;
line.Qty = 1;
line.PassQty = 1;
line.LossQty = 0;
line.UnitConversionMultiplier = JobOrderLine.UnitConversionMultiplier;
line.DealQty = 1 * JobOrderLine.UnitConversionMultiplier;
line.DealUnitId = JobOrderLine.DealUnitId;
line.Sr = Sr++;
line.CreatedDate = DateTime.Now;
line.ModifiedDate = DateTime.Now;
line.CreatedBy = User.Identity.Name;
line.ModifiedBy = User.Identity.Name;
line.JobReceiveLineId = pk;
line.ObjectState = Model.ObjectState.Added;
new JobReceiveLineService(_unitOfWork).Create(line);
new JobReceiveLineStatusService(_unitOfWork).CreateLineStatus(line.JobReceiveLineId, ref db, false);
pk++;
Cnt = Cnt + 1;
ProductUidCountForJobOrderLine++;
}
}
}
}
}
string Errormessage = "";
try
{
_unitOfWork.Save();
}
catch (Exception ex)
{
Errormessage = _exception.HandleException(ex);
ModelState.AddModelError("", Errormessage);
PrepareViewBag();
ViewBag.Mode = "Add";
return(View("Create", svm));
}
IEnumerable <JobReceiveLine> JobReceiveLineList = new JobReceiveLineService(_unitOfWork).GetJobReceiveLineList(s.JobReceiveHeaderId);
foreach (JobReceiveLine Line in JobReceiveLineList)
{
if (Line.ProductUidId != null)
{
ProductUid ProductUid = new ProductUidService(_unitOfWork).Find((int)Line.ProductUidId);
ProductUid.GenDocId = Line.JobReceiveHeaderId;
ProductUid.LastTransactionDocId = Line.JobReceiveHeaderId;
ProductUid.GenLineId = Line.JobReceiveLineId;
ProductUid.LastTransactionLineId = Line.JobReceiveLineId;
new ProductUidService(_unitOfWork).Update(ProductUid);
}
}
try
{
_unitOfWork.Save();
}
catch (Exception ex)
{
Errormessage = _exception.HandleException(ex);
ModelState.AddModelError("", Errormessage);
PrepareViewBag();
ViewBag.Mode = "Add";
return(View("Create", svm));
}
LogActivity.LogActivityDetail(LogVm.Map(new ActiivtyLogViewModel
{
DocTypeId = s.DocTypeId,
DocId = s.JobReceiveHeaderId,
ActivityType = (int)ActivityTypeContants.WizardCreate,
DocNo = s.DocNo,
DocDate = s.DocDate,
DocStatus = s.Status,
}));
System.Web.HttpContext.Current.Session.Remove("BarCodesWeavingWizardJobOrder");
return(Redirect(System.Configuration.ConfigurationManager.AppSettings["JobsDomain"] + "/JobReceiveHeader/Modify/" + s.JobReceiveHeaderId));
}
else
{
return(Redirect(System.Configuration.ConfigurationManager.AppSettings["JobsDomain"] + "/JobReceiveHeader/Index/" + s.DocTypeId));
}
}
else
{
}
}
PrepareViewBag();
ViewBag.Mode = "Add";
//return Redirect(System.Configuration.ConfigurationManager.AppSettings["JobsDomain"] + "/JobReceiveHeader/Submit/"+s.JobReceiveHeaderId);
return(View("Create", svm));
}
