void AddParametersToSqlCommand(Vodomer ent, ref SqlCommand sc)
{
sc.Parameters.Add("@nom_zavod", ent.FactoryNumber);
sc.Parameters.Add("@date_make", ent.DateOfProduce);
// sc.Parameters.Add("@exploited", ent.Exploited);
sc.Parameters.Add("@id_type_vodomer", ent.VodomerType);
}
public Vodomer createEntityFromReader(SqlDataReader dr)
{
Vodomer ent = new Vodomer();
if (!dr.IsDBNull(dr.GetOrdinal("ID")))
{
ent.ID = Convert.ToInt32(dr["ID"]);
}
if (!dr.IsDBNull(dr.GetOrdinal("nom_zavod")))
{
ent.FactoryNumber = dr["nom_zavod"].ToString();
}
if (!dr.IsDBNull(dr.GetOrdinal("date_make")))
{
ent.DateOfProduce = Convert.ToDateTime(dr["date_make"]);
}
if (!dr.IsDBNull(dr.GetOrdinal("exploited")))
{
ent.Exploited = Convert.ToBoolean(dr["exploited"]);
}
if (!dr.IsDBNull(dr.GetOrdinal("id_type_vodomer")))
{
ent.VodomerType = Convert.ToInt32(dr["id_type_vodomer"]);
}
return(ent);
}
public int Create(Vodomer ent)
{
int createdid = 0;
VodomerDAO entDAO = new VodomerDAO();
sc = new SqlCommand("CreateVodomer");
sc.CommandType = CommandType.StoredProcedure;
addParameters(ent);
createdid = entDAO.createEntity(sc);
return(createdid);
}
public override UniversalEntity createEntity()
{
UniversalEntity ue = new UniversalEntity();
while (dr.Read())
{
Vodomer ent = new Vodomer();
ent = createEntityFromReader(dr);
ue.Add(ent);
}
return(ue);
}
public bool Update(Vodomer ent)
{
bool success = true;
VodomerDAO entDAO = new VodomerDAO();
sc = new SqlCommand("UpdateVodomer");
sc.CommandType = CommandType.StoredProcedure;
sc.Parameters.Add("@ID", ent.ID);
addParameters(ent);
success = entDAO.updateEntity(sc);
return(success);
}
public int Create1(Vodomer ent)
{
int createdid = 0;
VodomerDAO entDAO = new VodomerDAO();
sc = new SqlCommand("CreateVodomer1");
sc.CommandType = CommandType.StoredProcedure;
sc.Parameters.Add("@exploited", ent.Exploited);
addParameters(ent);
createdid = entDAO.createEntity(sc);
return(createdid);
}
//Добавление водомера
protected void lbSearch_Click(object sender, EventArgs e)
{
Regex regex = new Regex("[0-9]+");
if (string.IsNullOrEmpty(tbStartValue.Text) || string.IsNullOrEmpty(tbFactoryNumber.Text) || !regex.IsMatch(tbStartValue.Text))
{
StringBuilder sb = new StringBuilder();
if (string.IsNullOrEmpty(tbStartValue.Text))
{
sb.Append("Необходимо заполнить паказания.<br/>");
}
else
{
if (!regex.IsMatch(tbStartValue.Text))
{
sb.Append("Показания не корректно заполнены.<br/>");
}
}
if (string.IsNullOrEmpty(tbFactoryNumber.Text))
{
sb.Append("Необходимо заполнить заводской номер.<br/>");
}
radWM.RadAlert(sb.ToString(), null, null, "Предупреждение", "");
}
else
{
Vodomer v = new Vodomer();
v.VodomerType = Convert.ToInt32(hfModel.Value);
v.FactoryNumber = tbFactoryNumber.Text.Trim();
v.Exploited = cbNew.Checked;
v.DateOfProduce = new DateTime(Utilities.ConvertToInt(radddlYear.SelectedValue), 1, 1);
VodomerPreview vp = new VodomerPreview();
vp.Diameter = Convert.ToInt32(litD.Text);
vp.Model = litM.Text;
vp.Seller = litS.Text;
vp.StartValue = tbStartValue.Text.Trim();
vp.IsNew = v.Exploited;
vp.Year = v.DateOfProduce.Year;
v.VodomerPreview = vp;
SessionAbonent sa = (SessionAbonent)Session["Abonent"];
sa.AddVodomer(v);
BindVodomer();
tbFactoryNumber.Text = tbStartValue.Text = "";
}
CheckCountVodomer();
}
//генерация квитнации
protected void btAlternativePay_Click(object sender, EventArgs e)
{
AlternativeAbonentDO aaDO = new AlternativeAbonentDO();
AlternativeOrderDO aoDO = new AlternativeOrderDO();
VodomerType vt = new VodomerType();
AlternativeOrder ao;
AlternativeAbonent aa;
UniversalEntity ue = new UniversalEntity();
int id = Convert.ToInt32(hfODID.Value);
ue = aaDO.RetrieveBySOrderID(id);
Vodomer vod = new Vodomer();
VodomerDO vodDO = new VodomerDO();
AlternativeOrderDetailsDO aodDO = new AlternativeOrderDetailsDO();
AlternativeOrderDetails aods = new AlternativeOrderDetails();
//FOrderDetails fod;
double sum = 0; //гривневая цена
double getvat = 0; //гривневый ндс
double uafin = 0; //гривневая итоговая сумма
double sumrub = 0; //рублевая цена
double dissum = 0; //цена демонтаж
double instsum = 0;
double getvatrub = 0; //рублевый ндс
double finish = 0; //рублевая итоговая сумма
if (ue.Count > 0)
{
aa = (AlternativeAbonent)ue[0];
ue = aoDO.RetrieveSOrderById(id);
if (ue.Count > 0)
{
ao = (AlternativeOrder)ue[0];
ue = aodDO.RetrieveSOrderDetailsBySorderID(id);
foreach (AlternativeOrderDetails fod in ue)
{
//гривневый счет
/*sum += fod.Price;
* getvat = sum * 0.2;
* getvat = Math.Round(getvat, 2);
* uafin = (sum + getvat);*/
//рублевый счет
//sumrub += fod.ReplacementPrice;
dissum += fod.DismantlingPrice;
instsum += fod.InstallPrice;
sumrub = dissum + instsum;
}
using (DocX document = DocX.Load(Request.MapPath("~\\Templates/payaltern.docx")))
{
//DocXExtender.ReplaceFormatedText(document, "DDD", "дата");
document.ReplaceText("FIO", aa.FirstName + " " + aa.Surname + " " + aa.LastName, false, System.Text.RegularExpressions.RegexOptions.IgnoreCase);
document.ReplaceText("ADDRESS", aa.Address, false, System.Text.RegularExpressions.RegexOptions.IgnoreCase);
document.ReplaceText("PNONE", aa.Phone, false, System.Text.RegularExpressions.RegexOptions.IgnoreCase);
document.ReplaceText("DATE", DateTime.Now.ToString("dd MMMM yyyy"), false, System.Text.RegularExpressions.RegexOptions.IgnoreCase);
document.ReplaceText("NUMBER", ao.Prefix + ao.ID.ToString(), false, System.Text.RegularExpressions.RegexOptions.IgnoreCase);
//document.ReplaceText("VIEW", ao.WorkType, false, System.Text.RegularExpressions.RegexOptions.IgnoreCase);
//document.ReplaceText("DIAMETR", vt.Diameter.ToString(), false, System.Text.RegularExpressions.RegexOptions.IgnoreCase);
//document.ReplaceText("NOMZAVOD", vod.FactoryNumber.ToString(), false, System.Text.RegularExpressions.RegexOptions.IgnoreCase);
//document.ReplaceText("SUM", sum.ToString("0.00"), false, System.Text.RegularExpressions.RegexOptions.IgnoreCase);
//document.ReplaceText("VAT", getvat.ToString("0.00"), false, System.Text.RegularExpressions.RegexOptions.IgnoreCase);
//document.ReplaceText("ALL", uafin.ToString("0.00"), false, System.Text.RegularExpressions.RegexOptions.IgnoreCase);
//document.ReplaceText("CENA", sumrub.ToString("0.00"), false, System.Text.RegularExpressions.RegexOptions.IgnoreCase);
//document.ReplaceText("NDS", getvatrub.ToString("0.00"), false, System.Text.RegularExpressions.RegexOptions.IgnoreCase);
document.ReplaceText("VSEGO", sumrub.ToString("0.00"), false, System.Text.RegularExpressions.RegexOptions.IgnoreCase);
//VODOMER
document.SaveAs(Request.MapPath("~\\Templates/alternativepay.docx"));
litScriptS.Text = "<iframe style=\"display:none;\" src=\"../GetDocument.ashx?alternativepay=Special\"></iframe>";
}
}
}
}
//Добавление водомера
protected void lbSearch_Click(object sender, EventArgs e)
{
Regex regex = new Regex("[0-9]+");
if (string.IsNullOrEmpty(tbStartValue.Text) || string.IsNullOrEmpty(tbFactoryNumber.Text) || ddlModel.SelectedValue == "0" || ddlModel.SelectedValue == "" || !regex.IsMatch(tbStartValue.Text) || ddlDiameter1.SelectedValue == "-1" || ddlSeller.SelectedValue == "0")
{
StringBuilder sb = new StringBuilder();
if (ddlDiameter1.SelectedValue == "-1")
{
sb.Append("Необходимо выбрать диаметр.<br/>");
}
else
{
if (ddlSeller.SelectedValue == "0")
{
sb.Append("Необходимо выбрать производителя.<br/>");
}
else
{
if (ddlModel.SelectedValue == "0" || ddlModel.SelectedValue == "")
{
sb.Append("Необходимо выбрать модель.<br/>");
}
}
}
if (string.IsNullOrEmpty(tbStartValue.Text))
{
sb.Append("Необходимо заполнить паказания.<br/>");
}
else
{
if (!regex.IsMatch(tbStartValue.Text))
{
sb.Append("Показания не корректно заполнены.<br/>");
}
}
if (string.IsNullOrEmpty(tbFactoryNumber.Text))
{
sb.Append("Необходимо заполнить заводской номер.<br/>");
}
SetMessege("Предупреждение", sb.ToString());
}
else
{
Vodomer v = new Vodomer();
v.VodomerType = Convert.ToInt32(ddlModel.SelectedValue);
v.FactoryNumber = tbFactoryNumber.Text.Trim();
VodomerPreview vp = new VodomerPreview();
vp.Diameter = Convert.ToInt32(ddlDiameter1.SelectedValue);
vp.Model = ddlModel.SelectedItem.Text;
vp.Seller = ddlSeller.SelectedItem.Text;
vp.StartValue = tbStartValue.Text.Trim();
v.VodomerPreview = vp;
SessionAbonent sa = (SessionAbonent)Session["Abonent"];
sa.AddVodomer(v);
BindVodomer();
tbFactoryNumber.Text = tbStartValue.Text = "";
}
}
//генерация квитнации
protected void btPay_Click(object sender, EventArgs e)
{
NewFAbonentDO faDO = new NewFAbonentDO();
FOrderDO foDO = new FOrderDO();
VodomerType vt = new VodomerType();
FOrder fo;
NewFAbonent fa;
UniversalEntity ue = new UniversalEntity();
int id = Convert.ToInt32(hfODID.Value);
ue = faDO.RetrieveByOrderID(id);
Vodomer vod = new Vodomer();
VodomerDO vodDO = new VodomerDO();
FOrderDetailsDO fodDO = new FOrderDetailsDO();
FOrderDetails fods = new FOrderDetails();
//FOrderDetails fod;
double sum = 0; //гривневая цена
double getvat = 0; //гривневый ндс
double uafin = 0; //гривневая итоговая сумма
double sumrub = 0; //рублевая цена
double getvatrub = 0; //рублевый ндс
double finish = 0; //рублевая итоговая сумма
if (ue.Count > 0)
{
fa = (NewFAbonent)ue[0];
ue = foDO.RetrieveFOrderById(id);
if (ue.Count > 0)
{
fo = (FOrder)ue[0];
ue = fodDO.RetrieveFOrderDetailsByOrderID(id);
foreach (FOrderDetails fod in ue)
{
//гривневый счет
sum += fod.Price;
getvat = sum * 0.2;
getvat = Math.Round(getvat, 2);
uafin = (sum + getvat);
//рублевый счет
sumrub += fod.Price;
getvatrub = sumrub * 0.2;
getvatrub = Math.Round(getvatrub, 2);
finish = (sumrub + getvatrub) + (sumrub + getvatrub);
}
using (DocX document = DocX.Load(Request.MapPath("~\\Templates/kvit.docx")))
{
//DocXExtender.ReplaceFormatedText(document, "DDD", "дата");
document.ReplaceText("FIO", fa.Surname + " " + fa.FirstName + " " + fa.LastName, false, System.Text.RegularExpressions.RegexOptions.IgnoreCase);
document.ReplaceText("ADDRESS", fa.Address, false, System.Text.RegularExpressions.RegexOptions.IgnoreCase);
document.ReplaceText("PNONE", fa.Phone, false, System.Text.RegularExpressions.RegexOptions.IgnoreCase);
document.ReplaceText("DATE", DateTime.Now.ToString("dd MMMM yyyy"), false, System.Text.RegularExpressions.RegexOptions.IgnoreCase);
document.ReplaceText("NUMBER", fo.Prefix + fo.ID.ToString(), false, System.Text.RegularExpressions.RegexOptions.IgnoreCase);
document.ReplaceText("VIEW", fo.ActionType, false, System.Text.RegularExpressions.RegexOptions.IgnoreCase);
document.ReplaceText("DIAMETR", vt.Diameter.ToString(), false, System.Text.RegularExpressions.RegexOptions.IgnoreCase);
document.ReplaceText("NOMZAVOD", vod.FactoryNumber.ToString(), false, System.Text.RegularExpressions.RegexOptions.IgnoreCase);
document.ReplaceText("SUM", sum.ToString("0.00"), false, System.Text.RegularExpressions.RegexOptions.IgnoreCase);
document.ReplaceText("VAT", getvat.ToString("0.00"), false, System.Text.RegularExpressions.RegexOptions.IgnoreCase);
document.ReplaceText("ALL", uafin.ToString("0.00"), false, System.Text.RegularExpressions.RegexOptions.IgnoreCase);
//document.ReplaceText("CENA", sumrub.ToString("0.00"), false, System.Text.RegularExpressions.RegexOptions.IgnoreCase);
//document.ReplaceText("NDS", getvatrub.ToString("0.00"), false, System.Text.RegularExpressions.RegexOptions.IgnoreCase);
document.ReplaceText("VSEGO", finish.ToString("0.00"), false, System.Text.RegularExpressions.RegexOptions.IgnoreCase);
//VODOMER
document.SaveAs(Request.MapPath("~\\Templates/kvitfa.docx"));
litScript.Text = "<iframe style=\"display:none;\" src=\"../GetDocument.ashx?pay=Private\"></iframe>";
}
}
}
}
void addParameters(Vodomer ent)
{
AddParametersToSqlCommand(ent, ref sc);
}
