public Models.OpexStaffExpDiffModel GetOpexStaffExpDiffMtd(int id) { // List<int> IDs_of_currentSubCaptions = (List<int>)System.Web.HttpContext.Current.Session["IDs_of_currentSubCaptionsOtherInfo"]; //List<int> IDs_of_currentSubCaptions = (List<int>)System.Web.HttpContext.Current.Session["IDs_of_currentSubCaptionsOtherInfo"]; List <OpexStaffExpDiffModel> op = (List <OpexStaffExpDiffModel>)System.Web.HttpContext.Current.Session["opexstaffexpdiff"]; OpexStaffExpDiffModel opObj = op.Where(x => x.ID == id).FirstOrDefault(); return(opObj); }
public HttpResponseMessage GetOpexRawExpense(HttpRequestMessage request, int id) { return(GetHttpResponse(request, () => { HttpResponseMessage res = null; //OpexStaffExpDiffModel opobj = new OpexStaffExpDiffModel(); OpexMtd obj = new OpexMtd(); OpexStaffExpDiffModel opObj = obj.GetOpexStaffExpDiffMtd(id); res = request.CreateResponse(HttpStatusCode.OK, opObj); return res; })); }
public IEnumerable <Models.OpexStaffExpDiffModel> GetTopOpexStaffExpDiffMtd() { List <OpexStaffExpDiffModel> opexstaffexpdiffList = new List <OpexStaffExpDiffModel>(); using (var con = new System.Data.SqlClient.SqlConnection(connectionString)) { var cmd = new System.Data.SqlClient.SqlCommand("spp_proc_ExpenseGLR", con); cmd.CommandType = System.Data.CommandType.StoredProcedure; cmd.CommandTimeout = 0; con.Open(); SqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { var op = new OpexStaffExpDiffModel(); //op.OPEX_STAFFEXP_DIFF_Id = reader["OPEX_STAFFEXP_DIFF_Id"] != DBNull.Value ? int.Parse(reader["OPEX_STAFFEXP_DIFF_Id"].ToString()) : 0; //op.Salary_BranchCode = reader["Salary_BranchCode"] != DBNull.Value ? reader["Salary_BranchCode"].ToString() : "default"; //op.RawExpense_BranchCode = reader["RawExpense_BranchCode"] != DBNull.Value ? reader["RawExpense_BranchCode"].ToString() : "default"; //op.SalaryAMount = reader["SalaryAMount"] != DBNull.Value ? double.Parse(reader["SalaryAMount"].ToString()) : 0; //op.RawExpenseAmount = reader["RawExpenseAmount"] != DBNull.Value ? double.Parse(reader["RawExpenseAmount"].ToString()) : 0; //op.Differences = reader["Differences"] != DBNull.Value ? double.Parse(reader["Differences"].ToString()) : 0; op.ID = reader["ID"] != DBNull.Value ? int.Parse(reader["ID"].ToString()) : 0; op.GL_Code = reader["GL_Code"] != DBNull.Value ? reader["GL_Code"].ToString() : "null"; op.GL_Description = reader["GL_Description"] != DBNull.Value ? reader["GL_Description"].ToString() : "null"; op.FinstatAmount = reader["FinstatAmount"] != DBNull.Value ? double.Parse(reader["FinstatAmount"].ToString()) : 0; op.OpexAmount = reader["OpexAmount"] != DBNull.Value ? double.Parse(reader["OpexAmount"].ToString()) : 0; op.Difference = reader["Difference"] != DBNull.Value ? double.Parse(reader["Difference"].ToString()) : 0; opexstaffexpdiffList.Add(op); } con.Close(); System.Web.HttpContext.Current.Session["opexstaffexpdiff"] = opexstaffexpdiffList; } return(opexstaffexpdiffList); } //========== end of the mtd