public string UpdateDataToSakala(string Fac_Id, string App_Status, string Remarks)
{
string gsc_no = null;
string sendXml = null, recvXml = null;
try
{
DataSet ds = opr.DDL("sp_Get_GSCNO", Fac_Id);
foreach (DataRow item in ds.Tables[0].Rows)
{
gsc_no = (item[0].ToString());
}
if (gsc_no != null)
{
StringBuilder xmlData = new StringBuilder();
xmlData.Append("<upd_sakala>").Append("<upd_gscdata>");
xmlData.Append("<DEPT_CODE>").Append("IS")
.Append("</DEPT_CODE>");
xmlData.Append("<GSC_NO>").Append(gsc_no).Append("</GSC_NO>");
xmlData.Append("<GSC_STATUS_CODE>").Append(App_Status)
.Append("</GSC_STATUS_CODE>");
xmlData.Append("<GSC_STATUS_DESC>").Append(Remarks)
.Append("</GSC_STATUS_DESC>");
xmlData.Append("<UPD_DT>").Append(DateTime.Now.ToString("dd-MM-yyyy")).Append("</UPD_DT>");
xmlData.Append("</upd_gscdata>").Append("</upd_sakala>");
sendXml = xmlData.ToString();
SakalaHandler sa = new SakalaHandler();
//recvXml = sa.sendData2NIC(sendXml,UPDATE_DATA);
Thread.Sleep(1000);
/* string sql = opr.DML("sp_Update_sakala_dtls", App_Status, Remarks, sendXml, recvXml,Fac_Id).ToString();
*/
}
return(gsc_no);
}
catch (Exception e)
{
Log log = new Log();
log.LogFile("Exception:" + e.Message.ToString(), appRunningId);
}
return(gsc_no);
}
public string postingDataToSakala(string Fac_id, string div_code, string service_code, string applicantname, string appl_Address1, string appl_Address2)
{
string fac_id = Fac_id;
string sa_app_dept_code = "IS";
string sa_desig_off_code = getNicDeptCode(div_code);
string sa_service_code = service_code;
string sa_gsc_no = null;
try
{
string sql = opr.DML("Sp_Insert_Sakala_dtls", fac_id, sa_desig_off_code, sa_service_code).ToString();
if (sql != null)
{
sa_gsc_no = getGscNumber(fac_id);
}
}
catch (Exception e)
{
Log log = new Log();
log.LogFile("Exception:" + e.Message.ToString(), appRunningId);
}
string sa_gsc_date = DateTime.Now.ToString("dd/MM/yyyy");
string sa_appl_name = applicantname;
string sa_appl_addr1 = appl_Address1;
string sa_appl_addr2 = appl_Address2;
string sendXml = "";
string recvXml = "";
StringBuilder xmlData = new StringBuilder();
xmlData.Append("<acpt_sakala>");
xmlData.Append("<acpt_gscdata>");
xmlData.Append("<DEPT_CODE>").Append(sa_app_dept_code)
.Append("</DEPT_CODE>");
xmlData.Append("<DESIG_OFF_CODE>").Append(sa_desig_off_code)
.Append("</DESIG_OFF_CODE>");
xmlData.Append("<SERVICE_CODE>").Append(sa_service_code)
.Append("</SERVICE_CODE>");
xmlData.Append("<SUB_SERVICE_CODE>").Append("00")
.Append("</SUB_SERVICE_CODE>");
xmlData.Append("<GSC_NO>").Append(sa_gsc_no).Append("</GSC_NO>");
xmlData.Append("<GSC_DT>").Append(sa_gsc_date).Append("</GSC_DT>");
xmlData.Append("<APPL_NAME>").Append(sa_appl_name)
.Append("</APPL_NAME>");
xmlData.Append("<APPL_ADDRESS1>").Append(sa_appl_addr1)
.Append("</APPL_ADDRESS1>");
xmlData.Append("<APPL_ADDRESS2>").Append(sa_appl_addr2)
.Append("</APPL_ADDRESS2>");
xmlData.Append("<APPL_MOBILE>").Append(0)
.Append("</APPL_MOBILE>");
xmlData.Append("<DOC_SUBMITTED>").Append("Y")
.Append("</DOC_SUBMITTED>");
xmlData.Append("<GSC_UPD_FLAG>").Append("N").Append("</GSC_UPD_FLAG>");
xmlData.Append("</acpt_gscdata>");
xmlData.Append("</acpt_sakala>");
sendXml = xmlData.ToString();
SakalaHandler sa = new SakalaHandler();
recvXml = sa.sendData2NIC(sendXml, ACCEPT_DATA);
Thread.Sleep(1000);
try
{
/*string sql = opr.DML("sp_Update_Form1_Details", sa_gsc_no, sa_gsc_date, sa_appl_name, sendXml, recvXml, fac_id).ToString();
*/
}
catch (Exception e)
{
Log log = new Log();
log.LogFile("Exception:" + e.Message.ToString(), appRunningId);
}
return(sa_gsc_no);
}
