public static List <PenjaminanDataset.m_pemegangsahamRow> selectSahamFK(decimal fk)
{
PenjaminanDatasetTableAdapters.m_pemegangsahamTableAdapter ta = new PenjaminanDatasetTableAdapters.m_pemegangsahamTableAdapter();
PenjaminanDataset.m_pemegangsahamDataTable dt = new PenjaminanDataset.m_pemegangsahamDataTable();
List <PenjaminanDataset.m_pemegangsahamRow> SahamList = new List <PenjaminanDataset.m_pemegangsahamRow>();
try
{
ta.FillByFkMitra(dt, fk);
if (dt.Count > 0)
{
for (int i = 0; i < dt.Count; i++)
{
SahamList.Add(dt[i]);
}
}
return(SahamList);
}
catch (Exception ex)
{
throw new ApplicationException("Failed to load Employee data : " + ex.Message);
}
}
public static void Delete(int fkMitra)
{
PenjaminanDatasetTableAdapters.m_pemegangsahamTableAdapter taX = new PenjaminanDatasetTableAdapters.m_pemegangsahamTableAdapter();
PenjaminanDataset.m_pemegangsahamDataTable dt = taX.GetDataByFkMitra(Convert.ToDecimal(fkMitra));
try
{
taX.softDelete(1, fkMitra);
}
catch (Exception ex)
{
throw new ApplicationException(ex.Message, ex);
}
}
public static void insertData(List <Object.PemegangSaham> b, int idMitra)
{
PenjaminanDatasetTableAdapters.m_pemegangsahamTableAdapter ta = new PenjaminanDatasetTableAdapters.m_pemegangsahamTableAdapter();
foreach (var data in b)
{
try
{
if (data.id != 0)
{
int newID = data.id;
PenjaminanDatasetTableAdapters.m_pemegangsahamTableAdapter taX = new PenjaminanDatasetTableAdapters.m_pemegangsahamTableAdapter();
PenjaminanDataset.m_pemegangsahamDataTable dt = taX.GetDataByID(newID);
try
{
if (dt != null)
{
ta.UpdateQuery(data.name, data.jumlah, data.total, data.persentase, DateTime.Now, 2, data.id);
idMitra = data.fk_mitra;
}
}
catch (Exception ex)
{
throw new ApplicationException(ex.Message, ex);
}
}
else
{
ta.InsertQuerypemegangsaham(idMitra, data.name, data.jumlah, data.total, data.persentase, 1, DateTime.Now, DateTime.Now, 0, 1);
}
}
catch (Exception ex)
{
throw new ApplicationException(ex.Message, ex);
}
}
}