public int SaveInsurance(PreInsurance preIns)
{
int InsuranceNo = 0;
// DataSet set = new DataSet();
PreInsurance objpreinsu = new PreInsurance();
try
{
using (SqlConnection sqlCon = new SqlConnection(_connectionString))
{
using (SqlCommand sqlCmd = new SqlCommand("sspSaveInsurance", sqlCon))
{
sqlCmd.CommandType = CommandType.StoredProcedure;
sqlCmd.Parameters.Add(new SqlParameter("@PatientName", preIns.PatientName));
sqlCmd.Parameters.Add(new SqlParameter("@Gender", preIns.Gender));
sqlCmd.Parameters.Add(new SqlParameter("@Dataofbirth", preIns.Dataofbirth));
sqlCmd.Parameters.Add(new SqlParameter("@InsuranceCard_IDno", preIns.InsuranceCard_IDno));
sqlCmd.Parameters.Add(new SqlParameter("@MobileNumber", preIns.MobileNumber));
sqlCmd.Parameters.Add(new SqlParameter("@PolicyName", preIns.PolicyName));
sqlCmd.Parameters.Add(new SqlParameter("@PolicyNumber", preIns.PolicyNumber));
sqlCmd.Parameters.Add(new SqlParameter("@PrimaryInsName", preIns.PrimaryInsName));
//sqlCmd.Parameters.Add(new SqlParameter("@OtherInsurance", preIns.OtherInsurance));
sqlCmd.Parameters.Add(new SqlParameter("@TenantID", preIns.TenantID));
sqlCon.Open();
SqlDataReader reader = sqlCmd.ExecuteReader();
if (reader.HasRows)
{
while (reader.Read())
{
InsuranceNo = (reader[0] == DBNull.Value ? 0 : Convert.ToInt32(reader[0]));
}
}
reader.Close();
reader = null;
//if (set.Tables.Count > 1)
//{
// customerNumber = set.Tables[1].Rows[0].ItemArray[0] == DBNull.Value ? 0 : Convert.ToInt32(set.Tables[1].Rows[0].ItemArray[0]);
// //ordKitBO.OrderNumber = set.Tables[0].Rows[0].ItemArray[0] == DBNull.Value ? string.Empty : Convert.ToString(set.Tables[0].Rows[0].ItemArray[0]);
//}
sqlCon.Close();
}
}
}
catch (Exception ex)
{
//strErrorMsg = ex.Message;
throw;
}
return(InsuranceNo);
}
public HttpResponseMessage Post([FromBody] PreInsurance preinsurance)
{
ApiDA apiDA = new ApiDA();
HttpResponseMessage responce = new HttpResponseMessage();
// bool isEntity=apiDA.CheckEntity(kitOrder.AuthenticateToken);
int TenantID = apiDA.CheckEntity(preinsurance.PreAuthoriztionToken);
preinsurance.TenantID = TenantID;
if (TenantID != 0)
{
apiDA.SaveInsurance(preinsurance);
}
return(responce);
}
