public IEnumerable <IncomeOtherBreakdownTEMPModel> MPRDownloadBaseFintrakFinalManualTEMPusingparams(string status, string search) { List <IncomeOtherBreakdownTEMPModel> obuList = new List <IncomeOtherBreakdownTEMPModel>(); 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_TEMP where ApprovalStatus=@STATUS and " + "(MIS_Code like @searchval or Caption like @searchval or Accountnumber like @searchval or Caption like @searchval or " + "CustomerName like @searchval or AccountOfficerCode like @searchval or ProductCode like @searchval)"; cmd.Parameters.AddWithValue("@STATUS", status); cmd.Parameters.AddWithValue("@searchval", "%" + search + "%"); cmd.Parameters.AddWithValue("@TAKETOP", taketop); System.Data.SqlClient.SqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { var iob = new IncomeOtherBreakdownTEMPModel(); iob.ID = reader["ID"] != DBNull.Value ? int.Parse(reader["ID"].ToString()) : 0; iob.MIS_Code = reader["MIS_Code"] != DBNull.Value ? reader["MIS_Code"].ToString() : "default"; iob.Caption = reader["Caption"] != DBNull.Value ? reader["Caption"].ToString() : "default"; iob.Accountnumber = reader["Accountnumber"] != DBNull.Value ? reader["Accountnumber"].ToString() : "default"; iob.Narrative = reader["Narrative"] != DBNull.Value ? reader["Narrative"].ToString() : "default"; iob.CustomerName = reader["CustomerName"] != DBNull.Value ? reader["CustomerName"].ToString() : "default"; iob.Period = reader["Period"] != DBNull.Value ? int.Parse(reader["Period"].ToString()) : 0; iob.Year = reader["Year"] != DBNull.Value ? int.Parse(reader["Year"].ToString()) : 0; iob.Amount = reader["Amount"] != DBNull.Value ? decimal.Parse(reader["Amount"].ToString()) : 0; iob.AccountOfficer_Code = reader["AccountOfficer_Code"] != DBNull.Value ? reader["AccountOfficer_Code"].ToString() : "default"; //iob.Volume = reader["Volume"] != DBNull.Value ? decimal.Parse(reader["Volume"].ToString()) : 0; //iob.Indicator = reader["Indicator"] != DBNull.Value ? reader["Indicator"].ToString() : "default"; iob.EntryStatus = reader["EntryStatus"] != DBNull.Value ? reader["EntryStatus"].ToString() : "default"; iob.DateEntered = reader["DateEntered"] != DBNull.Value ? DateTime.Parse(reader["DateEntered"].ToString()) : DateTime.Parse("1000-01-01"); iob.ProductCode = reader["ProductCode"] != DBNull.Value ? reader["ProductCode"].ToString() : "default"; iob.RunDate = reader["DateEntered"] != DBNull.Value ? DateTime.Parse(reader["DateEntered"].ToString()) : DateTime.Parse("1000-01-01"); iob.GLName = reader["GLName"] != DBNull.Value ? reader["GLName"].ToString() : ""; iob.Tran_ID = reader["Tran_ID"] != DBNull.Value ? reader["Tran_ID"].ToString() : ""; iob.Tran_Date = reader["Tran_Date"] != DBNull.Value ? DateTime.Parse(reader["Tran_Date"].ToString()) : DateTime.Parse("1000-01-01"); obuList.Add(iob); } con.Close(); } return(obuList); }
//================ methods to call starts IncomeNewDetails ========================================== public IEnumerable <IncomeOtherBreakdownTEMPModel> IncomeNewDetailsTEMP(string status) { List <IncomeOtherBreakdownTEMPModel> obuList = new List <IncomeOtherBreakdownTEMPModel>(); 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 Income_IncomeNewDetails_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 iob = new IncomeOtherBreakdownTEMPModel(); iob.ID = reader["ID"] != DBNull.Value ? int.Parse(reader["ID"].ToString()) : 0; iob.MIS_Code = reader["MIS_Code"] != DBNull.Value ? reader["MIS_Code"].ToString() : ""; iob.Caption = reader["Caption"] != DBNull.Value ? reader["Caption"].ToString() : "default"; iob.Accountnumber = reader["Accountnumber"] != DBNull.Value ? reader["Accountnumber"].ToString() : ""; iob.Narrative = reader["Narrative"] != DBNull.Value ? reader["Narrative"].ToString() : ""; iob.CustomerName = reader["CustomerName"] != DBNull.Value ? reader["CustomerName"].ToString() : ""; iob.Period = reader["Period"] != DBNull.Value ? int.Parse(reader["Period"].ToString()) : 0; iob.Year = reader["Year"] != DBNull.Value ? int.Parse(reader["Year"].ToString()) : 0; iob.Amount = reader["Amount"] != DBNull.Value ? decimal.Parse(reader["Amount"].ToString()) : 0; iob.AccountOfficer_Code = reader["AccountOfficer_Code"] != DBNull.Value ? reader["AccountOfficer_Code"].ToString() : ""; //iob.Volume = reader["Volume"] != DBNull.Value ? decimal.Parse(reader["Volume"].ToString()) : 0; //iob.Indicator = reader["Indicator"] != DBNull.Value ? reader["Indicator"].ToString() : ""; iob.EntryStatus = reader["EntryStatus"] != DBNull.Value ? reader["EntryStatus"].ToString() : ""; iob.DateEntered = reader["DateEntered"] != DBNull.Value ? DateTime.Parse(reader["DateEntered"].ToString()) : DateTime.Parse("1000-01-01"); iob.ProductCode = reader["ProductCode"] != DBNull.Value ? reader["ProductCode"].ToString() : ""; iob.RunDate = reader["DateEntered"] != DBNull.Value ? DateTime.Parse(reader["DateEntered"].ToString()) : DateTime.Parse("1000-01-01"); iob.GLName = reader["GLName"] != DBNull.Value ? reader["GLName"].ToString() : ""; iob.Tran_ID = reader["Tran_ID"] != DBNull.Value ? reader["Tran_ID"].ToString() : ""; iob.Tran_Date = reader["Tran_Date"] != DBNull.Value ? DateTime.Parse(reader["Tran_Date"].ToString()) : DateTime.Parse("1000-01-01"); obuList.Add(iob); } con.Close(); } return(obuList); }