protected void btnUpdateFactureStatus_Click(object sender, EventArgs e)
{
if (dvChangeStatus.SelectedValue != null)
{
int factureID = Convert.ToInt32(dvChangeStatus.SelectedValue);
AccountFacture f = AccountFacture.Get(factureID);
DropDownList ddlStatuses = (DropDownList)dvChangeStatus.FindControl("ddlStatuses");
f.StatusID = Convert.ToInt32(ddlStatuses.SelectedValue);
AccountFacture.Table.Context.SubmitChanges();
GXGridView1.DataBind();
mvMain.SetActiveView(viewGrid);
}
}
protected void btnDiscardFacture_Click(object sender, EventArgs e)
{
int id = GXGridView1SelectedValue;
if (GXGridView1.SelectedIndex != -1)
{
if (GXGridView1.SelectedValue != null)
{
id = Convert.ToInt32(GXGridView1.SelectedValue);
}
else
{
id = GXGridView1SelectedValue;
}
AccountFacture.DiscardFacture(id);
}
}
protected void btnPintFacture_Click(object sender, EventArgs e)
{
if (GXGridView1SelectedValue > 0)
{
AccountFacture f;
f = AccountFacture.Get(GXGridView1SelectedValue);
btnNew.CssClass = "novZapis";
btnFactureItems.CssClass = "izmeni";
btnPreview.CssClass = "osvezi";
btnReport.CssClass = "izvestaj";
btnSearch.CssClass = "prebaraj";
btnFactureItems.CssClass = "prikaz";
btnPintFacture.CssClass = "pecati_Active";
btnChangeStatus.CssClass = "izmeni";
PrintAccountFactures.PrintAccountFacture(f);
}
}
public static void PrintAccountFacture(AccountFacture f)
{
if (f.DocumentSubType.Code == DocumentSubType.FAKTURA_PROVIZIJA)
{
PDFCreators creator = new PDFCreators(true, 15, 15, 15, 15);
creator.OpenPDF();
creator.GetContentByte();
creator.AddJDBLogoForFactures(10, 760);
creator.SetTitleLeft8(" ");
creator.SetTitleLeftBold14(" " + Broker.DataAccess.Parameter.GetByCode(Broker.DataAccess.Parameter.IME).Value);
creator.SetTitle(" ");
creator.SetTitleLeft8(" ");
creator.SetTitleLeft8(" Адреса : " + Broker.DataAccess.Parameter.GetByCode(Broker.DataAccess.Parameter.ADRESA).Value);
creator.SetTitleLeft8(" Место : " + Broker.DataAccess.Parameter.GetByCode(Broker.DataAccess.Parameter.MESTO).Value);
creator.SetTitleLeft8(" Телефон : " + Broker.DataAccess.Parameter.GetByCode(Broker.DataAccess.Parameter.TELEFON).Value + " " + "Факс : " + Broker.DataAccess.Parameter.GetByCode(Broker.DataAccess.Parameter.FAKS).Value);
if (f.DocumentSubType.Code == DocumentSubType.FAKTURA_PROVIZIJA)
{
creator.SetTitleLeft8(" Жиро-сметка : " + Broker.DataAccess.Parameter.GetByCode(Broker.DataAccess.Parameter.ZIRO_SMETKA_ZA_OSIG_KOMPANII).Value);
}
else if (f.DocumentSubType.Code == DocumentSubType.FAKTURA_KLIENT)
{
creator.SetTitleLeft8(" Жиро-сметка : " + Broker.DataAccess.Parameter.GetByCode(Broker.DataAccess.Parameter.ZIRO_SMETKA).Value);
}
creator.SetTitleLeft8(" Депонент : " + Broker.DataAccess.Parameter.GetByCode(Broker.DataAccess.Parameter.DEPONENT).Value);
creator.SetTitleLeft8(" ЕДБ : " + Broker.DataAccess.Parameter.GetByCode(Broker.DataAccess.Parameter.EDB).Value + " " + "Матичен број : " + Broker.DataAccess.Parameter.GetByCode(Broker.DataAccess.Parameter.MATICEN_BROJ).Value);
creator.SetTitleLeft8(" Web-страна : " + Broker.DataAccess.Parameter.GetByCode(Broker.DataAccess.Parameter.WEB_STRANA).Value + " " + "E-Mail : " + Broker.DataAccess.Parameter.GetByCode(Broker.DataAccess.Parameter.EMAIL).Value);
creator.SetTitleLeft8(" ");
if (f.Discard)
{
creator.SetTitleCenterForFactureNumber("СТОРНИРАНА Ф-ра бр. " + f.FactureNumber);
}
else
{
creator.SetTitleCenterForFactureNumber("Фактура бр. " + f.FactureNumber);
}
creator.SetTitleLeftWithFontSize10(ConvertToMacedonian.ConvertToMACEDONIAN(f.Client.Name).ToUpper());
creator.SetTitleLeftWithFontSize10(ConvertToMacedonian.ConvertToMACEDONIAN(f.Client.Address).ToUpper());
creator.SetTitleLeftWithFontSize10(ConvertToMacedonian.ConvertToMACEDONIAN(f.Client.Place.Municipality.Name).ToUpper());
creator.SetTitleLeft10("Датум на фактура: " + f.DateOfCreation.ToShortDateString());
creator.SetTitleLeft10("Рок на плаќање: " + f.DateOfPayment.ToShortDateString());
//creator.SetTitleLeft8("Период: " + f.FromDate.ToShortDateString() + " - " + f.ToDate.ToShortDateString());
string[] headers = { "Ред. бр.", "Опис", "Количина", "Премија", "Брокеража" };
float[] widthPercentages = { 8, 45, 15, 17, 15 };
TypeCode[] typeCodes = { TypeCode.Int32, TypeCode.String, TypeCode.Int32, TypeCode.Decimal, TypeCode.Decimal };
creator.CreateTable_Facture(headers.Length, headers, widthPercentages);
object[] values;
foreach (AccountFactureItem fi in f.AccountFactureItems)
{
values = new object[headers.Length];
values[0] = fi.Number.ToString();
values[1] = fi.Description;
values[2] = fi.Count.ToString();
values[3] = String.Format("{0:#,0.00}", fi.PremiumValue);
values[4] = String.Format("{0:#,0.00}", fi.BrokerageValue);
creator.AddDataRowForFactures(values, headers.Length, typeCodes);
}
values = new object[headers.Length];
values[0] = "";
values[1] = "";
values[2] = "";
values[3] = "Вкупно";
values[4] = String.Format("{0:#,0.00}", f.BrokerageValue);
creator.AddDataRowForFactures(values, headers.Length, typeCodes);
creator.AddTable();
creator.SetTitleLeftBold14(" ");
creator.SetTitleLeftItalic10("Со букви: " + NumberToTextController.Konvertiranje(f.BrokerageValue));
creator.SetTitleLeft8(" ");
creator.SetTitleLeft10("Ве молиме фактурираниот износ да го платите до назначениот рок на плаќање.");
creator.SetTitleLeft8(" ");
creator.SetTitleLeft10("Доколку износот за фактурата не биде платен до наведениот датум, се пресметува затезна камата од денот на стасаност до денот на плаќањето.");
creator.SetTitleLeft8(" ");
creator.SetTitleLeft10("Согласно со член 23, точка 6 од Законот за ДДВ дејноста осигурување е ослободена од плаќање данок без право на одбиток на претходниот данок.");
creator.SetTitleLeft8(" ");
creator.SetTitleLeft8(" ");
creator.SetTitleLeft8(" ");
creator.SetTitleLeft8(" ");
creator.SetTitleLeft10(" Фактурирал Примил Одобрил");
creator.SetTitleLeft10(" _________________ __________________ ____________________");
creator.AddPage();
creator.SetTitleCenterForFactureNumber("Спецификација за фактура бр. " + f.FactureNumber);
string[] headersSpecifications = { "Ред. бр.", "Број на полиса", "Почеток", "Истек", "Дата на издавање", "Премија" };
float[] widthPercentagesSpecifications = { 10, 20, 19, 19, 19, 13 };
TypeCode[] typeCodesSpecifications = { TypeCode.Int32, TypeCode.String, TypeCode.String, TypeCode.String, TypeCode.String, TypeCode.Decimal };
object[] valuesSpecifications;
foreach (AccountFactureItem fi in f.AccountFactureItems)
{
creator.SetTitleLeft10Bold(fi.InsuranceSubType.Description);
creator.CreateTable_Facture(headersSpecifications.Length, headersSpecifications, widthPercentagesSpecifications);
List <AccountFactureItemPolicyItem> pifiList = AccountFactureItemPolicyItem.GetByAccountFactureItem(fi.ID);
int ordinalNumber = 1;
foreach (AccountFactureItemPolicyItem pifi in pifiList)
{
valuesSpecifications = new object[6];
valuesSpecifications[0] = ordinalNumber;
valuesSpecifications[1] = pifi.PolicyItem.PolicyNumber;
valuesSpecifications[2] = pifi.PolicyItem.Policy.StartDate.ToShortDateString();
valuesSpecifications[3] = pifi.PolicyItem.Policy.EndDate.ToShortDateString();
valuesSpecifications[4] = pifi.PolicyItem.Policy.ApplicationDate.ToShortDateString();
valuesSpecifications[5] = pifi.PolicyItem.PremiumValue;
creator.AddDataRowForFacturesExtend(valuesSpecifications, headersSpecifications.Length, typeCodesSpecifications, headersSpecifications, widthPercentagesSpecifications);
ordinalNumber++;
}
creator.AddTable();
creator.SetTitleCenterForFactureNumber(" ");
}
creator.FinishPDF_FileName("Factura" + f.FactureNumber);
}
//if (f.DocumentSubType.Code == DocumentSubType.FAKTURA_KLIENT)
//{
// PDFCreators creator = new PDFCreators(true, 15, 15, 15, 15);
// creator.OpenPDF();
// creator.GetContentByte();
// creator.AddJDBLogoForFactures(10, 760);
// creator.SetTitleLeft8(" ");
// creator.SetTitleLeftBold14(" " + Parameter.GetByCode(Parameter.IME).Value);
// creator.SetTitle(" ");
// creator.SetTitleLeft8(" ");
// creator.SetTitleLeft8(" Адреса : " + Parameter.GetByCode(Parameter.ADRESA).Value);
// creator.SetTitleLeft8(" Место : " + Parameter.GetByCode(Parameter.MESTO).Value);
// creator.SetTitleLeft8(" Телефон : " + Parameter.GetByCode(Parameter.TELEFON).Value + " " + "Факс : " + Parameter.GetByCode(Parameter.FAKS).Value);
// creator.SetTitleLeft8(" Жиро-сметка : " + Parameter.GetByCode(Parameter.ZIRO_SMETKA).Value);
// creator.SetTitleLeft8(" Депонент : " + Parameter.GetByCode(Parameter.DEPONENT).Value);
// creator.SetTitleLeft8(" ЕДБ : " + Parameter.GetByCode(Parameter.EDB).Value + " " + "Матичен број : " + Parameter.GetByCode(Parameter.MATICEN_BROJ).Value);
// creator.SetTitleLeft8(" Web-страна : " + Parameter.GetByCode(Parameter.WEB_STRANA).Value + " " + "E-Mail : " + Parameter.GetByCode(Parameter.EMAIL).Value);
// creator.SetTitleLeft8(" ");
// creator.SetTitleCenterForFactureNumber("Фактура бр. " + f.FactureNumber);
// creator.SetTitleLeftWithFontSize10(ConvertToMacedonian.ConvertToMACEDONIAN(f.Client.Name).ToUpper());
// creator.SetTitleLeftWithFontSize10(ConvertToMacedonian.ConvertToMACEDONIAN(f.Client.Address).ToUpper());
// creator.SetTitleLeftWithFontSize10(ConvertToMacedonian.ConvertToMACEDONIAN(f.Client.Place.Municipality.Name).ToUpper());
// creator.SetTitleLeft10("Датум на фактура: " + f.DateOfCreation.ToShortDateString());
// creator.SetTitleLeft10("Рок на плаќање: " + f.DateOfPayment.ToShortDateString());
// //creator.SetTitleLeft8("Период: " + f.FromDate.ToShortDateString() + " - " + f.ToDate.ToShortDateString());
// string[] headers = { "Ред. бр.", "Опис", "Количина", "Премија" };
// float[] widthPercentages = { 10, 50, 15, 25 };
// TypeCode[] typeCodes = { TypeCode.Int32, TypeCode.String, TypeCode.Int32, TypeCode.Decimal };
// creator.CreateTable_Facture(headers.Length, headers, widthPercentages);
// object[] values;
// foreach (FactureItem fi in f.FactureItems)
// {
// values = new object[headers.Length];
// values[0] = fi.Number.ToString();
// values[1] = fi.Description;
// values[2] = fi.Count.ToString();
// values[3] = String.Format("{0:#,0.00}", fi.PremiumValue);
// creator.AddDataRowForFactures(values, headers.Length, typeCodes);
// }
// values = new object[headers.Length];
// values[0] = "";
// values[1] = "";
// values[2] = "Вкупно";
// values[3] = String.Format("{0:#,0.00}", f.TotalCost);
// creator.AddDataRowForFactures(values, headers.Length, typeCodes);
// creator.AddTable();
// creator.SetTitleLeftBold14(" ");
// creator.SetTitleLeftItalic10("Со букви: " + NumberToTextController.Konvertiranje(f.TotalCost));
// creator.SetTitleLeft8(" ");
// creator.SetTitleLeft10("Ве молиме фактурираниот износ да го платите до назначениот рок на плаќање.");
// creator.SetTitleLeft8(" ");
// creator.SetTitleLeft10("Доколку износот за фактурата не биде платен до наведениот датум, се пресметува затезна камата од денот на стасаност до денот на плаќањето.");
// creator.SetTitleLeft8(" ");
// creator.SetTitleLeft10("Согласно со член 23, точка 6 од Законот за ДДВ дејноста осигурување е ослободена од плаќање данок без право на одбиток на претходниот данок.");
// creator.SetTitleLeft8(" ");
// creator.SetTitleLeft8(" ");
// creator.SetTitleLeft8(" ");
// creator.SetTitleLeft8(" ");
// creator.SetTitleLeft10(" Фактурирал Примил Одобрил");
// creator.SetTitleLeft10(" _________________ __________________ ____________________");
// string facItemDescriptionStart = "Полиса - ";
// creator.AddPage();
// foreach (FactureItem fi in f.FactureItems) {
// string polNumber = fi.Description.Substring(facItemDescriptionStart.Length);
// creator.SetTitleLeft10(facItemDescriptionStart + polNumber);
// string[] headersRates = { "Рата бр.", "Дата за плаќање", "Износ" };
// float[] widthPercentagesRates = { 15, 50, 35 };
// TypeCode[] typeCodesRates = { TypeCode.Int32, TypeCode.String, TypeCode.Decimal };
// creator.CreateTable_Facture(headersRates.Length, headersRates, widthPercentagesRates);
// PolicyItem pi = PolicyItem.GetByNumberAndInsuranceSubType(polNumber, fi.InsuranceSubTypeID, fi.Facture.InsuranceCompanyID);
// List<Rate> rates = Rate.GetByPolicyItemID(pi.ID);
// rates = rates.OrderBy(c => c.Number).ToList();
// foreach (Rate r in rates) {
// object[] valuesRates = new object[headersRates.Length];
// valuesRates[0] = r.Number;
// valuesRates[1] = r.Date.ToShortDateString();
// valuesRates[2] = String.Format("{0:#,0.00}", r.Value);
// creator.AddDataRowForFactures(valuesRates, headersRates.Length, typeCodes);
// }
// creator.AddTable();
// }
//creator.FinishPDF_FileName("Factura" + f.FactureNumber);
}
protected void btnCreate_Click(object sender, EventArgs e)
{
DateTime startDate = DateTime.Parse(tbStartDate.Text);
DateTime endDate = DateTime.Parse(tbEndDate.Text);
DateTime dateOfPayment = DateTime.Now.AddDays(15);
if (tbDateOfPayment.Text.Trim() != string.Empty)
{
DateTime.TryParse(tbDateOfPayment.Text, out dateOfPayment);
}
InsuranceCompany company = InsuranceCompany.Get(int.Parse(ddlInsuranceCompanies.SelectedValue));
Broker.DataAccess.User u = this.PageUser;
DateTime fromDate = DateTime.Parse(tbStartDate.Text);
DateTime toDate = DateTime.Parse(tbEndDate.Text);
//List<PolicyItem> piList = PolicyItem.GetFromPreivousMonths(fromDate, company.ID);
List <FactureInfo> lastFactureInfos = listNewFactureInfos;
GridViewRowCollection displayedRows = gvNewPolicies.Rows;
foreach (GridViewRow gvRow in displayedRows)
{
CheckBox cbIsForFacturing = gvRow.FindControl("cbIsForFacturing") as CheckBox;
int factureInfoID = Convert.ToInt32(gvNewPolicies.DataKeys[gvRow.RowIndex].Value);
FactureInfo fi = lastFactureInfos.Where(facInfo => facInfo.ID == factureInfoID).SingleOrDefault();
fi.IsForFacturing = cbIsForFacturing.Checked;
}
listNewFactureInfos = lastFactureInfos;
lastFactureInfos = listFactureInfos;
displayedRows = gvOldPolicies.Rows;
foreach (GridViewRow gvRow in displayedRows)
{
CheckBox cbIsForFacturing = gvRow.FindControl("cbIsForFacturing") as CheckBox;
int factureInfoID = Convert.ToInt32(gvOldPolicies.DataKeys[gvRow.RowIndex].Value);
FactureInfo fi = lastFactureInfos.Where(facInfo => facInfo.ID == factureInfoID).SingleOrDefault();
fi.IsForFacturing = cbIsForFacturing.Checked;
}
listFactureInfos = lastFactureInfos;
List <PolicyItem> policiesToInclude = new List <PolicyItem>();
List <FactureInfo> listOldPolicies = (List <FactureInfo>)listFactureInfos;
foreach (FactureInfo fi in listOldPolicies)
{
if (fi.IsForFacturing)
{
policiesToInclude.Add(PolicyItem.Get(fi.ID));
}
}
List <FactureInfo> listNewPolicies = (List <FactureInfo>)listNewFactureInfos;
foreach (FactureInfo fi in listNewPolicies)
{
if (fi.IsForFacturing)
{
PolicyItem pi = PolicyItem.Get(fi.ID);
if (!policiesToInclude.Contains(pi))
{
policiesToInclude.Add(pi);
}
}
}
AccountFacture f = AccountFacture.Generate(tbAccountFactureNumber.Text, startDate, endDate, company, u, dateOfPayment, policiesToInclude, this.PageBranch);
if (f != null)
{
lblError.Visible = false;
odsFacturePreview.SelectParameters.Clear();
odsFacturePreview.SelectParameters.Add("id", f.ID.ToString());
odsFactureItems.SelectParameters.Clear();
odsFactureItems.SelectParameters.Add("factureID", f.ID.ToString());
mvMain.SetActiveView(viewFactureItems);
GXGridView1SelectedValue = f.ID;
}
else
{
lblError.Visible = true;
lblError.Font.Bold = true;
lblError.Text = "Не постојат нефактурирани износи";
}
}
