public static List <clsSwitchFee> computePerSwitchFeeReport(int intIFA_ID, string strStartDate, string strEndDate)
{
List <clsSwitchFee> oSwitchFeeList = new List <clsSwitchFee>();
decimal dTotalFee = 0;
SqlConnection con = new clsSystem_DBConnection(clsSystem_DBConnection.strConnectionString.NavIntegrationDB).propConnection;
SqlCommand cmd = new SqlCommand();
SqlDataReader dr;
con.Open();
cmd.Connection = con;
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.CommandText = "SWITCH_FeeReportGet";
cmd.Parameters.Add("@param_intIFA_ID", System.Data.SqlDbType.Int).Value = intIFA_ID;
cmd.Parameters.Add("@param_StartDate", System.Data.SqlDbType.NVarChar).Value = strStartDate;
cmd.Parameters.Add("@param_EndDate", System.Data.SqlDbType.NVarChar).Value = strEndDate;
dr = cmd.ExecuteReader();
while (dr.Read())
{
clsSwitchFee oSwitchFee = new clsSwitchFee();
//oSwitchFee.propSwitches = Array.ConvertAll(dr["Switches"].ToString().Split(','), s => int.Parse(s));
oSwitchFee.propSwitches = dr["Switches"].ToString();
oSwitchFee.propIFA_ID = (int)dr["IFA_ID"];
oSwitchFee.propIFA_Name = dr["IFA_Name"].ToString();
oSwitchFee.propPer_Switch_Fee = (decimal)dr["Per_Switch_Fee"];
oSwitchFee.propQuantity = (int)dr["Quantity"];
oSwitchFee.propStartDate = DateTime.Parse(dr["StartDate"].ToString());
oSwitchFee.propEndDate = DateTime.Parse(dr["EndDate"].ToString());
dTotalFee = dTotalFee + oSwitchFee.propFees_Due;
oSwitchFee.propTotal_Fee = dTotalFee;
oSwitchFeeList.Add(oSwitchFee);
}
return(oSwitchFeeList);
}
public static List <clsSwitchFee> getSwitchFeeList()
{
List <clsSwitchFee> oSwitchFeeList = new List <clsSwitchFee>();
SqlConnection con = new clsSystem_DBConnection(clsSystem_DBConnection.strConnectionString.NavIntegrationDB).propConnection;
SqlCommand cmd = new SqlCommand();
SqlDataReader dr;
con.Open();
cmd.Connection = con;
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.CommandText = "SWITCH_FeeGet";
cmd.Parameters.Add("@param_intIFA_ID", System.Data.SqlDbType.Int).Value = 0;
dr = cmd.ExecuteReader();
while (dr.Read())
{
clsSwitchFee oSwitchFee = new clsSwitchFee();
oSwitchFee.propIFA_ID = dr["IFA_ID"] == System.DBNull.Value ? 0 : int.Parse(dr["IFA_ID"].ToString());
oSwitchFee.propIFA_Name = dr["IFA_Username"] == System.DBNull.Value ? string.Empty : dr["IFA_Username"].ToString();
oSwitchFee.propAnnual_Fee = dr["Annual_Fee"] == System.DBNull.Value ? 0 : decimal.Parse(dr["Annual_Fee"].ToString());
oSwitchFee.propPer_Switch_Fee = dr["Per_Switch_Fee"] == System.DBNull.Value ? 0 : decimal.Parse(dr["Per_Switch_Fee"].ToString());
oSwitchFee.propAccess_Denied = dr["Access_Denied"] == System.DBNull.Value ? false : bool.Parse(dr["Access_Denied"].ToString());
oSwitchFeeList.Add(oSwitchFee);
}
dr.Close();
cmd.Dispose();
con.Close();
con.Dispose();
return(oSwitchFeeList);
}
public static List<clsSwitchFee> getSwitchFeeList()
{
List<clsSwitchFee> oSwitchFeeList = new List<clsSwitchFee>();
SqlConnection con = new clsSystem_DBConnection(clsSystem_DBConnection.strConnectionString.NavIntegrationDB).propConnection;
SqlCommand cmd = new SqlCommand();
SqlDataReader dr;
con.Open();
cmd.Connection = con;
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.CommandText = "SWITCH_FeeGet";
cmd.Parameters.Add("@param_intIFA_ID", System.Data.SqlDbType.Int).Value = 0;
dr = cmd.ExecuteReader();
while (dr.Read())
{
clsSwitchFee oSwitchFee = new clsSwitchFee();
oSwitchFee.propIFA_ID = dr["IFA_ID"] == System.DBNull.Value ? 0 : int.Parse(dr["IFA_ID"].ToString());
oSwitchFee.propIFA_Name = dr["IFA_Username"] == System.DBNull.Value ? string.Empty : dr["IFA_Username"].ToString();
oSwitchFee.propAnnual_Fee = dr["Annual_Fee"] == System.DBNull.Value ? 0 : decimal.Parse(dr["Annual_Fee"].ToString());
oSwitchFee.propPer_Switch_Fee = dr["Per_Switch_Fee"] == System.DBNull.Value ? 0 : decimal.Parse(dr["Per_Switch_Fee"].ToString());
oSwitchFee.propAccess_Denied = dr["Access_Denied"] == System.DBNull.Value ? false : bool.Parse(dr["Access_Denied"].ToString());
oSwitchFeeList.Add(oSwitchFee);
}
dr.Close();
cmd.Dispose();
con.Close();
con.Dispose();
return oSwitchFeeList;
}
public static List<clsSwitchFee> computePerSwitchFeeReport(int intIFA_ID, string strStartDate, string strEndDate)
{
List<clsSwitchFee> oSwitchFeeList = new List<clsSwitchFee>();
decimal dTotalFee = 0;
SqlConnection con = new clsSystem_DBConnection(clsSystem_DBConnection.strConnectionString.NavIntegrationDB).propConnection;
SqlCommand cmd = new SqlCommand();
SqlDataReader dr;
con.Open();
cmd.Connection = con;
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.CommandText = "SWITCH_FeeReportGet";
cmd.Parameters.Add("@param_intIFA_ID", System.Data.SqlDbType.Int).Value = intIFA_ID;
cmd.Parameters.Add("@param_StartDate", System.Data.SqlDbType.NVarChar).Value = strStartDate;
cmd.Parameters.Add("@param_EndDate", System.Data.SqlDbType.NVarChar).Value = strEndDate;
dr = cmd.ExecuteReader();
while (dr.Read())
{
clsSwitchFee oSwitchFee = new clsSwitchFee();
//oSwitchFee.propSwitches = Array.ConvertAll(dr["Switches"].ToString().Split(','), s => int.Parse(s));
oSwitchFee.propSwitches = dr["Switches"].ToString();
oSwitchFee.propIFA_ID = (int)dr["IFA_ID"];
oSwitchFee.propIFA_Name = dr["IFA_Name"].ToString();
oSwitchFee.propPer_Switch_Fee = (decimal)dr["Per_Switch_Fee"];
oSwitchFee.propQuantity = (int)dr["Quantity"];
oSwitchFee.propStartDate = DateTime.Parse(dr["StartDate"].ToString());
oSwitchFee.propEndDate = DateTime.Parse(dr["EndDate"].ToString());
dTotalFee = dTotalFee + oSwitchFee.propFees_Due;
oSwitchFee.propTotal_Fee = dTotalFee;
oSwitchFeeList.Add(oSwitchFee);
}
return oSwitchFeeList;
}