public bool UpdateFOrder(FOrder2018 ent) { /*bool success = true; * FOrder2018DAO entDAO = new FOrder2018DAO(); * sc = new SqlCommand("UpdateFOrder2018"); * sc.CommandType = CommandType.StoredProcedure; * sc.Parameters.Add("@DefectVodomer", ent.DefectVodmer); * sc.Parameters.Add("@UserID", ent.UserID); * sc.Parameters.Add("@IsPaid", ent.IsPaid); * if (ent.DateOut == null) * { * sc.Parameters.Add("@DateOut", DBNull.Value); * } * else * { * sc.Parameters.Add("@DateOut", ent.DateOut); * } * if (ent.PaymentDay == null) * { * sc.Parameters.Add("@PaymentDay", DBNull.Value); * } * else * { * sc.Parameters.Add("@PaymentDay", ent.PaymentDay); * } * success = (entDAO.updateEntity(sc)); * return success;*/ bool success = true; FOrder2018DAO entDAO = new FOrder2018DAO(); sc = new SqlCommand("UpdateFOrder2018"); sc.CommandType = CommandType.StoredProcedure; sc.Parameters.Add("@ID", ent.ID); sc.Parameters.Add("@IsPaid", ent.IsPaid); sc.Parameters.Add("@DefectVodomer", ent.DefectVodmer); sc.Parameters.Add("@UserID", ent.UserID); if (ent.DateOut == null) { sc.Parameters.Add("@DateOut", DBNull.Value); } else { sc.Parameters.Add("@DateOut", ent.DateOut); } if (ent.PaymentDay == null) { sc.Parameters.Add("@PaymentDay", DBNull.Value); } else { sc.Parameters.Add("@PaymentDay", ent.PaymentDay.Value); } //addParameters(ent); success = entDAO.updateEntity(sc); return(success); }
public FOrder2018 createEntityFromReader(SqlDataReader dr) { FOrder2018 ent = new FOrder2018(); if (!dr.IsDBNull(dr.GetOrdinal("ID"))) { ent.ID = Convert.ToInt32(dr["ID"]); } if (!dr.IsDBNull(dr.GetOrdinal("FAbonentID"))) { ent.FAbonentID = Convert.ToInt32(dr["FAbonentID"]); } if (!dr.IsDBNull(dr.GetOrdinal("DateIn"))) { ent.DateIn = Convert.ToDateTime(dr["DateIn"]); } if (!dr.IsDBNull(dr.GetOrdinal("DateOut"))) { ent.DateOut = Convert.ToDateTime(dr["DateOut"]); } if (!dr.IsDBNull(dr.GetOrdinal("Comment"))) { ent.Comment = dr["Comment"].ToString(); } if (!dr.IsDBNull(dr.GetOrdinal("IsPaid"))) { ent.IsPaid = Convert.ToBoolean(dr["IsPaid"]); } if (!dr.IsDBNull(dr.GetOrdinal("ActionType"))) { ent.ActionType = dr["ActionType"].ToString(); } if (!dr.IsDBNull(dr.GetOrdinal("PaymentDay"))) { ent.PaymentDay = Convert.ToDateTime(dr["PaymentDay"]); } if (!dr.IsDBNull(dr.GetOrdinal("UserID"))) { ent.UserID = Convert.ToInt32(dr["UserID"]); } if (!dr.IsDBNull(dr.GetOrdinal("DefectVodomer"))) { ent.DefectVodmer = Convert.ToBoolean(dr["DefectVodomer"]); } return(ent); }
public int CreateFOrder(FOrder2018 ent) { int createid = 0; FOrder2018DAO entDAO = new FOrder2018DAO(); sc = new SqlCommand("CreateFOrder2018"); sc.CommandType = CommandType.StoredProcedure; addParameters(ent); createid = (entDAO.createEntity(sc)); return(createid); }
void AddParametersToSqlCommand(FOrder2018 ent, ref SqlCommand sc) { sc.Parameters.Add("@FAbonentID", ent.FAbonentID); //sc.Parameters.Add("@DateIn", ent.DateIn); //sc.Parameters.Add("@DateOut", ent.DateOut); //sc.Parameters.Add("@Comment", ent.Comment); //sc.Parameters.Add("@IsPaid", ent.IsPaid); sc.Parameters.Add("@ActionType", ent.ActionType); //sc.Parameters.Add("@PaymentDay", ent.PaymentDay); sc.Parameters.Add("@UserID", ent.UserID); //sc.Parameters.Add("@DefectVodomer", ent.DefectVodmer); }
public override UniversalEntity createEntity() { UniversalEntity ue = new UniversalEntity(); while (!dr.Read()) { FOrder2018 ent = new FOrder2018(); ent = createEntityFromReader(dr); ue.Add(ent); } return(ue); }
void addParameters(FOrder2018 ent) { AddParametersToSqlCommand(ent, ref sc); }
//Сохранение в базу protected void lbSaveAll_Click(object sender, EventArgs e) { if (Session["Abonent"] != null) { SessionAbonent sa = (SessionAbonent)Session["Abonent"]; if (sa.Vodomer.Count == 0) { SetMessege("Предупреждение", "Необходимо добавить минимум 1 водомер."); } else { if (sa.Type == (short)Abonent.Corporate) { UAbonent ua = sa.UAbon; UAbonentDO uado = new UAbonentDO(); int uid = uado.Create(ua); if (uid > 0) { sa.UAbon.ID = uid; Session["Abonent"] = sa; UOrder uo = new UOrder(); UOrderDO uodo = new UOrderDO(); uo.ActionType = "Определения метрологических характеристик водомера."; uo.UAbonentID = uid; uo.UserID = GetCurrentUser().ID; int uoid = uodo.Create(uo); if (uoid > 0) { hfOrder.Value = uoid.ToString(); UOrderDetails uod = new UOrderDetails(); UOrderDetailsDO uoddo = new UOrderDetailsDO(); VodomerDO vdo = new VodomerDO(); foreach (Vodomer v in sa.Vodomer) { int vid = vdo.Create(v); uod.UOrderID = uoid; uod.VodomerID = vid; uod.StartValue = v.VodomerPreview.StartValue; int uodid = uoddo.Create(uod); } } } } if (sa.Type == (short)Abonent.Private) { NewFAbonent fa = sa.FAbon; NewFAbonentDO fado = new NewFAbonentDO(); int fid = fado.Create(fa); if (fid > 0) { sa.FAbon.ID = fid; Session["Abonent"] = sa; FOrder2018 fo = new FOrder2018(); FOrder2018DO fodo = new FOrder2018DO(); fo.ActionType = "Определения метрологических характеристик водомера."; fo.FAbonentID = fid; fo.UserID = GetCurrentUser().ID; int foid = fodo.CreateFOrder(fo); if (foid > 0) { hfOrder.Value = foid.ToString(); FOD2018 fod = new FOD2018(); FOrderDetails2018DO foddo = new FOrderDetails2018DO(); VodomerDO vdo = new VodomerDO(); foreach (Vodomer v in sa.Vodomer) { int vid = vdo.Create(v); fod.FOrderID = foid; fod.VodomerID = vid; fod.StartValue = v.VodomerPreview.StartValue; int uodid = foddo.CreateFOrderDetails(fod); } } } } if (sa.Type == (short)Abonent.Special) { AlternativeAbonent sab = sa.AlternativeAbon; AlternativeAbonentDO sabo = new AlternativeAbonentDO(); int fid = sabo.Create(sab); if (fid > 0) { sa.AlternativeAbon.ID = fid; Session["Abonent"] = sa; AlternativeOrder so = new AlternativeOrder(); AlternativeOrderDO sod = new AlternativeOrderDO(); so.WorkType = "Снятие/установка водомеров."; so.SAbonentID = fid; so.UserID = GetCurrentUser().ID; int soid = sod.CreateSOrder(so); if (soid > 0) { hfOrder.Value = soid.ToString(); AlternativeOrderDetails sd = new AlternativeOrderDetails(); AlternativeOrderDetailsDO sodDO = new AlternativeOrderDetailsDO(); VodomerDO vdo = new VodomerDO(); foreach (Vodomer v in sa.Vodomer) { int vid = vdo.Create(v); sd.SOrderID = soid; sd.VodomerID = vid; sd.StartValue = v.VodomerPreview.StartValue; int uodid = sodDO.Create(sd); } } } } //SetMessege("Статус", "Абонент и водомер успешно внесены в базу."); LoadStep3(); } } }