public int CreateFAbonent(FAbonent2018 ent)
{
int createid = 0;
FAbonent2018DAO entDAO = new FAbonent2018DAO();
sc = new SqlCommand("CreateFAbonent2018");
sc.CommandType = CommandType.StoredProcedure;
addParameters(ent);
createid = (entDAO.createEntity(sc));
return(createid);
}
void AddParametersToSqlCommand(FAbonent2018 ent, ref SqlCommand sc)
{
sc.Parameters.Add("@FirstName", ent.FirstName);
sc.Parameters.Add("@Surname", ent.Surname);
sc.Parameters.Add("@LastName", ent.LastName);
sc.Parameters.Add("@Address", ent.Address);
sc.Parameters.Add("@Phone", ent.Phone);
sc.Parameters.Add("@NumberJournal", ent.NumberJournal);
sc.Parameters.Add("@DistrictID", ent.DistrictID);
sc.Parameters.Add("@NotPay", ent.NotPay);
}
public FAbonent2018 createEntityFromReader(SqlDataReader dr)
{
FAbonent2018 ent = new FAbonent2018();
if (!dr.IsDBNull(dr.GetOrdinal("ID")))
{
ent.ID = Convert.ToInt32(dr["ID"]);
}
if (!dr.IsDBNull(dr.GetOrdinal("FirstName")))
{
ent.FirstName = dr["FirstName"].ToString();
}
if (!dr.IsDBNull(dr.GetOrdinal("Surname")))
{
ent.Surname = dr["Surname"].ToString();
}
if (!dr.IsDBNull(dr.GetOrdinal("LastName")))
{
ent.LastName = dr["LastName"].ToString();
}
if (!dr.IsDBNull(dr.GetOrdinal("DistrictID")))
{
ent.DistrictID = Convert.ToInt32(dr["DistrictID"]);
}
if (!dr.IsDBNull(dr.GetOrdinal("Phone")))
{
ent.Phone = dr["Phone"].ToString();
}
if (!dr.IsDBNull(dr.GetOrdinal("Address")))
{
ent.Address = dr["Address"].ToString();
}
if (!dr.IsDBNull(dr.GetOrdinal("NotPay")))
{
ent.NotPay = Convert.ToBoolean(dr["NotPay"]);
}
/*if (!dr.IsDBNull(dr.GetOrdinal("IsDeleted")))
* ent.IsDeleted = Convert.ToBoolean(dr["IsDeleted"]);*/
if (!dr.IsDBNull(dr.GetOrdinal("NumberJournal")))
{
ent.NumberJournal = dr["NumberJournal"].ToString();
}
return(ent);
}
public override UniversalEntity createEntity()
{
UniversalEntity ue = new UniversalEntity();
while (!dr.Read())
{
FAbonent2018 ent = new FAbonent2018();
ent = createEntityFromReader(dr);
ue.Add(ent);
}
return(ue);
}
public bool Update(FAbonent2018 ent, int UserID)
{
bool succes = true;
FAbonent2018DAO entDAO = new FAbonent2018DAO();
sc = new SqlCommand("UpdateFAbonent2018");
sc.CommandType = CommandType.StoredProcedure;
sc.Parameters.Add("@FAbonentID", ent.ID);
sc.Parameters.Add("@UserID", UserID);
sc.Parameters.Add("@FirstName", ent.FirstName);
sc.Parameters.Add("@Surname", ent.Surname);
sc.Parameters.Add("@LastName", ent.LastName);
sc.Parameters.Add("@DistrictID", ent.DistrictID);
sc.Parameters.Add("@Phone", ent.Phone);
sc.Parameters.Add("@Address", ent.Address);
sc.Parameters.Add("@NotPay", ent.NotPay);
sc.Parameters.Add("@NumberJournal", ent.NumberJournal);
succes = (entDAO.updateEntity(sc));
return(succes);
}
void addParameters(FAbonent2018 ent)
{
AddParametersToSqlCommand(ent, ref sc);
}
