protected void ASPxGridView1_StartRowEditing(object sender, DevExpress.Web.Data.ASPxStartRowEditingEventArgs e)
{
AccountingPeriod currentEdit = session.GetObjectByKey <AccountingPeriod>(Guid.Parse(e.EditingKeyValue.ToString()));
Guid accountingPeriodId = Guid.Parse(e.EditingKeyValue.ToString());
if (AccountingPeriodBO.IsChildOfAnother(session, accountingPeriodId))
{
e.Cancel = true;
(sender as ASPxGridView).CancelEdit();
throw new Exception("Chu kì kế toán này đang là chu kì trực thuộc của một chu kì khác! Không thể chỉnh sửa");
}
Session["AccountingPeriodId_cr"] = currentEdit.AccountingPeriodId;
ASPxGridLookup grid = ASPxGridView1.FindEditRowCellTemplateControl(ASPxGridView1.Columns[5] as GridViewDataColumn, "cp_Grid1").FindControl("GridUnderPeriod") as ASPxGridLookup;
if (currentEdit.AccountingPeriodTypeId.IsDefault == true)
{
XPOAccountingPeriodLookup.Criteria = "[RowStatus] > 0s And [IsActive] = True And [IsActive] <> True And [Code] <> 'NAAN_DEFAULT' And [AccountingPeriodTypeId.IsDefault] = True";
grid.Enabled = false;
}
else
{
XPOAccountingPeriodLookup.Criteria = "[RowStatus] > 0s And [IsActive] = True And [Code] <> 'NAAN_DEFAULT' And [AccountingPeriodTypeId.IsDefault] = True";
grid.Enabled = true;
}
}
protected void ASPxGridView1_RowInserting(object sender, DevExpress.Web.Data.ASPxDataInsertingEventArgs e)
{
if (e.NewValues["IsActive"] == null)
{
e.NewValues["IsActive"] = false;
}
if (Util.isExistXpoObject <AccountingPeriod>("Code", (string)e.NewValues["Code"]))
{
e.Cancel = true;
throw (new Exception("Trùng mã chu kì"));
return;
}
if (e.NewValues["AccountingPeriodTypeId!Key"] == null)
{
e.Cancel = true;
throw (new Exception("Chưa chọn thể loại"));
return;
}
AccountingPeriod accountingPeriod = new AccountingPeriod(session);
accountingPeriod.Description = (string)e.NewValues["Description"];
accountingPeriod.Code = (string)e.NewValues["Code"];
accountingPeriod.AccountingPeriodTypeId = session.GetObjectByKey <AccountingPeriodType>(Guid.Parse(e.NewValues["AccountingPeriodTypeId!Key"].ToString()));
accountingPeriod.FromDateTime = (DateTime)e.NewValues["FromDateTime"];
accountingPeriod.ToDateTime = (DateTime)e.NewValues["ToDateTime"];
accountingPeriod.RowStatus = Constant.ROWSTATUS_ACTIVE;
accountingPeriod.IsActive = (bool)e.NewValues["IsActive"];
if (accountingPeriod.Code != null)
{
accountingPeriod.Save();
}
ASPxGridLookup grid = ASPxGridView1.FindEditRowCellTemplateControl(ASPxGridView1.Columns[5] as GridViewDataColumn, "cp_Grid1").FindControl("GridUnderPeriod") as ASPxGridLookup;
List <object> selectedRows = grid.GridView.GetSelectedFieldValues("AccountingPeriodId");
if (!accountingPeriod.AccountingPeriodTypeId.IsDefault)
{
foreach (var o in selectedRows)
{
AccountingPeriodBO.CreatAccountingPeriodComposite(session, accountingPeriod.AccountingPeriodId, Guid.Parse(o.ToString()));
}
}
e.Cancel = true;
ASPxGridView1.CancelEdit();
}
protected void ASPxGridView1_RowUpdating(object sender, DevExpress.Web.Data.ASPxDataUpdatingEventArgs e)
{
try
{
AccountingPeriod currentAP = session.GetObjectByKey <AccountingPeriod>((Guid)e.Keys[0]);
if (Util.isExistXpoObject <AccountingPeriod>("Code", e.NewValues["Code"].ToString()))
{
CriteriaOperator criteria0 = new BinaryOperator("Code", e.NewValues["Code"].ToString(), BinaryOperatorType.Equal);
CriteriaOperator criteria1 = new BinaryOperator("AccountingPeriodId", e.Keys[0], BinaryOperatorType.NotEqual);
CriteriaOperator criteria2 = new BinaryOperator("RowStatus", Constant.ROWSTATUS_ACTIVE, BinaryOperatorType.GreaterOrEqual);
CriteriaOperator cr = new GroupOperator(GroupOperatorType.And, criteria0, criteria1, criteria2);
AccountingPeriod ap = session.FindObject <AccountingPeriod>(cr);
if (ap != null)
{
e.Cancel = true;
throw (new Exception("Trùng mã chu kì"));
return;
}
}
ASPxGridLookup grid = ASPxGridView1.FindEditRowCellTemplateControl(ASPxGridView1.Columns[5] as GridViewDataColumn, "cp_Grid1").FindControl("GridUnderPeriod") as ASPxGridLookup;
CriteriaOperator criteria_0 = new BinaryOperator("AccountingPeriodId", currentAP, BinaryOperatorType.Equal);
CriteriaOperator criteria_1 = new BinaryOperator("RowStatus", Constant.ROWSTATUS_ACTIVE, BinaryOperatorType.GreaterOrEqual);
CriteriaOperator criteria = new GroupOperator(GroupOperatorType.And, criteria_0, criteria_1);
XPCollection <AccountingPeriodComposite> collection = new XPCollection <AccountingPeriodComposite>(session, criteria);
foreach (AccountingPeriodComposite cp in collection)
{
cp.RowStatus = Constant.ROWSTATUS_DELETED;
cp.Save();
}
List <object> selectedRows = grid.GridView.GetSelectedFieldValues("AccountingPeriodId");
if (!currentAP.AccountingPeriodTypeId.IsDefault)
{
foreach (var o in selectedRows)
{
AccountingPeriodBO.CreatAccountingPeriodComposite(session, currentAP.AccountingPeriodId, Guid.Parse(o.ToString()));
}
}
}
catch (Exception)
{
throw (new Exception("Trùng mã chu kì"));
}
}
protected void cmb_FromCurrency_CustomJSProperties(object sender, DevExpress.Web.ASPxClasses.CustomJSPropertiesEventArgs e)
{
ASPxComboBox cmb = sender as ASPxComboBox;
object[] yahooRate = new object[cmb.Items.Count];
string sql = "";
//ASPxComboBox _fromCurrency = ASPxGridView1.FindEditRowCellTemplateControl(null, "cmb_FromCurrency") as ASPxComboBox;
//ASPxComboBox _toCurrency = ASPxGridView1.FindEditRowCellTemplateControl(null, "cmb_ToCurrency") as ASPxComboBox;
ASPxDateEdit _exRateDate = ASPxGridView1.FindEditRowCellTemplateControl(null, "Date_ExRateDate") as ASPxDateEdit;
//if (_exRateDate != null && SafeValue.SafeDate(_exRateDate.Date, new DateTime(1753, 01, 01)).ToString("yyyy-MM-dd") == DateTime.Today.ToString("yyyy-MM-dd") && _fromCurrency != null && _toCurrency != null && SafeValue.SafeString(_fromCurrency.Text).Length == 3 && SafeValue.SafeString(_toCurrency.Text).Length == 3)
//{
for (int i = 0; i < cmb.Items.Count; i++)
{
Stream objStream;
StreamReader objSR;
System.Text.Encoding encode = System.Text.Encoding.GetEncoding("utf-8");
string str = "http://download.finance.yahoo.com/d/quotes.csv?s=" + cmb.Items[i].Text + System.Configuration.ConfigurationManager.AppSettings["Currency"] + "=X&f=l1";
HttpWebRequest wrquest = (HttpWebRequest)WebRequest.Create(str);
HttpWebResponse getresponse = null;
getresponse = (HttpWebResponse)wrquest.GetResponse();
objStream = getresponse.GetResponseStream();
objSR = new StreamReader(objStream, encode, true);
string strResponse = objSR.ReadToEnd();
yahooRate[i] = SafeValue.SafeDecimal(strResponse, 0);
}
//}
//else
//{
// for (int i = 0; i < cmb.Items.Count; i++)
// {
// yahooRate[i] = 0;
// }
//}
e.Properties["cpYahooRate"] = yahooRate;
}
protected void ASPxGridView1_RowUpdating(object sender, DevExpress.Web.Data.ASPxDataUpdatingEventArgs e)
{
string biegly = (string)Session["idMediatora"];
e.NewValues["id_bieglego"] = biegly;
ASPxPageControl pageControl = ASPxGridView1.FindEditFormTemplateControl("ASPxPageControl1") as ASPxPageControl;
// ASPxComboBox combobox = pageControl.FindControl("ASPxComboBox1") as ASPxComboBox;
ASPxComboBox combobox = ASPxGridView1.FindEditRowCellTemplateControl((GridViewDataColumn)ASPxGridView1.Columns["nazwa"], "ASPxComboBox1") as ASPxComboBox;
var id = e.OldValues["id_"];
try
{
var idspecjalizacji = combobox.SelectedItem.Value;
e.NewValues["id_specjalizacji"] = idspecjalizacji;
Int64 te = (Int64)Session["key"];
e.NewValues["id"] = te;
e.NewValues["id_"] = te;
}
catch (Exception ex)
{ }
Session["flagaSkarg"] = 1;
}
