// GET: StockIns/Details/5
public ActionResult Details(string id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
StockIn stockIn = db.StockIn.Find(id);
if (stockIn == null)
{
return(HttpNotFound());
}
var da = db.StockIn.Where(w => w.StockInID == id).Select(s => s.SignStatus).ToList();
string datastust = stut(da[0]);
var dat = db.StockIn.Where(w => w.StockInID == id).Select(s => s.CreateDate).ToList();
var date = dat[0].ToShortDateString();
var datas = db.StockIn.AsEnumerable().Where(w => w.StockInID == id).
Select(s => new
{
s.StockInID,
s.PurchaseOrderReceiveID,
s.Remark,
s.AddStockDate,
s.CreateEmployeeID,
date,
datastust
});
return(Json(datas, JsonRequestBehavior.AllowGet));
}
public ActionResult StockInItem(StockIn stockIn)
{
if (Request.IsAuthenticated)
{
if (ModelState.IsValid)
{
stockIn.Month = stockIn.Date.Substring(0, 2);
stockIn.Year = stockIn.Date.Substring(6, 4);
stockIn.ActionDate = DateTime.Now.ToString();
stockIn.ActionType = ActionType.Insert;
stockIn.ActionBy = ActionType.User;
ViewBag.Response = stockInManager.AddStockIn(stockIn);
}
else
{
ViewBag.Response = 3;
}
ViewBag.Companies = companyManager.GetCompaniesForDropDown();
ModelState.Clear();
return(View());
}
else
{
return(HttpNotFound());
}
}
protected void itemDropdownList_SelectedIndexChanged(object sender, EventArgs e)
{
reorderLevelTextBox.Enabled = false;
quantityTextBox.Enabled = false;
int id = Convert.ToInt32(itemDropdownList.SelectedValue);
if (id == 0)
{
reorderLevelTextBox.Text = 0.ToString();
}
else
{
Item item = stockInManager.GetReorderLevelByItemId(id);
reorderLevelTextBox.Text = item.ReorderLevel.ToString();
}
StockIn stockIn = stockInManager.GetAvailableQuantityByItemId(id);
int quantity = stockIn.AvailableQuantity;
if (quantity == 0)
{
quantityTextBox.Text = 0.ToString();
}
else
{
quantityTextBox.Text = quantity.ToString();
}
}
protected void itemDropDownList_SelectedIndexChanged(object sender, EventArgs e)
{
int itemId = Convert.ToInt32(itemDropDownList.SelectedValue);
Item item = stockInManager.GetReorderLevel(itemId);
reorderLevelTextBox.Text = item.ReorderLavel.ToString();
StockIn stockIn = new StockIn();
stockIn.ItemID = itemId;
StockIn stock = stockInManager.IsExist(stockIn);
if (stock == null)
{
stockInTextBox.Text = " ";
messageLabel.Text = "Insert Stock In";
}
else
{
StockIn aStockIn = stockInManager.GetAvailableQuantity(stockIn);
stockInTextBox.Text = aStockIn.AvailableQuantity;
messageLabel.Text = "Output";
}
}
public ActionResult SaveStockIn(string InvoiceNo, string Notes, List <StockInRequest> stockIns)
{
StockIn result = new StockIn();
StockIn FinalResult = new StockIn();
//if (ModelState.IsValid)
{
foreach (var item in stockIns)
{
result.InvoiceNo = InvoiceNo;
result.Notes = Notes;
result.IsActive = true;
result.CreatedDate = DateTime.Now;
result.ProductionDate = DateTime.Now;
result.CreatedBy = CurrentSession.GetCurrentSession().UserName;
result.SupplierId = 0;
result.ProductId = item.ProductId;
result.BaleWeight = 0;
result.WarehouseId = item.WarehouseId;
result.SupplierId = 1;
result.BaleQty = item.Qty;
result.WeightInMon = item.Qty;
FinalResult = serviceStockIn.Save(result, Notes);
}
}
return(Json(FinalResult, JsonRequestBehavior.AllowGet));
}
public string SaveManager(StockIn stockIn)
{
if (stockIn.StockQuantity == 0)
{
return("Stock Quantity should be filled");
}
else if (stockInGateway.IsStockExist(stockIn))
{
int stockQuantityAvailable = stockInGateway.StockQuantityAvailable(stockIn);
stockIn.StockQuantity = stockIn.StockQuantity + stockQuantityAvailable;
int row = stockInGateway.Update(stockIn);
if (row > 0)
{
return("Save Successful !");
}
else
{
return("Saving Failed !");
}
}
else
{
int row = stockInGateway.SaveGateway(stockIn);
if (row > 0)
{
return("Save Successful !");
}
else
{
return("Saving Failed !");
}
}
}
public async Task <ActionResult <StockIn> > PostStockIn(StockIn stockIn)
{
_context.StockIns.Add(stockIn);
await _context.SaveChangesAsync();
return(CreatedAtAction("GetStockIn", new { id = stockIn.StockInNo }, stockIn));
}
private void btnUpdate_Click(object sender, EventArgs e)
{
if (IsNameEmpty())
{
return;
}
int stockInId = EditStockInId;
string name = txtBatch.Text.Trim();
int count = Convert.ToInt32(txtCount.Text.Trim());
int productId = Convert.ToInt32(txtProductId.Text.Trim());
decimal subtotal = Convert.ToDecimal(txtSubtotal.Text.Trim());
int userId = UserLogined.UserId;
DateTime inStockTime = dtpInStockTime.Value;
StockIn stockIn = new StockIn()
{
StockInId = stockInId,
Batch = name,
Count = count,
ProductId = productId,
Subtotal = subtotal,
UserId = userId,
InStockTime = inStockTime,
};
StockInService.UpdateInventoryByInventory(stockIn);
BindData();
ResetUIInputtdData();
}
public ActionResult StockIn(StockInViewModel stockInViewModel)
{
if (ModelState.IsValid)
{
StockIn stockIn = Mapper.Map <StockIn>(stockInViewModel);
db.StockIns.Add(stockIn);
if (db.SaveChanges() > 0)
{
ModelState.Clear();
TempData["msg"] = "StockIn information has been successfully saved.";
return(RedirectToAction("Index", "StockInDetails", new { area = "" }));
}
}
var model = new StockInViewModel();
model.Categories = db.Categories.ToList();
model.Parties = _partyManager.PartyList();
ViewBag.ProductDropDown = new SelectList(new[] { new SelectListItem()
{
Value = "", Text = "Select Product"
} }, "Value", "Text");
TempData["msg"] = "StockIn information has been failed to save!";
return(View(model));
}
public IHttpActionResult AddStock(StockIn data)
{
//return new string[] { "value1", "value2" };
// return new Vishnu { name = "rams", password = "******" };
Console.WriteLine(data);
return(Ok(data));
}
public string StockSaveUpdate(StockIn stockIn)
{
if (stockInGateway.StockUpdate(stockIn) > 0)
{
int available = stockIn.AvailableQuantity;
stockIn.StockInQuantity += available;
int rowAffect = stockInGateway.StockUpdate(stockIn);
if (rowAffect > 0)
{
return("Stock Update");
}
else
{
return("Update Failed");
}
}
else
{
int rowAffect = stockInGateway.StockSave(stockIn);
if (rowAffect > 0)
{
return("Stock Saved");
}
else
{
return("Save Failed");
}
}
}
public void DeleteInventoryById(int inventoryId)
{
StockIn inventory = GetInventoryById(inventoryId);
Context.StockIns.Remove(inventory);
Context.SaveChanges();
}
public int SaveStockIn(StockIn stockIn)
{
string query = "INSERT INTO StockIn (BranchId, PartyId, EmployeeId, Date, Quantity, ItemId, PurchaseTransactionId) " +
"VALUES(@branchId, @partyId, @employeeId, @puchaseDateTime, @quantity, @itemId, @purchaseTransactionId)";
var purchaseTransactionId = GetPurchaseTransactionId(stockIn.PurchaseTransaction.Total, stockIn.PurchaseTransaction.Paid, stockIn.PurchaseTransaction.Return);
Gateway gateway = new Gateway(query);
int rowAffected = -1;
foreach (Item anItem in stockIn.Items)
{
gateway.SqlCommand.Parameters.Clear();
gateway.SqlCommand.Parameters.AddWithValue("@branchId", stockIn.BranchId);
gateway.SqlCommand.Parameters.AddWithValue("@partyId", stockIn.PartyId);
gateway.SqlCommand.Parameters.AddWithValue("@employeeId", stockIn.EmployeeId);
gateway.SqlCommand.Parameters.AddWithValue("@puchaseDateTime", stockIn.PurchaseDateTime);
gateway.SqlCommand.Parameters.AddWithValue("@quantity", anItem.Quantity);
gateway.SqlCommand.Parameters.AddWithValue("@itemId", anItem.ItemId);
gateway.SqlCommand.Parameters.AddWithValue("@purchaseTransactionId", purchaseTransactionId);
rowAffected = gateway.SqlCommand.ExecuteNonQuery();
if (rowAffected <= 0)
{
gateway.Connection.Close();
return(rowAffected);
}
}
gateway.Connection.Close();
return(rowAffected);
}
public StockIn Save(StockIn stockIn, string Notes)
{
var existingItem = inventory.GetAll(a => a.ProductId == stockIn.ProductId && a.IsActive == true && a.WarehouseId == stockIn.WarehouseId).ToList();
if (existingItem.Count > 0)
{
foreach (var inv in existingItem)
{
inv.UpdatedDate = DateTime.Now;
inv.UpdatedBy = CurrentSession.GetCurrentSession().UserName;
inv.ReceiveQty = stockIn.BaleQty;
inv.GoodsType = "2";
inventory.Update(inv, inv.Id);
}
}
else
{
Inventory result = new Inventory();
Inventory FinalResult = new Inventory();
result.ProductId = (int)stockIn.ProductId;
result.QtyInBale = (int?)stockIn.BaleWeight;
result.SupplierId = 1;
result.WarehouseId = (int)stockIn.WarehouseId;
result.ReceiveQty = stockIn.BaleQty;
result.Notes = Notes;
result.GoodsType = "2";
result.CreatedBy = CurrentSession.GetCurrentSession().UserName;
result.CreatedDate = DateTime.Now;
result.IsActive = true;
FinalResult = inventory.Save(result);
}
return(service.Save(stockIn));
}
public ItemSummaryUi()
{
InitializeComponent();
itemSummary = new ItemSummary();
stockIn = new StockIn();
stockOut = new StockOut();
}
public string StockOut(string type)
{
DateTime date = DateTime.Today;
StockOut stockOut = new StockOut();
StockIn stockIn = new StockIn();
for (int i = 0; i < stockOutGridView.Rows.Count; i++)
{
HiddenField hiddenField = stockOutGridView.Rows[i].FindControl("HiddenField1") as HiddenField;
Label quantityLabel = stockOutGridView.Rows[i].FindControl("ItemQuantity") as Label;
stockOut.ItemId = Convert.ToInt32(hiddenField.Value);
stockOut.StockOutQuantity = Convert.ToInt32(quantityLabel.Text);
stockOut.Date = date;
stockOut.Type = type;
stockOutManager.SaveStockOut(stockOut);
stockIn.ItemId = Convert.ToInt32(hiddenField.Value);
int realQuantity = stockInManager.GetAvailableQuantity(stockIn.ItemId);
if (realQuantity >= Convert.ToInt32(quantityLabel.Text))
{
stockIn.AvailableQuantity = realQuantity - Convert.ToInt32(quantityLabel.Text);
}
else
{
errorMessegeLabel.Text = "Insufficient stock";
}
stockInManager.SaveStockIn(stockIn);
}
return(type);
}
public string StockSaveUpdate(StockIn stock)
{
if (stockInGateway.IsItemExists(stock.ItemId))
{
int available = stock.AvailableQuantity;
stock.StockInQuantity += available;
int rowAffect = stockInGateway.StockUpdate(stock);
if (rowAffect > 0)
{
return("Stock Update");
}
else
{
return("! Faild");
}
}
else
{
int rowAffect = stockInGateway.StockSave(stock);
if (rowAffect > 0)
{
return("Stock Save");
}
else
{
return("! Fail");
}
}
}
public ActionResult StockIn(StockCreateVM model)
{
//var stck = new StockIn()
//{
// StocInDate = model.StocInDate,
// Description = model.Description,
// StockInDetails = model.StockInDetails
//};
StockIn stockIn = Mapper.Map <StockIn>(model);
db.StockIns.Add(stockIn);
int isSaved = db.SaveChanges();
if (isSaved > 0)
{
TempData["msg"] = "Successful";
}
model.Categories = db.Categories.ToList();
model.Parties = _partyManager.GetAll().ToList();
ViewBag.ProductDropDown = new SelectListItem[] { new SelectListItem()
{
Value = "", Text = "Select...."
} };
return(View(model));
}
public List <StockIn> GetAllitem(int companyId)
{
SetConnection();
string query = "SELECT * FROM Item WHERE CompanyID=" + companyId;
SqlCommand command = new SqlCommand(query, connection);
connection.Open();
List <StockIn> StockInlist = new List <StockIn>();
SqlDataReader reader = command.ExecuteReader();
while (reader.Read())
{
int itemID = (int)reader["ItemID"];
string itemName = reader["ItemName"].ToString();
StockIn astock = new StockIn();
astock.ItemId = itemID;
astock.ItemName = itemName;
StockInlist.Add(astock);
}
reader.Close();
connection.Close();
return(StockInlist);
}
public int SaveStockin(StockIn stockIn)
{
string query = @"INSERT INTO [dbo].[tb_StockIn]
([CategoryId]
,[ItemId]
,[Quentity]
,[EntryDate]
,[EmployeeId])
VALUES
('" + stockIn.CategoryId + "','" + stockIn.ItemId + "','" + stockIn.TotalQuantity + "','" +
stockIn.EntryDate + "','" + stockIn.EmployeeId + "')";
try
{
SqlCommand command = new SqlCommand(query, _connection);
_connection.Open();
int rowAffected = command.ExecuteNonQuery();
_connection.Close();
return(rowAffected);
}
catch (Exception exception)
{
throw new Exception("Unable to connect Server", exception);
}
finally
{
_connection.Close();
}
}
public async Task <IActionResult> PutStockIn(int id, StockIn stockIn)
{
if (id != stockIn.StockInNo)
{
return(BadRequest());
}
_context.Entry(stockIn).State = EntityState.Modified;
try
{
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!StockInExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(NoContent());
}
public bool IsItemNameExists(StockIn stockIn)
{
try
{
string Query = "SELECT * FROM tb_StockIn WHERE (CategoryId = @CategoryId and ItemId = @ItemId)";
SqlCommand Command = new SqlCommand(Query, _connection);
_connection.Open();
Command.Parameters.Clear();
Command.Parameters.Add("CategoryId", SqlDbType.Int);
Command.Parameters["CategoryId"].Value = stockIn.CategoryId;
Command.Parameters.Add("ItemId", SqlDbType.Int);
Command.Parameters["ItemId"].Value = stockIn.ItemId;
SqlDataReader Reader = Command.ExecuteReader();
Reader.Read();
bool isExist = Reader.HasRows;
Reader.Close();
return(isExist);
}
catch (Exception exception)
{
throw new Exception("Unable to connect Server", exception);
}
finally
{
_connection.Close();
}
}
private void Init()
{
tempSIO = new StockIn();
tempSIO.U8Details = new List <StockInDetail>();
tempSIO.OperateDetails = new List <StockInDetail>();
tempSIO.OperaPositions = new List <InvPositionInfo>();
cbxBatch.DataSource = null;
cbxBatch.Items.Clear();
cbxBatch.Refresh();
cbxBatch.Enabled = false;
InputPannel.Enabled = false;
txtOrder.Enabled = true;
rbtOther.Enabled = true;
rbtRecord.Enabled = true;
txtPosition.Enabled = false;
txtLabel.Enabled = false;
btnSource.Enabled = false;
btnDone.Enabled = false;
btnSubmit.Enabled = false;
txtOrder.Text = "";
txtPosition.Text = "";
lblStore.Text = "";
SetFocus();
}
public int AddStockIn(StockIn stockIn)
{
Context.StockIns.Add(stockIn);
int rowsAffected = Context.SaveChanges();
return(rowsAffected);
}
public string SaveStockIn(StockIn stockIn)
{
bool isItemExist = stockInGateway.IsItemExist(stockIn.ItemId);
if (isItemExist)
{
int rowAffect = stockInGateway.UpdateAvailableQuantityByItem(stockIn);
if (rowAffect > 0)
{
return("Stocked in successfully");
}
else
{
return("Stocked in failed");
}
}
else
{
int rowAffect = stockInGateway.SaveStockIn(stockIn);
if (rowAffect > 0)
{
return("Stocked in successfully");
}
else
{
return("Stocked in failed");
}
}
}
protected void saveButton_Click(object sender, EventArgs e)
{
StockIn stockIn = new StockIn();
if (availableQuantityTextBox.Text == "")
{
stockIn.ItemId = Convert.ToInt32(itemDropDownList.SelectedValue);
stockIn.Quantity = Convert.ToInt32(stockInQuantityTextBox.Text);
string message = stockInManager.Save(stockIn);
stockInQuantityTextBox.Text = "";
reorderLevelTextBox.Text = "";
itemDropDownList.SelectedValue = "0";
messageLabel.Text = message;
}
else
{
stockIn.ItemId = Convert.ToInt32(itemDropDownList.SelectedValue);
int quantity = Convert.ToInt32(availableQuantityTextBox.Text);
stockIn.Quantity = quantity + Convert.ToInt32(stockInQuantityTextBox.Text);
string message = stockInManager.UpdateStockInById(stockIn);
stockInQuantityTextBox.Text = "";
availableQuantityTextBox.Text = "";
reorderLevelTextBox.Text = "";
itemDropDownList.SelectedValue = "0";
messageLabel.Text = message;
}
}
public string StockInQuantity(StockIn stockInObj)
{
StockInRepository stockInRepoObj = new StockInRepository();
string stockInInfo = stockInRepoObj.StockInQuantity(stockInObj);
return(stockInInfo);
}
private void Init()
{
tempSIO = new StockIn();
tempSIO.U8Details = new List <StockInDetail>();
tempSIO.OperateDetails = new List <StockInDetail>();
tempSIO.OperaPositions = new List <InvPositionInfo>();
MODetails = new List <Om_MoHeadInfo>();
tempSDL = new List <StockInDetail>();
cbxMoDetails.DataSource = null;
cbxMoDetails.Items.Clear();
cbxMoDetails.Enabled = false;
InputPannel.Enabled = false;
txtOrder.Enabled = true;
txtPosition.Enabled = false;
txtLabel.Enabled = false;
btnSource.Enabled = false;
btnDone.Enabled = false;
btnSubmit.Enabled = false;
txtOrder.Text = "";
txtPosition.Text = "";
SetFocus();
}
protected void saveButton_Click(object sender, EventArgs e)
{
if (stockInQuantityTextBox.Text == "")
{
errorMessegeLabel.Text = "*Stock In quantity required";
}
else if (Convert.ToInt32(stockInQuantityTextBox.Text) < 0)
{
errorMessegeLabel.Text = "*Stock In quantity can not be negetive";
}
else
{
StockIn stockIn = new StockIn();
stockIn.ItemId = Convert.ToInt32(itemDropDownList.SelectedValue);
int realQuantity = stockInManager.GetAvailableQuantity(stockIn.ItemId);
stockIn.AvailableQuantity = Convert.ToInt32(stockInQuantityTextBox.Text) + realQuantity;
string message = stockInManager.SaveStockIn(stockIn);
messegeLabel.Text = message;
//int temp = Convert.ToInt32(availableQuantityTextBox.Text);
int stockInQuantity = Convert.ToInt32(stockInQuantityTextBox.Text);
int TotalQuantity = stockInQuantity + realQuantity;
availableQuantityTextBox.Text = TotalQuantity.ToString();
stockInQuantityTextBox.Text = String.Empty;
}
}
public ActionResult Edit(StockIn stockIn)
{
string message = "修改成功!!";
bool status = true;
switch (stockIn.SignStatus)
{
case "同意":
stockIn.SignStatus = "Y";
break;
case "拒絕":
stockIn.SignStatus = "N";
break;
case "簽核中":
stockIn.SignStatus = "S";
break;
}
if (ModelState.IsValid)
{
db.Entry(stockIn).State = EntityState.Modified;
db.SaveChanges();
return(Json(new { status = status, message = message, id = db.StockIn.Max(x => x.StockInOID) }, JsonRequestBehavior.AllowGet));
}
else
{
message = "修改失敗!!";
status = false;
return(Json(new { status = status, message = message }, JsonRequestBehavior.AllowGet));
}
}
