protected void Page_Load(object sender, EventArgs e)
{
// InvoiceItemsGrid Control
_sqlDataSourceInvoiceItems = InvoiceItemGrid1.GetSqlDataSourceInvoiceItems();
_radGridInvoiceItems = InvoiceItemGrid1.GetRadGridInvoiceItems();
_radGridInvoiceItems.PreRender += _radGridInvoiceItems_PreRender;
InvoiceItemGrid1.SetEditMode(false);
// PaymentHistoryGrid control
_linqDataSourcePaymentHistory = PaymentHistoryGrid1.GetLinqDataSourcePaymentHistory();
_radGridPaymentHistory = PaymentHistoryGrid1.GetRadGridPaymentHistory();
_radGridPaymentHistory.SelectedIndexChanged += Payment_SelectedIndexChanged;
if (!IsPostBack)
{
var excel = RadToolBarPaymentTop.FindItemByText("Excel");
if (CurrentGroupId == (int)CConstValue.UserGroupForAccountExcelExport.Accounting ||
CurrentGroupId == (int)CConstValue.UserGroupForAccountExcelExport.IT)
{
excel.Visible = true;
}
var btnDetailStudentReciept = RadToolBarPayment.FindItemByText("Student Detail Reciept");
var btnDetailAgencyReciept = RadToolBarPayment.FindItemByText("Agency Detail Reciept");
btnDetailStudentReciept.Enabled = false;
btnDetailAgencyReciept.Enabled = false;
}
PaymentListSearch();
GetPaymentItems();
}
protected void Page_Load(object sender, EventArgs e)
{
if (Request["Id"] != null)
{
int InvoiceId = 0;
var cDormitoryStudent = new CDormitoryRegistrations();
InvoiceId = cDormitoryStudent.GetInvoiceIdbyDormitoryStudentId(Convert.ToInt32(Request["Id"]));
// Payment
_linqDataSourcePaymentHistory = PaymentHistoryGrid1.GetLinqDataSourcePaymentHistory();
_radGridPaymentHistory = PaymentHistoryGrid1.GetRadGridPaymentHistory();
_linqDataSourcePaymentHistory.WhereParameters.Clear();
_linqDataSourcePaymentHistory.WhereParameters.Add("InvoiceId", DbType.Int32, InvoiceId.ToString());
//_linqDataSourcePaymentHistory.WhereParameters.Add("InvoiceId", DbType.Int32, "26367");
_linqDataSourcePaymentHistory.Where = "InvoiceId == @InvoiceId";
//Invoice Item
_sqlDataSourceInvoiceItems = InvoiceItemGrid1.GetSqlDataSourceInvoiceItems();
_radGridInvoiceItems = InvoiceItemGrid1.GetRadGridInvoiceItems();
// connect event of invoice Items.
InvoiceItemGrid1.SetEditMode(false);
_sqlDataSourceInvoiceItems.WhereParameters.Clear();
_sqlDataSourceInvoiceItems.WhereParameters.Add("InvoiceId", DbType.Int32, InvoiceId.ToString());
//_sqlDataSourceInvoiceItems.WhereParameters.Add("InvoiceId", DbType.Int32, "26367");
_sqlDataSourceInvoiceItems.Where = "InvoiceId == @InvoiceId";
}
}
protected void Page_Load(object sender, EventArgs e)
{
// find user control
_radGridInvoiceItems = InvoiceItemGrid1.GetRadGridInvoiceItems();
// connect event of invoice Items.
_radGridInvoiceItems.PreRender += _radGridInvoiceItems_PreRender;
_radGridInvoiceItems.MasterTableView.DataSourceID = null;
_radGridInvoiceItems.DataSourceID = null;
// just view
InvoiceItemGrid1.SetEditMode(false);
Id = Convert.ToInt32(Request["id"]);
if (!IsPostBack)
{
var global = new CGlobal();
var cStudent = new CStudent();
var student = cStudent.Get(Id);
var studentSite = new CSiteLocation().Get(student.SiteLocationId);
StudentSiteId = studentSite.SiteId;
StudentSiteLocationId = student.SiteLocationId;
LoadAgency();
LoadFaculty();
LoadProgramGroup("0");
LoadProgram("0");
ddlProgramWeeks.DataSource = new CProgram().GetProgramWeeksList();
ddlProgramWeeks.DataTextField = "Name";
ddlProgramWeeks.DataValueField = "Value";
ddlProgramWeeks.DataBind();
ddlPrgHours.DataSource = global.GetDictionary(150);
ddlPrgHours.DataTextField = "Name";
ddlPrgHours.DataValueField = "Value";
ddlPrgHours.DataBind();
var cCountry = new CCountry().Get((int)student.CountryId);
var cCountryMarket = new CCountryMarket().Get((int)cCountry.CountryMarketId);
ViewState["CountryMarketId"] = cCountry.CountryMarketId;
ttName1.Text = cStudent.GetStudentName(student) + " [" + student.StudentNo + "]";
ttName2.Text = cCountryMarket.Name;
}
ddlAgency.OpenDropDownOnLoad = false;
ddlFaculty.OpenDropDownOnLoad = false;
ddlProgramGrp.OpenDropDownOnLoad = false;
ddlProgramName.OpenDropDownOnLoad = false;
ddlProgramWeeks.OpenDropDownOnLoad = false;
ddlPrgHours.OpenDropDownOnLoad = false;
}
protected void Page_Load(object sender, EventArgs e)
{
// find user control
_sqlDataSourceInvoiceItems = InvoiceItemGrid1.GetSqlDataSourceInvoiceItems();
_radGridInvoiceItems = InvoiceItemGrid1.GetRadGridInvoiceItems();
// just view
InvoiceItemGrid1.SetEditMode(false);
_sqlDataSourceInvoiceItems.WhereParameters.Clear();
_sqlDataSourceInvoiceItems.WhereParameters.Add("InvoiceId", DbType.Int32, Request["id"]);
_sqlDataSourceInvoiceItems.Where = "InvoiceId == @InvoiceId";
}
public override void SetVisibleModifyControllers()
{
if (UserPermissionModel.IsModify == false)
{
// toolbar
foreach (RadToolBarItem toolbarItem in RadToolBar1.Items)
{
toolbarItem.Enabled = false;
}
ddlFG.Enabled = false;
InvoiceItemGrid1.SetEditMode(false);
}
}
private void _radGridInvoiceItems_PreRender(object sender, EventArgs e)
{
if (RadGridInvoice.SelectedValue != null)
{
// save invoiceId
InvoiceItemGrid1.InvoiceId = (int)RadGridInvoice.SelectedValue;
}
// validation
InvoiceItemGrid1.ValidateInvoiceItems();
// Get Select
// todo: here is problem....
GetInvoiceItems();
SetVisibleModifyControllers();
}
protected void Page_Load(object sender, EventArgs e)
{
// find Invoice user control
_radGridInvoiceItems = InvoiceItemGrid1.GetRadGridInvoiceItems();
// connect event of invoice Items.
_radGridInvoiceItems.PreRender += _radGridInvoiceItems_PreRender;
_radGridInvoiceItems.MasterTableView.DataSourceID = null;
_radGridInvoiceItems.DataSourceID = null;
// just view
InvoiceItemGrid1.SetEditMode(false);
Id = Convert.ToInt32(Request["id"].ToString()); //HomestayStudentId
StudentIdFromStudentRegistrar = Convert.ToInt32(Request["StudentId"].ToString());
if (Request["ScheduleChange"] != null)
{
string sc = Request["ScheduleChange"].ToString();
ScheduleChange = Convert.ToInt32(sc);
}
if (!IsPostBack)
{
file_upload.InitFileDownloadList((int)CConstValue.Upload.Homestay);
var global = new CGlobal();
SetDateTime();
if (Id > 0)
{
FillFormData(Id); //Fill Form if it's not a new request
UpdateToolBar.Items[0].Text = "Requested";
}
Dropdown_StudentlList(Id, StudentIdFromStudentRegistrar); // Load Student List
if (ScheduleChange == 1) // Schedule Change
{
ShowScheduleChange(true);
}
else
{
ShowScheduleChange(false);
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
//if (Request["__EVENTTARGET"] == "btnNew" &&
//Request["__EVENTARGUMENT"] == "MyArgument")
//{
// //do something
//}
// Refund_R
InvoiceItemGrid1.SetTypeOfInvoiceCoaItem(2);
RefundId = Convert.ToInt32(Request["id"]);
// find user control
_sqlDataSourceInvoiceItems = InvoiceItemGrid1.GetSqlDataSourceInvoiceItems();
_radGridInvoiceItems = InvoiceItemGrid1.GetRadGridInvoiceItems();
// connect event of invoice Items.
_radGridInvoiceItems.PreRender += _radGridInvoiceItems_PreRender;
//_radGridInvoiceItems.MasterTableView.CommandItemSettings.ShowSaveChangesButton = false;
FileDownloadList1.InitFileDownloadList((int)CConstValue.Upload.Refund);
CreditMemoPayout1.SetReadonly(false);
if (!IsPostBack)
{
//// new
//if (Request["type"] == "0")
//{
// // nothing
//}
//else
//{
var cRefund = new CRefund();
var refund = cRefund.Get(RefundId);
FileDownloadList1.GetFileDownload(refund.RefundId);
InvoiceItemGrid1.InvoiceId = refund.InvoiceId;
InvoiceItemGrid1.SetEditMode(true);
CreditMemoPayout1.SetCreditVisible(true);
var cCreditMemoPayout = new CCreditMemoPayout();
var creditMemoPayout = cCreditMemoPayout.Get(refund.CreditMemoPayoutId);
CreditMemoPayout1.SetData(creditMemoPayout);
//}
}
}
protected void Page_Load(object sender, EventArgs e)
{
// find user control
_sqlDataSourceInvoiceItems = InvoiceItemGrid1.GetSqlDataSourceInvoiceItems();
_radGridInvoiceItems = InvoiceItemGrid1.GetRadGridInvoiceItems();
_radGridInvoiceItems.MasterTableView.CommandItemSettings.ShowSaveChangesButton = false;
// Simple
InvoiceItemGrid1.SetTypeOfInvoiceCoaItem(1);
if (!IsPostBack)
{
InvoiceItemGrid1.SetEditMode(true);
var cStudent = new CStudent();
var student = cStudent.GetStudentList(CurrentSiteLocationId);
foreach (var stu in student)
{
RadComboBoxMenu.Items.Add(new RadComboBoxItem(cStudent.GetStudentName(stu) + "(" + stu.StudentNo + ")", stu.StudentId.ToString()));
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
// find user control
_radGridInvoiceItems = InvoiceItemGrid1.GetRadGridInvoiceItems();
// connect event of invoice Items.
_radGridInvoiceItems.PreRender += _radGridInvoiceItems_PreRender;
_radGridInvoiceItems.MasterTableView.DataSourceID = null;
_radGridInvoiceItems.DataSourceID = null;
// just view
InvoiceItemGrid1.SetEditMode(false);
Id = Convert.ToInt32(Request["id"]);
if (!IsPostBack)
{
var cStudent = new CStudent();
var student = cStudent.Get(Id);
LoadAgency(student.SiteLocationId);
var cCountry = new CCountry().Get((int)student.CountryId);
var cCountryMarket = new CCountryMarket().Get((int)cCountry.CountryMarketId);
ViewState["CountryMarketId"] = cCountry.CountryMarketId;
ttName1.Text = cStudent.GetStudentName(student) + " [" + student.StudentNo + "]";
ttName2.Text = cCountryMarket.Name;
// Package Program
ddlPackageProgram.DataSource = new CPackageProgram().GetPackageProgramBySiteIdAndCountryId(student.SiteLocationId);
ddlPackageProgram.DataTextField = "Name";
ddlPackageProgram.DataValueField = "Value";
ddlPackageProgram.DataBind();
if (ddlPackageProgram.Items.Count > 0)
{
SetPackageProgramData(ddlPackageProgram.Items[0].Value);
}
}
ddlPackageProgram.OpenDropDownOnLoad = false;
}
public void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
//var scriptManager = (RadScriptManager)Page.Master.FindControl("RadScriptManager1");
//scriptManager.RegisterPostBackControl(RadToolBar1.FindItemByText("Excel"));
if (CurrentGroupId == (int)CConstValue.UserGroupForAccountExcelExport.Accounting ||
CurrentGroupId == (int)CConstValue.UserGroupForAccountExcelExport.IT)
{
RadToolBar1.FindItemByText("Excel").Visible = true;
RadToolBar1.FindItemByText("ExcelDetail").Visible = true;
}
}
// find user control
_sqlDataSourceInvoiceItems = InvoiceItemGrid1.GetSqlDataSourceInvoiceItems();
_radGridInvoiceItems = InvoiceItemGrid1.GetRadGridInvoiceItems();
// connect event of invoice Items.
_radGridInvoiceItems.PreRender += _radGridInvoiceItems_PreRender;
InvoiceListSearch();
}
protected void RadToolBar1_ButtonClick(object sender, RadToolBarEventArgs e)
{
switch (e.Item.Text)
{
case "Save":
if (IsValid)
{
foreach (var chkItem in RadComboBoxMenu.CheckedItems)
{
var cInvoice = new CInvoice();
var invoice = new Erp2016.Lib.Invoice();
invoice.StudentId = Convert.ToInt32(chkItem.Value);
invoice.Status = (int)CConstValue.InvoiceStatus.Pending; // pending
invoice.SiteLocationId = CurrentSiteLocationId;
invoice.InvoiceType = (int)CConstValue.InvoiceType.Simple; //Simple Invoice(SI)
invoice.CreatedId = CurrentUserId;
invoice.CreatedDate = DateTime.Now;
var invoiceId = cInvoice.Add(invoice); //DB:Invoice
if (invoiceId > 0)
{
var cInvoiceItem = new CInvoiceItem();
var gridData = InvoiceItemGrid1.GetGridData();
gridData = gridData.Insert(0, ",");
var gridDataRows = gridData.Split('|');
foreach (var gridDataRow in gridDataRows)
{
if (string.IsNullOrEmpty(gridDataRow))
{
break;
}
var gridDataRowCell = gridDataRow.Split(',');
var invoiceCoaItem = gridDataRowCell[1];
var standardPrice = gridDataRowCell[2];
var studentPrice = gridDataRowCell[3];
var agencyPrice = gridDataRowCell[4];
var remark = gridDataRowCell[5];
var invoiceItem = new InvoiceItem();
invoiceItem.InvoiceId = invoiceId;
var cInvoiceCoaItem = new CInvoiceCoaItem();
invoiceItem.InvoiceCoaItemId = cInvoiceCoaItem.Get(invoiceCoaItem).InvoiceCoaItemId;
if (!string.IsNullOrEmpty(standardPrice))
{
invoiceItem.StandardPrice = Convert.ToDecimal(standardPrice.Replace("$", string.Empty));
}
if (!string.IsNullOrEmpty(studentPrice))
{
invoiceItem.StudentPrice = Convert.ToDecimal(studentPrice.Replace("$", string.Empty));
}
if (!string.IsNullOrEmpty(agencyPrice))
{
invoiceItem.AgencyPrice = Convert.ToDecimal(agencyPrice.Replace("$", string.Empty));
}
invoiceItem.Remark = remark;
invoiceItem.CreatedId = CurrentUserId;
invoiceItem.CreatedDate = DateTime.Now;
cInvoiceItem.Add(invoiceItem);
}
}
}
RunClientScript("Close();");
}
else
{
ShowMessage("Error to add Simple Invoice");
}
break;
case "Cancel":
RunClientScript("Close();");
break;
}
}
public void GetInvoiceItems()
{
var btnConfirm = RadToolBar1.FindItemByText("Confirm");
var btnModify = RadToolBar1.FindItemByText("Modify");
var btnCancel = RadToolBar1.FindItemByText("Cancel");
var btnStudentInvoice = RadToolBar1.FindItemByText("Student Invoice");
var btnAgencyInvoice = RadToolBar1.FindItemByText("Agency Invoice");
var btnNewSimpleInvoice = RadToolBar1.FindItemByText("New Simple Invoice");
if (RadGridInvoice.SelectedValue == null)
{
_sqlDataSourceInvoiceItems.WhereParameters.Clear();
_sqlDataSourceInvoiceItems.WhereParameters.Add("InvoiceId", DbType.Int32, "0");
_sqlDataSourceInvoiceItems.Where = "InvoiceId == @InvoiceId";
LinqDataSourceInvoiceHistory.WhereParameters.Clear();
LinqDataSourceInvoiceHistory.WhereParameters.Add("InvoiceId", DbType.Int32, "0");
LinqDataSourceInvoiceHistory.Where = "InvoiceId == @InvoiceId";
}
else
{
var cInvoice = new CInvoice();
var invoice = cInvoice.Get(Convert.ToInt32(RadGridInvoice.SelectedValue.ToString()));
_sqlDataSourceInvoiceItems.WhereParameters.Clear();
_sqlDataSourceInvoiceItems.WhereParameters.Add("InvoiceId", DbType.Int32, RadGridInvoice.SelectedValue.ToString());
_sqlDataSourceInvoiceItems.Where = "InvoiceId == @InvoiceId";
if (invoice.OriginalInvoiceId != null)
{
LinqDataSourceInvoiceHistory.WhereParameters.Clear();
LinqDataSourceInvoiceHistory.WhereParameters.Add("InvoiceId", DbType.Int32, invoice.InvoiceId.ToString());
LinqDataSourceInvoiceHistory.WhereParameters.Add("InvoiceNumber", DbType.String, invoice.InvoiceNumber.Substring(2, 8));
LinqDataSourceInvoiceHistory.WhereParameters.Add("InvoicePartialIndex", DbType.Int32, invoice.InvoicePartialIndex.ToString());
LinqDataSourceInvoiceHistory.Where = "InvoiceId != @InvoiceId && InvoiceNumber.Contains(@InvoiceNumber) && InvoicePartialIndex < @InvoicePartialIndex";
}
else
{
LinqDataSourceInvoiceHistory.WhereParameters.Clear();
LinqDataSourceInvoiceHistory.WhereParameters.Add("OriginalInvoiceId", DbType.Int32, "0");
LinqDataSourceInvoiceHistory.Where = "InvoiceId == @OriginalInvoiceId";
}
ddlFG.SelectedValue = invoice.IsFinancialGurantee.ToString();
var status = Convert.ToInt32(invoice.Status);
var invoiceType = Convert.ToInt32(invoice.InvoiceType);
var delete = _radGridInvoiceItems.MasterTableView.GetColumn("DeleteColumn");
if (status == (int)CConstValue.InvoiceStatus.Pending)
{
switch (invoiceType)
{
case (int)CConstValue.InvoiceType.Simple:
case (int)CConstValue.InvoiceType.General:
case (int)CConstValue.InvoiceType.Manual:
case (int)CConstValue.InvoiceType.Dormitory:
case (int)CConstValue.InvoiceType.Homestay:
btnConfirm.Enabled = true;
btnModify.Enabled = false;
btnCancel.Enabled = true;
btnStudentInvoice.Enabled = true;
btnAgencyInvoice.Enabled = true;
_radGridInvoiceItems.MasterTableView.CommandItemDisplay = GridCommandItemDisplay.Top;
_radGridInvoiceItems.MasterTableView.EditMode = GridEditMode.Batch;
delete.Visible = true;
ddlFG.Enabled = true;
break;
default:
btnConfirm.Enabled = false; //Confirm
btnModify.Enabled = false; //Modify
btnCancel.Enabled = false; //Cancel
btnStudentInvoice.Enabled = true; //Student Invoice Print
btnAgencyInvoice.Enabled = true; //Agency Invoice Print
_radGridInvoiceItems.MasterTableView.CommandItemDisplay = GridCommandItemDisplay.None;
_radGridInvoiceItems.MasterTableView.EditMode = GridEditMode.InPlace;
delete.Visible = false;
ddlFG.Enabled = false;
break;
}
}
else if (status == (int)CConstValue.InvoiceStatus.Invoiced) //Invoiced
{
switch (invoiceType)
{
case (int)CConstValue.InvoiceType.Simple:
case (int)CConstValue.InvoiceType.General:
case (int)CConstValue.InvoiceType.Manual:
case (int)CConstValue.InvoiceType.Dormitory:
case (int)CConstValue.InvoiceType.Homestay:
btnConfirm.Enabled = false;
btnModify.Enabled = true;
btnCancel.Enabled = true;
btnStudentInvoice.Enabled = true;
btnAgencyInvoice.Enabled = true;
_radGridInvoiceItems.MasterTableView.CommandItemDisplay = GridCommandItemDisplay.None;
_radGridInvoiceItems.MasterTableView.EditMode = GridEditMode.InPlace;
delete.Visible = false;
ddlFG.Enabled = false;
break;
default:
btnConfirm.Enabled = false; //Confirm
btnModify.Enabled = false; //Modify
btnCancel.Enabled = false; //Cancel
btnStudentInvoice.Enabled = true; //Student Invoice Print
btnAgencyInvoice.Enabled = true; //Agency Invoice Print
_radGridInvoiceItems.MasterTableView.CommandItemDisplay = GridCommandItemDisplay.None;
_radGridInvoiceItems.MasterTableView.EditMode = GridEditMode.InPlace;
delete.Visible = false;
ddlFG.Enabled = false;
break;
}
}
else
{
btnConfirm.Enabled = false;
btnModify.Enabled = false;
btnCancel.Enabled = false;
btnStudentInvoice.Enabled = true;
btnAgencyInvoice.Enabled = true;
_radGridInvoiceItems.MasterTableView.CommandItemDisplay = GridCommandItemDisplay.None;
_radGridInvoiceItems.MasterTableView.EditMode = GridEditMode.InPlace;
delete.Visible = false;
ddlFG.Enabled = false;
}
if (invoice.AgencyId != null)
{
var cAgency = new CAgency();
var agency = cAgency.Get(Convert.ToInt32(invoice.AgencyId));
if (agency != null)
{
tbAgencyName.Text = agency.Name;
if (agency.Location != null)
{
var country = new CCountry().Get((int)agency.Location);
tbCountryCity.Text = country.Name;
}
else
{
tbCountryCity.Text = string.Empty;
}
if (agency.ContractStartDate != null && agency.ContractEndDate != null)
{
tbContractDate.Text = agency.ContractStartDate.Value.Date.ToString("MM-dd-yyyy") + " - " + agency.ContractEndDate.Value.Date.ToString("MM-dd-yyyy");
}
tbCommissionRate.Text = invoice.AgencyRate + "%";
tbDescription.Text = agency.Comment;
}
}
else
{
tbAgencyName.Text = "Direct Student";
tbCountryCity.Text = string.Empty;
tbContractDate.Text = string.Empty;
tbCommissionRate.Text = string.Empty;
tbDescription.Text = string.Empty;
}
if (_radGridInvoiceItems.MasterTableView.EditMode == GridEditMode.Batch)
{
InvoiceItemGrid1.SetTypeOfInvoiceCoaItem(invoice.InvoiceType);
}
}
_radGridInvoiceItems.Rebind();
RadGridInvoiceHistory.Rebind();
}
