public AssetItemModel GetAssetItemById(int id)
{
AssetItemModel assetItemModel = new AssetItemModel();
using (SqlConnection con = new SqlConnection(_ConnectionString.Value.ConnectionString))
{
var query = " select AI.Id,AI.AssetCategoryId,AC.AssetCategoryName,AssetItemName,ShortName,Code,Brandname,Model,Picture,AI.Notes,CostPrice,AI.UnitId,U.UnitName,AI.TaxId,T.Taxname as Tax " +
" from AssetItem AI " +
" Inner Join Units U ON U.Id = AI.UnitId " +
" Inner Join Tax T ON T.Id = AI.TaxId " +
" Inner Join AssetCategory AC ON AC.Id = AI.AssetCategoryId " +
" Where AI.IsDeleted = 0 And AI.Id = " + id;
assetItemModel = con.Query <AssetItemModel>(query).FirstOrDefault();
}
return(assetItemModel);
}
public int InsertAssetItem(AssetItemModel assetItemModel)
{
int result = 0;
using (SqlConnection con = new SqlConnection(_ConnectionString.Value.ConnectionString))
{
CommonRepository commonRepository = new CommonRepository(_ConnectionString);
result = commonRepository.GetValidateUnique("AssetItem", "AssetItemName", assetItemModel.AssetItemName, assetItemModel.Id.ToString());
if (result > 0)
{
return(-1);
}
int MaxId = commonRepository.GetMaxId("AssetItem");
con.Open();
SqlTransaction sqltrans = con.BeginTransaction();
var query = "INSERT INTO AssetItem " +
"(AssetCategoryId,AssetItemName, ShortName, Code, Brandname, Model, Notes,CostPrice,UnitId,TaxId," +
" UserIdInserted, DateInserted,IsDeleted) " +
"Values " +
"(@AssetCategoryId,@AssetItemName, @ShortName,@Code, @Brandname, @Model,@Notes,@CostPrice,@UnitId,@TaxId," +
LoginInfo.Userid + ",GetUtcDate(),0);" +
" SELECT CAST(SCOPE_IDENTITY() as INT);";
result = con.Execute(query, assetItemModel, sqltrans, 0, System.Data.CommandType.Text);
if (result > 0)
{
sqltrans.Commit();
//CREATE ENTRY INTO INVETORY AS STOCK 0.00
query = " INSERT INTO INVENTORY (STOREID,AssetItemId,STOCKQTY,USERIDINSERTED,ISDELETED)" +
" Select S.ID as StoreId,FM.Id,0,1,0 from AssetItem FM CROSS JOIN STORE S " +
" WHERE FM.ID =" + MaxId;
result = con.Execute(query, assetItemModel, sqltrans, 0, System.Data.CommandType.Text);
string output = commonRepository.SyncTableStatus("AssetItem");
output = commonRepository.SyncTableStatus("Inventory");
}
else
{
sqltrans.Rollback();
}
}
return(result);
}
public ActionResult AssetItem(int?id)
{
AssetItemModel assetItemModel = new AssetItemModel();
if (UserRolePermissionForPage.Add == true || UserRolePermissionForPage.Edit == true)
{
if (id > 0)
{
assetItemModel = _iAssetItemService.GetAssetItemById(Convert.ToInt32(id));
}
assetItemModel.UnitList = _iDropDownService.GetUnitList();
assetItemModel.TaxList = _iDropDownService.GetTaxList();
assetItemModel.AssetCategoryList = _iDropDownService.GetAssetCategoryList();
return(View(assetItemModel));
}
else
{
return(RedirectToAction("NotFound", "Error"));
}
}
public int UpdateAssetItem(AssetItemModel assetItemModel)
{
int result = 0;
using (SqlConnection con = new SqlConnection(_ConnectionString.Value.ConnectionString))
{
CommonRepository commonRepository = new CommonRepository(_ConnectionString);
result = commonRepository.GetValidateUnique("AssetItem", "AssetItemName", assetItemModel.AssetItemName, assetItemModel.Id.ToString());
if (result > 0)
{
return(-1);
}
con.Open();
SqlTransaction sqltrans = con.BeginTransaction();
var query = "UPDATE AssetItem SET " +
"AssetCategoryId=@AssetCategoryId, " +
"AssetItemName=@AssetItemName, " +
"ShortName=@ShortName, " +
"Code=@Code, " +
"CostPrice=@CostPrice, " +
" Brandname = @Brandname," +
" Model =@Model ," +
"Notes=@Notes," +
"UnitId=@UnitId, " +
"TaxId=@TaxId, " +
"[UserIdUpdated] = " + LoginInfo.Userid + " " +
",[DateUpdated] = GetUtcDate() WHERE Id = @Id;";
result = con.Execute(query, assetItemModel, sqltrans, 0, System.Data.CommandType.Text);
if (result > 0)
{
sqltrans.Commit();
string output = commonRepository.SyncTableStatus("AssetItem");
}
else
{
sqltrans.Rollback();
}
return(result);
}
}
public ActionResult AssetItem(AssetItemModel assetItemModel)
{
if (assetItemModel.Id > 0)
{
var result = _iAssetItemService.UpdateAssetItem(assetItemModel);
if (result == -1)
{
ModelState.AddModelError("AssetItemName", "Asset item already exists");
return(View(assetItemModel));
}
ViewBag.Result = _locService.GetLocalizedHtmlString("EditSuccss");
}
else
{
var result = _iAssetItemService.InsertAssetItem(assetItemModel);
if (result == -1)
{
ModelState.AddModelError("AssetItemName", "Asset item already exists");
return(View(assetItemModel));
}
ViewBag.Result = _locService.GetLocalizedHtmlString("SaveSuccess");
}
return(RedirectToAction("Index", "AssetItem"));
}
public int UpdateAssetItem(AssetItemModel assetItemModel)
{
return(iAssetItemRepository.UpdateAssetItem(assetItemModel));
}
public int InsertAssetItem(AssetItemModel assetItemModel)
{
return(iAssetItemRepository.InsertAssetItem(assetItemModel));
}
