public bool InsertAssetTransfer(FA_AssetTransfer item)
{
string sql = " Insert into FA_AssetTransfer (AssetId,OrganizationId,BranchId,LocationId," +
" TransferDate,TransferDateBS,Remarks,AssignedTo,AssignedDate,IsReceived,ReceivedBy,ReceivedDate," +
" EnteredBy , EnteredDate , LastUpdatedBy , LastUpdatedDate , IsDeleted , DeletedBy , DeletedDate,IsTransfered,CategoryId) " +
" values (" +
"@AssetId,@OrganizationId, @BranchId, @LocationId , " +
" @TransferDate,@TransferDateBS,@Remarks,@AssignedTo,@AssignedDate,0,0,null," +
" @EnteredBy , @EnteredDate , 0 , null , 0 , 0 , null,@IsTransfered,@CategoryId)";
using (var db = DbHelper.GetDBConnection())
{
using (var trsn = new TransactionScope())
{
//db.Execute(sql);
var lst = db.Execute(sql, item);
trsn.Complete();
db.Close();
if (lst > 0)
{
return(true);
}
else
{
return(false);
}
}
}
}
public bool UpdateAssetTransfer(FA_AssetTransfer item)
{
string sql = " Update FA_AssetTransfer set AssetId=@AssetId,OrganizationId=@OrganizationId , BranchId=@BranchId ," +
" LocationId=@LocationId , LastUpdatedBy=@LastUpdatedBy , LastUpdatedDate=@LastUpdatedDate, Remarks=@Remarks, " +
" TransferDate=@TransferDate, TransferDateBS=@TransferDateBS, AssignedTo=@AssignedTo,AssignedDate=@AssignedDate" +
" where AssetTransferId= @AssetTransferId";
using (var db = DbHelper.GetDBConnection())
{
using (var trsn = new TransactionScope())
{
//db.Execute(sql);
var lst = db.Execute(sql, item);
trsn.Complete();
db.Close();
if (lst > 0)
{
return(true);
}
else
{
return(false);
}
}
}
}
public ActionResult Create(FormCollection frm)
{
var ses = sesrepo.GetSessionById((User as CustomPrincipal).UserId);
int orgid = ses.OrganizationId;
int uid = (User as CustomPrincipal).UserId;
FA_AssetTransfer item = new FA_AssetTransfer();
item.CategoryId = Convert.ToInt32(frm["CategoryId"]);
item.AssetId = Convert.ToInt32(frm["AssetItemId"]);
FA_Asset assetid1 = db.getAssetId(item.AssetId);
if (assetid1 != null)
{
int assetid = assetid1.AssetId;
}
item.OrganizationId = string.IsNullOrEmpty(frm["OrganizationId1"]) ? 0 : Convert.ToInt32(frm["OrganizationId1"]);
item.BranchId = string.IsNullOrEmpty(frm["BranchId1"]) ? 0 : Convert.ToInt32(frm["BranchId1"]);
item.LocationId = string.IsNullOrEmpty(frm["LocationId1"]) ? 0 : Convert.ToInt32(frm["LocationId1"]);
item.TransferDate = DateTime.ParseExact(frm["TransferDate"], "yyyy-MM-dd", null);
item.TransferDateBS = frm["TransferDateBS"];
item.Remarks = frm["Remarks"];
item.AssignedTo = Convert.ToInt32(frm["AssignedToID"]);
item.AssignedDate = DateTime.ParseExact(frm["AssignedDate"], "yyyy-MM-dd", null);
item.IsReceived = null;
item.ReceivedBy = null;
item.ReceivedDate = null;
item.EnteredBy = uid;
item.EnteredDate = DateTime.Now;
item.LastUpdatedBy = null;
item.LastUpdatedDate = null;
item.IsDeleted = false;
item.DeletedBy = null;
item.DeletedDate = null;
//item.TransferId = 0;
item.IsTransfered = 0;
if (ModelState.IsValid)
{
db.InsertAssetTransfer(item);
AssetTransferVM assetTransid = db.GetAssetTransferId();
int assetTraId = assetTransid.AssetTransferId;
int assetId = assetTransid.AssetId;
db.UpdateAsset(assetTraId, assetId);
AssetTransferVM PrevAssetTraId = db.GetAssetTransferSecondLastValue(assetTraId, assetId);
if (PrevAssetTraId != null)
{
int PrevAssetTransferId = PrevAssetTraId.AssetTransferId;
assetId = PrevAssetTraId.AssetId;
db.UpdateAssetTransfer(PrevAssetTransferId, assetId, assetTraId);
}
return(RedirectToAction("Index"));
}
ViewBag.OrganizationId = new SelectList(ddl.GetOrganizationList(), "Id", "Name", item.OrganizationId);
//ViewBag.AssetItemId = new SelectList(ddl.GetAssetItemList(orgid), "Id", "Name", item.AssetItemId);
ViewBag.BranchId = new SelectList(ddl.GetBranchList(orgid), "Id", "Name", item.BranchId);
ViewBag.LocationId = new SelectList(ddl.GetLocationList(orgid), "Id", "Name", item.LocationId);
//ViewBag.AccessoryForAssetId = new SelectList(ddl.GetAssetList(orgid), "Id", "Name", item.AccessoryForAssetId);
return(View(item));
}
public ActionResult Edit(FormCollection frm)
{
var ses = sesrepo.GetSessionById((User as CustomPrincipal).UserId);
int orgid = ses.OrganizationId;
FA_AssetTransfer item = db.GetAssetTransferById(Convert.ToInt32(frm["AssetTransferId"]));
item.AssetTransferId = Convert.ToInt32(frm["AssetTransferId"]);
item.CategoryId = Convert.ToInt32(frm["CategoryId"]);
item.AssetId = string.IsNullOrEmpty(frm["AssetId"]) ? 0 : Convert.ToInt32(frm["AssetId"]);
int assetItemId = Convert.ToInt32(frm["AssetItemId"]);
item.OrganizationId = string.IsNullOrEmpty(frm["OrganizationId"]) ? 0 : Convert.ToInt32(frm["OrganizationId"]);
item.BranchId = string.IsNullOrEmpty(frm["BranchId"]) ? 0 : Convert.ToInt32(frm["BranchId"]);
item.LocationId = string.IsNullOrEmpty(frm["LocationId"]) ? 0 : Convert.ToInt32(frm["LocationId"]);
item.TransferDate = DateTime.ParseExact(frm["TransferDate"], "yyyy-MM-dd", null);
item.TransferDateBS = frm["TransferDateBS"];
item.Remarks = frm["Remarks"];
item.AssignedTo = Convert.ToInt32(frm["FullName"]);
item.AssignedDate = DateTime.ParseExact(frm["AssignedDate"], "yyyy-MM-dd", null);
item.IsDeleted = false;
item.LastUpdatedBy = (User as CustomPrincipal).UserId;
item.LastUpdatedDate = DateTime.Now;
if (ModelState.IsValid)
{
db.updateAssetForAssetItem(item.AssetId, assetItemId);
db.UpdateAssetTransfer(item);
return(RedirectToAction("Index"));
}
//ViewBag.OrganizationId = new SelectList(ddl.GetOrganizationList(), "Id", "Name", item.OrganizationId);
//ViewBag.CategoryId = new SelectList(ddl.GetAssetCategoryList(orgid), "Id", "Name", item.CategoryId);
//ViewBag.AssetItemId = new SelectList(ddl.GetAssetItemList(orgid), "Id", "Name", item.AssetItemId);
//ViewBag.BranchId = new SelectList(ddl.GetBranchList(item.OrganizationId), "Id", "Name", item.BranchId);
//ViewBag.LocationId = new SelectList(ddl.GetLocationList(item.OrganizationId), "Id", "Name", item.LocationId);
//ViewBag.FullName = new SelectList(ddl.GetUserList(item.OrganizationId), "Id", "Name", item.UserId);
return(View(item));
}
