public FormInstanceModel InsertOrUpdateFormInstance(FormInstanceModel instanceModel)
{
using (var conn = new SqlConnection(ConnectionString))
{
var cmd = new SqlCommand("[dbo].[SP_AddOrUpdateFormInstance]", conn)
{
CommandType = CommandType.StoredProcedure
};
var param = new SqlParameter
{
ParameterName = "@FormInstanceId",
Value = instanceModel.FormInstanceId,
SqlDbType = SqlDbType.BigInt
};
cmd.Parameters.Add(param);
param = new SqlParameter
{
ParameterName = "@FormDataFields",
Value = instanceModel.FormData,
SqlDbType = SqlDbType.NVarChar
};
cmd.Parameters.Add(param);
param = new SqlParameter
{
ParameterName = "@FormTemplateId",
Value = instanceModel.FormTemplateId,
SqlDbType = SqlDbType.BigInt
};
cmd.Parameters.Add(param);
conn.Open();
var da = new SqlDataAdapter(cmd);
var ds = new DataSet();
da.Fill(ds, "FormTemplate");
conn.Close();
var tempData = FormInstanceModeMapping.MapDataTableToFormTemplateModel(ds);
conn.Close();
return(tempData);
}
}
public FormInstanceModel InsertOrUpdateFormInstance(FormInstanceModel instanceModel)
{
var instanceDal = new FormInstanceDAL();
var instanceMode = instanceDal.InsertOrUpdateFormInstance(instanceModel);
return instanceMode;
}
