void GetFromDataRow(DataRow dr)
{
try
{
_rowID = dr.Field <Guid>("RowID");
_noBukti = dr.Field <string>("NoBukti");
_tanggal = dr.Field <DateTime?>("Tanggal");
_perusahaanDariRowID = dr.Field <Guid>("PerusahaanDariRowID");
_perusahaanKeRowID = dr.Field <Guid>("PerusahaanKeRowID");
_cabangDariID = dr.Field <string>("CabangDariID");
_cabangKeID = dr.Field <string>("CabangKeID");
_tipeDKN = (Enums.enumTipeDKN) int.Parse(dr["TipeNota"].ToString());
_tipeHI = (Enums.enumTipeHI) int.Parse(dr["TipeHI"].ToString());
}
catch (Exception ex)
{
string s = ex.Message;
}
}
public static string DKN00To11_new(DataTable tblHeader, UserObject userObject, bool gg)
{
int counter = 0;
DataTable dtResult = new DataTable();
DataTable dtSdhDownload = tblHeader.Clone();
DataTable dt = new DataTable();
// int result = 0;
string _dk = "";
object rslt = null;
using (Database db = new Database())
{
List <Parameter> prm = new List <Parameter>();
string _src, _cabId;
int _tipeHI;
db.BeginTransaction();
// HEADERS
db.Commands.Add(db.CreateCommand("usp_HI00_Download"));
db.Commands.Add(db.CreateCommand("[usp_DKN_Download_newDKN]"));
bool _cabRowID = tblHeader.Columns.Contains("HRowID");
foreach (DataRow dr in tblHeader.Rows)
{
try
{
_src = Tools.isNull(dr["src"], "").ToString();
_tipeHI = (_src == "STR") ? 0 : 1;
_cabId = Tools.isNull(dr["dari"], "").ToString().Trim();
if ((_cabId.Substring(0, 2) != userObject.CabangID) && (userObject.CabangID != "11"))
{
rslt = "Bukan HI Cabang anda.";
}
else
{
//add parameters
_dk = (Tools.isNull(dr["dk"], "").ToString() == "D") ? "K" : "D";
prm.Clear();
prm.Add(new Parameter("@PerusahaanRowID", SqlDbType.UniqueIdentifier, userObject.SelectedPerusahaanRowID));
if (_cabRowID == true)
{
prm.Add(new Parameter("@HRowID", SqlDbType.UniqueIdentifier, new Guid(Tools.isNull(dr["HRowID"], Guid.Empty).ToString())));
}
if (_cabRowID == true)
{
prm.Add(new Parameter("@DRowID", SqlDbType.UniqueIdentifier, new Guid(Tools.isNull(dr["DtRowID"], Guid.Empty).ToString())));
}
prm.Add(new Parameter("@HRecordID", SqlDbType.VarChar, Tools.isNull(dr["idhead"], "").ToString()));
prm.Add(new Parameter("@RecordID", SqlDbType.VarChar, Tools.isNull(dr["iddetail"], "").ToString()));
prm.Add(new Parameter("@Tanggal", SqlDbType.DateTime, dr["tanggal"]));
prm.Add(new Parameter("@NoDKN", SqlDbType.VarChar, Tools.isNull(dr["no_dkn"], "").ToString()));
prm.Add(new Parameter("@TipeHI", SqlDbType.TinyInt, _tipeHI));
prm.Add(new Parameter("@DK", SqlDbType.VarChar, _dk));
prm.Add(new Parameter("@Cabang", SqlDbType.VarChar, Tools.isNull(dr["cabang"], "").ToString()));
prm.Add(new Parameter("@CD", SqlDbType.VarChar, Tools.isNull(dr["cd"], "").ToString()));
prm.Add(new Parameter("@Src", SqlDbType.VarChar, Tools.isNull(dr["src"], "").ToString()));
prm.Add(new Parameter("@NoPerkiraan", SqlDbType.VarChar, Tools.isNull(dr["no_perk"], "").ToString()));
prm.Add(new Parameter("@Uraian", SqlDbType.VarChar, Tools.isNull(dr["uraian"], "").ToString()));
prm.Add(new Parameter("@Jumlah", SqlDbType.Money, (dr["jumlah"])));
prm.Add(new Parameter("@Dari", SqlDbType.VarChar, _cabId));
prm.Add(new Parameter("@Tolak", SqlDbType.Bit, (dr["ltolak"])));
prm.Add(new Parameter("@Alasan", SqlDbType.VarChar, Tools.isNull(dr["alasan"], "").ToString()));
prm.Add(new Parameter("@LastUpdatedBy", SqlDbType.VarChar, userObject.UserID));
db.Commands[0].Parameters = prm;
rslt = db.Commands[0].ExecuteScalar();
if ((Tools.isNull(rslt, "").ToString() == "Ok") && (_tipeHI == 1))
{
db.Commands[1].Parameters = prm;
rslt = db.Commands[1].ExecuteScalar();
}
if (Tools.isNull(rslt, "").ToString() == "Ok")
{
counter++;
}
else
{
rslt = rslt + "; NoDKN : " + Tools.isNull(dr["no_dkn"], "").ToString()
+ "; iddetail : " + Tools.isNull(dr["iddetail"], "").ToString();
break;
}
}
}
catch (Exception ex)
{
rslt = "Catch error : " + ex.Message + "; No.DKN : " + Tools.isNull(dr["no_dkn"], "").ToString()
+ "; iddetail : " + Tools.isNull(dr["iddetail"], "").ToString();
break;
}
}
if (Tools.isNull(rslt, "").ToString() == "Ok")
{
db.CommitTransaction();
}
else
{
db.RollbackTransaction();
}
}
return(Tools.isNull(rslt, "").ToString());
}
