//================ methods to call starts IncomeNewDetails ========================================== public IEnumerable <MPRDownLoadBaseFintrakFinalMemoManualModel> MPRDownloadBaseFintrakFinalManualTEMP(string status) { List <MPRDownLoadBaseFintrakFinalMemoManualModel> obuList = new List <MPRDownLoadBaseFintrakFinalMemoManualModel>(); var taketop = ConfigurationManager.AppSettings["TakeTop"].ToString().ToUpper(); using (var con = new System.Data.SqlClient.SqlConnection(connectionString)) { var cmd = new System.Data.SqlClient.SqlCommand("", con); //cmd.CommandText = "select * from Names where Id=@Id"; //cmd.Parameters.AddWithValue("@Id", id); con.Open(); //cmd.CommandText = "select top @TAKETOP * from mpr_downloadBase_FintrakFinalManual where ApprovalStatus=@STATUS"; cmd.CommandText = "select top (@TAKETOP) * from mpr_downloadBase_FintrakFinalManual_TEMP where ApprovalStatus=@STATUS"; cmd.Parameters.AddWithValue("@STATUS", status); cmd.Parameters.AddWithValue("@TAKETOP", taketop); System.Data.SqlClient.SqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { var ddb = new MPRDownLoadBaseFintrakFinalMemoManualModel(); ddb.AccountNumber = reader["AccountNumber"] != DBNull.Value ? reader["AccountNumber"].ToString() : "default"; ddb.customername = reader["customername"] != DBNull.Value ? reader["customername"].ToString() : "default"; ddb.MIS_Code = reader["MIS_Code"] != DBNull.Value ? reader["MIS_Code"].ToString() : "default"; ddb.accountofficercode = reader["accountofficercode"] != DBNull.Value ? reader["accountofficercode"].ToString() : "default"; ddb.accountofficer = reader["accountofficer"] != DBNull.Value ? reader["accountofficer"].ToString() : "default"; ddb.ActualBalance = reader["ActualBalance"] != DBNull.Value ? decimal.Parse(reader["ActualBalance"].ToString()) : 0; ddb.AverageBalance = reader["AverageBalance"] != DBNull.Value ? decimal.Parse(reader["AverageBalance"].ToString()) : 0; //ddb.RevExp = reader["RevExp"] != DBNull.Value ? decimal.Parse(reader["RevExp"].ToString()) : 0; ddb.ProductCode = reader["ProductCode"] != DBNull.Value ? reader["ProductCode"].ToString() : "default"; ddb.Category = reader["Category"] != DBNull.Value ? reader["Category"].ToString() : "default"; ddb.Currency_Type = reader["Currency_Type"] != DBNull.Value ? reader["Currency_Type"].ToString() : "default"; ddb.Period = reader["Period"] != DBNull.Value ? int.Parse(reader["Period"].ToString()) : 0; ddb.Year = reader["Year"] != DBNull.Value ? int.Parse(reader["Year"].ToString()) : 0; //ddb.GL_Sub = reader["GL_Sub"] != DBNull.Value ? reader["GL_Sub"].ToString() : "default"; ddb.Refno = reader["Refno"] != DBNull.Value ? reader["Refno"].ToString() : "default"; ddb.PoolRate = reader["PoolRate"] != DBNull.Value ? decimal.Parse(reader["PoolRate"].ToString()) : 0; ddb.Caption = reader["Caption"] != DBNull.Value ? reader["Caption"].ToString() : "default"; //ddb.Category_Filter = reader["Category_Filter"] != DBNull.Value ? reader["Category_Filter"].ToString() : "default"; ddb.Currency_Code = reader["Currency_Code"] != DBNull.Value ? reader["Currency_Code"].ToString() : "default"; obuList.Add(ddb); } con.Close(); } return(obuList); }
} //========== end of the mtd public IEnumerable <Models.MPRDownLoadBaseFintrakFinalMemoManualModel> GetMPRDownloadBaseFintrakFinalManualUsingYearPeriod(int yr, int pr, string param) { param = param.Replace("FORWARDSLASHXTER", "/"); param = param.Replace("DOTXTER", "."); List <MPRDownLoadBaseFintrakFinalMemoManualModel> ddbList = new List <MPRDownLoadBaseFintrakFinalMemoManualModel>(); using (var con = new System.Data.SqlClient.SqlConnection(connectionString)) { var cmd = new System.Data.SqlClient.SqlCommand("spp_mprdownloadbasefintrakfinalmanualusingparams", con); cmd.CommandType = System.Data.CommandType.StoredProcedure; cmd.CommandTimeout = 0; //cmd.Parameters.Add("@result", System.Data.SqlDbType.TinyInt).Direction = System.Data.ParameterDirection.Output; cmd.Parameters.Add(new SqlParameter { ParameterName = "Year", Value = yr, }); cmd.Parameters.Add(new SqlParameter { ParameterName = "Period", Value = pr, }); cmd.Parameters.Add(new SqlParameter { ParameterName = "search", Value = param, }); con.Open(); //cmd.ExecuteNonQuery(); //cmd2.ExecuteNonQuery(); SqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { var ddb = new MPRDownLoadBaseFintrakFinalMemoManualModel(); ddb.ID = reader["ID"] != DBNull.Value ? int.Parse(reader["ID"].ToString()) : 0; ddb.AccountNumber = reader["AccountNumber"] != DBNull.Value ? reader["AccountNumber"].ToString() : "default"; ddb.customername = reader["customername"] != DBNull.Value ? reader["customername"].ToString() : "default"; //ddb.sbuCode = reader["sbuCode"] != DBNull.Value ? reader["sbuCode"].ToString() : "default"; ddb.MIS_Code = reader["MIS_Code"] != DBNull.Value ? reader["MIS_Code"].ToString() : "default"; ddb.accountofficercode = reader["accountofficercode"] != DBNull.Value ? reader["accountofficercode"].ToString() : "default"; ddb.accountofficer = reader["accountofficer"] != DBNull.Value ? reader["accountofficer"].ToString() : "default"; ddb.ActualBalance = reader["ActualBalance"] != DBNull.Value ? decimal.Parse(reader["ActualBalance"].ToString()) : 0; ddb.AverageBalance = reader["AverageBalance"] != DBNull.Value ? decimal.Parse(reader["AverageBalance"].ToString()) : 0; ddb.RevExp = reader["RevExp"] != DBNull.Value ? decimal.Parse(reader["RevExp"].ToString()) : 0; //ddb.interestRate = reader["interestRate"] != DBNull.Value ? decimal.Parse(reader["interestRate"].ToString()) : 0; ddb.ProductCode = reader["ProductCode"] != DBNull.Value ? reader["ProductCode"].ToString() : "default"; ddb.Category = reader["Category"] != DBNull.Value ? reader["Category"].ToString() : "default"; ddb.Currency_Type = reader["Currency_Type"] != DBNull.Value ? reader["Currency_Type"].ToString() : "default"; //ddb.postedDate = reader["postedDate"] != DBNull.Value ? DateTime.Parse(reader["postedDate"].ToString()) : DateTime.Parse("1000-01-01"); ddb.Period = reader["Period"] != DBNull.Value ? int.Parse(reader["Period"].ToString()) : 0; ddb.Year = reader["Year"] != DBNull.Value ? int.Parse(reader["Year"].ToString()) : 0; //ddb.EntryStatus = reader["EntryStatus"] != DBNull.Value ? reader["EntryStatus"].ToString() : "default"; ddb.GL_Sub = reader["GL_Sub"] != DBNull.Value ? reader["GL_Sub"].ToString() : "default"; ddb.Refno = reader["Refno"] != DBNull.Value ? reader["Refno"].ToString() : "default"; ddb.PoolRate = reader["PoolRate"] != DBNull.Value ? decimal.Parse(reader["PoolRate"].ToString()) : 0; //ddb.BankMaxRate = reader["BankMaxRate"] != DBNull.Value ? decimal.Parse(reader["BankMaxRate"].ToString()) : 0; //ddb.CustomerRating = reader["CustomerRating"] != DBNull.Value ? reader["CustomerRating"].ToString() : "default"; ddb.EffYield = reader["EffYield"] != DBNull.Value ? decimal.Parse(reader["EffYield"].ToString()) : 0; ddb.ExpRev = reader["ExpRev"] != DBNull.Value ? decimal.Parse(reader["ExpRev"].ToString()) : 0; ddb.Caption = reader["Caption"] != DBNull.Value ? reader["Caption"].ToString() : "default"; ddb.Category_Filter = reader["Category_Filter"] != DBNull.Value ? reader["Category_Filter"].ToString() : "default"; ddb.Currency_Code = reader["Currency_Code"] != DBNull.Value ? reader["Currency_Code"].ToString() : "default"; //ddb.Unit = reader["Unit"] != DBNull.Value ? reader["Unit"].ToString() : "default"; ddb.EntryDate = reader["Entry_Date"] != DBNull.Value ? DateTime.Parse(reader["Entry_Date"].ToString()) : DateTime.Parse("1000-01-01"); ddbList.Add(ddb); } con.Close(); } return(ddbList); } //========== end of the mtd