public void EditorMode() { User u = GetCurrentUser(); u.GetPermissions(); if (u.ChekPermission("Editor")) { punAlternAbonentEditor.Visible = true; gvJournal.Visible = false; gvJournal2.Visible = true; BindDistricts(); UniversalEntity ue = new UniversalEntity(); AlternativeAbonent aa = new AlternativeAbonent(); AlternativeAbonentDO aado = new AlternativeAbonentDO(); ue = aado.RetrieveBySOrderID(_OrderID); if (ue.Count > 0) { aa = (AlternativeAbonent)ue[0]; stbNumberJournalPhysical.Text = aa.PhysicalNumberJournal; tbAddress.Text = aa.Address; stbClientSurname.Text = aa.Surname; stbClientName.Text = aa.FirstName; stbClientLastName.Text = aa.LastName; stbPhone.Text = aa.Phone; ddsDistrict.SelectedValue = aa.DistrictID.ToString(); } } else { punAlternAbonentEditor.Visible = false; gvJournal.Visible = true; gvJournal2.Visible = false; } }
public void Bind() { EditorMode(); cbSeld.Checked = false; cbSeld.Enabled = true; cbPaid.Checked = false; cbPaid.Enabled = true; tbPaymentDay.Enabled = true; tbPaymentDay.Text = DateTime.Now.ToShortDateString(); AlternativeOrder ao = new AlternativeOrder(); AlternativeOrderDO aodo = new AlternativeOrderDO(); UniversalEntity ue = new UniversalEntity(); ue = aodo.RetrieveSOrderById(_OrderID); if (ue.Count > 0) { ao = (AlternativeOrder)ue[0]; if (ao.DateOut != null) { cbSeld.Checked = true; cbSeld.Enabled = false; cbPaid.Checked = true; cbPaid.Enabled = false; } if (ao.IsPaid) { cbPaid.Checked = true; cbPaid.Enabled = false; cbSeld.Checked = true; cbSeld.Enabled = false; if (ao.PaymentDay.HasValue) { tbPaymentDay.Text = ao.PaymentDay.Value.ToShortDateString(); } tbPaymentDay.Enabled = false; } } hfODID.Value = _OrderID.ToString(); StringBuilder sb = new StringBuilder(); AlternativeAbonent aa = new AlternativeAbonent(); AlternativeAbonentDO aado = new AlternativeAbonentDO(); ue = aado.RetrieveBySOrderID(_OrderID); if (ue.Count > 0) { aa = (AlternativeAbonent)ue[0]; sb.AppendLine("<span>ФИО: " + aa.Surname + " " + aa.FirstName + " " + aa.LastName + "</span><br/>"); sb.AppendLine("<span>Номер по журналу: " + aa.PhysicalNumberJournal + "</span><br/>"); sb.AppendLine("<span>Тел. " + aa.Phone + "</span><br/>"); sb.AppendLine("<span>Адрес: " + aa.Address + "</span><br/>"); AlternAbonentInfo.Text = sb.ToString(); } }
void AddParametersToSqlCommand(AlternativeAbonent 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("@Phone", ent.Phone); sc.Parameters.Add("@Address", ent.Address); sc.Parameters.Add("@NumberJournal", ent.PhysicalNumberJournal); sc.Parameters.Add("@DistrictID", ent.DistrictID); }
public int Create(AlternativeAbonent ent) { int createid = 0; AlternativeAbonentDAO entDAO = new AlternativeAbonentDAO(); sc = new SqlCommand("CreateSAbonent"); sc.CommandType = CommandType.StoredProcedure; addParametres(ent); createid = entDAO.createEntity(sc); return(createid); }
public override UniversalEntity createEntity() { UniversalEntity ue = new UniversalEntity(); while (dr.Read()) { AlternativeAbonent ent = new AlternativeAbonent(); ent = createEntityFromReader(dr); ue.Add(ent); } return(ue); }
public bool Update(AlternativeAbonent ent) { bool success = true; AlternativeAbonentDAO aaDAO = new AlternativeAbonentDAO(); sc = new SqlCommand("UpdateAlternativeAbonent"); sc.CommandType = CommandType.StoredProcedure; sc.Parameters.Add("@ID", ent.ID); addParametres(ent); success = aaDAO.updateEntity(sc); return(success); }
public AlternativeAbonent createEntityFromReader(SqlDataReader dr) { AlternativeAbonent ent = new AlternativeAbonent(); 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("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("Phone"))) { ent.Phone = dr["Phone"].ToString(); } if (!dr.IsDBNull(dr.GetOrdinal("NumberJournal"))) { ent.PhysicalNumberJournal = dr["NumberJournal"].ToString(); } if (!dr.IsDBNull(dr.GetOrdinal("Address"))) { ent.Address = dr["Address"].ToString(); } if (!dr.IsDBNull(dr.GetOrdinal("DistrictID"))) { ent.DistrictID = Convert.ToInt32(dr["DistrictID"]); } return(ent); }
public bool CreateUpdate(AlternativeAbonent ent, int UserID) { bool success = true; AlternativeAbonentDAO entDAO = new AlternativeAbonentDAO(); sc = new SqlCommand("CreateSAbonentByOrderID"); sc.Parameters.Add("@UserID", UserID); sc.Parameters.Add("@SAbonentID", ent.ID); sc.Parameters.Add("@FirstName", ent.FirstName); sc.Parameters.Add("@Surname", ent.Surname); sc.Parameters.Add("@LastName", ent.LastName); sc.Parameters.Add("@Phone", ent.Phone); sc.Parameters.Add("@NumberJournal", ent.PhysicalNumberJournal); sc.Parameters.Add("@DistrictID", ent.DistrictID); sc.Parameters.Add("@Address", ent.Address); success = entDAO.updateEntity(sc); return(success); }
/* * public bool Update(FAbonent ent,int UserID) * { * bool success = true; * FAbonentDAO entDAO = new FAbonentDAO(); * sc = new SqlCommand("UpdateFAbonent"); * sc.CommandType = CommandType.StoredProcedure; * sc.Parameters.Add("@UserID ", UserID); * sc.Parameters.Add("@FAbonentID ", ent.ID); * 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("@NumberJournal", ent.PhysicalNumberJournal); * sc.Parameters.Add("@Phone", ent.Phone); * sc.Parameters.Add("@DistrictID", ent.DistrictID); * sc.Parameters.Add("@NotPay", ent.NotPay); * //sc.Parameters.Add("@RejectVodomer", ent.RejectVodomer); * //addParameters(ent); * success = entDAO.updateEntity(sc); * return success; * } * */ public bool UpdateWithHistory(AlternativeAbonent ent, int UserID) { bool success = true; AlternativeAbonentDAO entDAO = new AlternativeAbonentDAO(); sc = new SqlCommand("UpdateAlternativeAbonent"); sc.CommandType = CommandType.StoredProcedure; sc.Parameters.Add("@UserID", UserID); sc.Parameters.Add("@SAbonentID", ent.ID); 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("@NumberJournal", ent.PhysicalNumberJournal); sc.Parameters.Add("@Phone", ent.Phone); sc.Parameters.Add("@DistrictID", ent.DistrictID); success = entDAO.updateEntity(sc); return(success); }
protected void radbutSaveAlternativeAbonentInfo_OnClick(object sender, EventArgs e) { UniversalEntity ue = new UniversalEntity(); AlternativeAbonent aa = new AlternativeAbonent(); AlternativeAbonentDO aado = new AlternativeAbonentDO(); ue = aado.RetrieveBySOrderID(Utilities.ConvertToInt(hfODID.Value)); if (ue.Count > 0) { aa = (AlternativeAbonent)ue[0]; aa.PhysicalNumberJournal = stbNumberJournalPhysical.Text; aa.FirstName = stbClientName.Text; aa.Surname = stbClientSurname.Text; aa.LastName = stbClientLastName.Text; aa.Phone = stbPhone.Text; aa.Address = tbAddress.Text; aado.UpdateWithHistory(aa, GetCurrentUser().ID); } _OrderID = Utilities.ConvertToInt(hfODID.Value); Bind(); }
void addParametres(AlternativeAbonent 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) { radWM.RadAlert("Необходимо добавить минимум 1 водомер.", null, null, "Предупреждение", ""); } 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 = "*377;08;1;1 Опр. метр. хар."; 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.Create1(v); uod.UOrderID = uoid; uod.VodomerID = vid; uod.StartValue = v.VodomerPreview.StartValue; int uodid = uoddo.Create(uod); } Response.Redirect("UJournal.aspx?id=" + uoid.ToString()); } } } 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; NewFOrder fo = new NewFOrder(); NewFOrderDO fodo = new NewFOrderDO(); fo.ActionType = "*377;08;1;0 Проведение периодической поверки счетчика"; fo.FAbonentID = fid; fo.UserID = GetCurrentUser().ID; int foid = fodo.Create(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.Create1(v); fod.FOrderID = foid; fod.VodomerID = vid; fod.StartValue = v.VodomerPreview.StartValue; int uodid = foddo.CreateFOrderDetails(fod); } Response.Redirect("FJournal2018.aspx?id=" + foid.ToString()); } } } 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 = "*377;09;1;1 Снятие/установка водомеров."; 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.Create1(v); sd.SOrderID = soid; sd.VodomerID = vid; sd.StartValue = v.VodomerPreview.StartValue; int uodid = sodDO.Create(sd); } Response.Redirect("SJournal.aspx?id=" + soid.ToString()); } } } // LoadStep3(); } } }
//добавление снятия/установки водомера protected void WithdrawalAbonentAdd_Click(object sender, EventArgs e) { Session["Abonent"] = null; SessionAbonent sa = new SessionAbonent(); StringBuilder sb = new StringBuilder(); StringBuilder sbError = new StringBuilder(); if (string.IsNullOrEmpty(tbWithdrawalFirstName.Text)) { sbError.Append("Необходимо заполнить фамилию.<br/>"); } if (string.IsNullOrEmpty(tbWithdrawalSurname.Text)) { sbError.Append("Необходимо заполнить имя.<br/>"); } if (string.IsNullOrEmpty(tbWithdrawaLastName.Text)) { sbError.Append("Необходимо заполнить отчество.<br/>"); } if (string.IsNullOrEmpty(tbWithdrawalPhone.Text)) { sbError.Append("Необходимо запонить телефон.<br/>"); } if (string.IsNullOrEmpty(tbWithdrawalAddress.Text)) { sbError.Append("Необходимо заполнить адрес.<br/>"); } if (ddDistrictWithdrawal.SelectedValue == "0") { sbError.Append("Необходимо заполнить район.<br/>"); } if (sbError.Length > 0) { radWM.RadAlert(sbError.ToString(), null, null, "Предупреждение", ""); } else { if (hfClientType.Value == Abonent.Special.ToString()) { sa.Type = (short)Abonent.Special; AlternativeAbonent sab = new AlternativeAbonent(); sab.Surname = tbWithdrawalSurname.Text.Trim(); sab.LastName = tbWithdrawaLastName.Text.Trim(); sab.FirstName = tbWithdrawalFirstName.Text.Trim(); sab.Address = tbWithdrawalAddress.Text.Trim(); sab.Phone = tbWithdrawalPhone.Text.Trim(); sab.PhysicalNumberJournal = tbWithdrawalNumberJournal.Text.Trim(); sab.DistrictID = Convert.ToInt32(ddDistrictWithdrawal.SelectedValue); sa.AlternativeAbon = sab; sb.AppendLine("<b><span>Номер по журналу:" + sab.PhysicalNumberJournal + "</span><br/>"); sb.AppendLine("<b><span>ФИО:" + sab.FirstName + " " + sab.Surname + " " + sab.LastName + "</span><br/>"); sb.AppendLine("<b><span>Телефон: " + sab.Phone + "</span><br/>"); sb.AppendLine("<b><span>Адрес: " + sab.Address + "</span><br/>"); litAbonentInfo.Text = sb.ToString(); } Session["Abonent"] = sa; ClearSAbonentForm(); Step1.Visible = false; Step2.Visible = true; radgridD.Rebind(); } }
//Сохранение в базу 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(); } } }