/// <summary>
/// Updates the Depreciation previously set for selected Purchased Asset ID on particular date
/// </summary>
/// <param name="sdfvm"></param>
/// <returns>Rollback Flag 1 or 0</returns>
public int UpdateSetDepreciationForIndividual(SetDepreciationFirstViewModel sdfvm)
{
var rollbackFlag = 0;
using (SqlConnection con = new SqlConnection(TableConstant.CONNECTION_STRING))
{
using (SqlCommand cmd = new SqlCommand("dbo.usp_UpdateSetDepreciationForIndividual"))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Connection = con;
cmd.Parameters.AddWithValue("@AssetPurchaseId", sdfvm.AssetPurchaseId);
cmd.Parameters.AddWithValue("@DepreciationType", sdfvm.DepreciationType);
cmd.Parameters.AddWithValue("@CurrentYear", sdfvm.CurrentYear);
cmd.Parameters.AddWithValue("@DepreciationRate", sdfvm.DepreciationRate);
cmd.Parameters.AddWithValue("@RateStatus", sdfvm.RateStatus);
var returnParameter = cmd.Parameters.Add("@RollBackFlag", SqlDbType.Int);
returnParameter.Direction = ParameterDirection.ReturnValue;
con.Open();
cmd.ExecuteNonQuery();
con.Close();
rollbackFlag = (int)returnParameter.Value;
}
}
return(rollbackFlag);
}
public ActionResult SetDepreciationRate(long id, FormCollection fc) //id => AssetPurchaseId
{
//Check if Depreciation Rate exists for Purchase ID (edit purpose)
var depnRateObj = _repDepreciation.GetDepreciationRate(id);
decimal existingDepnRate = (depnRateObj != null) ? depnRateObj.Rate : 0;
string existingDepnType = (depnRateObj != null) ? depnRateObj.DepreciationType : "";
var purchaseNo = _repPurchaseAsset.GetAssetPurchaseDetails()
.Where(x => x.Id == id)
.SingleOrDefault().PurchaseNo;
ViewBag.Title = String.Concat(Constant.SET_DEPRECIATION_RATE, " for ", purchaseNo);
var sdfvm = new SetDepreciationFirstViewModel()
{
DepreciationRate = Decimal.Parse(fc["formValue[DepreciationRate]"]),
AssetPurchaseId = id,
DepreciationType = fc["formValue[DepreciationType]"],
CurrentYear = DateTime.Now.Year.ToString(),
RateStatus = 1,
DepreciationEntryDate = DateTime.Now
};
int isDepreciated = 0;
if (depnRateObj == null)
{
//Creates/Sets Depreciation rate for individual purchase Id
isDepreciated = _repDepreciation.SetDepreciationForIndividual(sdfvm);
}
else
{
//Updates/Sets Depreciation rate for individual purchase Id
isDepreciated = _repDepreciation.UpdateSetDepreciationForIndividual(sdfvm);
}
var json = JsonConvert.SerializeObject(sdfvm);
return(Json(json));
}