public int CreateVodomerType(VodomerType ent)
{
int createdid = 0;
VodomerTypeDAO entDAO = new VodomerTypeDAO();
sc = new SqlCommand("CreateVodomerType");
sc.CommandType = CommandType.StoredProcedure;
addParameters(ent);
createdid = entDAO.createEntity(sc);
return(createdid);
}
public override UniversalEntity createEntity()
{
UniversalEntity ue = new UniversalEntity();
while (dr.Read())
{
VodomerType ent = new VodomerType();
ent = createEntityFromReader(dr);
ue.Add(ent);
}
return(ue);
}
void AddParametersToSqlCommand(VodomerType ent, ref SqlCommand sc)
{
sc.Parameters.Add("@conventional_signth", ent.ConventionalSignth);
sc.Parameters.Add("@diameter", ent.Diameter);
sc.Parameters.Add("@id_seller", ent.SellerID);
sc.Parameters.Add("@Active", ent.IsActive);
sc.Parameters.Add("@description", ent.Description);
sc.Parameters.Add("@GovRegister", ent.GovRegister);
sc.Parameters.Add("@DateProduced", ent.DateProduced);
sc.Parameters.Add("@CheckInterval", ent.CheckInterval);
sc.Parameters.Add("@Approve", ent.Approve);
}
VodomerType Collect()
{
VodomerType vt = new VodomerType();
vt.Diameter = Utilities.ConvertToInt(tbDiametr.Text.Trim());
vt.SellerID = Utilities.ConvertToInt(ddlSeller.SelectedValue);
vt.ConventionalSignth = tbModel.Text.Trim();
vt.Description = tbDescription.Text.Trim();
vt.GovRegister = tbGovRegistry.Text.Trim();
vt.DateProduced = tbDateProduce.Text;
vt.CheckInterval = Utilities.ConvertToInt(tbChreckInterval.Text.Trim());
vt.IsActive = cbActive.Checked;
vt.Approve = cbApprove.Checked;
return(vt);
}
public bool UpdateVodomerType(VodomerType ent)
{
bool success = true;
VodomerTypeDAO entDAO = new VodomerTypeDAO();
sc = new SqlCommand("UpdateRegisty");
sc.CommandType = CommandType.StoredProcedure;
sc.Parameters.Add("@ID", ent.ID);
sc.Parameters.Add("@Approve", ent.Approve);
sc.Parameters.Add("@conventional_signth", ent.ConventionalSignth);
sc.Parameters.Add("@diameter", ent.Diameter);
sc.Parameters.Add("@id_seller", ent.SellerID);
sc.Parameters.Add("@Active", ent.IsActive);
sc.Parameters.Add("@description", ent.Description);
sc.Parameters.Add("@GovRegister", ent.GovRegister);
sc.Parameters.Add("@DateProduced", ent.DateProduced);
sc.Parameters.Add("@CheckInterval", ent.CheckInterval);
//addParameters(ent);
success = entDAO.updateEntity(sc);
return(success);
}
protected void gvJournal_SelectedIndexChanged(object sender, EventArgs e)
{
VodomerType vt = new VodomerType();
VodomerTypeDO vtDO = new VodomerTypeDO();
UniversalEntity ue = new UniversalEntity();
ue = vtDO.RetrieveVodomerById(Utilities.ConvertToInt(gvJournal.SelectedDataKey.Value.ToString()));
if (ue.Count > 0)
{
vt = (VodomerType)ue[0];
}
ddlDiameter1.SelectedValue = vt.Diameter.ToString();
ddlSeller.SelectedValue = vt.SellerID.ToString();
BindModels(vt.SellerID);
ddlModel.SelectedValue = vt.ID.ToString();
tbVodomerSearch.Text = "";
gvJournal.DataBind();
panVodomerSearch.Visible = false;
Step2.CssClass = "";
}
//Привязка моделей водомеров
void BindModels(int id)
{
if (id > 0)
{
ddlModel.Items.Clear();
VodomerType v = new VodomerType();
VodomerTypeDO vdo = new VodomerTypeDO();
UniversalEntity ue = new UniversalEntity();
int diameter = Convert.ToInt32(ddlDiameter1.SelectedValue);
ue = vdo.RetrieveVodomerTypeBySellerIdAndDiameter(id, diameter);
ddlModel.Items.Add(new ListItem("Модель", "0"));
for (int i = 0; i < ue.Count; i++)
{
v = (VodomerType)ue[i];
ddlModel.Items.Add(new ListItem(v.ConventionalSignth + " " + v.Description + " " + v.Diameter.ToString(), v.ID.ToString()));
}
}
else
{
ddlModel.Items.Clear();
}
}
public VodomerType createEntityFromReader(SqlDataReader dr)
{
VodomerType ent = new VodomerType();
if (!dr.IsDBNull(dr.GetOrdinal("ID")))
{
ent.ID = Convert.ToInt32(dr["ID"]);
}
if (!dr.IsDBNull(dr.GetOrdinal("conventional_signth")))
{
ent.ConventionalSignth = dr["conventional_signth"].ToString();
}
if (!dr.IsDBNull(dr.GetOrdinal("diameter")))
{
ent.Diameter = Convert.ToInt32(dr["diameter"]);
}
if (!dr.IsDBNull(dr.GetOrdinal("gear_ratio")))
{
ent.GearRatio = dr["gear_ratio"].ToString();
}
if (!dr.IsDBNull(dr.GetOrdinal("Active")))
{
ent.IsActive = Convert.ToBoolean(dr["Active"]);
}
if (!dr.IsDBNull(dr.GetOrdinal("id_seller")))
{
ent.SellerID = Convert.ToInt32(dr["id_seller"]);
}
if (!dr.IsDBNull(dr.GetOrdinal("description")))
{
ent.Description = dr["description"].ToString();
}
if (!dr.IsDBNull(dr.GetOrdinal("GovRegister")))
{
ent.GovRegister = dr["GovRegister"].ToString();
}
if (!dr.IsDBNull(dr.GetOrdinal("DateProduced")))
{
ent.DateProduced = dr["DateProduced"].ToString();
}
if (!dr.IsDBNull(dr.GetOrdinal("CheckInterval")))
{
ent.CheckInterval = Convert.ToInt32(dr["CheckInterval"]);
}
if (!dr.IsDBNull(dr.GetOrdinal("Approve")))
{
ent.Approve = Convert.ToBoolean(dr["Approve"]);
}
return(ent);
}
//генерация квитнации
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>";
}
}
}
}
void addParameters(VodomerType ent)
{
AddParametersToSqlCommand(ent, ref sc);
}
//генерация квитнации
protected void btPay_Click(object sender, EventArgs e)
{
FAbonentDO faDO = new FAbonentDO();
FOrderDO foDO = new FOrderDO();
VodomerType vt = new VodomerType();
FOrder fo;
FAbonent fa;
UniversalEntity ue = new UniversalEntity();
int id = Convert.ToInt32(hfODID.Value);
ue = faDO.RetrieveByOrderID(id);
FOrderDetailsDO fodDO = new FOrderDetailsDO();
//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 = (FAbonent)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("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>";
}
}
}
}
