private void AddExchangedItem(inv_Items _p, long quantity, int?ordernTOventoryID)
{
using (SqlConnection con2 = new SqlConnection(constr))
{
using (SqlCommand cmd2 = new SqlCommand("Insert_PurshaseItems"))
{
cmd2.CommandType = CommandType.StoredProcedure;
cmd2.Parameters.AddWithValue("@ItemID", _p.ItemID);
cmd2.Parameters.AddWithValue("@ItemNameAr", _p.ItemNameAr);
cmd2.Parameters.AddWithValue("@ItemQuantity", quantity);
cmd2.Parameters.AddWithValue("@sellamount", _p.ItemSalePrice);
cmd2.Parameters.AddWithValue("@ItemPuchasePrice", _p.ItemPuchasePrice);
cmd2.Parameters.AddWithValue("@ItemHistoryDecription", " تحويل بضاعة من المخزن الى المخزن");
cmd2.Parameters.AddWithValue("@ItemHistoryProccessTypeID", 2);
cmd2.Parameters.AddWithValue("@InventoryID", ordernTOventoryID);
cmd2.Parameters.AddWithValue("@CategoryID", _p.CategoryID);
cmd2.Parameters.AddWithValue("@ItemPurchaseCurrencyID", _p.CategoryID);
cmd2.Parameters.AddWithValue("@BillNo", "-1");
////cmd2.Parameters.AddWithValue("@PurchaseStatusID", 1);// if purchase operation done or not
////// cmd2.Parameters.AddWithValue("@ItemTotalPurchaseAmount", ItemPuchasePrice );
//////cmd2.Parameters.AddWithValue("@ItemCostPurchase", ItemCostPurchase);
////////////////
cmd2.Connection = con2;
con2.Open();
cmd2.ExecuteNonQuery();
con2.Close();
}
}
}
public async Task <ActionResult> DeleteConfirmed(int id)
{
inv_Items inv_Items = await db.inv_Items.FindAsync(id);
db.inv_Items.Remove(inv_Items);
await db.SaveChangesAsync();
return(RedirectToAction("Index"));
}
public ActionResult Remove(inv_Items Item)
{
inv_Items inv_Items = db.inv_Items.Find(Item.ItemID);
db.inv_Items.Remove(inv_Items);
db.SaveChanges();
return(new JsonResult {
Data = new { status = 1 }
});
}
public async Task <ActionResult> UpdateQuantity(inv_Items Item, inv_ItemHistory ItemHistory, decimal?NewQuantity)
{
int status = 0;
long ItemId;
if (Item.ItemID > 0)
{
//Edit
var v = db.inv_Items.Where(a => a.ItemID == Item.ItemID).FirstOrDefault();
if (v != null)
{
Session["OldQuantityTemp"] = v.ItemQuantity;
Session["NewQuantityTemp"] = NewQuantity;
v.ItemID = Item.ItemID;
ItemId = Item.ItemID;
v.ItemQuantity = int.Parse(Session["OldQuantityTemp"].ToString()) + int.Parse(Session["NewQuantityTemp"].ToString());
await db.SaveChangesAsync();
status = 1;
// Log ItemHistroy
string constr = ConfigurationManager.ConnectionStrings["DBConnectionString"].ConnectionString;
using (SqlConnection con = new SqlConnection(constr))
{
using (SqlCommand cmd = new SqlCommand("Insert_ItemHistory"))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@ItemID", Item.ItemID);
cmd.Parameters.AddWithValue("@ItemHistoryQuantity", long.Parse(Session["NewQuantityTemp"].ToString()));
cmd.Parameters.AddWithValue("@ItemHistoryProccessTypeID", 1);
cmd.Parameters.AddWithValue("@ItemHistoryDebitOrCredit", true);
cmd.Parameters.AddWithValue("@ItemHistoryDecription", "توريدة جديدة");
cmd.Connection = con;
con.Open();
cmd.ExecuteNonQuery();
con.Close();
}
}
//Log ItemHistroy
}
}
return(new JsonResult {
Data = new { status = status }
});
}
public async Task <ActionResult> Edit([Bind(Include = "ItemID,ItemBatch,ItemNameAr,ItemNameEn,ItemQuantity,ItemMinimumQuantity,ItemSalePrice,ItemSaleCurrencyID,ItemPuchasePrice,ItemPurchaseCurrencyID,InventoryID,CategoryID,SubCategoryID,ItemExpiredDate,ItemAddedDate,ItemUpdatedAt,UpLoaded,BarCode")] inv_Items inv_Items)
{
if (ModelState.IsValid)
{
db.Entry(inv_Items).State = EntityState.Modified;
await db.SaveChangesAsync();
//return RedirectToAction("Index");
}
return(View(inv_Items));
}
// GET: GoodExchanges/Delete/5
public async Task <ActionResult> Delete(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
inv_Items inv_Items = await db.inv_Items.FindAsync(id);
if (inv_Items == null)
{
return(HttpNotFound());
}
return(View(inv_Items));
}
public async Task <ActionResult> Details(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
inv_Items inv_Items = await db.inv_Items.FindAsync(id);
if (inv_Items == null)
{
return(HttpNotFound());
}
return(Json(inv_Items, JsonRequestBehavior.AllowGet));
//return View(inv_Items);
}
public ActionResult Save(inv_Items Item)
{
int status = 0;
// Start Validation cheack
if (ModelState.IsValid)
{
//################### Edit Item ###################//
if (Item.ItemID > 0)
{
var v = db.inv_Items.Where(I => I.ItemID == Item.ItemID).FirstOrDefault();
if (v != null)
{
v.ItemID = Item.ItemID;
v.ItemNameAr = Item.ItemNameAr;
v.ItemQuantity = Item.ItemQuantity;
v.ItemSalePrice = Item.ItemSalePrice;
v.CategoryID = Item.CategoryID;
v.SubCategoryID = Item.SubCategoryID;
v.ItemExpiredDate = Item.ItemExpiredDate;
status = 1; // 1 for update
db.SaveChanges();
}
}
//################### Edit Item //###################
// Start Save New Item
else
{
#region
string constr = ConfigurationManager.ConnectionStrings["DBConnectionString"].ConnectionString;
using (SqlConnection con2 = new SqlConnection(constr))
{
using (SqlCommand cmd2 = new SqlCommand("Insert_PurshaseItems"))
{
cmd2.CommandType = CommandType.StoredProcedure;
cmd2.Parameters.AddWithValue("@ItemID", Item.ItemID);
cmd2.Parameters.AddWithValue("@ItemNameAr", Item.ItemNameAr);
cmd2.Parameters.AddWithValue("@ItemQuantity", Item.ItemQuantity);
cmd2.Parameters.AddWithValue("@sellamount", Item.ItemSalePrice);
cmd2.Parameters.AddWithValue("@ItemPuchasePrice", Item.ItemPuchasePrice);
cmd2.Parameters.AddWithValue("@ItemHistoryDecription", "توريد بضاعة جديدة");
cmd2.Parameters.AddWithValue("@ItemHistoryProccessTypeID", 3);
cmd2.Parameters.AddWithValue("@InventoryID", int.Parse(Session["ii"].ToString()));
cmd2.Parameters.AddWithValue("@CategoryID", Item.CategoryID);
cmd2.Parameters.AddWithValue("@ItemPurchaseCurrencyID", 1);
cmd2.Parameters.AddWithValue("@BillNo", "-1");
cmd2.Connection = con2;
con2.Open();
cmd2.ExecuteNonQuery();
con2.Close();
}
}
#endregion
status = 2; // 2 fro
}
//End Save New Item
return(new JsonResult {
Data = new { status = status }
});
}
// End Validation cheack
// Start Send validation error
else
{
var errorList = ModelState.Values.SelectMany(m => m.Errors)
.Select(e => e.ErrorMessage)
.ToList();
return(new JsonResult {
Data = new { status = errorList }
});
}
// End Send validation error
}
public JsonResult ComplateRequestOrder(string OrderpaymentAmount, string ItemIDArray, string NamesArray, string ItemPriceArray, string QuantitiesArray, int RequestSourceID, int RequestType)
{
int LastRequest;
string OrderNumber = " ";
List <inv_Requests> LastList = db.inv_Requests.ToList();
if (LastList == null)
{
LastRequest = 1;
}
else
{
LastRequest = db.inv_Requests.Max(item => item.RequestID);;
}
if (RequestType == 1)
{
OrderNumber = "POS" + DateTime.Now.ToString("yyyyMMdd") + (LastRequest + 1);
}
else if (RequestType == 2)
{
OrderNumber = "CUS" + DateTime.Now.ToString("yyyyMMdd") + (LastRequest + 1);
}
int[] ItemIDs = Array.ConvertAll(ItemIDArray.Split(','), int.Parse);
string[] Names = NamesArray.Split(',');
int[] ItemsSellPrice = Array.ConvertAll(ItemPriceArray.Split(','), int.Parse);
//int[] ItemspurchasePrice = Array.ConvertAll(ItempurchasePriceArray.Split(','), int.Parse);
int[] Quantities = Array.ConvertAll(QuantitiesArray.Split(','), int.Parse);
// ################################################ //
// Phase 1: Insert Sales Reciept (order) //
// ################################################ //
string constr = ConfigurationManager.ConnectionStrings["DBConnectionString"].ConnectionString;
using (SqlConnection con = new SqlConnection(constr))
{
using (SqlCommand cmd = new SqlCommand("inv_Insert_RequestOrder"))
{
var TotatItmesAmount = ItemsSellPrice.Sum();
var PointOfSaleID = Session["PointOfSaleID"];
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@RequestSourceTypeID", 1); // Point Of Sale Request
cmd.Parameters.AddWithValue("@RequestSourceID", RequestSourceID);
cmd.Parameters.AddWithValue("@RequestSourceName", ' ');
cmd.Parameters.AddWithValue("@RequestDestinationID", 0);
cmd.Parameters.AddWithValue("@RequestNo", OrderNumber);
cmd.Parameters.AddWithValue("@RequestTotalSaleAmount", TotatItmesAmount);
cmd.Parameters.AddWithValue("@RequestPaidAmount", 0);
cmd.Parameters.AddWithValue("@RequestRemaining", 0);
cmd.Connection = con;
con.Open();
cmd.ExecuteNonQuery();
con.Close();
}
}
// ################################################ //
// Phase 2: Insert Inventory Items Request //
// ################################################ //
using (SqlConnection con2 = new SqlConnection(constr))
{
for (int i = 0; i < Names.Length; i++)
{
using (SqlCommand cmd2 = new SqlCommand("inv_Insert_RequestItems"))
{
var name = Names[i];
var quantity = Quantities[i];
var amount = ItemsSellPrice[i];
var itemID = ItemIDs[i];
inv_Items inv_Items = db.inv_Items.SingleOrDefault(I => I.ItemID == itemID);
// var name = inv_Items.ItemNameAr;
var purchasePrice = inv_Items.ItemPuchasePrice;
var CategoryID = inv_Items.CategoryID;
var ItemSalePrice = inv_Items.ItemSalePrice;
var ItemPurshasePrice = inv_Items.ItemPuchasePrice;
cmd2.CommandType = CommandType.StoredProcedure;
cmd2.Parameters.AddWithValue("@RequestNo", OrderNumber);
cmd2.Parameters.AddWithValue("@ItemID", itemID);
cmd2.Parameters.AddWithValue("@ItemNameAr", name);
cmd2.Parameters.AddWithValue("@ItemQuantity", quantity);
cmd2.Parameters.AddWithValue("@ItemSalePrice", ItemSalePrice);
cmd2.Parameters.AddWithValue("@ItemPurshasePrice", ItemPurshasePrice);
cmd2.Parameters.AddWithValue("@CategoryID", CategoryID);
cmd2.Parameters.AddWithValue("@ItemTotalAmount", amount);
//cmd2.Parameters.AddWithValue("@ItemPurchasePrice", purchasePrice);
cmd2.Connection = con2;
con2.Open();
cmd2.ExecuteNonQuery();
con2.Close();
// Functions.Functions.InsertItemHistory(itemID, quantity,"Sales Credit",0,0,"Sales Credit");
// Functions.Functions.InsertSalesHistory(itemID, quantity, 0, amount, "Sales");
}
}
}
// ################################################ //
// Phase 3: Empty Sales Cart
// ################################################ //
using (SqlConnection con2 = new SqlConnection(constr))
{
using (SqlCommand cmd2 = new SqlCommand("inv_DeleteRequestCart"))
{
cmd2.CommandType = CommandType.StoredProcedure;
cmd2.Parameters.AddWithValue("@RequestType", RequestType);
cmd2.Connection = con2;
con2.Open();
cmd2.ExecuteNonQuery();
con2.Close();
}
}
return(Json(1));
}
