public void BindSPDViewForADH()
{
try
{
DataTable dataSource = new DataTable();
List <string> listCostCenter = new List <string>();
listCostCenter = getListCosCenterADH(karyawan.nrp);
if (listCostCenter.Count > 0)
{
//header.Text = "List Approval ADH";
foreach (var item in listCostCenter)
{
ESPDJson Row = new ESPDJson();
Row.FISCAL_YEAR = DateTime.Now.Year.ToString();
Row.FUNDS_CTR = item;
Row.NO_ESPD = "";
Row.TRANSPORT = "0";
Row.AKOMODASI = "0";
Row.UANG_MAKAN = "0";
Row.UANG_SAKU = "0";
string Response = ESPDBudget.CheckBudgetSAP(Row);
if (!string.IsNullOrEmpty(Response))
{
var result = Newtonsoft.Json.JsonConvert.DeserializeObject <dynamic>(Response);
string message = result["BudgetESPD_Res_MT"]["ROW"]["RESP_MESSAGE"];
if (message.Contains("berhasil terkirim"))
{
Row.TRANSPORT = result["BudgetESPD_Res_MT"]["ROW"]["TRANSPORT"];
Row.AKOMODASI = result["BudgetESPD_Res_MT"]["ROW"]["AKOMODASI"];
Row.UANG_MAKAN = result["BudgetESPD_Res_MT"]["ROW"]["UANG_MAKAN"];
Row.UANG_SAKU = result["BudgetESPD_Res_MT"]["ROW"]["UANG_SAKU"];
GetViewBudgetSPD(Row, dataSource);
}
}
}
ViewADH.DataSource = dataSource;
ViewADH.DataBind();
}
}
catch (Exception e)
{
}
}
private void GetViewBudgetSPD(ESPDJson spdDetail, DataTable dt)
{
int UangMakan = 0, UangSaku = 0, Akomodasi = 0, Transportasi = 0;
if (spdDetail.UANG_MAKAN != "0")
{
UangMakan = int.Parse(spdDetail.UANG_MAKAN.Remove(spdDetail.UANG_MAKAN.IndexOf(',')).Replace(".", ""));
}
if (spdDetail.UANG_SAKU != "0")
{
UangSaku = int.Parse(spdDetail.UANG_SAKU.Remove(spdDetail.UANG_SAKU.IndexOf(',')).Replace(".", ""));
}
if (spdDetail.AKOMODASI != "0")
{
Akomodasi = int.Parse(spdDetail.AKOMODASI.Remove(spdDetail.AKOMODASI.IndexOf(',')).Replace(".", ""));
}
if (spdDetail.TRANSPORT != "0")
{
Transportasi = int.Parse(spdDetail.TRANSPORT.Remove(spdDetail.TRANSPORT.IndexOf(',')).Replace(".", ""));
}
string constr = ConfigurationManager.ConnectionStrings["SPDConnectionString1"].ConnectionString;
using (SqlConnection con = new SqlConnection(constr))
{
using (SqlCommand cmd = new SqlCommand("GetBiayaSPD"))
{
cmd.Parameters.AddWithValue("@CostCenter", spdDetail.FUNDS_CTR);
cmd.Parameters.AddWithValue("@UangMakan", UangMakan);
cmd.Parameters.AddWithValue("@Uang_Saku", UangSaku);
cmd.Parameters.AddWithValue("@Transportasi_", Transportasi);
cmd.Parameters.AddWithValue("@Akomodasi_", Akomodasi);
using (SqlDataAdapter sda = new SqlDataAdapter())
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Connection = con;
sda.SelectCommand = cmd;
sda.Fill(dt);
dt.Rows.Add();
}
}
}
}
