public ActionResult insert(T03001 t03001)
{
try
{
var data = repository.insert(t03001, Session["T_EMP_CODE"].ToString());
string JSONString = string.Empty;
if (data == "Invalid Iqama #")
{
JSONString = JsonConvert.SerializeObject(this.repository.GetUserMsg("S0095", Session["T_LANG"].ToString()));
}
if (data == "Data Insert Successfully")
{
JSONString = JsonConvert.SerializeObject(this.repository.GetUserMsg("N0040", Session["T_LANG"].ToString()));
}
if (data == "Data Update Successfully")
{
JSONString = JsonConvert.SerializeObject(this.repository.GetUserMsg("N0041", Session["T_LANG"].ToString()));
}
JSONString = JSONString.Replace("\"", "");
JSONString = JsonConvert.SerializeObject(JSONString);
return(Json(JSONString, JsonRequestBehavior.AllowGet));
}
catch (Exception e)
{
err.SetServerErrorLog(ControllerContext.RouteData.Values["controller"].ToString(),
ControllerContext.RouteData.Values["action"].ToString(),
Session["T_ENTRY_USER"] == null ? "" : Session["T_ENTRY_USER"].ToString(), e.Message);
return(Json(e.Message, JsonRequestBehavior.AllowGet));
}
}
public string insert(T03001 t03001, string T_EMP_CODE)
{
string msg = "";
string user = T_EMP_CODE;
bool isInsert = false;
DataTable dtExistingPat = this.obj.CheckExtistingPatient(t03001.T_PAT_NO);
obj.BeginTransaction();
if (dtExistingPat.Rows.Count > 0)
{
isInsert = this.obj.update03001(
user,
t03001.T_BIRTH_DATE,
t03001.T_PAT_NO,
t03001.T_FAMILY_LANG1_NAME,
t03001.T_FAMILY_LANG2_NAME,
t03001.T_FATHER_LANG1_NAME,
t03001.T_FATHER_LANG2_NAME,
t03001.T_GFATHER_LANG1_NAME,
t03001.T_GFATHER_LANG2_NAME,
t03001.T_FIRST_LANG1_NAME,
t03001.T_FIRST_LANG2_NAME,
t03001.T_MOTHER_LANG1_NAME,
t03001.T_MOTHER_LANG2_NAME,
t03001.T_NTNLTY_CODE,
t03001.T_NTNLTY_ID,
t03001.T_ADDRESS1,
t03001.T_ADDRESS2,
t03001.T_RLGN_CODE,
t03001.T_RLTN_CODE,
t03001.T_GENDER,
t03001.T_MOBILE_NO,
t03001.T_POSTAL_CODE,
t03001.T_POBOX_NO,
t03001.T_EMAIL_ID,
t03001.T_ER_RLTN_CODE,
t03001.T_ER_MOBILE,
t03001.T_PAT_TITLE, t03001.T_MRTL_STATUS);
msg = "Data Update Successfully";
}
if (dtExistingPat.Rows.Count == 0)
{
string maxPatNo = obj.GetMaxPatNo().Rows[0][0].ToString();
string maxId = obj.GetMaxId();
DataTable dtNationalitychech = this.obj.CheckNationalityCode(t03001.T_NTNLTY_ID);
if (dtNationalitychech.Rows.Count > 0)
{
return(msg = "Invalid Iqama #");
}
isInsert = this.obj.insert03001(user, maxId, t03001.T_BIRTH_DATE, maxPatNo, t03001.T_FAMILY_LANG1_NAME, t03001.T_FAMILY_LANG2_NAME,
t03001.T_FATHER_LANG1_NAME, t03001.T_FATHER_LANG2_NAME, t03001.T_GFATHER_LANG1_NAME,
t03001.T_GFATHER_LANG2_NAME, t03001.T_FIRST_LANG1_NAME, t03001.T_FIRST_LANG2_NAME,
t03001.T_MOTHER_LANG1_NAME, t03001.T_MOTHER_LANG2_NAME, t03001.T_NTNLTY_CODE,
t03001.T_NTNLTY_ID, t03001.T_ADDRESS1, t03001.T_ADDRESS2, t03001.T_RLGN_CODE,
t03001.T_RLTN_CODE, t03001.T_GENDER, t03001.T_MOBILE_NO, t03001.T_POSTAL_CODE,
t03001.T_POBOX_NO, t03001.T_EMAIL_ID, t03001.T_ER_RLTN_CODE, t03001.T_ER_MOBILE, t03001.T_PAT_TITLE, t03001.T_MRTL_STATUS);
msg = "Data Insert Successfully";
}
if (isInsert)
{
obj.CommitTransaction();
}
else
{
obj.RollbackTransaction();
msg = "Data faild to save";
}
return(msg);
}
