public bool EditPlan(PlanCode planCode)
{
using (SqlConnection connection = new SqlConnection(callConnection))
{
connection.Open();
SqlCommand command = new SqlCommand
{
Connection = connection,
CommandType = CommandType.Text,
CommandText = Queries.editPlan
};
command.Parameters.Add(Constants.atPlanDescription, SqlDbType.VarChar).Value = planCode.PlanDescription;
command.Parameters.Add(Constants.atCoverage1, SqlDbType.VarChar).Value = planCode.Coverage1;
command.Parameters.Add(Constants.atCoverage2, SqlDbType.VarChar).Value = planCode.Coverage2;
command.Parameters.Add(Constants.atCoverage3, SqlDbType.VarChar).Value = planCode.Coverage3;
command.Parameters.Add(Constants.atCoverage4, SqlDbType.VarChar).Value = planCode.Coverage4;
command.Parameters.Add(Constants.atCoverage5, SqlDbType.VarChar).Value = planCode.Coverage5;
int i = command.ExecuteNonQuery();
bool result = false;
if (i > 0)
{
result = true;
}
return(result);
}
}
public override int GetHashCode()
{
var planCodeHash = PlanCode?.GetHashCode() ?? 0;
var addOnCodeHash = AddOnCode?.GetHashCode() ?? 0;
return(planCodeHash + addOnCodeHash);
}
public bool Search(string query)
{
query = query.ToLower();
bool codeContains = DisciplineCode.Contains(query);
bool disciplineContains = Discipline != null && Discipline.Name.ToLower().Contains(query);
bool planContains = PlanCode.Contains(query);
return(codeContains || disciplineContains || planContains);
}
protected void Page_Load(object sender, EventArgs e)
{
userManager theUserManager = (userManager)Session["theUserManager"];
string theCompanyCode = theUserManager.getCompanyCode();
string theUserID = theUserManager.getUserId();
if (!IsPostBack)
{
List <LineSideStoreEntity> stores = LinesideStoreFactory.GetAll();
List <PlanEntity> dataSource = PlanFactory.GetByUserID(theUserID);
PlanCode.DataSource = dataSource;
PlanCode.ValueField = "ORDER_CODE";
PlanCode.TextField = "ORDER_CODE";
PlanCode.DataBind();
}
setCondition();
}
public bool RemovePlan(PlanCode planCodeId)
{
using (SqlConnection connection = new SqlConnection(callConnection))
{
connection.Open();
SqlCommand command = new SqlCommand
{
Connection = connection,
CommandType = CommandType.Text,
CommandText = Queries.removePlan
};
command.Parameters.Add(Constants.atPlanCodeId, SqlDbType.Int).Value = planCodeId;
int i = command.ExecuteNonQuery();
bool result = false;
if (i > 0)
{
result = true;
}
return(result);
}
}
public List <PlanCode> ViewPlan()
{
List <PlanCode> planCodeList = new List <PlanCode>();
using (SqlConnection connection = new SqlConnection(callConnection))
{
connection.Open();
SqlCommand command = new SqlCommand
{
Connection = connection,
CommandType = CommandType.Text,
CommandText = Queries.viewPlan
};
SqlDataReader dataReader = command.ExecuteReader();
int count = 0;
while (dataReader.Read())
{
PlanCode planCode = new PlanCode();
planCode.PlanDescription = Convert.ToString(dataReader.GetValue(dataReader.GetOrdinal(Constants.planDescription)));
planCode.Coverage1 = Convert.ToString(dataReader.GetValue(dataReader.GetOrdinal(Constants.coverage1)));
planCode.Coverage2 = Convert.ToString(dataReader.GetValue(dataReader.GetOrdinal(Constants.coverage2)));
planCode.Coverage3 = Convert.ToString(dataReader.GetValue(dataReader.GetOrdinal(Constants.coverage3)));
planCode.Coverage4 = Convert.ToString(dataReader.GetValue(dataReader.GetOrdinal(Constants.coverage4)));
planCode.Coverage5 = Convert.ToString(dataReader.GetValue(dataReader.GetOrdinal(Constants.coverage5)));
planCodeList.Add(planCode);
count++;
}
if (count == 0)
{
throw new NoPlanException();
}
return(planCodeList);
}
}
public override int GetHashCode()
{
return(PlanCode.GetHashCode());
}
public override int GetHashCode()
{
return(PlanCode?.GetHashCode() ?? 0);
}
