public int CreateFOrderDetails(FOD2018 ent)
{
int createid = 0;
FOrderDetails2018DAO entDAO = new FOrderDetails2018DAO();
sc = new SqlCommand("CreateFOrderDetails2018");
sc.CommandType = CommandType.StoredProcedure;
addParameters(ent);
createid = (entDAO.createEntity(sc));
return(createid);
}
void AddParametersToSqlCommand(FOD2018 ent, ref SqlCommand sc)
{
sc.Parameters.Add("@FOrderID", ent.FOrderID);
sc.Parameters.Add("@VodomerID", ent.VodomerID);
sc.Parameters.Add("@StartValue", ent.StartValue);
//sc.Parameters.Add("@EndValue", ent.EndValue);
/*sc.Parameters.Add("@Price", ent.Price);
* sc.Parameters.Add("@PriceRub", ent.PriceRub);
* sc.Parameters.Add("@SpecialPrice", ent.SpecialPrice);*/
sc.Parameters.Add("@DefectVodomer", ent.DefectVodomer);
}
public override UniversalEntity createEntity()
{
UniversalEntity ue = new UniversalEntity();
while (!dr.Read())
{
FOD2018 ent = new FOD2018();
ent = createEntityFromReader(dr);
ue.Add(ent);
}
return(ue);
}
public FOD2018 createEntityFromReader(SqlDataReader dr)
{
FOD2018 ent = new FOD2018();
if (!dr.IsDBNull(dr.GetOrdinal("ID")))
{
ent.ID = Convert.ToInt32(dr["ID"]);
}
if (!dr.IsDBNull(dr.GetOrdinal("FOrderID")))
{
ent.FOrderID = Convert.ToInt32(dr["FOrderID"]);
}
if (!dr.IsDBNull(dr.GetOrdinal("VodomerID")))
{
ent.VodomerID = Convert.ToInt32(dr["VodomerID"]);
}
if (!dr.IsDBNull(dr.GetOrdinal("StartValue")))
{
ent.StartValue = dr["StartValue"].ToString();
}
if (!dr.IsDBNull(dr.GetOrdinal("EndValue")))
{
ent.EndValue = dr["EndValue"].ToString();
}
if (!dr.IsDBNull(dr.GetOrdinal("Price")))
{
ent.Price = Convert.ToDouble(dr["Price"]);
}
if (!dr.IsDBNull(dr.GetOrdinal("PriceRub")))
{
ent.PriceRub = Convert.ToDouble(dr["PriceRub"]);
}
if (!dr.IsDBNull(dr.GetOrdinal("SpecialPrice")))
{
ent.SpecialPrice = Convert.ToDouble(dr["SpecialPrice"]);
}
if (!dr.IsDBNull(dr.GetOrdinal("DefectVodomer")))
{
ent.DefectVodomer = dr["DefetcVodomer"].ToString();
}
return(ent);
}
void addParameters(FOD2018 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();
}
}
}
