public PartialViewResult StockJournelList(int?StockPointId)
{
FIllStockItems(StockPointId);
FillPartNoInStock(StockPointId ?? 0);
StockJournal StockJournalList = new StockJournal {
StockJournelItems = new List <StockJournalItem>()
};
StockJournalList.StockJournelItems.Add(new StockJournalItem());
//StockJournal List = new StockJournal();
//List.StockJournelItems = new StockJournalItem();
return(PartialView("_StockJournalList", StockJournalList));
}
public ActionResult Create()
{
FillStockPoint();
FIllEmployee();
FIllStockItems(0);
FillPartNoInStock(0);
//StockJournal StockJournal = new StockJournal();
string internalid = DatabaseCommonRepository.GetNextDocNo(22, OrganizationId);
StockJournal StockJournalList = new StockJournal {
StockJournelItems = new List <StockJournalItem>(), StockJournalRefno = internalid
};
StockJournalList.StockJournelItems.Add(new StockJournalItem());
//StockJournal.StockJournalRefno = "SJ/" + internalid;
return(View("Create", StockJournalList));
//return View(new StockJournal { StockJournalRefno = "SJ/" + internalid });
}
public ActionResult Edit(int id = 0)
{
try
{
if (id != 0)
{
FillStockPoint();
FIllEmployee();
StockJournal StockJournal = new StockJournal();
StockJournal = new StockJournalRepository().GetStockJournalHD(id);
FIllStockItems(StockJournal.StockPointId);
FillPartNoInStock(StockJournal.StockPointId ?? 0);
StockJournal.StockJournelItems = new StockJournalItemsRepository().GetStockJournalDT(id);
return(View(StockJournal));
}
else
{
TempData["error"] = "That was an invalid/unknown request. Please try again.";
TempData["success"] = "";
}
}
catch (InvalidOperationException iox)
{
TempData["error"] = "Sorry, we could not find the requested item. Please try again.|" + iox.Message;
}
catch (SqlException sx)
{
TempData["error"] = "Some error occured while connecting to database. Please try again after sometime.|" + sx.Message;
}
catch (NullReferenceException nx)
{
TempData["error"] = "Some required data was missing. Please try again.|" + nx.Message;
}
catch (Exception ex)
{
TempData["error"] = "Some error occured. Please try again.|" + ex.Message;
}
TempData["success"] = "";
return(RedirectToAction("Index"));
}
public int InsertStockJournal(StockJournal model)
{
using (IDbConnection connection = OpenConnection(dataConnection))
{
IDbTransaction trn = connection.BeginTransaction();
try
{
int id = 0;
string sql = @"INSERT INTO StockJournal (StockJournalRefno,StockPointId,Remarks,IssuedBy,StockJournalDate,CreatedBy,CreatedDate,OrganizationId) VALUES (@StockJournalRefno,@StockPointId,@Remarks,@IssuedBy,GETDATE(),@CreatedBy,GETDATE(),@OrganizationId);
SELECT CAST(SCOPE_IDENTITY() as int)";
model.StockJournalRefno = DatabaseCommonRepository.GetNewDocNo(connection, model.OrganizationId ?? 0, 22, true, trn);
id = connection.Query <int>(sql, model, trn).Single();
var StockJournalItemsRepo = new StockJournalItemsRepository();
int? StockPointId = model.StockPointId;
string RefNo = model.StockJournalRefno;
string Remarks = model.Remarks;
string CreatedBy = model.CreatedBy;
int? OrgId = model.OrganizationId;
foreach (var item in model.StockJournelItems)
{
item.StockJournalId = id;
item.StockPointId = StockPointId;
item.Remarks = Remarks;
item.CreatedBy = CreatedBy;
item.OrganizationId = OrgId;
item.StockJournalRefno = RefNo;
new StockJournalItemsRepository().InsertStockJournalItem(item, connection, trn);
}
InsertLoginHistory(dataConnection, model.CreatedBy, "Create", "Stock Journal", id.ToString(), "0");
trn.Commit();
return(id);
}
catch (Exception)
{
trn.Rollback();
return(0);
}
}
}
public ActionResult Create(StockJournal model)
{
model.OrganizationId = OrganizationId;
model.CreatedDate = System.DateTime.Now;
model.CreatedBy = UserID.ToString();
if (new StockJournalRepository().InsertStockJournal(model) > 0)
{
TempData["success"] = "Saved successfully";
TempData["error"] = "";
return(RedirectToAction("Create"));
}
else
{
FillStockPoint();
FIllEmployee();
FIllStockItems(model.StockPointId);
TempData["success"] = "";
TempData["error"] = "Some error occured. Please try again.";
return(View("Create", model));
}
}
