protected void RadGrid1_NeedDataSource(object source, Telerik.Web.UI.GridNeedDataSourceEventArgs e)
{
RscmBkuDataContext rscmdc = new RscmBkuDataContext();
var kelAg = from k in rscmdc.Kel_anggarans
join p in rscmdc.ParentId_DataSource_ComboBoxes on k.PARENT_CODE equals p.KA_CODE
where (k.IS_KAS == false)
select new { KaId = k.KA_ID, KaCode = k.KA_CODE, KaName = k.KA_NAME, Parent = p.KA_NAME, GtCode = k.GT_CODE, Prefix = k.PREFIX, KaLevel=k.KA_LEVEL, Type=k.TYPE, IsDetail=k.IS_DETAIL, IsActive=k.IS_ACTIVE, IsKas=k.IS_KAS };
KelAnggaranCollection kaColl = new KelAnggaranCollection();
ParentIdDataSourceComboBoxQuery parentQ = new ParentIdDataSourceComboBoxQuery("a");
KelAnggaranQuery kaQ = new KelAnggaranQuery("b");
kaQ.Select(kaQ.KaId.As("KaId"), kaQ.KaCode.As("KaCode"), kaQ.KaName.As("KaName"), parentQ.KaName.As("Parent"), kaQ.GtCode.As("GtCode"), kaQ.Prefix.As("Prefix"), kaQ.KaLevel.As("KaLevel"), kaQ.Type.As("Type"), kaQ.IsDetail.As("IsDetail"), kaQ.IsActive.As("IsActive"), kaQ.IsKas.As("IsKas"));
kaQ.InnerJoin(parentQ).On(kaQ.ParentCode == parentQ.KaCode);
kaColl.Load(kaQ);
DataTable dtKA = kaQ.LoadDataTable();
foreach (DataRow dr in dtKA.Rows)
{
for (int i = 0; i <= Convert.ToInt32(dr["KaLevel"]); i++)
{
if (i != 0)
{
dr["KaName"] = " " + dr["KaName"];
dr.AcceptChanges();
}
}
}
//this.RadGrid1.DataSource = kelAg;
this.RadGrid1.DataSource = dtKA;
}
public bool Load(KelAnggaranQuery query)
{
this.query = query;
base.InitQuery(this.query);
return(this.Query.Load());
}
protected void RadGrid1_InsertCommand(object source, Telerik.Web.UI.GridCommandEventArgs e)
{
GridEditableItem editedItem = e.Item as GridEditableItem;
UserControl userControl = (UserControl)e.Item.FindControl(GridEditFormItem.EditFormUserControlID);
string month = DateTime.Now.Month.ToString().Trim();
string autonumber = "";
if (month.Length == 1)
month = ('0' + month).Trim();
Trans Trans = new Trans();
//Auto Number
AutoNumberingQuery anQ = new AutoNumberingQuery();
anQ.SelectAll();
anQ.Where(anQ.KaMonth == month, anQ.KaYear == DateTime.Now.Year.ToString().Trim());
AutoNumberingCollection anColl = new AutoNumberingCollection();
anColl.Load(anQ);
KelAnggaranQuery kaQ = new KelAnggaranQuery();
kaQ.SelectAll();
kaQ.Where(kaQ.KaCode == (userControl.FindControl("cmbTransCODE") as RadComboBox).SelectedValue.Trim());
KelAnggaranCollection kaColl = new KelAnggaranCollection();
kaColl.Load(kaQ);
if (kaColl.Count > 0)
foreach (KelAnggaran kkk in kaColl)
autonumber = kkk.Prefix.Trim();
else
return;
if (anColl.Count == 0)
{
AutoNumbering an = new AutoNumbering { KaYear = DateTime.Now.Year.ToString().Trim(), KaMonth = month, LastNumber = 1, PrefixNumber = "000" };
autonumber = String.Format("{0}{1}{2}-0001", autonumber, DateTime.Now.Year.ToString().Trim(), month);
an.Save();
}
else
foreach (AutoNumbering aa in anColl)
{
string i = (aa.LastNumber + 1).ToString().Trim();
if (i.Length == 1)
autonumber = String.Format("{0}{1}{2}-000{3}", autonumber, aa.KaYear, aa.KaMonth, i);
if (i.Length == 2)
autonumber = String.Format("{0}{1}{2}-00{3}", autonumber, aa.KaYear, aa.KaMonth, i);
if (i.Length == 3)
autonumber = String.Format("{0}{1}{2}-0{3}", autonumber, aa.KaYear, aa.KaMonth, i);
if (i.Length == 4)
autonumber = String.Format("{0}{1}{2}-{3}", autonumber, aa.KaYear, aa.KaMonth, i);
AutoNumbering anb = new AutoNumbering();
if (anb.LoadByPrimaryKey((long)aa.Id))
{
anb.LastNumber = aa.LastNumber + 1;
anb.Save();
}
}
try
{
Trans.KaCode = (userControl.FindControl("cmbTransCODE") as RadComboBox).SelectedValue.ToUpper();
Trans.TransNumber = autonumber.ToUpper();
Trans.CekBgNumber = (userControl.FindControl("txtCek") as RadTextBox).Text.ToUpper();
//Trans.Amount = Convert.ToDecimal((userControl.FindControl("txtDebitAmount") as RadNumericTextBox).Value - (userControl.FindControl("txtCreditAmount") as RadNumericTextBox).Value);
Trans.DebitAmount = Convert.ToDecimal((userControl.FindControl("txtDebitAmount") as RadNumericTextBox).Value);
Trans.CreditAmount = Convert.ToDecimal((userControl.FindControl("txtCreditAmount") as RadNumericTextBox).Value);
Trans.Descript = (userControl.FindControl("txtDESC") as RadTextBox).Text.ToUpper();
Trans.KasId = (userControl.FindControl("cmbKasID") as RadComboBox).SelectedValue.ToUpper();
Trans.TransDate = (DateTime)(userControl.FindControl("dtpTransDate") as RadDatePicker).DbSelectedDate;
Trans.UserInsert = "toro";
Trans.TglInsert = DateTime.Now;
Trans.PeriodId = (Int32)HttpContext.Current.Session["_periodeId"];
Trans.Isverified = false;
Trans.IsClosed = false;
Trans.Save();
}
catch (Exception ex)
{
string es = ex.Message;
}
finally
{
RadGrid1.Rebind();
}
}
private DataTable GetDataTableKA()
{
KelAnggaranQuery kaQ = new KelAnggaranQuery();
kaQ.es2.Connection.Name = "LIVE";
kaQ.Select(kaQ.KaCode, kaQ.KaName);
kaQ.Where(kaQ.KaLevel == 3);
dtKa = kaQ.LoadDataTable();
return dtKa;
}