public DataBaseResultSet SaveBranchStock <T>(T objData) where T : class, IModel, new()
{
BranchStock obj = objData as BranchStock;
string sQuery = "sprocBranchStockInsertUpdateSingleItem";
List <DbParameter> list = new List <DbParameter>();
list.Add(SqlConnManager.GetConnParameters("RecNo", "RecNo", 8, GenericDataType.Long, ParameterDirection.Input, obj.RecNo));
list.Add(SqlConnManager.GetConnParameters("BranchName", "BranchName", 50, GenericDataType.String, ParameterDirection.Input, obj.BranchName));
list.Add(SqlConnManager.GetConnParameters("ProductCode", "ProductCode", 8, GenericDataType.Long, ParameterDirection.Input, obj.ProductCode));
list.Add(SqlConnManager.GetConnParameters("PartyPrdCode", "PartyPrdCode", 8, GenericDataType.Long, ParameterDirection.Input, obj.PartyPrdCode));
list.Add(SqlConnManager.GetConnParameters("ProductName", "ProductName", 50, GenericDataType.String, ParameterDirection.Input, obj.ProductName));
list.Add(SqlConnManager.GetConnParameters("Packing", "Packing", 50, GenericDataType.String, ParameterDirection.Input, obj.Packing));
list.Add(SqlConnManager.GetConnParameters("CompanyTag", "CompanyTag", 50, GenericDataType.String, ParameterDirection.Input, obj.CompanyTag));
list.Add(SqlConnManager.GetConnParameters("RackID", "RackID", 50, GenericDataType.String, ParameterDirection.Input, obj.RackID));
list.Add(SqlConnManager.GetConnParameters("TStk", "TStk", 8, GenericDataType.Decimal, ParameterDirection.Input, obj.TStk));
list.Add(SqlConnManager.GetConnParameters("Scheme", "Scheme", 8, GenericDataType.Decimal, ParameterDirection.Input, obj.Scheme));
list.Add(SqlConnManager.GetConnParameters("SQty", "SQty", 8, GenericDataType.Decimal, ParameterDirection.Input, obj.SQty));
list.Add(SqlConnManager.GetConnParameters("SFQty", "SFQty", 8, GenericDataType.Decimal, ParameterDirection.Input, obj.SFQty));
list.Add(SqlConnManager.GetConnParameters("CUser", "CUser", 8, GenericDataType.Long, ParameterDirection.Input, obj.CUser));
list.Add(SqlConnManager.GetConnParameters("CDateTime", "CDateTime", 8, GenericDataType.DateTime, ParameterDirection.Input, obj.CDateTime));
list.Add(SqlConnManager.GetConnParameters("EUser", "EUser", 8, GenericDataType.Long, ParameterDirection.Input, obj.EUser));
list.Add(SqlConnManager.GetConnParameters("EDateTime", "EDateTime", 8, GenericDataType.DateTime, ParameterDirection.Input, obj.EDateTime));
list.Add(SqlConnManager.GetConnParameters("BranchCode", "BranchCode", 10, GenericDataType.String, ParameterDirection.Input, obj.BranchCode));
list.Add(SqlConnManager.GetConnParameters("UDateTime", "UDateTime", 8, GenericDataType.DateTime, ParameterDirection.Input, obj.UDateTime));
list.Add(SqlConnManager.GetConnParameters("CreatedBy", "CreatedBy", 50, GenericDataType.String, ParameterDirection.Input, obj.CreatedBy));
list.Add(SqlConnManager.GetConnParameters("CreatedDate", "CreatedDate", 8, GenericDataType.DateTime, ParameterDirection.Input, obj.CreatedDate));
list.Add(SqlConnManager.GetConnParameters("UpdateddBy", "UpdateddBy", 50, GenericDataType.String, ParameterDirection.Input, obj.UpdateddBy));
list.Add(SqlConnManager.GetConnParameters("UpdatedDate", "UpdatedDate", 8, GenericDataType.DateTime, ParameterDirection.Input, obj.UpdatedDate));
list.Add(SqlConnManager.GetConnParameters("UpdatedCount", "UpdatedCount", 4, GenericDataType.Int, ParameterDirection.Input, obj.UpdatedCount));
list.Add(SqlConnManager.GetConnParameters("LUT", "LUT", 8, GenericDataType.DateTime, ParameterDirection.Input, obj.LUT));
list.Add(SqlConnManager.GetConnParameters("OperationFlag", "OperationFlag", 4, GenericDataType.Int, ParameterDirection.Input, (short)obj.OperationFlag));
list.Add(SqlConnManager.GetConnParameters("Message", "Message", 300, GenericDataType.String, ParameterDirection.Output, null));
list.Add(SqlConnManager.GetConnParameters("ErrorCode", "ErrorCode", 4, GenericDataType.Int, ParameterDirection.Output, null));
return(SqlConnManager.Save(sQuery, CommandType.StoredProcedure, list.ToArray()));
}
public ActionResult SaveStocks(BranchStock bs)
{
if (bs.Id > 0)
{
BranchStockHandler.Update(bs.Id, bs);
db.SaveChanges();
return(RedirectToAction("ListStocks"));
}
else
{
bs.BranchID = Convert.ToInt32(Session["Branchid"]);
var bsdata = db.BranchStocks.Where(m => m.ItemID == bs.ItemID & m.BranchID == bs.BranchID).FirstOrDefault();
if (bsdata != null)
{
bsdata.Quantity = bsdata.Quantity + bs.Quantity;
db.SaveChanges();
}
else
{
var dta = db.inventryItems.Where(m => m.id == bs.ItemID).FirstOrDefault();
int count = Convert.ToInt32(dta.TotalQuantity);
dta.TotalQuantity = count + bs.Quantity;
bs.BranchID = Convert.ToInt32(Session["Branchid"]);
bs.CreatedBy = (Session["BranchAdminname"]).ToString();
db.BranchStocks.Add(bs);
db.SaveChanges();
}
return(RedirectToAction("ListStocks"));
}
}
public void GetListBranchStock <T>(T objFilter, ref List <T> listData) where T : class, IModel, new()
{
string sQuery = "GetListBranchStock";
BranchStock objData = objFilter as BranchStock;
List <DbParameter> list = new List <DbParameter>();
list.Add(SqlConnManager.GetConnParameters("RecNo", "RecNo", 8, GenericDataType.Long, ParameterDirection.Input, objData.RecNo));
SqlConnManager.GetList <T>(sQuery, CommandType.StoredProcedure, list.ToArray(), FillBranchStockDataFromReader, ref listData);
}
public static void Update(int id, BranchStock bs)
{
ServicesPortalApiEntities db = new ServicesPortalApiEntities();
var data = db.BranchStocks.Where(m => m.Id == id).FirstOrDefault();
data.Quantity = bs.Quantity;
data.ItemID = bs.ItemID;
db.SaveChanges();
}
public ActionResult IssueItemSave(Issue iss)
{
if (iss.IssuedQuantity < 0)
{
return(Content("minus"));
}
else
{
iss.BranchID = Convert.ToInt32(Session["Branchid"]);
iss.ItemID = Convert.ToInt32(Session["IssueItemId"]);
iss.CreatedBy = (Session["BranchAdminname"]).ToString();
iss.CreatedOn = DateTime.Now;
iss.IssuedBy = (Session["BranchAdminname"]).ToString();
iss.IssuedOn = DateTime.Now;
var data = db.BranchStocks.Where(m => m.ItemID == iss.ItemID & m.BranchID == iss.BranchID).FirstOrDefault();
if (data != null)
{
if (data.Quantity >= iss.IssuedQuantity)
{
data.Quantity = data.Quantity - Convert.ToInt32(iss.IssuedQuantity);
db.Issues.Add(iss);
db.SaveChanges();
var dta = db.BranchStocks.Where(m => m.BranchID == iss.IssuedBranchID & m.ItemID == iss.ItemID).FirstOrDefault();
if (dta != null)
{
dta.Quantity = dta.Quantity + Convert.ToInt32(iss.IssuedQuantity);
db.SaveChanges();
}
else
{
BranchStock bs = new BranchStock()
{
Quantity = Convert.ToInt32(iss.IssuedQuantity),
ItemID = iss.ItemID,
BranchID = iss.IssuedBranchID,
CreatedBy = iss.CreatedBy,
};
db.BranchStocks.Add(bs);
db.SaveChanges();
return(Content("NoItemInstock"));
//TempData["qunaty"] = "Branch Not have this item in stock";
}
}
else
{
return(Content("NoQuantityToIssue"));
//TempData["qunaty"] = "You have not enough quantity to issue";
}
}
return(RedirectToAction("IssueItems"));
}
}
private void FillBranchStockDataFromReader <T>(DbDataReader DbReader, ref List <T> listData) where T : class, IModel, new()
{
while (DbReader.Read())
{
T obj = new T();
BranchStock objData = obj as BranchStock;
obj.FillDataFromDB(DbReader);
listData.Add(obj);
}
}
public ActionResult ReturnItemSave(ReturnItem rt)
{
if (rt.QuantityReturn < 0)
{
return(Content("minus"));
}
else
{
rt.BranchID = Convert.ToInt32(Session["Branchid"]);
rt.ItemID = Convert.ToInt32(Session["returnItemID"]);
rt.CreatedBy = (Session["BranchAdminname"]).ToString();
rt.CreatedOn = DateTime.Now;
rt.ReturnBy = (Session["BranchAdminname"]).ToString();
rt.ReturnedOn = DateTime.Now;
var data = db.Issues.Where(m => m.ItemID == rt.ItemID & (m.BranchID == rt.BranchID || m.CustomerID == rt.CustomerID)).FirstOrDefault();
if (data != null)
{
var dta = db.BranchStocks.Where(m => m.ItemID == rt.ItemID & m.BranchID == rt.BranchID).FirstOrDefault();
if (dta != null)
{
dta.Quantity = dta.Quantity + Convert.ToInt32(rt.QuantityReturn); db.SaveChanges();
db.ReturnItems.Add(rt);
db.SaveChanges();
return(Content("returnitem"));
}
else
{
BranchStock bs = new BranchStock()
{
ItemID = rt.ItemID,
BranchID = rt.BranchID,
Quantity = Convert.ToInt32(rt.QuantityReturn),
CreatedBy = rt.CreatedBy
};
db.BranchStocks.Add(bs);
db.ReturnItems.Add(rt);
db.SaveChanges();
return(Content("rtrn"));
}
}
else
{
return(Content("noitem"));
//TempData["qunaty"] = "You have not enough quantity to issue";
}
}
//return RedirectToAction("IssueItems");
}
public ActionResult PurchaseSave(Receipt rec)
{
//double AvgPurchasePrice;
var InventryItemDetail = db.inventryItems.Where(m => m.id == rec.ItemID).FirstOrDefault();
double AvgCurrentPrice = rec.ReceiptPrice / rec.ReceiptQuantity;
if (InventryItemDetail != null)
{
if (InventryItemDetail.AvgPurchasePrice > 0)
{
InventryItemDetail.AvgPurchasePrice = (Convert.ToDouble(InventryItemDetail.AvgPurchasePrice) + AvgCurrentPrice) / 2;
InventryItemDetail.LastPurchasePrice = AvgCurrentPrice;
db.SaveChanges();
}
else
{
InventryItemDetail.AvgPurchasePrice = AvgCurrentPrice;
InventryItemDetail.LastPurchasePrice = AvgCurrentPrice;
db.SaveChanges();
}
}
Session["check"] = 0;
rec.BranchID = Convert.ToInt32(Session["Branchid"]);
BranchStock bs = new BranchStock()
{
Quantity = Convert.ToInt32(rec.ReceiptQuantity),
BranchID = rec.BranchID,
ItemID = rec.ItemID,
CreatedBy = Session["BranchAdminname"].ToString()
};
var data = db.BranchStocks.Where(m => m.BranchID == rec.BranchID & m.ItemID == rec.ItemID).FirstOrDefault();
if (data != null)
{
Session["check"] = 1;
data.Quantity = data.Quantity + Convert.ToInt32(rec.ReceiptQuantity);
db.SaveChanges();
}
string path = null;
if (Request.Files != null && Request.Files.Count > 0)
{
foreach (string f in Request.Files)
{
HttpPostedFileBase file = Request.Files[f];
if (file.FileName == "")
{
path = "/Files/user.jpg";
}
else
{
string webpath = "/Files/" + DateTime.Now.Ticks + file.FileName.Substring(file.FileName.LastIndexOf("."));
file.SaveAs(Request.MapPath(webpath)); //physical path is required to save a file
path = webpath;
}
}
}
rec.ReceiptDocument = path;
rec.ReceivedBy = Session["BranchAdminname"].ToString();
rec.ReceivedOn = DateTime.Now;
rec.CreatedBy = Session["BranchAdminname"].ToString();
rec.CreateOn = DateTime.Now;
int check = Convert.ToInt32(Session["check"]);
if (check == 0)
{
db.BranchStocks.Add(bs);
}
db.Receipts.Add(rec);
db.SaveChanges();
return(RedirectToAction("PurchaseItems"));
}
