protected void dgSKPersetujuan_ItemCommand(object source, DataGridCommandEventArgs e) { List<SKPersetujuan> coll = new List<SKPersetujuan>(); if (ViewState["SKPERSETUJUAN"] != null) coll = ViewState["SKPERSETUJUAN"] as List<SKPersetujuan>; if (e.CommandName == "add") { TextBox txtNoAdd = e.Item.FindControl("txtNoAdd") as TextBox; TextBox txtKeteranganAdd = e.Item.FindControl("txtKeteranganAdd") as TextBox; FileUpload fuAdd = e.Item.FindControl("fuAdd") as FileUpload; if (isExistInNPWPGrid(txtNoAdd.Text, "lblNo")) { Util.ShowMessage(Page, SR.DataIsExist(txtNoAdd.Text.Trim())); return; } if (isExistInNPWPGrid(fuAdd.FileName, "lblAtttachmentHidden")) { Util.ShowMessage(Page, SR.DataIsExist(fuAdd.FileName)); return; } SKPersetujuan o = new SKPersetujuan(); o.No = txtNoAdd.Text.Trim(); o.Keterangan = txtKeteranganAdd.Text.Trim(); Stream strm = fuAdd.PostedFile.InputStream; byte[] bytes = new byte[Convert.ToInt32(fuAdd.PostedFile.ContentLength)]; strm.Read(bytes, 0, Convert.ToInt32(fuAdd.PostedFile.ContentLength)); strm.Close(); o.Attachment = bytes; o.NamaFile = fuAdd.FileName; o.ID = 0; coll.Add(o); ViewState["SKPERSETUJUAN"] = coll; } if (e.CommandName == "save") { TextBox txtNoEdit = e.Item.FindControl("txtNoEdit") as TextBox; TextBox txtKeteranganEdit = e.Item.FindControl("txtKeteranganEdit") as TextBox; FileUpload fuEdit = e.Item.FindControl("fuEdit") as FileUpload; if (isExistInNPWPGrid(txtNoEdit.Text, "lblNPWP")) { Util.ShowMessage(Page, SR.DataIsExist(txtNoEdit.Text.Trim())); return; } if (isExistInNPWPGrid(fuEdit.FileName, "lblAtttachmentHidden")) { Util.ShowMessage(Page, SR.DataIsExist(fuEdit.FileName)); return; } SKPersetujuan o = coll[e.Item.ItemIndex] as SKPersetujuan; o.No = txtNoEdit.Text.Trim(); o.Keterangan = txtKeteranganEdit.Text.Trim(); if (fuEdit.PostedFile != null) { if (fuEdit.PostedFile.ContentLength > 0) { Stream strm = fuEdit.PostedFile.InputStream; byte[] bytes = new byte[Convert.ToInt32(fuEdit.PostedFile.ContentLength)]; strm.Read(bytes, 0, Convert.ToInt32(fuEdit.PostedFile.ContentLength)); strm.Close(); o.Attachment = bytes; o.NamaFile = fuEdit.FileName; } } coll[e.Item.ItemIndex] = o; ViewState["SKPERSETUJUAN"] = coll; dgSKPersetujuan.EditItemIndex = -1; dgSKPersetujuan.ShowFooter = true; } if (e.CommandName == "edit") { dgSKPersetujuan.ShowFooter = false; dgSKPersetujuan.EditItemIndex = e.Item.ItemIndex; } if (e.CommandName == "cancel") { dgSKPersetujuan.EditItemIndex = -1; dgSKPersetujuan.ShowFooter = true; } if (e.CommandName == "delete") { coll.RemoveAt(e.Item.ItemIndex); ViewState["NPWP"] = coll; } BindSKPersetujuan(); }
private void GetSKPersetujuan(int id) { SPQuery query = new SPQuery(); query.Query = "<Where>" + "<Eq>" + "<FieldRef Name='PerubahanAnggaran' LookupId='True' />" + "<Value Type='Lookup'>" + id + "</Value>" + "</Eq>" + "</Where>" + "<OrderBy>" + "<FieldRef Name='Created' Ascending='False' />" + "</OrderBy>"; SPList list = web.GetList(Util.CreateSharePointDocLibStrUrl(web.Url, "SKPersetujuan")); SPListItemCollection collSPPerubahan = list.GetItems(query); List<SKPersetujuan> collDokumen = new List<SKPersetujuan>(); foreach (SPListItem i in collSPPerubahan) { SKPersetujuan o = new SKPersetujuan(); o.ID = i.ID; o.NamaFile = i["Name"].ToString(); o.No = i["No"].ToString(); if (i["Keterangan"] != null) o.Keterangan = i["Keterangan"].ToString(); o.Attachment = i.File.OpenBinary(); o.Url = string.Format("<a href='/SKPersetujuan/{0}'>{0}</a>", i["Name"].ToString()); o.IsDeleted = false; collDokumen.Add(o); } ViewState["SKPERSETUJUAN"] = collDokumen; }