public JsonResult getCompanyActYearlyReport(string AccYear)
{
List <Jct_Asset_Dep_Asset_Slm_Cal> list = new List <Jct_Asset_Dep_Asset_Slm_Cal>();
if (!AccYear.Equals("null", StringComparison.InvariantCultureIgnoreCase))
{
using (SqlConnection con = DBConnection.getConnection())
{
string sql = "Jct_Asset_Dep_Slm_Yearly_Dep_Summary";
SqlCommand cmd = new SqlCommand(sql, con);
cmd.Parameters.AddWithValue("@AccYear", AccYear);
cmd.CommandType = CommandType.StoredProcedure;
SqlDataReader read = cmd.ExecuteReader();
if (read.HasRows)
{
while (read.Read())
{
Jct_Asset_Dep_Asset_Slm_Cal model = new Jct_Asset_Dep_Asset_Slm_Cal();
model.GroupCode = read["GroupCode"].ToString();
model.SubGroupCode = read["SubGroupCode"].ToString();
model.TotalAmount = (float)Convert.ToDouble(read["TotalAmount"].ToString());
model.TotalDepreciation = (float)Convert.ToDouble(read["TotalDepreciation"].ToString());
model.TotalOpeningBalance = (float)Convert.ToDouble(read["TotalOpeningBalance"].ToString());
model.TotalQuantity = (float)Convert.ToDouble(read["TotalQuantity"].ToString());
list.Add(model);
}
}
}
}
var jsonData = new{
records = list.Count,
rows = list
};
return(Json(jsonData, JsonRequestBehavior.AllowGet));
}
public ActionResult DepCalculation(ParentViewModel obj)
{
string msg = null;
string group_code = null;
if (obj.selectedGroupCode != null)
{
SqlConnection con = DBConnection.getConnection();
string sql = "Jct_Asset_Dep_Asset_IT_Cal_Proc";
SqlCommand cmd = new SqlCommand(sql, con);
cmd.CommandType = CommandType.StoredProcedure;
//cmd.Parameters.AddWithValue("@BookCode",HttpContext.User.)
cmd.Parameters.AddWithValue("@BookCode", User.book);
if (obj.selectedGroupCode != null)
{
List <string> li = obj.selectedGroupCode.Cast <string>().ToList();
group_code = string.Join(",", li.ToArray());
cmd.Parameters.AddWithValue("@GroupCodeCal", group_code);
}
SqlDataReader read = cmd.ExecuteReader();
List <Jct_Asset_Dep_Asset_Slm_Cal> list = new List <Jct_Asset_Dep_Asset_Slm_Cal>();
if (read.HasRows)
{
while (read.Read())
{
Jct_Asset_Dep_Asset_Slm_Cal model = new Jct_Asset_Dep_Asset_Slm_Cal();
model.Asset_Life = read["Asset Life (In Months)"].ToString();
model.AssetCode = read["AssetCode"].ToString();
model.Cost = float.Parse(read["Cost"].ToString());
model.Depriciation_Method = read["Depriciation Method"].ToString();
model.GroupCode = read["Group"].ToString();
model.Life_In_Days = Convert.ToInt32(read["Life In Days"].ToString());
//model.SalvageValue = Convert.ToInt32(Math.Round(Convert.ToDecimal(read["SalvageValue"].ToString()), 0));
model.SalvageValue = float.Parse(read["SalvageValue"].ToString());
//model.SlmValue = Convert.ToInt32(Math.Round(Convert.ToDecimal(read["SlmValue"].ToString()), 0));
model.SlmValue = float.Parse(read["SlmValue"].ToString());
model.Put_In_Use_Date = Convert.ToDateTime(read["Put_In_Use_Date"].ToString());
model.AccClDt = Convert.ToDateTime(read["AccClDt"].ToString());
model.AccDays = Convert.ToInt32(read["AccDays"].ToString());
model.DepPeriod = float.Parse(read["DepPeriod"].ToString());
model.DepAmount = float.Parse(read["DepAmount"].ToString());
model.AccYear = read["AccYear"].ToString();
model.AccDep = float.Parse(read["AccDep"].ToString());
model.Depriciation_Rate_Com = float.Parse(read["DepRate"].ToString());
//model.AccYear = read["AccYear"].ToString();
list.Add(model);
}
read.Close();
con.Close();
TempData["DepList"] = list;
}
}
else
{
SqlConnection con = DBConnection.getConnection();
string sql = "Jct_Asset_Dep_Asset_IT_Cal_Proc";
SqlCommand cmd = new SqlCommand(sql, con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@BookCode", User.book);
cmd.Parameters.AddWithValue("@GroupCodeCal", "");
SqlDataReader read = cmd.ExecuteReader();
List <Jct_Asset_Dep_Asset_Slm_Cal> list = new List <Jct_Asset_Dep_Asset_Slm_Cal>();
if (read.HasRows)
{
while (read.Read())
{
Jct_Asset_Dep_Asset_Slm_Cal model = new Jct_Asset_Dep_Asset_Slm_Cal();
model.Asset_Life = read["Asset Life (In Months)"].ToString();
model.AssetCode = read["AssetCode"].ToString();
model.Cost = float.Parse(read["Cost"].ToString());
model.Depriciation_Method = read["Depriciation Method"].ToString();
model.GroupCode = read["Group"].ToString();
model.Life_In_Days = Convert.ToInt32(read["Life In Days"].ToString());
//model.SalvageValue = Convert.ToInt32(Math.Round(Convert.ToDecimal(read["SalvageValue"].ToString()), 0));
model.SalvageValue = float.Parse(read["SalvageValue"].ToString());
model.SlmValue = (float)(read["SlmValue"] is DBNull ? 0.00 : float.Parse(read["SlmValue"].ToString()));
model.Put_In_Use_Date = Convert.ToDateTime(read["Put_In_Use_Date"].ToString());
//model.AccYear = read["AccYear"].ToString();
model.AccClDt = Convert.ToDateTime(read["AccClDt"].ToString());
model.AccDays = Convert.ToInt32(read["AccDays"].ToString());
model.DepPeriod = float.Parse(read["DepPeriod"].ToString());
model.DepAmount = float.Parse(read["DepAmount"].ToString());
model.AccYear = read["AccYear"].ToString();
model.AccDep = float.Parse(read["AccDep"].ToString());
model.Depriciation_Rate_Com = float.Parse(read["DepRate"].ToString());
list.Add(model);
}
read.Close();
con.Close();
TempData["DepList"] = list;
}
}
return(Json(msg = "Success", JsonRequestBehavior.AllowGet));
}
