static void Main(string[] args)
{
Mahasiswa Mahasiswa;
Mahasiswa = new MHS();
Mahasiswa.Biodata();
Mahasiswa = new KTP();
Mahasiswa.Biodata();
Console.WriteLine();
Console.ReadKey();
}
public string DukcapilWebServices(string NIK, string PassKey)
{
string Key = "NaAsTYMvZzNURPXO6m3RCNOROK7RMb5mG7vUk1p7hCG5JLieFlxJbg7ypG6ayndYNdGJA1RzP";
string JsonData = "";
string s = "nik data input or passkey must be correct";
string usr = "******";
string pass = "******";
string ip = "10.162.61.3";
if (PassKey == Key && NIK != "")
{
//return s;
Services sv = new Services();
KTP data = sv.KtpPickup(NIK, usr, pass, ip);
System.Web.Script.Serialization.JavaScriptSerializer serializer2 = new System.Web.Script.Serialization.JavaScriptSerializer();
JsonData = serializer2.Serialize(data);
}
else
{
return(s);
}
return(JsonData);
}
public KTP KtpPickup(string NIK, string UserID, string Pass, string Ip)
{
KTP data = new KTP();
try
{
var baseAddress = "http://172.16.160.128:8000/dukcapil/get_json/BATAVIA_FINANCE/call_nik";
var httpWebRequest = (HttpWebRequest)WebRequest.Create(baseAddress);
httpWebRequest.ContentType = "application/json";
httpWebRequest.Accept = "application/json";
httpWebRequest.Method = "POST";
using (var streamWriter = new StreamWriter(httpWebRequest.GetRequestStream()))
{
string json = "{\"NIK\":\"" + NIK + "\"," +
"\"user_id\":\"" + UserID + "\"," +
"\"password\":\"" + Pass + "\"," +
"\"ip_user\":\"" + Ip + "\"}";
streamWriter.Write(json);
streamWriter.Flush();
streamWriter.Close();
}
var httpResponse = (HttpWebResponse)httpWebRequest.GetResponse();
using (var streamReader = new StreamReader(httpResponse.GetResponseStream()))
{
string result = streamReader.ReadToEnd();
var items = JsonConvert.DeserializeObject <BaseEntity>(result);
foreach (KTP item in items.content)
{
data.AGAMA = item.AGAMA;
data.ALAMAT = item.ALAMAT;
data.JENIS_KLMIN = item.JENIS_KLMIN;
data.JENIS_PKRJN = item.JENIS_PKRJN;
data.KAB_NAME = item.KAB_NAME;
data.KEC_NAME = item.KEC_NAME;
data.KEL_NAME = item.KEL_NAME;
data.NAMA_LGKP = item.NAMA_LGKP;
data.NAMA_LGKP_IBU = item.NAMA_LGKP_IBU;
data.NIK = item.NIK;
data.NO_KAB = item.NO_KAB;
data.NO_KEC = item.NO_KEC;
data.NO_KEL = item.NO_KEL;
data.NO_KK = item.NO_KK;
data.NO_PROP = item.NO_PROP;
data.NO_RT = item.NO_RT;
data.NO_RW = item.NO_RW;
data.PROP_NAME = item.PROP_NAME;
data.STATUS_KAWIN = item.STATUS_KAWIN;
data.TGL_LHR = item.TGL_LHR;
data.TMPT_LHR = item.TMPT_LHR;
}
}
}
catch (Exception ex)
{
data = null;
}
return(data);
}
public KTP KtpPickup(string NIK, string UserID, string Pass, string Ip)
{
string x = "Error";
KTP data = new KTP();
try
{
var baseAddress = "http://172.16.160.128:8000/dukcapil/get_json/BATAVIA_FINANCE/call_nik";
var httpWebRequest = (HttpWebRequest)WebRequest.Create(baseAddress);
httpWebRequest.ContentType = "application/json";
httpWebRequest.Accept = "application/json";
httpWebRequest.Method = "POST";
using (var streamWriter = new StreamWriter(httpWebRequest.GetRequestStream()))
{
string json = "{\"NIK\":\"" + NIK + "\"," +
"\"user_id\":\"" + UserID + "\"," +
"\"password\":\"" + Pass + "\"," +
"\"ip_user\":\"" + Ip + "\"}";
streamWriter.Write(json);
streamWriter.Flush();
streamWriter.Close();
}
var httpResponse = (HttpWebResponse)httpWebRequest.GetResponse();
using (var streamReader = new StreamReader(httpResponse.GetResponseStream()))
{
string result = streamReader.ReadToEnd();
var items = JsonConvert.DeserializeObject <BaseEntity>(result);
foreach (KTP item in items.content)
{
data.AGAMA = item.AGAMA;
data.ALAMAT = item.ALAMAT;
data.JENIS_KLMIN = item.JENIS_KLMIN;
data.JENIS_PKRJN = item.JENIS_PKRJN;
data.KAB_NAME = item.KAB_NAME;
data.KEC_NAME = item.KEC_NAME;
data.KEL_NAME = item.KEL_NAME;
data.NAMA_LGKP = item.NAMA_LGKP;
data.NAMA_LGKP_IBU = item.NAMA_LGKP_IBU;
data.NIK = item.NIK;
data.NO_KAB = item.NO_KAB;
data.NO_KEC = item.NO_KEC;
data.NO_KEL = item.NO_KEL;
data.NO_KK = item.NO_KK;
data.NO_PROP = item.NO_PROP;
data.NO_RT = item.NO_RT;
data.NO_RW = item.NO_RW;
data.PROP_NAME = item.PROP_NAME;
data.STATUS_KAWIN = item.STATUS_KAWIN;
data.TGL_LHR = item.TGL_LHR;
data.TMPT_LHR = item.TMPT_LHR;
}
//KAB_NAME,AGAMA,NO_RW,KEC_NAME,JENIS_PKRJN,NO_RT,NO_KEL,ALAMAT,NO_KEC,TMPT_LHR,STATUS_KAWIN,NO_PROP,NAMA_LGKP_IBU,PROP_NAME,NO_KAB,KEL_NAME,JENIS_KLMIN,TGL_LHR,CRE_DATE,CRE_BY,CRE_IP_ADDRESS,MOD_DATE,MOD_BY,MOD_IP_ADDRESS,IS_CHECK,IS_MOBILE,MOD_DATE_CHECK"
}
}
catch (Exception ex)
{
data = null;
Shared.ShowErrorDialog(this, ex);
}
if (CheckNIKisExists(NIK))
{
SqlConnection con = new SqlConnection("Server=10.162.61.3\\DUKCAPIL;Database=DUKCAPIL;User ID=sa;Password=admin123");
con.Open();
string sqlDelete = "delete from DATA_PENDUDUK where NIK='" + NIK + "'";
SqlCommand cmdd = new SqlCommand(sqlDelete, con);
cmdd.ExecuteNonQuery();
con.Close();
SqlConnection conn = new SqlConnection("Server=10.162.61.3\\DUKCAPIL;Database=DUKCAPIL;User ID=sa;Password=admin123");
conn.Open();
string hostName = Dns.GetHostName();
string myIP = Dns.GetHostByName(hostName).AddressList[0].ToString();
string sql = "insert into DATA_PENDUDUK (NO_KK,NIK,NAMA_LGKP,KAB_NAME,AGAMA,NO_RW,KEC_NAME,JENIS_PKRJN,NO_RT,NO_KEL,ALAMAT,NO_KEC,TMPT_LHR,STATUS_KAWIN,NO_PROP,NAMA_LGKP_IBU,PROP_NAME,NO_KAB,KEL_NAME,JENIS_KLMIN,TGL_LHR,IS_MOBILE,CRE_DATE,CRE_BY,CRE_IP_ADDRESS,MOD_IP_ADDRESS)";
sql = sql + " VALUES('" + data.NO_KK + "','" + data.NIK + "','" + data.NAMA_LGKP + "','" + data.KAB_NAME + "','" + data.AGAMA + "','" + data.NO_RW + "','" + data.KEC_NAME + "','" + data.JENIS_PKRJN + "','" + data.NO_RT + "','" + data.NO_KEL + "','" + data.ALAMAT + "','" + data.NO_KEC + "','" + data.TMPT_LHR + "','" + data.STATUS_KAWIN + "','" + data.NO_PROP + "','" + data.NAMA_LGKP_IBU + "','" + data.PROP_NAME + "','" + data.NO_KAB + "','" + data.KEC_NAME + "','" + data.JENIS_KLMIN + "','" + data.TGL_LHR + "','" + "1" + "','" + DateTime.Now + "','" + "App" + "','" + myIP + "','" + myIP + "')";
SqlCommand cmd = new SqlCommand(sql, conn);
cmd.ExecuteNonQuery();
conn.Close();
}
else
{
SqlConnection conn = new SqlConnection("Server=10.162.61.3\\DUKCAPIL;Database=DUKCAPIL;User ID=sa;Password=admin123");
conn.Open();
string hostName = Dns.GetHostName();
string myIP = Dns.GetHostByName(hostName).AddressList[0].ToString();
string sql = "insert into DATA_PENDUDUK (NO_KK,NIK,NAMA_LGKP,KAB_NAME,AGAMA,NO_RW,KEC_NAME,JENIS_PKRJN,NO_RT,NO_KEL,ALAMAT,NO_KEC,TMPT_LHR,STATUS_KAWIN,NO_PROP,NAMA_LGKP_IBU,PROP_NAME,NO_KAB,KEL_NAME,JENIS_KLMIN,TGL_LHR,IS_MOBILE,CRE_DATE,CRE_BY,CRE_IP_ADDRESS,MOD_IP_ADDRESS)";
sql = sql + " VALUES('" + data.NO_KK + "','" + data.NIK + "','" + data.NAMA_LGKP + "','" + data.KAB_NAME + "','" + data.AGAMA + "','" + data.NO_RW + "','" + data.KEC_NAME + "','" + data.JENIS_PKRJN + "','" + data.NO_RT + "','" + data.NO_KEL + "','" + data.ALAMAT + "','" + data.NO_KEC + "','" + data.TMPT_LHR + "','" + data.STATUS_KAWIN + "','" + data.NO_PROP + "','" + data.NAMA_LGKP_IBU + "','" + data.PROP_NAME + "','" + data.NO_KAB + "','" + data.KEC_NAME + "','" + data.JENIS_KLMIN + "','" + data.TGL_LHR + "','" + "1" + "','" + DateTime.Now + "','" + "App" + "','" + myIP + "','" + myIP + "')";
SqlCommand cmd = new SqlCommand(sql, conn);
cmd.ExecuteNonQuery();
conn.Close();
}
JavaScriptSerializer js = new JavaScriptSerializer();
js.Serialize(data);
return(data);
}
