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);
}
